Username: Password:
  Create an account Home  ·  Game Manager  ·  Forums  ·  Your Account  
Login
Username

Password

Don't have an account yet? You can create one.

Site Sections
· Home
· Game Manager
· Forums
· Private Messages
· Your Account

Game Manager
· Your games
· Waiting games
· Create new game
· Running games
· Completed games

Recent News

MaBiWeb: Forums

MaBiWeb :: View topic - Nations games with special characters not reachable
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Nations games with special characters not reachable
Goto page 1, 2  Next
 
Post new topic   Reply to topic    MaBiWeb Forum Index -> Bug reports
View previous topic :: View next topic  
Author Message
goonzo



Joined: May 10, 2017
Posts: 6
Location: Sweden

PostPosted: Thu Aug 26, 2021 11:03 am    Post subject: Nations games with special characters not reachable Reply with quote

As of today our tournament games are not reachable anymore.
eg: http://www.mabiweb.com/modules.php?name=GM_Nations&g_id=87472&op=view_game_reset
Back to top
View user's profile Send private message
Kayser



Joined: Feb 12, 2021
Posts: 12

PostPosted: Thu Aug 26, 2021 11:21 am    Post subject: Reply with quote

It worked until around 10 am
Back to top
View user's profile Send private message
Tankare



Joined: Jun 10, 2018
Posts: 1

PostPosted: Thu Aug 26, 2021 11:41 am    Post subject: Reply with quote

Same here, you can't play or even view them anymore
Back to top
View user's profile Send private message
megaorvar



Joined: Jul 19, 2018
Posts: 3

PostPosted: Thu Aug 26, 2021 12:23 pm    Post subject: Reply with quote

Same error with our game.

Error: invalid position for Nations game #87260
Back to top
View user's profile Send private message
MaBi
Site Admin


Joined: Jan 01, 2006
Posts: 999
Location: Italy

PostPosted: Thu Aug 26, 2021 2:35 pm    Post subject: Re: Nations games with special characters not reachable Reply with quote

goonzo wrote:
As of today our tournament games are not reachable anymore.
eg: http://www.mabiweb.com/modules.php?name=GM_Nations&g_id=87472&op=view_game_reset

Today the host provider upgraded MySQL and the new version of the database is creating these problems. There could be some easy and fast way to fix this but I don't know the details about mysql charcter sets and I don't have time to dedicate to fully study and debug the issue.
I think I know a way to fix a specific broken game but this must be done separately for each game, so I can do it only if there aren't too many games to fix.
I have done this on the game 87472, so please try accessing it and take a few moves so we can confirm that it works and there are no side effects.
Back to top
View user's profile Send private message Visit poster's website
Kayser



Joined: Feb 12, 2021
Posts: 12

PostPosted: Thu Aug 26, 2021 2:55 pm    Post subject: Reply with quote

It seems the Swedish characters (åäö) are still corrupted in the title of the game, and in the chat history.

I don't know if the issue will be there for new games/chat messages, and I don't know when the chat message as such was posted.

This is perhaps not a critical issue but of course it is not very pretty.
Back to top
View user's profile Send private message
goonzo



Joined: May 10, 2017
Posts: 6
Location: Sweden

PostPosted: Thu Aug 26, 2021 3:12 pm    Post subject: Re: Nations games with special characters not reachable Reply with quote

MaBi wrote:
goonzo wrote:
As of today our tournament games are not reachable anymore.
eg: http://www.mabiweb.com/modules.php?name=GM_Nations&g_id=87472&op=view_game_reset

Today the host provider upgraded MySQL and the new version of the database is creating these problems. There could be some easy and fast way to fix this but I don't know the details about mysql charcter sets and I don't have time to dedicate to fully study and debug the issue.
I think I know a way to fix a specific broken game but this must be done separately for each game, so I can do it only if there aren't too many games to fix.
I have done this on the game 87472, so please try accessing it and take a few moves so we can confirm that it works and there are no side effects.


Yes, this works now. Thank you.
But unfortunately all our tournament games (7more) suffers from the same issue.
The name of the games is "Svenska mästerskapen".
/Martin
Back to top
View user's profile Send private message
orinfury



Joined: Jun 15, 2021
Posts: 1

PostPosted: Thu Aug 26, 2021 3:40 pm    Post subject: Reply with quote

MaBi it looks like encoding of the database/table have been changed

You may check current encoding by following instructions in this link -
https://stackoverflow.com/questions/1049728/how-do-i-see-what-character-set-a-mysql-database-table-column-is

And this link describes how to change encoding -
https://stackoverflow.com/questions/202205/how-to-make-mysql-handle-utf-8-properly

/BR, Alexander
Back to top
View user's profile Send private message
MaBi
Site Admin


Joined: Jan 01, 2006
Posts: 999
Location: Italy

PostPosted: Thu Aug 26, 2021 3:42 pm    Post subject: Re: Nations games with special characters not reachable Reply with quote

goonzo wrote:

The name of the games is "Svenska mästerskapen".

I should have fixed all of them, and a few others that I noticed. But surely there are still other games to fix, please report them here.
Back to top
View user's profile Send private message Visit poster's website
MaBi
Site Admin


Joined: Jan 01, 2006
Posts: 999
Location: Italy

PostPosted: Thu Aug 26, 2021 3:50 pm    Post subject: Reply with quote

orinfury wrote:
MaBi it looks like encoding of the database/table have been changed

You may check current encoding by following instructions in this link -
https://stackoverflow.com/questions/1049728/how-do-i-see-what-character-set-a-mysql-database-table-column-is

And this link describes how to change encoding -
https://stackoverflow.com/questions/202205/how-to-make-mysql-handle-utf-8-properly

/BR, Alexander


Thank you for your suggestion. I already googled that (or something similar), but
- I tried the suggested conversion on a backup copy of the DB and it didn't fix the games;
- It's not clear which are the side effects (I have read something about possible changes to NULL values) and a change like that on the whole DB is scary, even after testing on a copy there could be downsides that turn up later.
So I would need much more time to fully test everything before changing the DB.
Back to top
View user's profile Send private message Visit poster's website
Kayser



Joined: Feb 12, 2021
Posts: 12

PostPosted: Thu Aug 26, 2021 4:11 pm    Post subject: Reply with quote

87474 please
Back to top
View user's profile Send private message
MaBi
Site Admin


Joined: Jan 01, 2006
Posts: 999
Location: Italy

PostPosted: Thu Aug 26, 2021 4:18 pm    Post subject: Reply with quote

Kayser wrote:
87474 please

Done, together with a few others.
Back to top
View user's profile Send private message Visit poster's website
Kayser



Joined: Feb 12, 2021
Posts: 12

PostPosted: Thu Aug 26, 2021 4:23 pm    Post subject: Reply with quote

THanks!!

New chat seems to work, too (old chat is still partially corrupted)
Back to top
View user's profile Send private message
Wondermoose



Joined: May 16, 2017
Posts: 1

PostPosted: Thu Aug 26, 2021 4:46 pm    Post subject: Reply with quote

87312

Can you fix this one please :)
Back to top
View user's profile Send private message
MaBi
Site Admin


Joined: Jan 01, 2006
Posts: 999
Location: Italy

PostPosted: Thu Aug 26, 2021 5:37 pm    Post subject: Reply with quote

Wondermoose wrote:
87312

Done.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    MaBiWeb Forum Index -> Bug reports All times are GMT + 1 Hour
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group
Forums ©

 
MaBiWeb copyright © 2006 by MaBi
PHP-Nuke Copyright © 2005 by Francisco Burzi.
Page Generation: 0.05 Seconds