EQEmulator Forums - cant create guilds

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - cant create guilds (https://www.eqemulator.org/forums/showthread.php?t=29535)

only thing i could find:

Code:

[09.17. - 16:08:42] [GUILDS__ERROR] Found rank 2 for non-existent guild 1, skipping.

[09.17. - 16:08:42] [GUILDS__ERROR] Found rank 2 for non-existent guild 2, skipping.

[09.17. - 16:08:42] [GUILDS__ERROR] Found rank 1 for non-existent guild 2, skipping.

[09.17. - 16:08:42] [GUILDS__ERROR] Found rank 0 for non-existent guild 2, skipping.

[09.17. - 16:08:42] [GUILDS__ERROR] Found rank 1 for non-existent guild 1, skipping.

[09.17. - 16:08:42] [GUILDS__ERROR] Found rank 0 for non-existent guild 1, skipping.

I found those errors in the zones log file. and I really don't know why its not working, I use navicat to source most of my stuff as its easier to understand hehe.

Change the sql-mode setting in my.ini to a blank string. MySQL defaults this setting to STRICT_TRANS_TABLES on Windows and blank on Linux so the behavior of the storage engine is slightly different (disallowing default values on Blob and Text type fields).

Also the MySQL documentation indicates that not allowing default values on these types is the correct behavior so it would probably be better to fix up the source to insert a value into these fields (even if that value is just a blank string).

So has anyone figured this issue out? I just ordered a 32 bit system, installed and I am still having this issue...

We are on the newest revision, I just compiled it.
ActivePearl 5.10
MySQL 5.1
Windows XP 32bit

<-- GRIM From "The Order of Sin" server.

Quote:

Originally Posted by nightsta69 (Post 178679)

hmm, thats weird. again my mysql isn't all that great. here is my guild_members.sql that i used to make it work. maybe there is somethin extra in it that made it work.

guild_members.rar

THANK YOU! This fixed guild creation!

However we are still not able to see guild members in the roster. Would you mind uploading the other guild fields for me?

Quote:

Originally Posted by lich2594 (Post 178686)

So has anyone figured this issue out? I just ordered a 32 bit system, installed and I am still having this issue...

Yeah you could use the suggestions posted or you could use a hack like this to get guild membership working.

Code:

Index: EQEmuServer/common/guild_base.cpp

===================================================================

--- EQEmuServer/common/guild_base.cpp   (revision 978)

+++ EQEmuServer/common/guild_base.cpp   (working copy)

@@ -651,7 +651,7 @@



        if(guild_id != GUILD_NONE) {

                if (!m_db->RunQuery(query, MakeAnyLenString(&query,

-                       "REPLACE INTO guild_members (char_id,guild_id,rank) VALUES(%d,%d,%d)",

+                       "REPLACE INTO guild_members (char_id,guild_id,rank,public_note) VALUES(%d,%d,%d,'')",

                        charid, guild_id, rank), errbuf))

                {

                        _log(GUILDS__ERROR, "Error Changing char %d to guild %d '%s': %s", charid, guild_id, query, errbuf);

That's not really a proper fix. Whatever public_note is supposed to be doing might get screwed up if you did this, but at least you would be able to add characters to guilds again.

Quote:

Originally Posted by Wesell (Post 178684)

so this would be correct?

Code:

# Set the SQL mode to strict

sql-mode=

nightsta69's table ended up working for me. thank you all.

Quote:

Originally Posted by eqemuross (Post 178697)

nightsta69's table ended up working for me. thank you all.

glad I could help :D

Quote:

Originally Posted by nightsta69 (Post 178698)

glad I could help :D

thanks again... EQEmu community has been more than helpful with me on my project.

thank you everyone!