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

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

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

Quote:
Originally Posted by Cameltoe
View Post
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...
Reply
#4

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

pawn Code:
if(mysql_fetch_row_format(Data,"|"))
Should be:
pawn Code:
if(mysql_retrieve_row())
Reply
#6

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


Forum Jump:


Users browsing this thread: 1 Guest(s)