An Error While Executing A Query.

This topic is empty.

Viewing 10 reply threads

Author

Posts
- June 25, 2009 at 4:53 am #11555
  
  bunkbunk
  Member
  
  hey i'am trying to import a SQL file for a (Game Server) But i get this error, But first i must add that, i did delete a data base and than. made a new one just like it, and yes it did work the first time,
  
  Also i run the MYSQL server,. well really i run it all i just can't seem to get past this
  
  Thanks for any help!
  
  Code:
  
  There was an error while executing a query.
  The query and the error message has been logged at:
  C:UsersBlack_HatAppDataRoamingSQLyogsqlyog.err.
  Please click on “Open Error File…” to open the error file.
  
  Code:
  
  Query:
  CREATE TABLE `character_equipmentsets` (
  `guid` int(11) NOT NULL default '0',
  `setguid` bigint(20) NOT NULL auto_increment,
  `setindex` tinyint(4) NOT NULL default '0',
  `name` varchar(100) NOT NULL,
  `iconname` varchar(100) NOT NULL,
  `item0` int(11) NOT NULL default '0',
  `item1` int(11) NOT NULL default '0',
  `item2` int(11) NOT NULL default '0',
  `item3` int(11) NOT NULL default '0',
  `item4` int(11) NOT NULL default '0',
  `item5` int(11) NOT NULL default '0',
  `item6` int(11) NOT NULL default '0',
  `item7` int(11) NOT NULL default '0',
  `item8` int(11) NOT NULL default '0',
  `item9` int(11) NOT NULL default '0',
  `item10` int(11) NOT NULL default '0',
  `item11` int(11) NOT NULL default '0',
  `item12` int(11) NOT NULL default '0',
  `item13` int(11) NOT NULL default '0',
  `item14` int(11) NOT NULL default '0',
  `item15` int(11) NOT NULL default '0',
  `item16` int(11) NOT NULL default '0',
  `item17` int(11) NOT NULL default '0',
  `item18` int(11) NOT NULL default '0',
  PRIMARY KEY (`setguid`),
  UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  
  Error occured at:2009-06-24 21:04:00
  Line no.:43
  Error Code: 1050 – Table 'character_equipmentsets' already exists
  
  Query:
  ALTER TABLE character_db_version CHANGE COLUMN required_7887_01_characters_character_pet required_7903_01_characters_character_pet bit
  
  Error occured at:2009-06-24 21:06:35
  Line no.:2
  Error Code: 1054 – Unknown column 'required_7887_01_characters_character_pet' in 'character_db_version'
  
  Query:
  ALTER TABLE character_db_version CHANGE COLUMN required_7644_01_characters_character_pet required_7802_01_characters_character_achievement bit
  
  Error occured at:2009-06-24 21:06:52
  Line no.:2
  Error Code: 1054 – Unknown column 'required_7644_01_characters_character_pet' in 'character_db_version'
  
  Query:
  ALTER TABLE db_version CHANGE COLUMN required_7893_01_mangos_command required_7896_01_mangos_creature_template bit
  
  Error occured at:2009-06-24 21:08:22
  Line no.:2
  Error Code: 1054 – Unknown column 'required_7893_01_mangos_command' in 'db_version'
  
  Query:
  INSERT IGNORE INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `cast_flags`) VALUES
  (28389, 51592, 12605, 1),
  (28389, 51593, 12605, 3)
  
  Error occured at:2009-06-24 21:08:55
  Line no.:1326
  Error Code: 1054 – Unknown column 'quest_id' in 'field list'
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:20:45
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:21: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:2009-06-25 00:22:17
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:23:20
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:27:33
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:29:03
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:29:45
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:30:01
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:33:19
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:42:15
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:42:21
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:42:24
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'mangos' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0
  
  Error occured at:2009-06-25 00:43:54
  Line no.:1
  Error Code: 1146 – Table 'mysql.user' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:45:40
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:49:26
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
- June 25, 2009 at 5:38 am #29181
  
  Khushboo
  Member
  
  Hi,
  
  We will need some more information , to solve your issue.
  
  So can you please tell us :
  
  1) With what program was that dump (SQL file) generated? 'mysqldump' ?
  
  2) From what MySQL version?
  
  3) To what version do you try to import ?
  
  4) SQLyog program version?
  
  Regards,
  
  Khushboo
