Jump to content
  • 0

Erori mysql_log


Punct.

Question

: Punct.

Problema: Primesc cateva erori in mysql_log cand opresc serverul SA:MP.

Erori / warnings:

[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='-185.539993', `MinY`='-2255.850098', `MaxY`='48.820000' WHERE `ID`='1'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='-70.309998', `MinY`='-2154.290039', `MaxY`='212.889999' WHERE `ID`='2'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='-68.349998', `MinY`='-2003.900024', `MaxY`='117.180000' WHERE `ID`='3'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='-291.010010', `MinY`='-2005.849976', `MaxY`='-68.349998' WHERE `ID`='4'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='46.869999', `MinY`='-2703.120117', `MaxY`='292.959991' WHERE `ID`='5'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='48.820000', `MinY`='-2416.010010', `MaxY`='169.919998' WHERE `ID`='6'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='-64.449997', `MinY`='-2597.649902', `MaxY`='48.820000' WHERE `ID`='7'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='-201.169998', `MinY`='-2417.959961', `MaxY`='50.779999' WHERE `ID`='8'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='-199.210007', `MinY`='-2599.600098', `MaxY`='-62.500000' WHERE `ID`='9'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='169.899994', `MinY`='-2542.959961', `MaxY`='292.959991' WHERE `ID`='10'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='292.959991', `MinY`='-2699.209961', `MaxY`='470.700012' WHERE `ID`='11'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='292.959991', `MinY`='-2546.870117', `MaxY`='470.700012' WHERE `ID`='12'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='714.840027', `MinY`='-2523.429932', `MaxY`='814.450012' WHERE `ID`='13'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='814.450012', `MinY`='-2525.389893', `MaxY`='908.200012' WHERE `ID`='14'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='908.200012', `MinY`='-2525.389893', `MaxY`='1015.619995' WHERE `ID`='15'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='716.750000', `MinY`='-2382.810059', `MaxY`='917.960022' WHERE `ID`='16'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='923.820007', `MinY`='-2138.669922', `MaxY`='1103.510010' WHERE `ID`='17'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='742.179993', `MinY`='-2138.669922', `MaxY`='925.780029' WHERE `ID`='18'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='570.309998', `MinY`='-2000.010010', `MaxY`='744.140015' WHERE `ID`='19'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='744.140015', `MinY`='-2001.949951', `MaxY`='966.789978' WHERE `ID`='20'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='613.280029', `MinY`='-1708.979980', `MaxY`='738.280029' WHERE `ID`='21'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='851.559998', `MinY`='-1890.619995', `MaxY`='1089.839966' WHERE `ID`='22'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='738.280029', `MinY`='-1802.729980', `MaxY`='853.510010' WHERE `ID`='23'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='853.510010', `MinY`='-1710.930054', `MaxY`='1111.319946' WHERE `ID`='24'' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='1103.510010', `MinY`='-2142.570068', `MaxY`='1281.250000' WHERE `ID`='25' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='1173.819946', `MinY`='-1878.900024', `MaxY`='1281.250000' WHERE `ID`='26' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='1111.319946', `MinY`='-1712.890015', `MaxY`='1281.250000' WHERE `ID`='27' at line 1
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`MaxX`='412.100006', `MinY`='-1847.650024', `MaxY`='617.179993' WHERE `ID`='28'' at line 1

Lini/script:

[pawn]

public OnGameModeExit()

{

//...

STeri();

//...

    return 1;

}

/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/

/*                  * TERI *   */

/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/

public LTeri()

{

new Rows, Fields, t=0, ax=0, nrt;

cache_get_data(Rows, Fields, mysql);

if(Rows)

{

for(; t != Rows; ++t, ax = 0)

{

if ( t >= 29 ) {

printf( " !ERROR! Numarul de teritorii depaseste numarul maxim !ERROR!" ) ;

break ;

}

TeriInfo[t][zID] = cache_get_row_int(t, ax++, mysql) ;

TeriInfo[t][zOwned] = cache_get_row_int(t, ax++, mysql) ;

TeriInfo[t][zMinX] = cache_get_row_float(t, ax++, mysql) ;

TeriInfo[t][zMaxX] = cache_get_row_float(t, ax++, mysql) ;

TeriInfo[t][zMinY] = cache_get_row_float(t, ax++, mysql) ;

TeriInfo[t][zMaxY] = cache_get_row_float(t, ax++, mysql) ;

ter[t] = GangZoneCreateEx(TeriInfo[t][zMinX], TeriInfo[t][zMaxX], TeriInfo[t][zMinY], TeriInfo[t][zMaxY], t, 0.7);

nrt++;

}

}

printf("* Total Teritorii War: %d", nrt);

return 1;

}

public STeri()

{

for(new t=0; t<teritoriii; t++)

{

mysql_format(mysql, query, sizeof(query), "UPDATE `teritorii` SET `Owned`='%d', `MinX`='%f' `MaxX`='%f', `MinY`='%f', `MaxY`='%f' WHERE `ID`='%d'",

TeriInfo[t][zOwned], TeriInfo[t][zMinX], TeriInfo[t][zMaxX], TeriInfo[t][zMinY], TeriInfo[t][zMaxY], TeriInfo[t][zID]);

mysql_tquery(mysql, query, "", "");

}

return 1;

}

[/pawn]

Ai incercat sa rezolvi singur ?: Da. Aveam si la case aceeasi problema, dar s-a rezolvat.

Nu mai deschideti in pu*a mea servere de SA:MP !

Jucati-va pe cele care sunt !   Sunt suficiente !

Reguli de bun simt:

1. Nu faceti reclama unde nu trebuie !

2. Nu injurati ca la usa cortului !

3. Daca esti analfabeti, taci din gura !

4. Nu abuza de 'scuze', 'din greseala' !

 

My work ::: http://pastebin.com/VRNRcaAs

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Rezolvat!

Am uitat o " , "

Nu mai deschideti in pu*a mea servere de SA:MP !

Jucati-va pe cele care sunt !   Sunt suficiente !

Reguli de bun simt:

1. Nu faceti reclama unde nu trebuie !

2. Nu injurati ca la usa cortului !

3. Daca esti analfabeti, taci din gura !

4. Nu abuza de 'scuze', 'din greseala' !

 

My work ::: http://pastebin.com/VRNRcaAs

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.