1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Help Archive

Linear Mode
mysql server problem
pantelimonfl
Huge Clucker
****
Posts: 312
Threads: 50
Joined: Jul 2010
Reputation: 0
#7

20.07.2011, 20:29
The new debug.txt
Код:
[23:32:05]  

[23:32:05] ---------------------------

[23:32:05] MySQL Debugging activated (07/20/11)

[23:32:05] ---------------------------

[23:32:05]  

[23:32:05] >> mysql_connect( )

[23:32:05] CMySQLHandler::CMySQLHandler() - constructor called.

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

[23:32:05] CMySQLHandler::Connect() - Connection was successful.

[23:32:05] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[23:32:05] >> mysql_ping( Connection handle: 1 )

[23:32:05] CMySQLHandler::Ping() - Connection is still alive.

[23:32:32] >> mysql_ping( Connection handle: 1 )

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

[23:32:32] >> mysql_real_escape_string( Connection handle: 1 )

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

[23:32:32] >> mysql_query( Connection handle: 1 )

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

[23:32:32] >> mysql_store_result( Connection handle: 1 )

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

[23:32:32] >> mysql_num_rows( Connection handle: 1 )

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

[23:32:32] >> mysql_fetch_row_format( Connection handle: 1 )

[23:32:32] CMySQLHandler::FetchRow() - Return: 1

[23:32:32] >> mysql_query( Connection handle: 1 )

[23:32:32] 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:32:32] >> mysql_store_result( Connection handle: 1 )

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

[23:32:32] >> mysql_fetch_row_format( Connection handle: 1 )

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

[23:32:35] >> mysql_ping( Connection handle: 1 )

[23:32:35] CMySQLHandler::Ping() - Connection is still alive.

[23:32:35] >> mysql_query( Connection handle: 1 )

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

[23:32:35] >> mysql_store_result( Connection handle: 1 )

[23:32:35] CMySQLHandler::StoreResult() - Result was stored.

[23:32:35] >> mysql_fetch_row_format( Connection handle: 1 )

[23:32:35] CMySQLHandler::FetchRow() - Return: asd

[23:32:38] >> mysql_ping( Connection handle: 1 )

[23:32:38] CMySQLHandler::Ping() - Connection is still alive.

[23:32:38] >> mysql_query( Connection handle: 1 )

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

[23:32:38] >> mysql_store_result( Connection handle: 1 )

[23:32:38] CMySQLHandler::StoreResult() - Result was stored.

[23:32:38] >> mysql_fetch_row_format( Connection handle: 1 )

[23:32:38] CMySQLHandler::FetchRow() - Return: asd

[23:32:38] >> mysql_query( Connection handle: 1 )

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

[23:32:39] >> mysql_store_result( Connection handle: 1 )

[23:32:39] CMySQLHandler::StoreResult() - Result was stored.

[23:32:39] >> mysql_num_rows( Connection handle: 1 )

[23:32:39] CMySQLHandler::NumRows() - Returned 1 row(s)

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Level") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Money") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Admin") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Vip") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Pos_x") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Pos_y") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Pos_z") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Carkey") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Carkey2") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Carkey3") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Fcarkey") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Health") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Respect") - 

[23:32:39] >> mysql_fetch_row_format( Connection handle: 1 )

[23:32:39] 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:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Mask") - 0

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Maskuse") - 0

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Leader") - 0

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Member") - 0

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Char") - 0

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Int") - 0

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("VirWorld") - 0

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Walkie") - 0

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Walkiefreq") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Lock") - 0

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Ban Reason") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Lock Date") - 0000-00-00

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Locked By") - 

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Tut") - 0

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Sex") - 0

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Origin") - 0

[23:32:39] >> mysql_fetch_field_row( Connection handle: 1 )

[23:32:39] CMySQLHandler::FetchField("Age") - 0

[23:32:39] >> mysql_free_result( Connection handle: 1 )

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

[23:32:52] >> mysql_ping( Connection handle: 1 )

[23:32:52] CMySQLHandler::Ping() - Connection is still alive.

[23:32:52] >> mysql_real_escape_string( Connection handle: 1 )

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

[23:32:52] >> mysql_query( Connection handle: 1 )

[23:32:52] CMySQLHandler::Query(UPDATE players SET Password='a',Level=0,Money=0,Admin=0,Vip=0,Pos_x=1120486209,Pos_y=-1038322018,Pos_z=1067397641,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:32:52] >> mysql_query( Connection handle: 1 )

[23:32:52] 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:32:57] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[23:32:57] CMySQLHandler::FreeResult() - The result is already empty.

[23:32:57] CMySQLHandler::Disconnect() - Connection was closed.
Find
Reply
« Next Oldest | Next Newest »


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: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Help Archive