mysql table bug - Printable Version

mysql table bug - 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: mysql table bug (/showthread.php?tid=303652)

mysql table bug - juraska - 14.12.2011

Code:

[10:55:09] CMySQLHandler::Query(DELETE FROM `vehiclesdata` WHERE `vID` = 1) - An error has occured. (Error ID: 1146, Table 'test.vehiclesdata' doesn't exist)

Corectly are write, that delete from `vehiclesdata`
but why i've got this error
An error has occured. (Error ID: 1146, Table 'test.vehiclesdata' doesn't exist)
Although in query are write that `vehiclesdata` not a 'test.vehiclesdata'

Re: mysql table bug - Mean - 14.12.2011

Well, then it's probably not that query. What other queries do you have?

Re: mysql table bug - juraska - 15.12.2011

one query (global) alright i try to change it

Re: mysql table bug - XFlawless - 15.12.2011

table name is case sensitive. Make sure you have named it properly.

Or Run this Query

REPAIR TABLE vehiclesdata;

Quote:

Originally Posted by belhot1992

Test writing your query like this:
"DELETE FROM `vehiclesdata` WHERE `vID` = '1';"

You can directly access the INTEGER in SQL, only String with variable character requires ''.