SA-MP Forums Archive
Error on MYSQL table - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Error on MYSQL table (/showthread.php?tid=660087)



Error on MYSQL table - Blackaslan - 24.10.2018

When My servers start , in the logs I can see the next error:

Quote:

[15:40:52] [DEBUG] mysql_format - connection: 1, len: 144, format: "SELECT Id_clan FROM Zonas WHERE Id=%d"
[15:40:52] [DEBUG] mysql_query - connection: 1, query: "SELECT Id_clan FROM Zonas WHERE Id=1", use_cache: true
[15:40:52] [DEBUG] CMySQLQuery::Execute - starting query execution
[15:40:52] [ERROR] CMySQLQuery::Execute - (error #1146) Table 'zombie.Zonas' doesn't exist
[15:40:52] [DEBUG] cache_get_row_count - connection: 1
[15:40:52] [WARNING] cache_get_row_count - no active cache
[15:40:52] [DEBUG] cache_delete - cache_id: 0, connection: 1
[15:40:52] [WARNING] CMySQLHandle:eleteSavedResult - invalid result id ('0')

How I can fix it? Thanks you in advance !


Re: Error on MYSQL table - KinderClans - 24.10.2018

Quote:

[15:40:52] [ERROR] CMySQLQuery::Execute - (error #1146) Table 'zombie.Zonas' doesn't exist

Well, error clearly says it. You're accessing the "Zonas" table which you don't have in your database.

Just create it.


Re: Error on MYSQL table - Blackaslan - 24.10.2018

Quote:
Originally Posted by KinderClans
View Post
Well, error clearly says it. You're accessing the "Zonas" table which you don't have in your database.

Just create it.
Sorry I'm nab in this , Thanks you very much !


Re: Error on MYSQL table - Blackaslan - 24.10.2018

And this error is for what?

Quote:

[16:57:00] [DEBUG] mysql_format - connection: 1, len: 144, format: "UPDATE Clanes SET Color=%d WHERE Id=%d"
[16:57:00] [DEBUG] mysql_query - connection: 1, query: "UPDATE Clanes SET Color=65535 WHERE Id=2", use_cache: false
[16:57:00] [DEBUG] CMySQLQuery::Execute - starting query execution
[16:57:00] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Color' in 'field list'
[16:57:05] [DEBUG] mysql_format - connection: 1, len: 144, format: "SELECT Color FROM Clanes WHERE Id=%d"
[16:57:05] [DEBUG] mysql_query - connection: 1, query: "SELECT Color FROM Clanes WHERE Id=2", use_cache: true
[16:57:05] [DEBUG] CMySQLQuery::Execute - starting query execution
[16:57:05] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Color' in 'field list'
[16:57:05] [DEBUG] cache_get_row_count - connection: 1
[16:57:05] [WARNING] cache_get_row_count - no active cache
[16:57:05] [DEBUG] cache_delete - cache_id: 0, connection: 1
[16:57:05] [WARNING] CMySQLHandle:eleteSavedResult - invalid result id ('0')




Re: Error on MYSQL table - KinderClans - 25.10.2018

Same as befire but this time is inside a table. Go in Clanes table and create a column called "Color"


Re: Error on MYSQL table - AmirSavand - 25.10.2018

Looks like your database is not initialized. This should happen automatically when server starts or database schema is stored in a file in the source code.