phpnuke SQL Error : 1064

Sparax · **phpnuke SQL Error : 1064 -** 01-25-2006, 04:19 PM

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

soulshade · 01-26-2006, 12:08 PM

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

Sparax · 01-30-2006, 03:26 AM

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.

ovaltrack · 04-10-2006, 02:30 AM

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.

Great_Bald_One · 12-28-2006, 04:07 PM

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

Ãƒâ€šÃ‚Â*