[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL

[FlowyFliphotell]

Gettings this error while runing a query in my database. the query is all the users that i fixed from r63 to latest UI, when i run it i get this error.

[Err] 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 '' at line 1

Do anyknow how to fix it?


design table for users

You must be registered for see links

You must be registered for see links

You must be registered for see links

You must be registered for see links

Best wishes
Flowy.

 

[Hindi]

What Query are you trying to run, Also are you trying to set the default value?

 

[FlowyFliphotell]

What Query are you trying to run, Also are you trying to set the default value?

INSERT INTO `users`(`id`, `username`, `real_name`, `password`, `mail`, `auth_ticket`, `rank`, `credits`, `seasonal_credits`, `belcredits`, `activity_points`, `activity_points_lastupdate`, `look`, `gender`, `motto`, `last_online`, `account_created`, `online`, `ip_last`, `ip_reg`, `home_room`, `respect`, `daily_respect_points`, `daily_pet_respect_points`, `newbie_status`, `is_muted`, `mutant_penalty`, `mutant_penalty_expire`, `block_newfriends`, `hide_online`, `hide_inroom`, `mail_verified`, `vip`, `client_volume`, `volume`, `last_login`, `accept_trading`, `whisper_enabled`, `is_guide`, `last_change`, `key_colour`, `position`, `acc_pornbanned`, `acc_flagged`, `points`, `staff_pin`, `failed_pins`, `working`, `secretcode`, `mymusik`, `seckey`, `use_newui) VALUES ('1', 'Flowy', 'k', '22b75d6007e06f4a959d1b1d69b4c4bd', '[email protected]', 'RevCMS-339/e4edf8cb55d03781f8dd5f180dba6836a', '9', '1484227993', '102', '10706492', '0', '1396279689.37522', 'sh-290-62.ch-3001-100-62.lg-275-62.hr-3090-37.ha-1002-100.hd-185-3', 'M', 'Alla sätt är bra, utom de dÃ¥liga.', '1396289502', '1386080919', '1', '127.0.0.1', '127.0.0.1', '11363', '0', '3', '3', '0', '0', '0', '0', '1', '0', '0', '0', '1', '100', '100,100,100', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '1234', '0', '0', '0', '0', 'd41d8cd98f00b204e9800998ecf8427e', '1',

Just edited my info abit in here cause its personal.

 

[Hindi]

INSERT INTO `users`(`id`, `username`, `real_name`, `password`, `mail`, `auth_ticket`, `rank`, `credits`, `seasonal_credits`, `belcredits`, `activity_points`, `activity_points_lastupdate`, `look`, `gender`, `motto`, `last_online`, `account_created`, `online`, `ip_last`, `ip_reg`, `home_room`, `respect`, `daily_respect_points`, `daily_pet_respect_points`, `newbie_status`, `is_muted`, `mutant_penalty`, `mutant_penalty_expire`, `block_newfriends`, `hide_online`, `hide_inroom`, `mail_verified`, `vip`, `client_volume`, `volume`, `last_login`, `accept_trading`, `whisper_enabled`, `is_guide`, `last_change`, `key_colour`, `position`, `acc_pornbanned`, `acc_flagged`, `points`, `staff_pin`, `failed_pins`, `working`, `secretcode`, `mymusik`, `seckey`, `use_newui) VALUES ('1', 'Flowy', 'k', '22b75d6007e06f4a959d1b1d69b4c4bd', '[email protected]', 'RevCMS-339/e4edf8cb55d03781f8dd5f180dba6836a', '9', '1484227993', '102', '10706492', '0', '1396279689.37522', 'sh-290-62.ch-3001-100-62.lg-275-62.hr-3090-37.ha-1002-100.hd-185-3', 'M', 'Alla sätt är bra, utom de dÃ¥liga.', '1396289502', '1386080919', '1', '127.0.0.1', '127.0.0.1', '11363', '0', '3', '3', '0', '0', '0', '0', '1', '0', '0', '0', '1', '100', '100,100,100', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '1234', '0', '0', '0', '0', 'd41d8cd98f00b204e9800998ecf8427e', '1',

Just edited my info abit in here cause its personal.

Should be

Insert into users values(); <-- values inbetween

Also if u could look at my thread and help me fix please?

You must be registered for see links

 

[FlowyFliphotell]

Should be

Insert into users values(); <-- values inbetween

Also if u could look at my thread and help me fix please?

You must be registered for see links

Doesnt really work. i have a script that transform the r63 users to new ui and now it doesnt work, 500 internal server error

 

[FlowyFliphotell]

You must be registered for see links

script looks like this, also tried to change to what you said, the code stoped work then lol

 

[Hindi]

You must be registered for see links

script looks like this, also tried to change to what you said, the code stoped work then lol

Dude mind setting up my retro up? Confused with the new Ui n such.

 

[FlowyFliphotell]

Dude mind setting up my retro up? Confused with the new Ui n such.

Atm i'm kinda busy need to fix my users from r63 to latest UI, after maybe yea

 

[Hindi]

W

Atm i'm kinda busy need to fix my users from r63 to latest UI, after maybe yea

Would be helpful