Guild Creation problems

[Mersia]

well tryign to create guilds but its not working and in my
logs i get this little bit of a number. i have the latest peq
so i cant figure out what i might have missed bots got their
stuff players loaded ect ect. yer standard proceds... hopefully
i can get some light shined on it.


zone-dynamic_05.log:[Debug] [ZONE__INIT] Loading guilds
zone-dynamic_05.log:[Debug] command_init(): - Command 'guild' set to access level 10.
zone-dynamic_05.log:[Debug] command_init(): - Command 'guildapprove' set to access level 0.
zone-dynamic_05.log:[Debug] command_init(): - Command 'guildcreate' set to access level 0.
zone-dynamic_05.log:[Debug] command_init(): - Command 'guildlist' set to access level 0.
zone-dynamic_05.log:[Debug] command_init(): - Command 'guilds' set to access level 0.
zone-dynamic_05.log:[Status] Zoning 'Zenya' to: guildlobby (344) - (0) x=18.000000, y=-46.000000, z=6.000000
zone-dynamic_05.log:[Debug] [GUILDS__ACTIONS] Anorkah: Creating guild ScaledWolf with leader 2 with GM command. It was given id 1.
zone-dynamic_05.log:[Debug] [GUILDS__ERROR] Error loading guild member 'SELECT c.id,c.name,c.class,c.level,c.timelaston,c.zoneid, g.guild_id,g.rank,g.tribute_enable,g.total_tribute ,g.last_tribute, g.banker,g.public_note,g.alt FROM vwBotCharacterMobs AS c LEFT JOIN vwGuildMembers AS g ON c.id=g.char_id AND c.mobtype = g.mobtype WHERE c.id=2 AND c.mobtype = 'C'': #1054: Unknown column 'g.alt' in 'field list'
zone-dynamic_05.log:[Debug] [GUILDS__ERROR] Error loading guild member 'SELECT c.id,c.name,c.class,c.level,c.timelaston,c.zoneid, g.guild_id,g.rank,g.tribute_enable,g.total_tribute ,g.last_tribute, g.banker,g.public_note,g.alt FROM vwBotCharacterMobs AS c LEFT JOIN vwGuildMembers AS g ON c.id=g.char_id AND c.mobtype = g.mobtype WHERE c.id=2 AND c.mobtype = 'C'': #1054: Unknown column 'g.alt' in 'field list'
zone-dynamic_05.log:[Debug] [GUILDS__ERROR] Zenya: Unable to obtain guild char info for Zenya (2)
zone-dynamic_05.log:[Debug] [GUILDS__ERROR] Error loading guild member 'SELECT c.id,c.name,c.class,c.level,c.timelaston,c.zoneid, g.guild_id,g.rank,g.tribute_enable,g.total_tribute ,g.last_tribute, g.banker,g.public_note,g.alt FROM vwBotCharacterMobs AS c LEFT JOIN vwGuildMembers AS g ON c.id=g.char_id AND c.mobtype = g.mobtype WHERE c.id=2 AND c.mobtype = 'C'': #1054: Unknown column 'g.alt' in 'field list'
zone-dynamic_05.log:[Debug] [GUILDS__ERROR] Zenya: Unable to obtain guild char info for Zenya (2)
zone-dynamic_05.log:[Debug] [GUILDS__ACTIONS] Anorkah: Putting Zenya (2) into guild ScaledWolf (1) with GM command.
zone-dynamic_05.log:[Debug] [GUILDS__ERROR] Error loading guild member 'SELECT c.id,c.name,c.class,c.level,c.timelaston,c.zoneid, g.guild_id,g.rank,g.tribute_enable,g.total_tribute ,g.last_tribute, g.banker,g.public_note,g.alt FROM vwBotCharacterMobs AS c LEFT JOIN vwGuildMembers AS g ON c.id=g.char_id AND c.mobtype = g.mobtype WHERE c.id=2 AND c.mobtype = 'C'': #1054: Unknown column 'g.alt' in 'field list'
zone-dynamic_05.log:[Debug] [GUILDS__ERROR] Error loading guild member 'SELECT c.id,c.name,c.class,c.level,c.timelaston,c.zoneid, g.guild_id,g.rank,g.tribute_enable,g.total_tribute ,g.last_tribute, g.banker,g.public_note,g.alt FROM vwBotCharacterMobs AS c LEFT JOIN vwGuildMembers AS g ON c.id=g.char_id AND c.mobtype = g.mobtype WHERE c.id=2 AND c.mobtype = 'C'': #1054: Unknown column 'g.alt' in 'field list'
zone-dynamic_05.log:[Debug] [GUILDS__ERROR] Zenya: Unable to obtain guild char info for Zenya (2)
zone-dynamic_05.log:[Debug] [GUILDS__ACTIONS] Anorkah: Deleting guild ScaledWolf (1) with GM command.
zone-dynamic_05.log:[Debug] [GUILDS__ACTIONS] Anorkah: Creating guild ScaledWolf with leader 20 with GM command. It was given id 1.
zone-dynamic_05.log:[Debug] [GUILDS__ERROR] Error loading guild member 'SELECT c.id,c.name,c.class,c.level,c.timelaston,c.zoneid, g.guild_id,g.rank,g.tribute_enable,g.total_tribute ,g.last_tribute, g.banker,g.public_note,g.alt FROM vwBotCharacterMobs AS c LEFT JOIN vwGuildMembers AS g ON c.id=g.char_id AND c.mobtype = g.mobtype WHERE c.id=20 AND c.mobtype = 'C'': #1054: Unknown column 'g.alt' in 'field list'


if you assign the person to the guild and they attempt to log in it crashes the client

[joligario]

You don't have a complete database. This change was put in waaaay back in rev 1451.

Ah, I stand corrected. That's regular guilds. I missed the bots. The latest bots.sql covers this view change.

EDIT: Found it. That change was put in back in rev 1673.

[Mersia]

i figure t hat was the problem but im running the latest PEQ straight from the svn isnt it strange that its not put in to r2092? at http://projecteqdb.googlecode.com/svn/trunk/peqdatabase/ as i was instructed by the wiki's and various posts all over the forums as its what i needed.

[joligario]

If you are running bots, you still need to run the bots scripts.

PEQ does not support bots.

EDIT: Ah, yeah. I see where the confusion can come in. There are still bot scripts in the PEQ database. Yeah, you need to use the ones from the EQEmu utils folder.

[Mersia]

Generally it just takes the load_bots.sql aye? but looks like i'll have to go back in the other directory and look up all the other 'Bot' based SQL's and attempt to add them in?