Hello everyone

Could someone please give me some advice on what i need to do to get rid off this error i would be extreemly grateful for any advice you can give me.

Cheers


Failed to update general configuration for ALTER TABLE nuke_users ADD
user_allowsignature TINYINT not null DEFAULT '1'

DEBUG MODE

SQL 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 '1''' at line 3

UPDATE nuke_bbconfig SET config_value = '' WHERE config_name = 'ALTER
TABLE nuke_users ADD user_allowsignature TINYINT not null DEFAULT '1''

Line : 62
File : admin_board.php

Was the site up and running before this error or was this after your initial install?

yes the board was up and running and i had a few mods installed and all was working fine for a few days then all of a sudden it started giving me this error i hadn't made any changes to the site for a few days prior to it showing up so i have no idea what had caused it. Anyway in the end i gave up and have now re-installed the whole board from scratch so not to worry about a fix for me but if you do know what was wrong here i would be interested to know just incase it happens again.

i have a very simular error.....

Code:

DEBUG MODE SQL Error : 1064 You have an error in your SQL syntax near ') AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.' at line 3 SELECT ug.user_id, COUNT(auth_mod) AS is_auth_mod FROM nuke_bbauth_access aa, nuke_bbuser_group ug WHERE ug.user_id IN () AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.user_id Line : 529 File : admin_ug_auth.php

I was tring to chang somones moderator status... only thing i have changed recently it upgading to nuke 7.8 (from 7.5)

any help greatly apreciated.

Hi All,

I'm using am unmodified server installed of Nuke 7.6 package. I too am having the same 1064 error! However, my error shows up when trying to restore the phpbb forum backup file.

Below is the full error statement:
---------------------------------------------------------------------------------------------

• Error importing backup file
  
  DEBUG MODE
  
  SQL 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 ' {messege ends here... nothing more is printed on screen}

---------------------------------------------------------------------------------------------

I haven’t got a clue how to fix this… I know next to nothing about SQL.

Does anyone have some notion how to correct this problem?

PS: Best regards for 2007 to all
Â*