mysql server problem
#9

The new
Код:
[23:49:16]  

[23:49:16] ---------------------------

[23:49:16] MySQL Debugging activated (07/20/11)

[23:49:16] ---------------------------

[23:49:16]  

[23:49:16] >> mysql_connect( )

[23:49:16] CMySQLHandler::CMySQLHandler() - constructor called.

[23:49:16] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp" | Username: "root" ...

[23:49:16] CMySQLHandler::Connect() - Connection was successful.

[23:49:16] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[23:49:16] >> mysql_ping( Connection handle: 1 )

[23:49:16] CMySQLHandler::Ping() - Connection is still alive.

[23:49:55] >> mysql_ping( Connection handle: 1 )

[23:49:55] CMySQLHandler::Ping() - Connection is still alive.

[23:49:55] >> mysql_real_escape_string( Connection handle: 1 )

[23:49:55] CMySQLHandler::EscapeString(Larry_Dee); - Escaped 9 characters to Larry_Dee.

[23:49:55] >> mysql_query( Connection handle: 1 )

[23:49:55] CMySQLHandler::Query(SELECT `id` FROM `players` WHERE LOWER(Name) = LOWER('Larry_Dee') LIMIT 1) - Successfully executed.

[23:49:55] >> mysql_store_result( Connection handle: 1 )

[23:49:55] CMySQLHandler::StoreResult() - Result was stored.

[23:49:55] >> mysql_num_rows( Connection handle: 1 )

[23:49:55] CMySQLHandler::NumRows() - Returned 1 row(s)

[23:49:55] >> mysql_fetch_row_format( Connection handle: 1 )

[23:49:55] CMySQLHandler::FetchRow() - Return: 1

[23:49:55] >> mysql_query( Connection handle: 1 )

[23:49:55] CMySQLHandler::Query(SELECT Lock FROM `players` WHERE id = 1 LIMIT 1) - 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 'Lock FROM `players` WHERE id = 1 LIMIT 1' at line 1)

[23:49:55] >> mysql_store_result( Connection handle: 1 )

[23:49:55] CMySQLHandler::StoreResult() - No data to store.

[23:49:55] >> mysql_fetch_row_format( Connection handle: 1 )

[23:49:55] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[23:49:57] >> mysql_ping( Connection handle: 1 )

[23:49:57] CMySQLHandler::Ping() - Connection is still alive.

[23:49:57] >> mysql_query( Connection handle: 1 )

[23:49:57] CMySQLHandler::Query(SELECT Password FROM `players` WHERE id = 1 LIMIT 1) - Successfully executed.

[23:49:57] >> mysql_store_result( Connection handle: 1 )

[23:49:57] CMySQLHandler::StoreResult() - Result was stored.

[23:49:57] >> mysql_fetch_row_format( Connection handle: 1 )

[23:49:57] CMySQLHandler::FetchRow() - Return: asd

[23:49:57] >> mysql_query( Connection handle: 1 )

[23:49:57] CMySQLHandler::Query(SELECT * FROM `players`) - Successfully executed.

[23:49:57] >> mysql_store_result( Connection handle: 1 )

[23:49:57] CMySQLHandler::StoreResult() - Result was stored.

[23:49:57] >> mysql_num_rows( Connection handle: 1 )

[23:49:57] CMySQLHandler::NumRows() - Returned 1 row(s)

[23:49:57] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:57] CMySQLHandler::FetchField("Level") - 

[23:49:57] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:57] CMySQLHandler::FetchField("Money") - 

[23:49:57] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Admin") - 

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Vip") - 

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Pos_x") - 

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Pos_y") - 

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Pos_z") - 

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Carkey") - 

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Carkey2") - 

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Carkey3") - 

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Fcarkey") - 

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Health") - 

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Respect") - 

[23:49:58] >> mysql_fetch_row_format( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchRow() - Return: 1|larry_dee|asd|3|5000000|10|0|111.805|-78.8418|2|0|0|0|0|0|0|0|0|0|0|100|0|0|0|0|0||0000-00-00||0|0|0|0

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Mask") - 0

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Maskuse") - 0

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Leader") - 0

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Member") - 0

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Char") - 0

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Int") - 0

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("VirWorld") - 0

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Walkie") - 0

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Walkiefreq") - 

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Lock") - 0

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Ban Reason") - 

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Lock Date") - 0000-00-00

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Locked By") - 

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Tut") - 0

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Sex") - 0

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Origin") - 0

[23:49:58] >> mysql_fetch_field_row( Connection handle: 1 )

[23:49:58] CMySQLHandler::FetchField("Age") - 0

[23:49:58] >> mysql_free_result( Connection handle: 1 )

[23:49:58] CMySQLHandler::FreeResult() - Result was successfully free'd.

[23:50:18] >> mysql_ping( Connection handle: 1 )

[23:50:18] CMySQLHandler::Ping() - Connection is still alive.

[23:50:18] >> mysql_real_escape_string( Connection handle: 1 )

[23:50:18] CMySQLHandler::EscapeString(a); - Escaped 1 characters to a.

[23:50:18] >> mysql_query( Connection handle: 1 )

[23:50:18] CMySQLHandler::Query(UPDATE `players` SET Password='a',Level=0,Money=0,Admin=0,Vip=0,Pos_x=1110290096,Pos_y=1115890745,Pos_z=1076627572,Carkey=0,Carkey2=0,Carkey3=0,Fcarkey=0,Leader=0,Member=0,Rank=0,Char=0,VirWorld=0,Int=0,Health=1120403456 WHERE id=1) - 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 'Char=0,VirWorld=0,Int=0,Health=1120403456 WHERE id=1' at line 1)

[23:50:18] >> mysql_query( Connection handle: 1 )

[23:50:18] CMySQLHandler::Query(UPDATE `players` SET Mask=0,Maskuse=0,Walkie=0,Wtfreq=0,Lock=0,Ban Reason=0,Lock Date=0,Locked By=0,Tut=0,Sex=0,Origin=0,Age=0 WHERE id=1) - 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 'Lock=0,Ban Reason=0,Lock Date=0,Locked By=0,Tut=0,Sex=0,Origin=0,Age=0 WHERE id=' at line 1)

[23:50:24] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[23:50:24] CMySQLHandler::FreeResult() - The result is already empty.

[23:50:24] CMySQLHandler::Disconnect() - Connection was closed.
Reply


Messages In This Thread
mysql server problem - by pantelimonfl - 20.07.2011, 16:44
Re: mysql server problem - by Hal - 20.07.2011, 19:05
Re: mysql server problem - by pantelimonfl - 20.07.2011, 19:08
Re: mysql server problem - by Grim_ - 20.07.2011, 19:11
Re: mysql server problem - by pantelimonfl - 20.07.2011, 20:13
Re: mysql server problem - by Grim_ - 20.07.2011, 20:23
Re: mysql server problem - by pantelimonfl - 20.07.2011, 20:29
Re: mysql server problem - by Grim_ - 20.07.2011, 20:37
Re: mysql server problem - by pantelimonfl - 20.07.2011, 20:45
Re: mysql server problem - by Grim_ - 20.07.2011, 20:54
Re: mysql server problem - by pantelimonfl - 20.07.2011, 21:43
Re: mysql server problem - by pantelimonfl - 21.07.2011, 09:20

Forum Jump:


Users browsing this thread: 4 Guest(s)