how to solve these errors that has appeared in my database

[johnsamir]

mysql errors in console

don't know why or how but i began to have problems with starting mysql in xampp

so i followed this


now i habe these problems in console}

[Error - mysql_real_query] Query: SELECT `value` FROM `server_config` WHERE `config` = 'db_version'
Message: Table 'tfs-1.5.server_config' doesn't exist in engine
[Error - mysql_store_result] Query: SELECT `value` FROM `server_config` WHERE `config` = 'db_version'
Message: Table 'tfs-1.5.server_config' doesn't exist in engine
[Error - DatabaseManager::updateDatabase - Version: -1] cannot open data/migrations/-1.lua: No such file or directory
>> Loading vocations

[Error - mysql_real_query] Query: SELECT `id`, `owner`, `paid`, `warnings` FROM `houses`
Message: Table 'tfs-1.5.houses' doesn't exist in engine
[Error - mysql_store_result] Query: SELECT `id`, `owner`, `paid`, `warnings` FROM `houses`
Message: Table 'tfs-1.5.houses' doesn't exist in engine
[Error - mysql_real_query] Query: SELECT `data` FROM `tile_store`
Message: Table 'tfs-1.5.tile_store' doesn't exist in engine
[Error - mysql_store_result] Query: SELECT `data` FROM `tile_store`
Message: Table 'tfs-1.5.tile_store' doesn't exist in engine
>> Initializing gamestate
[Error - mysql_real_query] Query: SELECT `value` FROM `server_config` WHERE `config` = 'motd_num'
Message: Table 'tfs-1.5.server_config' doesn't exist in engine
[Error - mysql_store_result] Query: SELECT `value` FROM `server_config` WHERE `config` = 'motd_num'
Message: Table 'tfs-1.5.server_config' doesn't exist in engine
[Error - mysql_real_query] Query: INSERT INTO `server_config` (`config`, `value`) VALUES ('motd_num', '0')
Message: Table 'tfs-1.5.server_config' doesn't exist in engine
[Error - mysql_real_query] Query: SELECT `value` FROM `server_config` WHERE `config` = 'motd_hash'
Message: Table 'tfs-1.5.server_config' doesn't exist in engine
[Error - mysql_store_result] Query: SELECT `value` FROM `server_config` WHERE `config` = 'motd_hash'
Message: Table 'tfs-1.5.server_config' doesn't exist in engine
[Error - mysql_real_query] Query: INSERT INTO `server_config` (`config`, `value`) VALUES ('motd_hash', '')
Message: Table 'tfs-1.5.server_config' doesn't exist in engine
[Error - mysql_real_query] Query: SELECT `value` FROM `server_config` WHERE `config` = 'players_record'
Message: Table 'tfs-1.5.server_config' doesn't exist in engine
[Error - mysql_store_result] Query: SELECT `value` FROM `server_config` WHERE `config` = 'players_record'
Message: Table 'tfs-1.5.server_config' doesn't exist in engine
[Error - mysql_real_query] Query: INSERT INTO `server_config` (`config`, `value`) VALUES ('players_record', '0')
Message: Table 'tfs-1.5.server_config' doesn't exist in engine
[Error - mysql_real_query] Query: SELECT `account_id`, `key`, `value` FROM `account_storage`
Message: Table 'tfs-1.5.account_storage' doesn't exist in engine
[Error - mysql_store_result] Query: SELECT `account_id`, `key`, `value` FROM `account_storage`
Message: Table 'tfs-1.5.account_storage' doesn't exist in engine

how do i solve this? or my database is f*cked up?
if i try to load the website i get this

string(62) "SHOW COLUMNS from `accounts` WHERE `Field` = 'premium_ends_at'"
(query - SQL error)
Type: select_single (select single row from database)

Table 'tfs-1.5.accounts' doesn't exist in engine

edit: i added theses the error persists

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `password` char(40) NOT NULL,
  `secret` char(16) DEFAULT NULL,
  `type` int NOT NULL DEFAULT '1',
  `premium_ends_at` int unsigned NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL DEFAULT '',
  `creation` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;

CREATE TABLE IF NOT EXISTS `server_config` (
  `config` varchar(50) NOT NULL,
  `value` varchar(256) NOT NULL DEFAULT '',
  PRIMARY KEY `config` (`config`)
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;

Post automatically merged: Sep 28, 2023

solved. i simply changed to a new database

 

[EkkoLua]

It seems like you might have spent more time creating this thread and adding the necessary images than actually trying to troubleshoot it yourself.

 

[johnsamir]

It seems like you might have spent more time creating this thread and adding the necessary images than actually trying to troubleshoot it yourself.

believe me before the thread searched for solution and it always f*ckung up my database in some way. so as i've posted the solution was simply use or create another database. Thing which i didn't want to do