Problem with MYSQL
#1

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] ---------------------------
Reply
#2

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.
Reply
#3

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?
Reply
#4

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
Reply


Forum Jump:


Users browsing this thread: