|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Support::Windows Servers Support forum for Windows EQEMu users. |
02-18-2009, 04:39 AM
|
|
Sarnak
|
|
Join Date: Jan 2009
Location: canada
Posts: 68
|
|
[Errors] I don't understand?
I am getting these errors and have no clue as to what they mean I am hoping a expert can help.
this one too has rule errors I Can see the crushbone quest error at the end I Can get that but why all the rule errors?
Any advice would be appreciated.
|
 |
|
 |
02-18-2009, 04:41 AM
|
|
Sarnak
|
|
Join Date: Jan 2009
Location: canada
Posts: 68
|
|
couldnt post this in first window too many smiliey's
|
|
|
|
02-22-2009, 04:50 AM
|
|
Sarnak
|
|
Join Date: Jan 2009
Location: canada
Posts: 68
|
|
Bump....
Are these common errors I can ignore?
|
02-22-2009, 05:12 AM
|
 |
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
You can sorta ignore those, because those errors themselves won't actually break anything. But, seeing those errors means that your database version and your server code version are not anywhere near matching, which is a huge problem. You need to make sure that your database matches the same revision of the source code you are running. It looks like your source is very old. I am guessing you are trying to run the base 1129 version from the downloads page? You need to be using the SVN to get the newer revisions. The 1129 version is very far behind at this point. We are 355 revisions after that right now which includes hundreds to thousands of changes.
|
02-22-2009, 05:33 AM
|
|
Sarnak
|
|
Join Date: Jan 2009
Location: canada
Posts: 68
|
|
I did a export in sql mode and when i try and source the character_.sql I get a error
Quote:
|
Error 1054 (42S22) : Unknown column 'instZflafNum' in 'field list'
|
over and over
I need help backing up the peq table files I tried exporting them as sql files but when I try to source the and I have about 100 or more accounts with allot of characters playing on it already so how would I go about backing it up so all my server users log back on after the update without them losing gear or account info?
eg. what tables? and what method so I Can just source all info back in? |
 |
|
 |
02-22-2009, 08:30 AM
|
|
Sarnak
|
|
Join Date: Jan 2009
Location: canada
Posts: 68
|
|
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?
|
|
|
|
|
|
|
02-22-2009, 06:02 PM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
I am not sure what that conversion sql stuff is, but it looks really old. It looked like you were closer before you started running those. Your first error shows this:
Unknown column 'augslot1visible' in 'field list'
Which is an issue that means you are trying to update your database with a new items table, but the existing items table is designed wrong. The augslot1visible used to be named differently until a recent change. You should just need to make sure that you run the SQL to change that field in your table before sourcing your items back in. Here is the SQL change from R292:
Code:
alter table items drop column augslot1visible;
alter table items drop column augslot2visible;
alter table items drop column augslot3visible;
alter table items drop column augslot4visible;
alter table items drop column augslot5visible;
alter table items change column `augslot1unk` `augslot1visible` tinyint(3);
alter table items change column `augslot2unk` `augslot2visible` tinyint(3);
alter table items change column `augslot3unk` `augslot3visible` tinyint(3);
alter table items change column `augslot4unk` `augslot4visible` tinyint(3);
alter table items change column `augslot5unk` `augslot5visible` tinyint(3);
|
|
|
|
02-25-2009, 01:05 PM
|
|
Sarnak
|
|
Join Date: Jan 2009
Location: canada
Posts: 68
|
|
Well like I said above i load up that db and source it and mysql drops connection and I also noticed after doing this my pc wil now crash constantly is this normal? what version of MYSQL Should I use like come on no one else had this problem?
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 09:14 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
eathExpLossLevel to value 0
Hybrid Mode
