MysQL Klaida

[Nelixus]

Taigi pasirasiau MysQL saugojima paciame gamemode nemeta klaidos bet Mysql Debuge meta klaidą:
 

Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near

[bebras]

Pirmiausia, tu naudoji ne MySQL, o MariaDB..

 

 

Antra, parodyk užklausą kuri sukelia šį įrašą "debuge".

[Nelixus]

[15:29:31]  

[15:29:31] ---------------------------

[15:29:31] MySQL Debugging activated (11/08/15)

[15:29:31] ---------------------------

[15:29:31]  

[15:29:31] >> mysql_connect( )

[15:29:31] CMySQLHandler::CMySQLHandler() - constructor called.

[15:29:31] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "LERG.LT" | Username: "root" ...

[15:29:31] CMySQLHandler::Connect() - Connection was successful.

[15:29:31] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[15:29:31] >> mysql_ping( Connection handle: 1 )

[15:29:31] CMySQLHandler::Ping() - Connection is still alive.

[15:30:03] >> mysql_query( Connection handle: 1 )

[15:30:03] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Admin_Mantas') - Successfully executed.

[15:30:03] >> mysql_store_result( Connection handle: 1 )

[15:30:03] CMySQLHandler::StoreResult() - Result was stored.

[15:30:03] >> mysql_num_rows( Connection handle: 1 )

[15:30:03] CMySQLHandler::NumRows() - Returned 0 row(s)

[15:30:03] >> mysql_free_result( Connection handle: 1 )

[15:30:03] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:41:44] >> mysql_query( Connection handle: 1 )

[15:41:44] CMySQLHandler::Query(INSERT INTO `zaidejai` (Vardas, Slaptazodis) VALUES ('Admin_Mantas', '07004592E3EFB64B77195B65923DB345')) - Successfully executed.

[15:42:03] >> mysql_query( Connection handle: 1 )

[15:42:03] CMySQLHandler::Query(UPDATE 'zaidejai' SET `pos_X` = '0.000000', `pos_Y` = '0.000000', pos_Z = '-66.042526', `Patirtis` = '0', `PinigaiKiseneje` = '0' WHERE `Vardas` = 'Admin_Mantas') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''zaidejai' SET `pos_X` = '0.000000', `pos_Y` = '0.000000', pos_Z = '-66.042526',' at line 1)

[15:42:03] >> mysql_query( Connection handle: 1 )

[15:42:03] CMySQLHandler::Query(UPDATE 'zaidejai' SET Lytis = '1' WHERE Vardas = 'Admin_Mantas') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''zaidejai' SET Lytis = '1' WHERE Vardas = 'Admin_Mantas'' at line 1)

[15:42:03] >> mysql_query( Connection handle: 1 )

[15:42:03] CMySQLHandler::Query(UPDATE zaidejai SET Ginklas0 = 0, Ammo0 = 0, Ginklas1 = 0, Ammo1 = 0, Ginklas2 = 0, Ammo2 = 0, Ginklas3 = 0, Ammo3 = 0, Ginklas4 = 0, Ammo4 = 0, Ginklas5 = 0, Ammo5 = 0, Ginklas6 = 0, Ammo6 = 0, Ginklas7 = 0, Ammo7 = 0, Ginklas8 = 0, Ammo8 = 0, Ginklas9 = 0, Ammo9 = 0, Ginklas10 = 0, Ammo10 = 0, Ginklas11 = 0, Ammo11 = 0 WHERE Vardas = 'Admin_Mantas') - Successfully executed.

[15:42:42] >> mysql_query( Connection handle: 1 )

[15:42:42] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Admin_Mantas') - Successfully executed.

[15:42:42] >> mysql_store_result( Connection handle: 1 )

[15:42:42] CMySQLHandler::StoreResult() - Result was stored.

[15:42:42] >> mysql_num_rows( Connection handle: 1 )

[15:42:42] CMySQLHandler::NumRows() - Returned 1 row(s)

[15:42:42] >> mysql_free_result( Connection handle: 1 )

[15:42:42] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:43:03] >> mysql_query( Connection handle: 1 )

[15:43:03] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Admin_Mantas' AND `Slaptazodis` = 'CDAE628CD0D895567383E1D093FDC897') - Successfully executed.

[15:43:03] >> mysql_store_result( Connection handle: 1 )

[15:43:03] CMySQLHandler::StoreResult() - Result was stored.

[15:43:03] >> mysql_retrieve_row( Connection handle: 1 )

[15:43:03] >> mysql_num_rows( Connection handle: 1 )

[15:43:03] CMySQLHandler::NumRows() - Returned 0 row(s)

[15:43:03] >> mysql_free_result( Connection handle: 1 )

[15:43:03] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:43:22] >> mysql_query( Connection handle: 1 )

[15:43:22] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Admin_Mantas' AND `Slaptazodis` = 'E488FDDB793ED0C40D8B2C7DB35ACFDD') - Successfully executed.

[15:43:22] >> mysql_store_result( Connection handle: 1 )

[15:43:22] CMySQLHandler::StoreResult() - Result was stored.

