EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)
-   -   Guild Creation problems (https://www.eqemulator.org/forums/showthread.php?t=34807)

Mersia 01-30-2012 06:57 AM
Guild Creation problems
 
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.

Code:
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 01-30-2012 07:13 AM
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 01-30-2012 07:25 AM
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/sv...k/peqdatabase/ as i was instructed by the wiki's and various posts all over the forums as its what i needed.

joligario 01-30-2012 07:30 AM
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 01-30-2012 07:48 AM
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?


All times are GMT -4. The time now is 04:43 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.