Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Tutorials/Howto's

Archive::Tutorials/Howto's Archive area for Tutorials/Howto's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 04-04-2004, 03:07 AM
Loosenut
Sarnak
 
Join Date: Feb 2004
Posts: 50
Default Updating DB

OK, i downloaded the file and then sourced them.. but when i sourced DB.sql .. i keep getting errors.

AM i doing it wrong?
Reply With Quote
  #2  
Old 04-04-2004, 05:01 AM
samandhi's Avatar
samandhi
Demi-God
 
Join Date: Aug 2003
Posts: 1,056
Default

Did you put the db.sql file in your /mysql/bin directory?
__________________

Quote:
Analysis paralysis will keep you from failing, but it will also keep you from succeeding.
  • L.L. CoolJ
Reply With Quote
  #3  
Old 04-04-2004, 05:33 AM
Loosenut
Sarnak
 
Join Date: Feb 2004
Posts: 50
Default

When i source it, it begins then it starts saying Error 1113(or sumthing like that) balh blah blah blah
Reply With Quote
  #4  
Old 04-04-2004, 05:37 AM
samandhi's Avatar
samandhi
Demi-God
 
Join Date: Aug 2003
Posts: 1,056
Default

But:
Quote:
Originally Posted by samandhi
Did you put the db.sql file in your /mysql/bin directory?
__________________

Quote:
Analysis paralysis will keep you from failing, but it will also keep you from succeeding.
  • L.L. CoolJ
Reply With Quote
  #5  
Old 04-04-2004, 05:45 AM
Loosenut
Sarnak
 
Join Date: Feb 2004
Posts: 50
Default

yes
Reply With Quote
  #6  
Old 04-04-2004, 06:57 AM
samandhi's Avatar
samandhi
Demi-God
 
Join Date: Aug 2003
Posts: 1,056
Default

Im not sure of why you would get errors with this.. Ill try and look into it after a bit, and get back to you on it..
__________________

Quote:
Analysis paralysis will keep you from failing, but it will also keep you from succeeding.
  • L.L. CoolJ
Reply With Quote
  #7  
Old 04-04-2004, 07:13 AM
Loosenut
Sarnak
 
Join Date: Feb 2004
Posts: 50
Default

I think it's because i have 2 DB's trying to source them both makes it Overwrite and then at one point it says the same error x infinity
Reply With Quote
  #8  
Old 04-04-2004, 07:31 AM
Loosenut
Sarnak
 
Join Date: Feb 2004
Posts: 50
Default

Error 1136 : column count doesnt match...........
Reply With Quote
  #9  
Old 04-06-2004, 04:05 AM
DrizztBanrae
Fire Beetle
 
Join Date: Jan 2004
Posts: 29
Default

I'm getting the same error...any help on this?
Reply With Quote
  #10  
Old 04-06-2004, 04:14 AM
govtcheeze
Hill Giant
 
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default

The error means the table definitions are different, and will result in an empty table. You should not source db.sql if you want to use MW.

Duplicate entry error on key errors are fine...its just a warning letting you know the index already exists in the database, and it will ignore the INSERT statement.
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 07:03 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