Ok I have backed up with navicat
Extracted the whole table.
Then Extracted just these sql's- Items list, Accounts, Character_, Character_backup Faction_List, Guild tables, Zone
I have created Custom Items and wanted to use them after updating to the peqdb_1129Rev333.sql.gz, so I have two pcs with the same server on them just incase, so I went ahead and sourced the new peqdb_1129Rev333.sql.gz and updates.
But all my custom items were gone, so I went and sourced the item file I extracted from my old DB and sourced it to the updated [peqdb_1129Rev333.sql.gz] db and I am getting this error.
Quote:
---------------------------------------------
[02.22. - 06:06:48] Starting Log: logs/eqemu_debug_world_1744.log
[02.22. - 06:06:48] [WORLD__INIT] Loading server configuration..
[02.22. - 06:06:48] [WORLD__INIT] Log settings loaded from log.ini
[02.22. - 06:06:48] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[02.22. - 06:06:48] [WORLD__INIT] Connecting to MySQL...
[02.22. - 06:06:48] [WORLD__INIT] Starting HTTP world service...
[02.22. - 06:06:48] [WORLD__HTTP] Loaded mime types from mime.types
[02.22. - 06:06:48] [WORLD__INIT] Loading variables..
[02.22. - 06:06:48] [WORLD__INIT] Loading zones..
[02.22. - 06:06:49] [WORLD__INIT] Clearing groups..
[02.22. - 06:06:49] [WORLD__INIT] Clearing raids..
[02.22. - 06:06:49] [WORLD__INIT] Loading items..
[02.22. - 06:06:49] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[02.22. - 06:06:49] [WORLD__INIT] Loading guilds..
[02.22. - 06:06:49] [RULES__CHANGE] Loading rule set
|
And
Quote:
---------------------------------------------
[02.22. - 06:06:49] Starting Log: logs/eqemu_error_world_1744.log
[02.22. - 06:06:49] DBLoadItems query 'select source,itemclass,name,lore,idfile,id,weight,norent ,nodrop,size,slots,price,icon,UNK012,UNK013,benefi tflag,tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,ad ex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,U NK033,skillmodtype,banedmgrace,banedmgamt,banedmgb ody,magic,casttime_,reqlevel,bardtype,bardvalue,li ght,delay,reclevel,recskill,elemdmgtype,elemdmgamt ,range,damage,color,classes,races,UNK054,maxcharge s,itemtype,material,sellrate,UNK059,casttime,UNK06 1,procrate,combateffects,shielding,stunresist,stri kethrough,extradmgskill,extradmgamt,spellshield,av oidance,accuracy,charmfileid,factionmod1,factionmo d2,factionmod3,factionmod4,factionamt1,factionamt2 ,factionamt3,factionamt4,charmfile,augtype,augslot 1type,augslot1visible,augslot2type,augslot2visible ,augslot3type,augslot3visible,augslot4type,augslot 4visible,augslot5type,augslot5visible,ldontheme,ld onprice,ldonsold,bagtype,bagslots,bagsize,bagwr,bo ok,booktype,filename,banedmgraceamt,augrestrict,lo regroup,pendingloreflag,artifactflag,summonedflag, favor,fvnodrop,endur,dotshielding,attack,regen,man aregen,enduranceregen,haste,damageshield,recastdel ay,recasttype,guildfavor,augdistiller,UNK123,UNK12 4,attuneable,nopet,UNK127,pointtype,potionbelt,pot ionbeltslots,stacksize,notransfer,stackable,UNK134 ,clickeffect,clicktype,clicklevel,clicklevel2,proc effect,proctype,proclevel,proclevel2,worneffect,wo rntype,wornlevel,wornlevel2,focuseffect,focustype, focuslevel,focuslevel2,scrolleffect,scrolltype,scr olllevel,scrolllevel2,updated from items order by id', #1054: Unknown column 'augslot1visible' in 'field list'
[02.22. - 06:06:49] If you got boat loads of errors, make sure you sourced: utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql
|
I tried sourcing the items-0.6.0-DR2-0.6.1-DR1-convert.sql
when I do this I get
Quote:
mysql> source items-0.6.0-DR2-0.6.1-DR1-convert.sql
ERROR 1054 (42S22): Unknown column 'unknown021' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown022' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown023' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown064' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown070' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown072' in 'items'
ERROR 1054 (42S22): Unknown column 'combatskill' in 'items'
ERROR 1054 (42S22): Unknown column 'combatskilldmg' in 'items'
ERROR 1060 (42S21): Duplicate column name 'book'
ERROR 1054 (42S22): Unknown column 'unknown108' in 'items'
ERROR 1054 (42S22): Unknown column 'banedmgamt2' in 'items'
ERROR 1054 (42S22): Unknown column 'augmentrestriction' in 'items'
ERROR 1054 (42S22): Unknown column 'tribute' in 'items'
ERROR 1054 (42S22): Unknown column 'attackbonus' in 'items'
ERROR 1054 (42S22): Unknown column 'hpregen' in 'items'
ERROR 1054 (42S22): Unknown column 'hastepercent' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown125' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown126' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown127' in 'items'
ERROR 1054 (42S22): Unknown column 'distiller' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown129' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown130' in 'items'
Query OK, 62263 rows affected (18.58 sec)
Records: 62263 Duplicates: 0 Warnings: 0
ERROR 1054 (42S22): Unknown column 'unknown131' in 'items'
ERROR 1054 (42S22): Unknown column 'unknown132' in 'items'
ERROR 1060 (42S21): Duplicate column name 'UNK121'
ERROR 1060 (42S21): Duplicate column name 'pointtype'
ERROR 1060 (42S21): Duplicate column name 'potionbelt'
ERROR 1060 (42S21): Duplicate column name 'UNK124'
ERROR 1060 (42S21): Duplicate column name 'stacksize'
ERROR 1054 (42S22): Unknown column 'hasteproclvl' in 'items'
ERROR 1054 (42S22): Unknown column 'spellid' in 'items'
ERROR 1054 (42S22): Unknown column 'focusid' in 'items'
ERROR 1054 (42S22): Unknown column 'effecttype' in 'items'
ERROR 1054 (42S22): Unknown column 'level' in 'items'
ERROR 1060 (42S21): Duplicate column name 'UNK129'
ERROR 1060 (42S21): Duplicate column name 'proceffect'
ERROR 1060 (42S21): Duplicate column name 'proctype'
ERROR 1060 (42S21): Duplicate column name 'proclevel'
Query OK, 62263 rows affected (4.81 sec)
Records: 62263 Duplicates: 0 Warnings: 0
ERROR 1060 (42S21): Duplicate column name 'worneffect'
ERROR 1060 (42S21): Duplicate column name 'worntype'
ERROR 1060 (42S21): Duplicate column name 'wornlevel'
ERROR 1060 (42S21): Duplicate column name 'UNK137'
ERROR 1060 (42S21): Duplicate column name 'focustype'
ERROR 1060 (42S21): Duplicate column name 'focuslevel'
Query OK, 62263 rows affected (4.84 sec)
Records: 62263 Duplicates: 0 Warnings: 0
ERROR 1060 (42S21): Duplicate column name 'scrolleffect'
ERROR 1060 (42S21): Duplicate column name 'scrolltype'
ERROR 1060 (42S21): Duplicate column name 'scrolllevel'
Query OK, 62263 rows affected (4.92 sec)
Records: 62263 Duplicates: 0 Warnings: 0
ERROR 1054 (42S22): Unknown column 'cost' in 'items'
ERROR 1054 (42S22): Unknown column 'casttime2' in 'items'
ERROR 1054 (42S22): Unknown column 'proc_rate_mod' in 'items'
ERROR 1054 (42S22): Unknown column 'charmformula' in 'items'
Query OK, 62263 rows affected (4.81 sec)
Records: 62263 Duplicates: 0 Warnings: 0
ERROR 1054 (42S22): Unknown column 'ldonpointtheme' in 'items'
ERROR 1054 (42S22): Unknown column 'ldonpointcost' in 'items'
ERROR 1054 (42S22): Unknown column 'gmflag' in 'items'
ERROR 1060 (42S21): Duplicate column name 'serialized'
ERROR 1060 (42S21): Duplicate column name 'verified'
ERROR 1060 (42S21): Duplicate column name 'serialization'
ERROR 1060 (42S21): Duplicate column name 'source'
ERROR 1060 (42S21): Duplicate column name 'UNK033'
ERROR 1091 (42000): Can't DROP 'charges'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'unknown001'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'collected_slot_id'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'merchantprice'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'unknown004'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'collected_inst_id'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'unknown006'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'spellcharges'; check that column/key exists
Query OK, 62263 rows affected (4.83 sec)
Records: 62263 Duplicates: 0 Warnings: 0
Query OK, 5 rows affected (0.67 sec)
Rows matched: 5 Changed: 5 Warnings: 0
Query OK, 0 rows affected (0.66 sec)
Rows matched: 0 Changed: 0 Warnings: 0
Query OK, 0 rows affected (0.66 sec)
Rows matched: 3641 Changed: 0 Warnings: 0
Query OK, 0 rows affected (0.66 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql>
|
any idea's of what I am doing wrong to get my items into the mix again?
|