[PoMoC] MySQL Error

[Kronny 0]

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

Edited December 3, 2010 by Kronny

[J0dA 135]

skus to reinstallovat

[Kronny 0]

skus to reinstallovat

OK Díky .. A nesmaže se mi celá databáze která je na tom MySQL serveru?

Znova bych to totiž nechtěl dělat!

Edited December 3, 2010 by Kronny

[Shadowhack 36]

Si to zálohuj,pro případ,ne?

[radimovecek 8]

zkontroluj, jestli nemas zamknuty nejaky tabulky, me to vyhazovalo podobny chyby. . .

pokud je neco lockly, zkus to unlocknout. nebudu to psat podrobnejc, protoze sem ted na internetu v mobilu. . .