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