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

close!

Check the tables in the sql that you are running to the ones that are currently in your database, it is trying to put something in a table that doesn't exists on your database .. just manually go through it and see which one it is in the sql and remove it.

Your last insert field isn't quote-closed `use_newui should be `use_newui`.

And your query is never closed.

i have use_newui but i forget to add the gyazo.

- - - Updated - - -

Quote:

---

Originally Posted by ZenLulz

Your last insert field isn't quote-closed `use_newui should be `use_newui`.

And your query is never closed.

---

kk fixed `use_newui` at the end copied and tried, still didnt work?

- - - Updated - - -

Quote:

---

Originally Posted by TardisHotel

Check the tables in the sql that you are running to the ones that are currently in your database, it is trying to put something in a table that doesn't exists on your database .. just manually go through it and see which one it is in the sql and remove it.

---

all sql are right, 53 in db and 53 im trying to run.

Quote:

---

Originally Posted by Flowy Otaku

i have use_newui but i forget to add the gyazo.

- - - Updated - - -



kk fixed `use_newui` at the end copied and tried, still didnt work?

- - - Updated - - -


all sql are right, 53 in db and 53 im trying to run.

---

yes but check all the table names against the sql table names in ur database, it's probably just something small and stupid like a typo on one of the tables.

Quote:

---

Originally Posted by TardisHotel

yes but check all the table names against the sql table names in ur database, it's probably just something small and stupid like a typo on one of the tables.

---

Just checked, it's all right, still dont work.

Great you fixed one thing. Look at my previous post. There is more things that needs to be fixed.

Quote:

---

Originally Posted by ZenLulz

Your last insert field isn't quote-closed `use_newui should be `use_newui`.

And your query is never closed.

---

never closed?

Quote:

---

Originally Posted by Flowy Otaku

never closed?

---

He means the '); at the end of the whole query

fdgdghfhgf

Quote:

---

Originally Posted by Flowy Otaku

it actually ends like that. i fixed that also before, still same error.

- - - Updated - - -



The query looks like this now. the one im trying to run.

- - - Updated - - -



now 1>st acc was working but not the others, getting this error on all other accs

---

Fixed query (you forgot to insert a value for activity_points. btw NEVER put in a value for autoincremented values. So remove id and its corresponding value otherwise you will break the autoincrement and get a duplicate error)

Code:

---

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', 'ingetviktigt', 'abd61b94862f6e65202db3bac08dcd62', 'test@hotmail.com', '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', '22b75d6007e06f4a959d1b1d69b4c4bd', '1');

---

Quote:

---

Originally Posted by moere

Fixed query (you forgot to insert a value for activity_points. btw NEVER put in a value for autoincremented values. So remove id and its corresponding value otherwise you will break the autoincrement and get a duplicate error)

Code:

---

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', 'ingetviktigt', 'abd61b94862f6e65202db3bac08dcd62', 'test@hotmail.com', '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', '22b75d6007e06f4a959d1b1d69b4c4bd', '1');

---

---

Nah i changed acitivity_points to seasonal_credits and vip_points to belcredits and i got it working