Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Strange letters
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Strange letters

 Post Reply Post Reply
Author
AllMor View Drop Down
Groupie
Groupie
Avatar

Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70
Post Options Post Options   Thanks (0) Thanks(0)   Quote AllMor Quote  Post ReplyReply Direct Link To This Post 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?
Allan


https://forum.excel-regneark.dk
Back to Top
AllMor View Drop Down
Groupie
Groupie
Avatar

Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70
Post Options Post Options   Thanks (0) Thanks(0)   Quote AllMor Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
AllMor View Drop Down
Groupie
Groupie
Avatar

Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70
Post Options Post Options   Thanks (0) Thanks(0)   Quote AllMor Quote  Post ReplyReply Direct Link To This Post 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 Cry because I can't solve the problem myself.

Allan


https://forum.excel-regneark.dk
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9748
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
AllMor View Drop Down
Groupie
Groupie
Avatar

Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70
Post Options Post Options   Thanks (0) Thanks(0)   Quote AllMor Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9748
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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,  
Back to Top
AllMor View Drop Down
Groupie
Groupie
Avatar

Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70
Post Options Post Options   Thanks (0) Thanks(0)   Quote AllMor Quote  Post ReplyReply Direct Link To This Post 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 Big smile thanks for your help

//Allan

https://forum.excel-regneark.dk
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.06
Copyright ©2001-2023 Web Wiz Ltd.


Become a Fan on Facebook Follow us on Twitter Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2023 Web Wiz Ltd. All rights reserved.