MySQL error ID 1064

[ManvYAn]

Sveiki, dariau registraciją su autosave ir man iškilo problemą, viską saugo išskyrus lytį.
 

[14:57:55] >> mysql_query( Connection handle: 1 )

[14:57:55] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'The_Manvyd') - Successfully executed.

[14:57:55] >> mysql_store_result( Connection handle: 1 )

[14:57:55] CMySQLHandler::StoreResult() - Result was stored.

[14:57:55] >> mysql_num_rows( Connection handle: 1 )

[14:57:55] CMySQLHandler::NumRows() - Returned 1 row(s)

[14:58:02] >> mysql_query( Connection handle: 1 )

[14:58:02] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'The_Manvyd' AND Slaptazodis = 'manvydas852') - Successfully executed.

[14:58:02] >> mysql_store_result( Connection handle: 1 )

[14:58:02] CMySQLHandler::StoreResult() - Result was stored.

[14:58:02] >> mysql_num_rows( Connection handle: 1 )

[14:58:02] CMySQLHandler::NumRows() - Returned 1 row(s)

[14:58:03] >> mysql_query( Connection handle: 1 )

[14:58:03] CMySQLHandler::Query(UPDATE zaidejai SET x='0.000000', y='0.000000', z='0.000000', Pinigai='0',Score='0', Drabuziai='0' WHERE Vardas='The_Manvyd') - Successfully executed.

[14:58:27] >> mysql_query( Connection handle: 1 )

[14:58:27] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'The_Manvydsas') - Successfully executed.

[14:58:27] >> mysql_store_result( Connection handle: 1 )

[14:58:27] CMySQLHandler::StoreResult() - Result was stored.

[14:58:27] >> mysql_num_rows( Connection handle: 1 )

[14:58:27] CMySQLHandler::NumRows() - Returned 0 row(s)

[14:58:44] >> mysql_query( Connection handle: 1 )

[14:58:44] CMySQLHandler::Query(INSERT INTO zaidejai(Vardas, Slaptazodis) VALUE ('The_Manvydsas', 'manvydas')) - Successfully executed.

[14:58:45] >> mysql_query( Connection handle: 1 )

[14:58:45] CMySQLHandler::Query(INSERT INTO zaidejai(Lytis Drabuziai) VALUE('1' '17')) - An error has occured. (Error ID: 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 'Drabuziai) VALUE('1' '17')' at line 1)

[14:58:55] >> mysql_query( Connection handle: 1 )

[14:58:55] CMySQLHandler::Query(UPDATE zaidejai SET x='-1978.631591', y='135.054458', z='28.384906', Pinigai='5000',Score='0', Drabuziai='17' WHERE Vardas='The_Manvydsas') - Successfully executed.

Script'as:
 

                new query[126], pName[MAX_PLAYER_NAME];
                GetPlayerName(playerid, pName, sizeof(pName));
                if(listitem == 0)
                {
                    zInfo[playerid][lytisvm] = 1;
                    zInfo[playerid][Drabuziaivm] = 17;
                    format(query, sizeof(query),"INSERT INTO zaidejai(Lytis Drabuziai) VALUE('%i' '%i')", zInfo[playerid][lytisvm], zInfo[playerid][Drabuziaivm]);
                    mysql_query(query);
                    SendClientMessage(playerid, -1,"{00FF00}Užsiregistravote sėkmingai. Sėkmės žaidime");
                    SetPVarInt(playerid, "Prisiregistravo", 1);
                }

Bandžiau didinti masyvus, bet vistiek tas pats.

Redaguota Sausio 5, 2014, nario ManvYAn

[bebras]

Easy. Ne "VALUE", o "VALUES"(daugiskaita).

[ManvYAn]

Ištaisiau, dėkui.

Redaguota Sausio 5, 2014, nario ManvYAn

[bebras]

 format(query, sizeof(query),"INSERT INTO zaidejai(Lytis,Drabuziai) VALUES('%i' '%i')", zInfo[playerid][lytisvm], zInfo[playerid][Drabuziaivm]);

Po "Lytis" trūko kablelio

[ManvYAn]

 format(query, sizeof(query),"INSERT INTO zaidejai(Lytis,Drabuziai) VALUES('%i' '%i')", zInfo[playerid][lytisvm], zInfo[playerid][Drabuziaivm]);

Po "Lytis" trūko kablelio

 

Padėjau, nes metė error. Dėkui už pagalbą.