Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Tutorials/Howto's > Tutorials--Outdated Use the Wiki > Tutorials::Discussion

Tutorials::Discussion Discuss Tutorials here. Do NOT POST tutorials here, they belong on the wiki.

Reply
 
Thread Tools Display Modes
  #1  
Old 06-09-2005, 07:00 PM
Aradorn
Sarnak
 
Join Date: Jan 2005
Posts: 65
Default

Quote:
Originally Posted by iamjooish
bull... I just ran everquest.exe and it replaced my eqgame.exe, among other things.


it doesn't bother me, I have the subject thread and the silly zipfile nested nicely in one of my folders. Besides, there are much less riskier ways of of reverting to the december patch, why put this great guide at risk...


edit

one last little thing





something I shourd be worried about?
i did everything in the post to do and i got his error too
when i did source the Source items-0.6.0-DR2-0.6.1-DR1-convert.sql;

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Brandon>cd\ c:\mysql\bin
The filename, directory name, or volume label syntax is incorrect.

C:\Documents and Settings\Brandon>cd c:\mysql\bin

C:\Mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37 to server version: 4.0.23-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use eq;
Database changed
mysql> source items-0.6.0-DR2-0.6.1-DR1-convert.sql;
ERROR 1054: Unknown column 'unknown021' in 'items'
ERROR 1054: Unknown column 'unknown022' in 'items'
ERROR 1054: Unknown column 'unknown023' in 'items'
ERROR 1054: Unknown column 'unknown064' in 'items'
ERROR 1054: Unknown column 'unknown070' in 'items'
ERROR 1054: Unknown column 'unknown072' in 'items'
ERROR 1054: Unknown column 'combatskill' in 'items'
ERROR 1054: Unknown column 'combatskilldmg' in 'items'
ERROR 1054: Unknown column 'booktype' in 'items'
ERROR 1054: Unknown column 'unknown108' in 'items'
ERROR 1054: Unknown column 'banedmgamt2' in 'items'
ERROR 1054: Unknown column 'augmentrestriction' in 'items'
ERROR 1054: Unknown column 'tribute' in 'items'
ERROR 1054: Unknown column 'attackbonus' in 'items'
ERROR 1054: Unknown column 'hpregen' in 'items'
ERROR 1054: Unknown column 'hastepercent' in 'items'
ERROR 1054: Unknown column 'unknown125' in 'items'
ERROR 1054: Unknown column 'unknown126' in 'items'
ERROR 1054: Unknown column 'unknown127' in 'items'
ERROR 1054: Unknown column 'distiller' in 'items'
ERROR 1054: Unknown column 'unknown129' in 'items'
ERROR 1054: Unknown column 'unknown130' in 'items'
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0

ERROR 1054: Unknown column 'unknown131' in 'items'
ERROR 1054: Unknown column 'unknown132' in 'items'
ERROR 1060: Duplicate column name 'UNK121'
ERROR 1060: Duplicate column name 'pointtype'
ERROR 1060: Duplicate column name 'potionbelt'
ERROR 1060: Duplicate column name 'UNK124'
ERROR 1060: Duplicate column name 'stacksize'
ERROR 1054: Unknown column 'hasteproclvl' in 'items'
ERROR 1054: Unknown column 'spellid' in 'items'
ERROR 1054: Unknown column 'focusid' in 'items'
ERROR 1054: Unknown column 'effecttype' in 'items'
ERROR 1054: Unknown column 'level' in 'items'
ERROR 1060: Duplicate column name 'UNK129'
ERROR 1060: Duplicate column name 'proceffect'
ERROR 1060: Duplicate column name 'proctype'
ERROR 1060: Duplicate column name 'proclevel'
ERROR 1060: Duplicate column name 'UNK133'
ERROR 1060: Duplicate column name 'worneffect'
ERROR 1060: Duplicate column name 'worntype'
ERROR 1060: Duplicate column name 'wornlevel'
ERROR 1060: Duplicate column name 'UNK137'
ERROR 1060: Duplicate column name 'focustype'
ERROR 1060: Duplicate column name 'focuslevel'
ERROR 1060: Duplicate column name 'UNK141'
ERROR 1060: Duplicate column name 'scrolleffect'
ERROR 1060: Duplicate column name 'scrolltype'
ERROR 1060: Duplicate column name 'scrolllevel'
ERROR 1060: Duplicate column name 'UNK145'
ERROR 1054: Unknown column 'cost' in 'items'
ERROR 1054: Unknown column 'casttime2' in 'items'
ERROR 1054: Unknown column 'proc_rate_mod' in 'items'
ERROR 1054: Unknown column 'charmformula' in 'items'
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0

ERROR 1054: Unknown column 'ldonpointtheme' in 'items'
ERROR 1054: Unknown column 'ldonpointcost' in 'items'
ERROR 1054: Unknown column 'gmflag' in 'items'
ERROR 1060: Duplicate column name 'serialized'
ERROR 1060: Duplicate column name 'verified'
ERROR 1060: Duplicate column name 'serialization'
ERROR 1060: Duplicate column name 'source'
ERROR 1060: Duplicate column name 'UNK033'
ERROR 1091: Can't DROP 'charges'. Check that column/key exists
ERROR 1091: Can't DROP 'unknown001'. Check that column/key exists
ERROR 1091: Can't DROP 'collected_slot_id'. Check that column/key exists
ERROR 1091: Can't DROP 'merchantprice'. Check that column/key exists
ERROR 1091: Can't DROP 'unknown004'. Check that column/key exists
ERROR 1091: Can't DROP 'collected_inst_id'. Check that column/key exists
ERROR 1091: Can't DROP 'unknown006'. Check that column/key exists
ERROR 1091: Can't DROP 'spellcharges'. Check that column/key exists
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

mysql>

i know this is out of order with the steps but this is what happend when i did all the steps in synch
im doing a fresh install with no other server to be upgraded

Last edited by Aradorn; 06-10-2005 at 03:05 AM..
Reply With Quote
  #2  
Old 06-09-2005, 10:50 PM
iwantavr4
Sarnak
 
Join Date: Jun 2005
Location: Arizona
Posts: 50
Default

Aradorn:
Drop the EQ Database! I linked to a page where it describes how to drop a database. You already aparently have a eq database.(and from the looks of it, one which isnt current, or is incomplete)

If you dont want to drop the databse then simply make the database name eqb or eq2 or testing, or database. And just make sure you change the db.ini file to point to your new database.

You dont need it named EQ. It looks as though you already have a eq database.

The second way you can rid yourself of the database is to navigate to your mysql/data directory and DELETE the eq folder. Then restart your computer, and start from step 1.

Either way, you missed my post about dropping teh database, you already have one there, youre trying to overwrite it.
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 09:53 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 - 2026, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3