Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Bug Reports

Development::Bug Reports Post detailed bug reports and what you would like to see next in the emu here.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-11-2008, 12:45 PM
Slingshot
Fire Beetle
 
Join Date: Oct 2008
Location: New Jersey
Posts: 19
Default

I take it the dowloads on here are out of date? (EQEmu-0.7.0-1129)
Reply With Quote
  #2  
Old 11-11-2008, 01:50 PM
Slingshot
Fire Beetle
 
Join Date: Oct 2008
Location: New Jersey
Posts: 19
Default

I tried to run the first script in revision189 (1_task_system.sql) figuring I just had to run them in order and they would update my DB but I got an error.

Script line: 118 Duplicate entry '1-TaskSystem:EnableTaskSystem' for key 1

Not sure if I made a mistake or I accidently ran it twice or something. Should I just move on to the next one?
Reply With Quote
  #3  
Old 11-11-2008, 01:58 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

You can ignore any errors relating to duplicate rows in the rule_values table, such as those, so yes, just carry on sourcing them in sequentially.
Reply With Quote
  #4  
Old 11-11-2008, 02:02 PM
Slingshot
Fire Beetle
 
Join Date: Oct 2008
Location: New Jersey
Posts: 19
Default

Problem is I'm not sure if it went threw the whole script or just stopped on that line.

I'm using Mysql Query Browser to execute the script. Should I be doing it a different way?

Thanks for helping me out with this.
Reply With Quote
  #5  
Old 11-11-2008, 02:12 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

I'm not familiar with the MySQL Query Browser, I use the command line interface which continues on after any errors.

If the tool you're using stopped when it encountered the error, that could be a problem.

Looking at 1_task_system.sql, after it has the inserts for those rule values, it creates a table called raid_details, amongst other things, so if you have that table, it looks like it carried on after the error. From the command prompt, I would check like this to see if I had that table.

Code:
mysql> describe raid_details ;
+----------+------------+------+-----+---------+-------+
| Field    | Type       | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| raidid   | int(4)     | NO   | PRI |         |       |
| loottype | int(4)     | NO   |     |         |       |
| locked   | tinyint(1) | NO   |     |         |       |
+----------+------------+------+-----+---------+-------+
3 rows in set (0.09 sec)
If it stopped at the first error, then you need to edit 1_task_system.sql and delete all the lines from the start up until and including the line:

Code:
Insert into rule_values values (1, 'World:AddMaxClientsStatus', -1);
Then source in the remainder of the file and carry on from there.

If you haven't already, I would back up your database before continuing.
Reply With Quote
  #6  
Old 11-11-2008, 02:39 PM
Slingshot
Fire Beetle
 
Join Date: Oct 2008
Location: New Jersey
Posts: 19
Default

I ended up using the command line interface and just ran each file. I didn't even know I could do that.

How often should I check that site for updates? And are there any other updates I needed to go from the 1129 version on this site?

Sorry for all the confusion on my part. It just seems (from my noob perspective) that there are files and info all over the place and finding exactly what I need seems to be a little bit of a scavenger hunt.
Reply With Quote
  #7  
Old 11-11-2008, 02:44 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

There are source code updates every few days at the moment, and new Windows executables appear every week or so.

If you got the Rev189 executables and sourced in all the SQL, then you should be up-to-date now with the latest code.
Reply With Quote
Reply


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 04:37 PM.


 

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