Weird MySQL issue !!
#1

FIXED ! IT WAS A SSCANF ISSUE !
Reply
#2

do never use SELECT *, because if you have an large number of columns into your table, the plugin will mess the data while storing it into variables.

select only the fields you will use in the code and see if this problem keeps ocurring, but keep in mind that it is only a hint for the problem solution, I don't know if the problem is related to the data storage, I am just telling you how I solve an problem similar to this one.
Reply
#3

Quote:
Originally Posted by Mandrakke
Посмотреть сообщение
do never use SELECT *, because if you have an large number of columns into your table, the plugin will mess the data while storing it into variables.

select only the fields you will use in the code and see if this problem keeps ocurring, but keep in mind that it is only a hint for the problem solution, I don't know if the problem is related to the data storage, I am just telling you how I solve an problem similar to this one.
I know as owner that he selects not more then 20 rows, because there are each 20 cars in each map.
Reply
#4

The problem has not to do with rows returned, it is an cols number issue, no matter how many rows the query returns.

just make a test, tests usually don't bite;
Код:
SELECT model, Xpos, Ypos, Zpos, Apos, Col1, Col2, Delay FROM `Car_MapSubmits` WHERE MapName = '%s'
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)