cant create guilds

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

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