Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Jan 2007
Posts: 1
Lurker
Lurker
Offline
Joined: Jan 2007
Posts: 1
Hi there,

I've got a problem with upgrading an existing installation (version 6.5) to version 7.02. The problems seems to be in the Import-Script for version 7.02. Before upgrading the existing database the Collation of mySQL is "utf8_general_ci". After running the import script to update the database, the Collation is switched to "Latin1_swedish_ci". I do not know why and if this is right. The problem is that no password of any user account is accepted anymore when I try to login to the new version 7.02 (after the upgrade). The user still exists, but the password is not accepted anymore. I think this problems belongs to the databse. Does anyone know this problem or can me help to solve it?

Thank you!

Regards, Johnny

Sponsored Links
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
hmmm... this could explain some of the issues I had with the upgrade too and why photopost logins are giving me heck.


- Allen wavey
- What Drives You?
Joined: Oct 2000
Posts: 2,223
Veteran
Veteran
Offline
Joined: Oct 2000
Posts: 2,223
In none of the scripts can I see where he defines that. He defines table type=MYISAM and that's it. In the installer for 6.5 I'm not even sure if he does that, just leaves it default.

Have you updated MySQL between your initial installation of the 6 series and now? If so it is likely that the default type of your MySQL changed.


Picture perfect penmanship here.
Joined: May 2000
Posts: 1,356
Addict
Addict
Joined: May 2000
Posts: 1,356
You can alter the charset and collation of the table:

Code

ALTER TABLE <table> DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci



Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Bill B
Bill B
Issaquah, WA
Posts: 87
Joined: December 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)