search

Znote / ZnoteAAC

Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server.
MIT License
145 stars 127 forks source link

create guild bug #385

Closed Methemia closed 4 years ago

Methemia commented 4 years ago

Guild list is empty.

string(109) "INSERT INTO guilds (name, ownerid, creationdata, motd) VALUES ('Staffffff', '1', '1583630902', '');" (query - SQL error) Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'description' doesn't have a default value

HalfAway commented 4 years ago

What server engine do you use?

Znote commented 4 years ago

As HalfAway says, what distro are you using? Znote AAC is cross compatible between multiple distros, but I have yet to see anything with a description column in the guilds table, thats what we use motd for.

Could it be another AAC has cluttered your original tables?

Methemia commented 4 years ago

I'm using tfs 1.3 and the datapack of opentibiabr

Znote commented 4 years ago

I have submitted a patch to opentibiabr to resolve this bug, for now you can enter phpmyadmin -> select db -> SQL and run this query to fix it:

ALTER TABLE `guilds` 
CHANGE `description` `description` TEXT NOT NULL DEFAULT ''