Author |
Topic Search Topic Options
|
AllMor
Groupie
Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70
|
Post Options
Thanks(0)
Quote Reply
Topic: Strange letters Posted: 23 December 2022 at 9:09pm |
Since the 21'th of December, users of my forum have been unable to log in if they have Danish letters in their username. If they´re allready logged in, their posts looks strange, with strange letters. I haven't touched the forum for a long time, and can't understand what's going on. Any ideas on where to look for errors?
|
https://forum.excel-regneark.dk
|
 |
AllMor
Groupie
Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 December 2022 at 3:56pm |
This is the error I receive when I try to update the members profile. All the other profiles are updating fine, but when this profile is posting i my forum, danish letters are not showing correctly.
|
https://forum.excel-regneark.dk
|
 |
AllMor
Groupie
Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 December 2022 at 2:05pm |
I found the reason. My hostingprovider has updated the sql-driver from v5.3 to v8 the day i discovered the isue. It seems that WWF needs an update to run om that driver version. My forum is dead now  because I can't solve the problem myself.
Allan
|
https://forum.excel-regneark.dk
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9748
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 December 2022 at 4:21pm |
Sorry to hear of your problems with your forum.
Both the MyODBC 8 database driver and MySQL 8 Database server are supported by Web Wiz Forums 12.05.
To update the driver your host would have had to go in to your forum setting and changed the database connection string. This seems unlikely. What sounds more likely is that you host has updated their MySQL database servers to MySQL 8.
MySQL 8 is supported by Web Wiz Forums with no changes needing to to made, we host hundreds of Web Wiz Forums for our customers using MySQL 8 without issue. If you host has upgraded their database servers to MySQL 8 it sounds like something went wrong and the encoding for the data in your database.
If your host did go into your database/database_settings.asp file and change the database driver, which seems very unlikely, it needs to be set to the following for MyODBC 8
strMyODBCDriver = "8.0 Unicode"
Edited by WebWiz-Bruce - 29 December 2022 at 4:34pm
|
|
 |
AllMor
Groupie
Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 December 2022 at 10:23pm |
Hi Bruce
Thank you Bruce, I really appreciate your help
strMyODBCDriver = "8.0 Unicode" solved the connection-part of the problem. The forum is now running again, but still with the strange danish letters - only in new posts, not in post allready stored in the database before the sql update to v8.
The page encoding in WWF is set to Western European iso-8859-1 in phpMyAdmin the Server connection collation is set to utf8mb4_unicode_ci
Do I have to change something here?
Allan
Edited by AllMor - 31 December 2022 at 9:36am
|
https://forum.excel-regneark.dk
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9748
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 January 2023 at 8:28am |
During the period that the incorrect driver was set any posts saved would have been using an incorrect encoding, now that you have the correct driver any new posts will use the correct encoding.
It will likely mean that for those few days that the encoding was wrong those posts will always show incorrectly as the encoding that was used to save them would have been set incorrectly,
|
|
 |
AllMor
Groupie
Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 January 2023 at 1:24pm |
Hi Bruce
The solution that worked for me, was to change strMyODBCDriver to "8.0 ANSI" in the database_settings.asp file. After this change, the Danish letters are shown correct again.
I am very happy now  thanks for your help
//Allan
|
https://forum.excel-regneark.dk
|
 |