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

Results 1 to 12 of 12
  1. #1
    Valued Member Flowy Otaku is offline
    MemberRank
    Feb 2013 Join Date
    113Posts

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

    close!
    Last edited by Flowy Otaku; 04-07-14 at 07:50 PM.


  2. #2
    Account Upgraded | Title Enabled! TardisHotel is offline
    MemberRank
    Mar 2013 Join Date
    404Posts

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

    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.

  3. #3
    ☮TAKU???? seanrom is offline
    MemberRank
    Nov 2009 Join Date
    1,004Posts

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

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

    And your query is never closed.

  4. #4
    Valued Member Flowy Otaku is offline
    MemberRank
    Feb 2013 Join Date
    113Posts

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

    i have use_newui but i forget to add the gyazo.

    - - - Updated - - -

    Quote Originally Posted by ZenLulz View Post
    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 View Post
    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.

  5. #5
    Account Upgraded | Title Enabled! TardisHotel is offline
    MemberRank
    Mar 2013 Join Date
    404Posts

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

    Quote Originally Posted by Flowy Otaku View Post
    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.

  6. #6
    Valued Member Flowy Otaku is offline
    MemberRank
    Feb 2013 Join Date
    113Posts

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

    Quote Originally Posted by TardisHotel View Post
    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.

  7. #7
    ☮TAKU???? seanrom is offline
    MemberRank
    Nov 2009 Join Date
    1,004Posts

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

    Great you fixed one thing. Look at my previous post. There is more things that needs to be fixed.
    Quote Originally Posted by ZenLulz View Post
    Your last insert field isn't quote-closed `use_newui should be `use_newui`.

    And your query is never closed.

  8. #8
    Valued Member Flowy Otaku is offline
    MemberRank
    Feb 2013 Join Date
    113Posts

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

    never closed?

  9. #9
    Valued Member moere is offline
    MemberRank
    Apr 2012 Join Date
    121Posts

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

    Quote Originally Posted by Flowy Otaku View Post
    never closed?
    He means the '); at the end of the whole query

  10. #10
    Valued Member Flowy Otaku is offline
    MemberRank
    Feb 2013 Join Date
    113Posts

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

    fdgdghfhgf
    Last edited by Flowy Otaku; 04-07-14 at 07:50 PM.

  11. #11
    Valued Member moere is offline
    MemberRank
    Apr 2012 Join Date
    121Posts

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

    Quote Originally Posted by Flowy Otaku View Post
    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');

  12. #12
    Valued Member Flowy Otaku is offline
    MemberRank
    Feb 2013 Join Date
    113Posts

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

    Quote Originally Posted by moere View Post
    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



Advertisement