PDA

View Full Version : SQL Error


Hobbes
09-08-2003, 11:45 PM
Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO usergroup (usergroupid,title,usertitle,cancontrolpanel,canmo difyprofile,canviewmembers,canview,showgroup,canse arch,canemail,canpostnew,canmove,canopenclose,cand eletethread,canreplyown,canreplyothers,canviewothe rs,caneditpost,candeletepost,canusepm,canpostpoll, canvote,canpostattachment,ismoderator,cancalendar, canpublicevent,canpublicedit,canthreadrate,cantrac kpm,candenypmreceipts,maxbuddypm,maxforwardpm,canw hosonline,canwhosonlineip,cangetattachment)
VALUES (NULL,'Global Moderator','Global Mod',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,,1, 1,1,1,1,0,0,1,1,1)
mysql error: 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,1,1,1,1,0,0,1,1,1)' at line 2

mysql error number: 1064

Date: Monday 08th of September 2003 07:43:49 PM
Script: http://forums.squareultima.com/admin/usergroup.php
Referer:




I really dont know how to fix this...it hasn't worked for months already...anyone have any idea? :(....anything...:(


FIXED

filburt1
09-09-2003, 12:06 AM
There are two commas in a row in the VALUES section.

Hobbes
09-09-2003, 12:27 AM
anyidea how to fix?
:(

Hobbes
09-19-2003, 02:32 AM
ARGH


Help!?!? :(