Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 MySQL error: 1064
mikeyz54 Offline
Junior Member
**
Posts: 4
Joined: May 2008
Post: #1
MySQL error: 1064
I tried recalculating the users money, and I got this error:

Code:
MySQL 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 'Shop,Games Consoles,Apple Store,avatar,avatardimensions,avatartype,usergroup,add' at line 1
Query: REPLACE INTO mybb_users(uid,username,password,salt,loginkey,email,postnum,Celebrity Shop,Games Consoles,Apple Store,avatar,avatardimensions,avatartype,usergroup,additionalgroups,displaygroup,usertitle,regdate,lastactive,lastvisit,lastpost,website,icq,aim,yahoo,msn,birthday,signature,allownotices,hideemail,emailnotify,invisible,receivepms,pmpopup,pmnotify,remember,threadmode,showsigs,showavatars,showquickreply,showredirect,ppp,tpp,daysprune,dateformat,timeformat,timezone,dst,buddylist,ignorelist,style,away,awaydate,returndate,awayreason,pmfolders,notepad,referrer,reputation,regip,language,timeonline,showcodebuttons,totalpms,newpms,unreadpms,mybank,mybanktime,mybankcheck,Games Console,money,purchases,inventory,bankmoneyoffset,bankbasetime) VALUES 


Followed by every member and other info such as avatar URL etc.

Example:

Code:
('1','USERNAME','2ccdd3b9e86b53f45982e1ac23670cd0','GDtKS9Kx','UO5lenYZNjXTo1XwRoRMzjPBMEMbeXYzHWFmFahtjAIx3Bpoqc','EMAIL ADDRESS','1512','','','','AVATAR','100|100','remote','4','','0','Owner','1197314241','1211564775','1211563272','1211561557','','0','','','','','[align=center][IMG]SIGNATURE[/IMG][/align]','yes','no','no','no','yes','yes','new','yes','linear','yes','yes','yes','yes','0','0','0','0','0','0','yes','','','6','no','0','0','','1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can','','0','16','82.5.128.21','','1318733','1','305','0','0','795000','0','no','','30046.2','2','','843167.0000000000','1211500800')


Is there a way to fix this?

Thanks Smile

(This post was last modified: 05-24-2008 03:54 AM by mikeyz54.)
05-24-2008 03:54 AM
Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

Messages In This Thread
MySQL error: 1064 - mikeyz54 - 05-24-2008 03:54 AM
RE: MySQL error: 1064 - ZiNgA BuRgA - 05-25-2008, 04:46 PM
RE: RE: MySQL error: 1064 - mikeyz54 - 05-25-2008, 05:49 PM

 Standard Tools
Forum Jump: