crash_bang Posted January 4, 2007 Share Posted January 4, 2007 I made a change via PHPMYADMIN (long ago and since forgotten unfortunately) which resulted in saving changes to the PHPBB General Admin. configuration panel impossible. Now, when you hit 'save' the following error occurs. [quote]Failed to update general configuration for ('reg_disable','0')DEBUG MODESQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'reg_disable','0')'' at line 3UPDATE phpbb_config SET config_value = '(''reg_disable'',''0'')' WHERE config_name = '('reg_disable','0')'Line : 79File : admin_board.php[/quote]I'm an SQL novice, shouldn't have been mussing around there in the first place, and am wondering if anything can be done to correct it. Much thanks and appreciation for your ideas. Quote Link to comment https://forums.phpfreaks.com/topic/32787-solved-sql-error-1064-you-have-an-error-in-your-sql-syntax/ Share on other sites More sharing options...
crash_bang Posted January 4, 2007 Author Share Posted January 4, 2007 Fixed it. Instead of upgrading phpbb, I tried adding a mod in an effort to fight spambots. Had a problem with the install - which involved creating a new sql table. Deleted that table. Problem resolved. Quote Link to comment https://forums.phpfreaks.com/topic/32787-solved-sql-error-1064-you-have-an-error-in-your-sql-syntax/#findComment-152652 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.