Error ID: 1064, MySQL
#2

Remove the quotes around each field name.
pawn Код:
'user', 'IP', 'Password', 'AccId', 'NoPrivM', 'Clothes', 'MissionCompleted', 'AgentCard', 'Story', 'BankPin', 'BankWealth', 'Banned', 'AdminLevel', 'VIPLevel', 'Money', 'Score', 'Kills', 'Deaths'
In MySQL, those singular quotes are for enclosing varchars(strings).

For the account ID system, check out this gamemode. Also, for registering, you can only insert the fields you need (name and password), and then run an UPDATE query for the rest of the data.
Reply


Messages In This Thread
Error ID: 1064, MySQL - by JaKe Elite - 16.11.2012, 13:30
Re: Error ID: 1064, MySQL - by ReneG - 16.11.2012, 13:35
Re: Error ID: 1064, MySQL - by Jarnu - 16.11.2012, 13:50
Re: Error ID: 1064, MySQL - by JaKe Elite - 16.11.2012, 22:56
Re: Error ID: 1064, MySQL - by ReneG - 17.11.2012, 00:47
Re: Error ID: 1064, MySQL - by JaKe Elite - 17.11.2012, 01:25
Re: Error ID: 1064, MySQL - by JaKe Elite - 17.11.2012, 07:03
Re: Error ID: 1064, MySQL - by Jarnu - 17.11.2012, 07:11
Re: Error ID: 1064, MySQL - by JaKe Elite - 17.11.2012, 07:21
Re: Error ID: 1064, MySQL - by Jochemd - 17.11.2012, 07:29

Forum Jump:


Users browsing this thread: 1 Guest(s)