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

[Flowy Otaku]

close!

[MentaL]

[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.

[seanrom]

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

And your query is never closed.

[Flowy Otaku]

i have use_newui but i forget to add the gyazo.

- - - Updated - - -

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 - - -

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.

[TardisHotel]

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.

[Flowy Otaku]

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.

[seanrom]

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

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

And your query is never closed.

[Flowy Otaku]

never closed?

[moere]

never closed?

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

[Flowy Otaku]

fdgdghfhgf

[moere]

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)

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');

[Flowy Otaku]

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)

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