Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

its not working did u test it ? it create guild after restart but its not working normaly theres no message nothink #111

Closed
Supacek opened this issue Dec 13, 2022 · 8 comments · Fixed by #116

Comments

@Supacek
Copy link

Supacek commented Dec 13, 2022

    its not working did u test it ? it create guild after restart but its not working normaly theres no message nothink

Originally posted by @Supacek in #97 (comment)

@Supacek
Copy link
Author

Supacek commented Dec 13, 2022

u change it for mysql 8 and now its not working for mysql 5...

@Supacek
Copy link
Author

Supacek commented Dec 13, 2022

image

@Supacek
Copy link
Author

Supacek commented Dec 13, 2022

image

@Supacek
Copy link
Author

Supacek commented Dec 13, 2022

when i change it like before it was working but i redownload ur changes and its not working

@Supacek
Copy link
Author

Supacek commented Dec 13, 2022

i added the intro into that shared file Guild.cpp
"INSERT INTO GuildMember( GuildID, Name, Rank, Intro ) VALUES ( %d, '%s', %d, 1 )",

@Supacek
Copy link
Author

Supacek commented Dec 13, 2022

and its working now but idk what happened when player put somethink in intro... there must be more testing

@Supacek
Copy link
Author

Supacek commented Dec 13, 2022

we should make just One mysql version and not 5 and 8

@tiancaiamao
Copy link
Contributor

OK, I see. Thanks for your feedback. @Supacek

This can be fixed by removing the STRICT_TRANS_TABLES from the sql_mode:

mysql> select @@global.sql_mode;
+-----------------------------------------------------------------------------------------------------------------------+
| @@global.sql_mode                                                                                                     |
+-----------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
+-----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

I'll update here.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants