Fix for Guilds and Faction!
ok when i added the 4.3 i had problems with the world.exe looking for some thing in the guild table, also i hade a problem with boot5zone.exe it poped up and wen away real fast i cought that it sayd some thing about faction tables, so i went to a fellow server op Darogar, at Darogar.net semi legit server and he was happy to provide me with the info to fix this problem, THANKS SO MUCH Darogar! heres how to use them
open mysql.exe in the bin folder, and type use eq then type source fix.sql then type source fixfaction.sql make sure you have the following attachments in the bin directory of mysql .... oh and un zip them to heheh for some rerason it wont let me post them as .sql files good luck, and thaks again to Darogar! izagod - Valudus of the Endless Time (legit) server! |
opps
no type source factionfix.sql
hehe not fixfaction.sql heheh :P |
Thanks for the info, I'll code this into my parser program ASAP.
|
Note
If you want a complete fix 0.4.2 to 0.4.3 you can get it here
http://www.darogar.net/42to43.sql And something important Izagod forgot to mention, Becarefull for this will completely destroy your faction table, and don't forget to source the npc_spells_id. - Darogar |
Thanks TheOne. This is what we should have included with the release. We use to create dbupgrade.sql 's that you could source in to convert your database to the new format. I think we need to get back into the habit..
|
player_corpses also need to be fixed
and a few more fix to the player_corpses. simply attach this to the 42to43fix.sql above.
ALTER TABLE player_corpses ADD COLUMN zoneid smallint(5) not null default '0' AFTER zonename; ALTER TABLE player_corpses DROP COLUMN time; ALTER TABLE player_corpses ADD COLUMN timeofdeath timestamp(14) not null AFTER data; :D |
Hey
Thanks ;) I added them to the file.
|
/cry I have the same issue even after applying the fix as me
Hello,
I have a new install of EqEmu (4.3) and after applying the changes memtioned here, I still have the error as mentioned above :cry: . What am I doing wrong? |
Load the 4.2 compatable DB file into a 4.2 SQL DB, then run the above stuff to update the entire thing (data and structure) to the 4.3 format
|
When I try to source any of the files on this thread, it whines about duplicate column names and tables already existing. What should I do to take out the original db?
This is the text in my happy little DOS-mysql.exe window: mysql> source factionfix.sql Query OK, 0 rows affected (0.06 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> source fix.sql; ERROR 1060: Duplicate column name 'minstatus' mysql> source 42to43.sql; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) ERROR 1050: Table 'npc_faction_entries' already exists ERROR 1060: Duplicate column name 'minstatus' ERROR 1091: Can't DROP 'usedspells'. Check that column/key exists ERROR 1060: Duplicate column name 'npc_spells_id' ERROR 1060: Duplicate column name 'zoneid' ERROR 1054: Unknown column 'zonename' in 'player_corpses' ERROR 1091: Can't DROP 'time'. Check that column/key exists ERROR 1060: Duplicate column name 'timeofdeath' |
well,
42to43.sql includes all the fixes mentioned in this thread. i'll suggest to just add in the top of the script DROP TABLE npc_faction_entries; This should avoid the error: ERROR 1050: Table 'npc_faction_entries' already exists The other errors mentioned in Floppies post just informs you that the modifications are already done. |
Right...thanks..lol
|
Right...thanks...lol
|
All times are GMT -4. The time now is 11:59 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.