Fix for Guilds and Faction!

[izagod]

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!

[izagod]

no type source factionfix.sql
hehe not fixfaction.sql heheh :P

[Drawde]

Thanks for the info, I'll code this into my parser program ASAP.

[TheOne]

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

[Trumpcard]

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..

[rockocool]

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;

[TheOne]

Thanks I added them to the file.

[ChuckUFarley]

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?

[Lurker_005]

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

[IAFloppie]

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'

[Mauritius]

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.

[IAFloppie]

Right...thanks..lol

[IAFloppie]

Right...thanks...lol