SA-MP Forums Archive
runtime error mysql +Rep - 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)
+--- Thread: runtime error mysql +Rep (/showthread.php?tid=571887)


runtime error mysql +Rep - iBots - 23.04.2015

well,i have made a command to store 800 things in the database using a loop,i mean i used the command to insert 800 things,when i type the command it does around 562 and stops and shows runtime error,why?
pawn Код:
CMD:test(playerid)
{
    new query[168];
    for(new n = 0; n < 750; n++)
    {
                        mysql_format(dbHandle, query, sizeof(query), "INSERT INTO `thing` \
                        (`num`, `crea`, `done`, `amount`, `gun1`, `gun2`, `gun3`, `gun4`, `gun5`, `gun6`, `gun7`, `gun8`, `gun9`, `valid`) \
                        VALUES (%d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d)", n, info[1][num][n], info[1][num2][n], info[1][num3][n], info[1][num4][n], 0info[1][num5][n] info[1][num6][n], info[1][num7][n], info[1][num8][n], info[1][num9][n], info[1][num10][n], info[1][num11][n], info[1][num12][n], info[1][num13][n]);
                        mysql_tquery(mysql, query, "", "");
    }
    return 1;
}
NOTE:I used packed string for the enum of this system

Re : runtime error mysql +Rep - Golimad - 23.04.2015

show the enum

Re: runtime error mysql +Rep - AberKane - 23.04.2015

Probably there's a data that it is not sent correctly or that doesn't match.
If i were you i would tighten my search area, and just try to find the number of that precise data and then check.
And the MySQL log please.