johnsamir
Advanced OT User
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}
how do i solve this? or my database is f*cked up?
if i try to load the website i get this
edit: i added theses the error persists
solved. i simply changed to a new database
don't know why or how but i began to have problems with starting mysql in xampp
now i habe these problems in console}
Code:
[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
Lua:
[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
if i try to load the website i get this
Code:
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
Lua:
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:
solved. i simply changed to a new database
Last edited: