[Emanuelll]

Hello.. i'm using MySQL Plugin R5 by G-sTyLeZzZ and i wanna create some personal car.. and i cannot read the cars from mysql.. can some one help me?


compile 0 errors, 0 warning..



does the script crash the connection?why?
where is the mistake?


i make in mysql table from id 0 and 1.. and the problem was seem..



sorry for my english

[Cameltoe]

for(new idx = 184; idx < 185; idx++) // Look here )

[Emanuelll]

Quote:

Originally Posted by Cameltoe for(new idx = 184; idx < 185; idx++) // Look here )

sorry.. i copied wrong from gm.. error isn't there


i belive that the problem is

Code:

 if(mysql_fetch_row_format(Data,"|"))

or in this code because if you see the server.log result of this expresion is false mysql_fetch_row_format(Data,"|") and.. it should be true

you can see the table in mysql.. (the coordonates weren't set yet)


sorry for my english...

[playbox12]

Coordinates should be a float, in the mysql table aswell!

[Miguel]

pawn Code:

if(mysql_fetch_row_format(Data,"|"))

Should be:

pawn Code:

if(mysql_retrieve_row())

[Emanuelll]

Code:

[05:54:02] MYSQL: Connection seems dead, retrying...
[05:54:02] MYSQL: Could not reconnect to server, terminating server...
[05:54:02] passed 01
[05:54:02] passed 02
[05:54:02] passed 04
[05:54:02] passed 02
[05:54:02] passed 04
[05:54:02] passed 02

error was in public MySQLCheckConnection() or i don't know where.. but now loadcars works...

second problem is that cannot read from variables that stores strings

code from mysql_log.txt

Code:

 [08:06:27] CMySQLHandler::Query(SELECT Owner FROM cars WHERE id = 184 LIMIT 1) - An error has occured. (Error ID: 1054, Unknown column 'Owner' in 'field list')

edit:

solved error.. i wrote an error code in mysql column... cOwner instead Owner..

i'm newbie but i try to learn

thank you so muck...


sorry for my english..