Error on MYSQL table
#1

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 !
Reply
#2

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.
Reply
#3

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 !
Reply
#4

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')

Reply
#5

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

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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)