[MySQL] Loading cars problem... Help me please

[MySQL] Loading cars problem... Help me please - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: [MySQL] Loading cars problem... Help me please (/showthread.php?tid=190454)

[SOLVED][MySQL] Loading cars problem... Help me please - Emanuelll - 15.11.2010

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

Re: [MySQL] Loading cars problem... Help me please - Cameltoe - 15.11.2010

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

)

Re: [MySQL] Loading cars problem... Help me please - Emanuelll - 15.11.2010

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...

Re: [MySQL] Loading cars problem... Help me please - playbox12 - 15.11.2010

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

Re: [MySQL] Loading cars problem... Help me please - Miguel - 15.11.2010

pawn Code:

if(mysql_fetch_row_format(Data,"|"))

Should be:

pawn Code:

if(mysql_retrieve_row())

Re: [MySQL] Loading cars problem... Help me please - Emanuelll - 15.11.2010

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..