sql error - Printable Version

sql error - 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: sql error (/showthread.php?tid=249034)

sql error - Gh0sT_ - 16.04.2011

What that mysql error means?

pawn Код:

An error has occured. (Error ID: 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

Re: sql error - WackoX - 16.04.2011

That you have an error in your syntax?

Re: sql error - Gh0sT_ - 17.04.2011

But where?

The line is

pawn Код:

format( Query, 560, "INSERT INTO `zaidejudb` `Vardas` = '%s', `Slaptazodis` = '%s', `IP` = '%s' WHERE `Vardas` = '%s'", EscapeName( playerid ), inputtext, GetPlayerIpEx( playerid ), EscapeName( playerid ) );
            mysql_query( Query );

Re: sql error - playbox12 - 17.04.2011

Its

pawn Код:

INSERT INTO `table` (`row1`, `other rows`) VALUES ('%s', '%s')

Judging what you're trying to do is updating a certain table

pawn Код:

UPDATE `table` SET `row1` = '%s', `other rows` = '%s' WHERE `condition` = '%s'

Re: sql error - Gh0sT_ - 17.04.2011

Thanks. >.>

And now syntax error here

pawn Код:

format( Query, 750, "UPDATE `namudb` SET `IsejimasX` = '%f', `IsejimasY` = '%f', `IsejimasZ` = '%f', `IeimasX` = '%f', `IeimasY` = '%f', `IeimasZ` = '%f', `Parduodamas` = '%i', `Uzrakintas` = '%i', `Raktai` = '%i' WHERE `SQL` = '%d'",
        NamuDB[ hID ][ hIsejimas ][ 0 ], NamuDB[ hID ][ hIsejimas ][ 1 ], NamuDB[ hID ][ hIsejimas ][ 2 ], NamuDB[ hID ][ hIeimas ][ 0 ], NamuDB[ hID ][ hIeimas ][ 1 ], NamuDB[ hID ][ hIeimas ][ 2 ], NamuDB[ hID ][ hParduodamas ], NamuDB[ hID ][ hUzrakintas ], NamuDB[ hID ][ hRaktai ], NamuDB[ hID ][ hNamoID ] );
        mysql_query( Query );
        format( Query, 500, "UPDATE `namudb` SET `Savininkas` = '%s', `RaktuSavininkas` = '%s', `Interior` = '%d', `NamoID` = '%d', `PadetiPinigai` = '%d', `Kaina` = '%d` WHERE `SQL` = '%d'", NamuDB[ hID ][ hSavininkas ], NamuDB[ hID ][ hRSavininkas ], NamuDB[ hID ][ hInterior ], NamuDB[ hID ][ hNamoID ], NamuDB[ hID ][ hPinigai ], NamuDB[ hID ][ hKaina ], NamuDB[ hID ][ hNamoID ] );
        mysql_query( Query );

Re: sql error - playbox12 - 17.04.2011

What and where is the error?

Re: sql error - Gh0sT_ - 17.04.2011

mysql_log:

pawn Код:

[14:37:31] CMySQLHandler::Query(SELECT * FROM `zaidejudb` WHERE `Vardas` = 'Raimis_R') - Successfully executed.

[14:37:31] >> mysql_store_result( Connection handle: 1 )

[14:37:31] CMySQLHandler::StoreResult() - Result was stored.

[14:37:31] >> mysql_fetch_row_format( Connection handle: 1 )

[14:37:31] >> mysql_free_result( Connection handle: 1 )

[14:37:31] CMySQLHandler::FreeResult() - Result was successfully free'd.

[14:52:06] >> mysql_query( Connection handle: 1 )

[14:52:06] CMySQLHandler::Query(UPDATE `namudb` SET `IsejimasX` = '-2646.763916', `IsejimasY` = '-26.979505', `IsejimasZ` = '6.132812', `IeimasX` = '-42.452201', `IeimasY` = '1405.485351', `IeimasZ` = '1084.429565', `Parduodamas` = '0', `Uzrakintas` = '1', `Raktai` = '0' WHERE `SQL` = '1') - Successfully executed.

[14:52:06] >> mysql_query( Connection handle: 1 )

[14:52:06] CMySQLHandler::Query(UPDATE `namudb` SET `Savininkas` = 'AndriusZ', `RaktuSavininkas` = 'NERA', `Interior` = '0', `NamoID` = '1', `PadetiPinigai` = '0', `Kaina` = '110000` WHERE `SQL` = '1') - An error has occured. (Error ID: 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 '1'' at line 1)

[14:52:06] >> mysql_close( Connection handle: 1 )

[14:52:06] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[14:52:06] CMySQLHandler::Disconnect() - Connection was closed.

lines

pawn Код:

format( Query, 750, "UPDATE `namudb` SET `IsejimasX` = '%f', `IsejimasY` = '%f', `IsejimasZ` = '%f', `IeimasX` = '%f', `IeimasY` = '%f', `IeimasZ` = '%f', `Parduodamas` = '%i', `Uzrakintas` = '%i', `Raktai` = '%i' WHERE `SQL` = '%d'",
        NamuDB[ hID ][ hIsejimas ][ 0 ], NamuDB[ hID ][ hIsejimas ][ 1 ], NamuDB[ hID ][ hIsejimas ][ 2 ], NamuDB[ hID ][ hIeimas ][ 0 ], NamuDB[ hID ][ hIeimas ][ 1 ], NamuDB[ hID ][ hIeimas ][ 2 ], NamuDB[ hID ][ hParduodamas ], NamuDB[ hID ][ hUzrakintas ], NamuDB[ hID ][ hRaktai ], NamuDB[ hID ][ hNamoID ] );
        mysql_query( Query );
        format( Query, 500, "UPDATE `namudb` SET `Savininkas` = '%s', `RaktuSavininkas` = '%s', `Interior` = '%d', `NamoID` = '%d', `PadetiPinigai` = '%d', `Kaina` = '%d` WHERE `SQL` = '%d'", NamuDB[ hID ][ hSavininkas ], NamuDB[ hID ][ hRSavininkas ], NamuDB[ hID ][ hInterior ], NamuDB[ hID ][ hNamoID ], NamuDB[ hID ][ hPinigai ], NamuDB[ hID ][ hKaina ], NamuDB[ hID ][ hNamoID ] );
        mysql_query( Query );

Re: sql error - Gh0sT_ - 17.04.2011

bump

Re: sql error - iJumbo - 17.04.2011

look here

`Kaina` = '110000` <<< you have put a `

Re: sql error - Gh0sT_ - 17.04.2011

Thanks you! Im so blind XD

Now problem with house system :/

I have house cmd, with checking.. Its always returning 0 (It means that I dont have house)

Lines:

(When player wants to buy a house):

pawn Код:

ZaidejuDB[ playerid ][ pPNamas ] = ID;

ID is foreach loop

When player buys a house:

pawn Код:

ZaidejuDB[ playerid ][ pNamas ] = ZaidejuDB[ playerid ][ pPNamas ];

Command:

pawn Код:

CMD:namas( playerid, params[ ] )
{
    if( ZaidejuDB[ playerid ][ pNamas ] == 0 || ZaidejuDB[ playerid ][ pRaktai ] == 0 ) return SendClientMessage( playerid, -1, "{FFFFFF}[ {FFFF00}INFORMACIJA {FFFFFF}]: Jыs {FF0000}neturite {FFFFFF}namo" );
    ShowPlayerDialog( playerid, HOUSE_MENU, DIALOG_STYLE_LIST, "{FFFFFF}Namo funkcijos", "{FFFF00}Funkcijos, kurias naudoti galima tik name\n{FFFF00}Kitos funkcijos", "Rinktis", "Uюdaryti" );
    return true;
}

I have tried to add prints and its returning house id. (NOT 0 like command)