cant create guilds

[eqemuross]

only thing i could find:

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

[nightsta69]

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.

[Wesell]

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

[Wesell]

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

[lich2594]

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.

[lich2594]

Originally Posted by nightsta69

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?

[Wesell]

Originally Posted by lich2594

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.

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.

[eqemuross]

Originally Posted by Wesell

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

so this would be correct?

# Set the SQL mode to strict
sql-mode=

[eqemuross]

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

[nightsta69]

Originally Posted by eqemuross

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

glad I could help

[eqemuross]

Originally Posted by nightsta69

glad I could help

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

thank you everyone!