[15:43:22] >> mysql_retrieve_row( Connection handle: 1 )

[15:43:22] >> mysql_num_rows( Connection handle: 1 )

[15:43:22] CMySQLHandler::NumRows() - Returned 0 row(s)

[15:43:22] >> mysql_free_result( Connection handle: 1 )

[15:43:22] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:43:28] >> mysql_query( Connection handle: 1 )

[15:43:28] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Admin_Mantas' AND `Slaptazodis` = 'E488FDDB793ED0C40D8B2C7DB35ACFDD') - Successfully executed.

[15:43:28] >> mysql_store_result( Connection handle: 1 )

[15:43:28] CMySQLHandler::StoreResult() - Result was stored.

[15:43:28] >> mysql_retrieve_row( Connection handle: 1 )

[15:43:28] >> mysql_num_rows( Connection handle: 1 )

[15:43:28] CMySQLHandler::NumRows() - Returned 0 row(s)

[15:43:28] >> mysql_free_result( Connection handle: 1 )

[15:43:28] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:43:32] >> mysql_query( Connection handle: 1 )

[15:43:32] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Admin_Mantas' AND `Slaptazodis` = 'E337E89581212EEA08A329B176C0A406') - Successfully executed.

[15:43:32] >> mysql_store_result( Connection handle: 1 )

[15:43:32] CMySQLHandler::StoreResult() - Result was stored.

[15:43:32] >> mysql_retrieve_row( Connection handle: 1 )

[15:43:32] >> mysql_num_rows( Connection handle: 1 )

[15:43:32] CMySQLHandler::NumRows() - Returned 0 row(s)

[15:43:32] >> mysql_free_result( Connection handle: 1 )

[15:43:32] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:43:47] >> mysql_query( Connection handle: 1 )

[15:43:47] CMySQLHandler::Query(UPDATE 'zaidejai' SET `pos_X` = '132.000000', `pos_Y` = '-67.291419', pos_Z = '1.578125', `Patirtis` = '0', `PinigaiKiseneje` = '0' WHERE `Vardas` = 'Admin_Mantas') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''zaidejai' SET `pos_X` = '132.000000', `pos_Y` = '-67.291419', pos_Z = '1.578125' at line 1)

[15:43:47] >> mysql_query( Connection handle: 1 )

[15:43:47] CMySQLHandler::Query(UPDATE 'zaidejai' SET Lytis = '1' WHERE Vardas = 'Admin_Mantas') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''zaidejai' SET Lytis = '1' WHERE Vardas = 'Admin_Mantas'' at line 1)

[15:43:47] >> mysql_query( Connection handle: 1 )

[15:43:47] CMySQLHandler::Query(UPDATE zaidejai SET Ginklas0 = 0, Ammo0 = 0, Ginklas1 = 0, Ammo1 = 0, Ginklas2 = 0, Ammo2 = 0, Ginklas3 = 0, Ammo3 = 0, Ginklas4 = 0, Ammo4 = 0, Ginklas5 = 0, Ammo5 = 0, Ginklas6 = 0, Ammo6 = 0, Ginklas7 = 0, Ammo7 = 0, Ginklas8 = 0, Ammo8 = 0, Ginklas9 = 0, Ammo9 = 0, Ginklas10 = 0, Ammo10 = 0, Ginklas11 = 0, Ammo11 = 0 WHERE Vardas = 'Admin_Mantas') - Successfully executed.

Logas

[bebras]

Tau jau beveik pavyko, nepasiduok! Beliko parodyti Pawn kodą kuriame formatuoji ir siunti užklausas kurios sukelia klaidas.

[Nelixus]

Tau jau beveik pavyko, nepasiduok! Beliko parodyti Pawn kodą kuriame formatuoji ir siunti užklausas kurios sukelia klaidas.

Taiva tame dalykas ir yra nzn kur klaida

[bebras]

UPDATE 'zaidejai' SET `pos_X` = '0.000000', `pos_Y` = '0.000000', pos_Z = '-66.042526', `Patirtis` = '0', `PinigaiKiseneje` = '0' WHERE `Vardas` = 'Admin_Mantas')

Šioje užklausoje, klaida yra tai, kad lentelės pavadinimas pažymėtas viengubomis kabutėmis, o ne simboliu `.(tiesą sakant šiuo atveju nei vienų nereikia)

 

 

Ai... Visur ta pati bėda. 

[Nelixus]

UPDATE 'zaidejai' SET `pos_X` = '0.000000', `pos_Y` = '0.000000', pos_Z = '-66.042526', `Patirtis` = '0', `PinigaiKiseneje` = '0' WHERE `Vardas` = 'Admin_Mantas')

Šioje užklausoje, klaida yra tai, kad lentelės pavadinimas pažymėtas viengubomis kabutėmis, o ne simboliu `.(tiesą sakant šiuo atveju nei vienų nereikia)

 

 

Ai... Visur ta pati bėda. 

 

Tai kaip ir perkur sutvarkyti klaidą?

Susitvarkiau galit temą rakinti