Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 12-22-2005, 09:07 AM
mikenune
Discordant
 
Join Date: Apr 2004
Location: Gukta
Posts: 359
Unhappy

OK, when I try to source the Velious PEQ DB (clean dump, no other files sourced), it works fine until it tries to make the "spawn2" table, where it gives me the following error:

The reason it says the error is at line 13 is because I cut the load_system.sql dump into 2 files with the second file starting at the creation of the "spawn2" table (so I could make sure everything else sourced fine).
Code:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition mediumint(8) unsigned NOT NULL default '0',
  cond_value mediumint(9)' at line 13
Here's the beginning of the file I'm trying to source in (load_system.b.sql):
Code:
-- MySQL dump 9.11
--
-- Host: 127.0.0.1    Database: peq_velious
-- ------------------------------------------------------
-- Server version	4.0.22

--
-- Table structure for table `spawn2`
--

CREATE TABLE spawn2 (
  id int(11) NOT NULL auto_increment,
  spawngroupID int(11) NOT NULL default '0',
  zone varchar(16) NOT NULL default '',
  x float(14,6) NOT NULL default '0.000000',
  y float(14,6) NOT NULL default '0.000000',
  z float(14,6) NOT NULL default '0.000000',
  heading float(14,6) NOT NULL default '0.000000',
  respawntime int(11) NOT NULL default '0',
  variance smallint(4) NOT NULL default '0',
  pathgrid int(10) NOT NULL default '0',
  timeleft bigint(16) NOT NULL default '0',
  condition mediumint(8) unsigned NOT NULL default '0',
  cond_value mediumint(9) NOT NULL default '1',
  PRIMARY KEY  (id),
  KEY ZoneGroup (zone,spawngroupID)
) TYPE=MyISAM;
an exact copy of what I typed into the MySQL Command Line:
Code:
CREATE DATABASE eq;
USE eq
SOURCE load_empty_users.sql;
SOURCE load_system.a.sql;
SOURCE load_system.b.sql;
The load_empty_users.sql file works perfectly.

The load_system.a.sql is the first half of the original load_system.sql file and covers tables "aa_actions" through "pets". This file sources without error.

The load_system.b.sql is the second half (and is only a 10MB file whereas the other one is 87MB - so I know it's not some weird file size issue) and covers "spawn2" through "zoneserver_auth". It, of course, gives the above error and is completely unable to dump the "spawn2" table. When I remove all the "spawn2" entries from the file, all the other tables in here source correctly.

Could it be a problem with "condition" being a keyword in MySQL 5?
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.

THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.

THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 10:05 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3