Problem with MYSQL - Printable Version

Problem with MYSQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Problem with MYSQL (/showthread.php?tid=360418)

Problem with MYSQL - Parka - 17.07.2012

hello friends i need know because the system give me this error

[03:04:38] ---------------------------

[03:04:38] MySQL Debugging activated (07/17/12)

[03:04:38] ---------------------------

[03:04:38]

[03:04:38] >> mysql_connect( )

[03:04:38] CMySQLHandler::CMySQLHandler() - constructor called.

[03:04:38] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "test" | Username: "root" ...

[03:04:38] CMySQLHandler::Connect() - Connection was successful.

[03:04:38] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[03:04:38] >> mysql_ping( Connection handle: 1 )

[03:04:38] CMySQLHandler::Ping() - Connection is still alive.

[03:04:59] >> mysql_query( Connection handle: 1 )

[03:05:00] CMySQLHandler::Query(SELECT `Nombre` FROM `Usuario` WHERE `Nombre` = `[FADE]EL_PARKA`) - An error has occured. (Error ID: 1054, Unknown column '[FADE]EL_PARKA' in 'where clause')

[03:05:00] >> mysql_store_result( Connection handle: 1 )

[03:05:00] CMySQLHandler::StoreResult() - No data to store.

[03:05:00] >> mysql_num_rows( Connection handle: 1 )

[03:05:00] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[03:05:00] >> mysql_free_result( Connection handle: 1 )

[03:05:00] CMySQLHandler::FreeResult() - The result is already empty.

[03:05:33] >> mysql_close( Connection handle: 1 )

[03:05:33] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[03:05:33] CMySQLHandler::FreeResult() - The result is already empty.

[03:05:33] CMySQLHandler:

isconnect() - Connection was closed.

[03:05:33] ---------------------------

[03:05:33] MySQL Debugging de-activated

[03:05:33] ---------------------------

Re: Problem with MYSQL - Vince - 17.07.2012

PHP код:



[03:05:00] CMySQLHandler::Query(SELECT `Nombre` FROM `Usuario` WHERE `Nombre` = `[FADE]EL_PARKA`) - An error has occured. (Error ID: 1054, Unknown column '[FADE]EL_PARKA' in 'where clause')

How hard could it possibly be to just read what it says?! Values need to be wrapped in normal single quotes, not backticks.

Respuesta: Re: Problem with MYSQL - Parka - 17.07.2012

Quote:

Originally Posted by Vince

PHP код:



[03:05:00] CMySQLHandler::Query(SELECT `Nombre` FROM `Usuario` WHERE `Nombre` = `[FADE]EL_PARKA`) - An error has occured. (Error ID: 1054, Unknown column '[FADE]EL_PARKA' in 'where clause')

How hard could it possibly be to just read what it says?! Values need to be wrapped in normal single quotes, not backticks.

sorry I'm new language learning mysql as I do that?

Respuesta: Problem with MYSQL - Parka - 17.07.2012

PHP код:



[12:59:24] ---------------------------

[12:59:24] MySQL Debugging activated (07/17/12)

[12:59:24] ---------------------------

[12:59:24]  

[12:59:24] >> mysql_connect( )

[12:59:24] CMySQLHandler::CMySQLHandler() - constructor called.

[12:59:24] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "test" | Username: "root" ...

[12:59:24] CMySQLHandler::Connect() - Connection was successful.

[12:59:24] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[12:59:24] >> mysql_ping( Connection handle: 1 )

[12:59:24] CMySQLHandler::Ping() - Connection is still alive.

[12:59:49] >> mysql_query( Connection handle: 1 )

[12:59:49] CMySQLHandler::Query(SELECT Nombre FROM Usuario WHERE Nombre = [FADE]EL_PARKA) - 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 '[FADE]EL_PARKA' at line 1)

[12:59:49] >> mysql_store_result( Connection handle: 1 )

[12:59:49] CMySQLHandler::StoreResult() - No data to store.

[12:59:49] >> mysql_num_rows( Connection handle: 1 )

[12:59:49] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[12:59:49] >> mysql_free_result( Connection handle: 1 )

[12:59:49] CMySQLHandler::FreeResult() - The result is already empty.

[12:59:52] >> mysql_query( Connection handle: 1 )

[12:59:52] CMySQLHandler::Query(INSERT INTO Usuario (Nombre, Clave, Nivel, Kills, Deaths) VALUES ([FADE]EL_PARKA,12345,0,0,0)) - 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 '[FADE]EL_PARKA,12345,0,0,0)' at line 1)

[12:59:55] >> mysql_query( Connection handle: 1 )

[12:59:55] CMySQLHandler::Query(UPDATE Usuario SET Nivel=0,Kills=0,Deaths=0 WHERE Nombre= [FADE]EL_PARKA  ) - 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 '[FADE]EL_PARKA' at line 1)

[13:00:05] >> mysql_close( Connection handle: 1 )

[13:00:05] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[13:00:05] CMySQLHandler::FreeResult() - The result is already empty.

[13:00:05] CMySQLHandler::Disconnect() - Connection was closed.

[13:00:05] ---------------------------

[13:00:05] MySQL Debugging de-activated

[13:00:05] ---------------------------

take away the accents and still the same