Go Back   EQEmulator Home > EQEmulator Forums > OpenZone > Simple Client

Reply
 
Thread Tools Display Modes
  #1  
Old 03-08-2009, 02:46 PM
OrisonSeven
Sarnak
 
Join Date: Feb 2009
Location: USA
Posts: 33
Default Simple Client Issues

To anyone who can help,
My team and I are pushing forward with our custom server and so on, but ran into an issue installing the server. While compiling into MySQL, an error occurs.

As I am no coder, yet have looked extensively at the code provided from eq55sc.sql, the issue pertains to the "items" table.

While compiling, the error comes up saying that the "items" table doenst exist. Any insight into this issue would be appreciated. I do know that MySQL is installed correctly, and also have active perl as the server did used to run an emu server. After following the instructions given in the tutorial, and even clearing the server completely, and then trying to source in the .sql file to a different database, the same "items" table is said to be missing.

Thanks in advance, If more information is needed, i will provide screen shots of the error and of the source in process.

As for the ep55sc.sql, the code doesnt look broken from what i can see. There is no variation in the names such as "items" being called "item" or anything like that I can see.

Thanks,
__________________
OrisonSeven

-A goal is in mind. but the view is still clouded-
Reply With Quote
  #2  
Old 03-09-2009, 02:30 PM
OrisonSeven
Sarnak
 
Join Date: Feb 2009
Location: USA
Posts: 33
Default

Here is a screen shot of the error at hand.



Hope this helps in deciphering the error.

Thanks,
__________________
OrisonSeven

-A goal is in mind. but the view is still clouded-
Reply With Quote
  #3  
Old 03-09-2009, 03:03 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

The problem is that 'range' became a reserved word in MySQL 5.1. Edit the SQL file and enclose range in 'backticks', e.g.

Code:
  `range` int(11) NOT NULL default '0',
Once you fix that, you will probably get another error:
Code:
ERROR 1060 (42S21): Duplicate column name 'id'
To fix that, I changed:
Code:
  PRIMARY KEY  (id,id)
to
Code:
  PRIMARY KEY  (id)
Reply With Quote
  #4  
Old 03-09-2009, 03:37 PM
OrisonSeven
Sarnak
 
Join Date: Feb 2009
Location: USA
Posts: 33
Default

Thank you Thank you Thank you...

Now I have a new problem though...
This occurs when trying to run the "world.exe" file.



HELP US PLEASE
and thanks,
__________________
OrisonSeven

-A goal is in mind. but the view is still clouded-
Reply With Quote
  #5  
Old 03-12-2009, 06:48 PM
kedobin
Sarnak
 
Join Date: Oct 2004
Posts: 30
Default

It can't find your database. You'll need to check that:
The database is running/started
Your info in your db.ini file is correct.


Checking that your db.ini file is correct should be pretty straightforward. Host is the ip of the computer that holds the server. Database is the name of the database, and user and password are for whatever account you set up to have access to your database.

Checking if your database is running/started...
I'm sure there's another way, but how I run version 5.0 of mysql is that I run MYSQLSystemTrayMonitor.exe, which loads an icon on my taskbar. There's more info about it here, but here's a quick rundown on it. On the icon's upper left should be a small white circle with either a green triangle or a red square. The green means it's running. If it's red, then right click and choose Start Instance (top of menu).
It looks like this file's included with the mysql administrator download
Reply With Quote
Reply

Thread Tools
Display Modes

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 12:58 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 - 2019, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3