Ahoj! ..
Má takovej problém ..
Týká se to databáze MySQL ..
Chtěl bych si aktualizovat databázi "characters" jenže mi to vyhodilo chybu:
Query:
/*!40103 SET TIME_ZONE='+00:00' */
Error occured at:2010-11-28 21:29:55
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist
Query:
/*!40103 SET TIME_ZONE='+00:00' */
Error occured at:2010-11-28 21:29:59
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist
Query:
/*!40103 SET TIME_ZONE='+00:00' */
Error occured at:2010-11-28 21:30:29
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist
Query:
/*!40103 SET TIME_ZONE='+00:00' */
Error occured at:2010-11-28 21:31:35
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist
Query:
INSERT INTO `player_classlevelstats` VALUES ( 1 , 81 , 8621 , 0 )
Error occured at:2010-12-01 20:07:51
Line no.:1
Error Code: 1146 - Table 'zkouska_sql.player_classlevelstats' doesn't exist
Query:
INSERT INTO `player_classlevelstats` VALUES ( 1 , 81 , 8621 , 0 )
Error occured at:2010-12-01 20:08:00
Line no.:1
Error Code: 1146 - Table 'zkouska_sql.player_classlevelstats' doesn't exist
Query:
INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES ( 1 , 1 , 81 , 187 , 115 , 171 , 37 , 60 )
Error occured at:2010-12-01 20:08:12
Line no.:1
Error Code: 1146 - Table 'zkouska_sql.player_levelstats' doesn't exist
Query:
INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES ( 1 , 1 , 81 , 187 , 115 , 171 , 37 , 60 )
Error occured at:2010-12-01 20:09:44
Line no.:1
Error Code: 1146 - Table 'zkouska_sql.player_levelstats' doesn't exist
Query:
ALTER TABLE `character_pet` DROP COLUMN `Commandstate`
Error occured at:2010-12-03 20:27:12
Line no.:2
Error Code: 1091 - Can't DROP 'Commandstate'; check that column/key exists
Query:
ALTER TABLE `character_instance`
DROP KEY `leader`,
DROP PRIMARY KEY,
ADD PRIMARY KEY `guid` (`guid`,`instance`),
DROP COLUMN `map`,
DROP COLUMN `leader`,
MODIFY COLUMN `instance` int(11) unsigned NOT NULL default '0',
ADD COLUMN `permanent` tinyint(1) unsigned NOT NULL default '0'
Error occured at:2010-12-03 20:27:18
Line no.:23
Error Code: 1091 - Can't DROP 'leader'; check that column/key exists
Query:
ALTER TABLE `character_instance`
DROP KEY `leader`,
DROP PRIMARY KEY,
ADD PRIMARY KEY `guid` (`guid`,`instance`),
DROP COLUMN `map`,
DROP COLUMN `leader`,
MODIFY COLUMN `instance` int(11) unsigned NOT NULL default '0',
ADD COLUMN `permanent` tinyint(1) unsigned NOT NULL default '0'
Error occured at:2010-12-03 20:27:26
Line no.:23
Error Code: 1091 - Can't DROP 'leader'; check that column/key exists
Query:
DELETE FROM `command` WHERE `name` IN ('instance unbind','instance listbinds','instance stats','instance savedata')
Error occured at:2010-12-03 20:28:12
Line no.:1
Error Code: 1146 - Table 'mysql.command' doesn't exist
Query:
ALTER TABLE `character_pet` DROP COLUMN `Commandstate`
Error occured at:2010-12-03 20:29:42
Line no.:2
Error Code: 1091 - Can't DROP 'Commandstate'; check that column/key exists
Query:
ALTER TABLE `character_pet` DROP COLUMN `Commandstate`
Error occured at:2010-12-03 20:30:27
Line no.:2
Error Code: 1091 - Can't DROP 'Commandstate'; check that column/key exists
Query:
CREATE DATABASE `mangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
Error occured at:2010-12-03 20:32:04
Line no.:3
Error Code: 1007 - Can't create database 'mangos'; database exists
Query:
ALTER TABLE `character_pet` DROP COLUMN `Commandstate`
Error occured at:2010-12-03 20:41:54
Line no.:2
Error Code: 1091 - Can't DROP 'Commandstate'; check that column/key exists
Co s tím mám dělat? Vůbec netuším co mám udělat s tou tabulkou "time_zone_name" ..
Ono to píše "doesn't exist" ale ona v db "mysql" je ..
Prosím pomoc ..
Předem díky ..