- June 25, 2009 at 5:51 am #29182
  
  bunkbunk
  Member
  
  Khushboo wrote on Jun 25 2009, 05:38 AM:
  
  Hi,
  
  We will need some more information , to solve your issue.
  
  So can you please tell us :
  
  1) With what program was that dump (SQL file) generated? 'mysqldump' ?
  
  2) From what MySQL version?
  
  3) To what version do you try to import ?
  
  4) SQLyog program version?
  
  Regards,
  
  Khushboo
  
  plz stay online i will git the info soon
  
  again thanks!
- June 25, 2009 at 5:55 am #29183
  
  bunkbunk
  Member
  
  I don't know how the SQL file was made, though i did a import of it be for and it was working “mind you this was just a few hours ago”
  
  i think MYSQL is 4.1 or some where in the 4's the 5's wont work for me on this computer “
  
  don't understand the 3'rd one
  
  SQLyog is 8 (point) some thing
  
  again it was working, all i did was delete the data base's and make them again and boom they don't work any more
- June 25, 2009 at 6:05 am #29184
  
  Mahesh
  Member
  
  Please zip and attach .sql dump file here, we will analyze and let you know the status.
- June 25, 2009 at 6:09 am #29185
  
  bunkbunk
  Member
  
  Mahesh wrote on Jun 25 2009, 06:05 AM:
  
  Please zip and attach .sql dump file here, we will analyze and let you know the status.
  
  here you go
  
  Thanks!
- June 25, 2009 at 6:52 am #29186
  
  Mahesh
  Member
  
  Attached .sql dump “imports successfully” at our end we have checked against 5.x as well as 4.x servers.
  
  Please provide a sample testcase to reproduce those errors mentioned in above post, then only we can do some progress.
  
  Thanks
- June 25, 2009 at 6:58 am #29187
  
  bunkbunk
  Member
  
  Mahesh wrote on Jun 25 2009, 06:52 AM:
  
  Attached .sql dump “imports successfully” at our end we have checked against 5.x as well as 4.x servers.
  
  Please provide a sample testcase to reproduce those errors mentioned in above post, then only we can do some progress.
  
  Thanks
  
  i know it work's it DID work for me now it's blah, i don't know what's going on i just delete all the data base's on SQLyog and than try to make them again i mean is it that i don't have the mysql data base there any more or what?
  
  thanks again for the fast help
  
  i will stay online for a week if that's what it take's to get going again
- June 25, 2009 at 7:34 am #29188
  
  bunkbunk
  Member
  
  bunkbunk wrote on Jun 25 2009, 06:58 AM:
  
  i know it work's it DID work for me now it's blah, i don't know what's going on i just delete all the data base's on SQLyog and than try to make them again i mean is it that i don't have the mysql data base there any more or what?
  
  thanks again for the fast help
  
  i will stay online for a week if that's what it take's to get going again
  
  i got it working, i had to re-move MYSQL all together seem's when i went to restart mysql server it would not, i was then thinking that my computer did some thing with out me lol, well i did a re install, made the server again and, did the dump for the sql file's and they all work,
  
  Thank you so much guy's for your time, and i'am so happy that you took the time to take a look at the sql file's, and for being there so fast, well THANKS!
- July 22, 2009 at 3:53 am #29189
  
  kage
  Member
  
  bunkbunk wrote on Jun 25 2009, 03:34 AM:
  
  Code:
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:20:45
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:21: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:2009-06-25 00:22:17
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:23:20
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:27:33
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:29:03
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:29:45
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:30:01
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:33:19
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:42:15
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:42:21
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:42:24
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'mangos' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0
  
  Error occured at:2009-06-25 00:43:54
  Line no.:1
  Error Code: 1146 – Table 'mysql.user' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:45:40
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  Query:
  /*!40103 SET TIME_ZONE='+00:00' */
  
  Error occured at:2009-06-25 00:49:26
  Line no.:12
  Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist
  
  i know this is resolved and somewhat necro'd, i thought I would comment on this. specifically the mysql.tables doesn't exist error.
  
  It would seem this person deleted, or had conection problems, to his mysql database?
- July 22, 2009 at 6:31 am #29190
  
  Mahesh
  Member
  
  When you update to a new version of MySQL, you should update your system tables as well to make sure that their structure is up to date.
  
  For more information, please visit – http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html
Author

Posts