PDA

View Full Version : SQL syntax????



Pablo
March 1st, 2004, 13:51
hello everybody, and thx for ur help again
a friend and me are having the same prob with a phpbb forum:
when we try to change a user`s permission from the admin panel, a message like this one appears:

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 2

INSERT INTO nuke_bbauth_access (forum_id, group_id, auth_mod) VALUES (16, , 1)

Line : 425
File : /home/xtremeg/public_html/html/modules/Forums/admin/admin_ug_auth.php

i`d really appreciate any help, thx in advance

bloodyveins
March 1st, 2004, 23:12
INSERT INTO nuke_bbauth_access (forum_id, group_id, auth_mod) VALUES (16, , 1)

I think you can change the query with a safer one:
INSERT INTO nuke_bbauth_access VALUES ('16',' ','1')

ps: take a look at the single quotes

Pablo
March 1st, 2004, 23:30
nope, didnt work
i tried replacing the admin_ug_auth.php for a new one, and its working perfect now, i wonder y didnt it work with the original one :doh!:
anyway, thx for yer help:coolmusic