Previous Thread
Next Thread
Print Thread
Rate Thread
Problems with mySQL while upgrading from 6.5 to 7 #312785
01/19/2007 7:25 AM
01/19/2007 7:25 AM
Joined: Jan 2007
Posts: 1
P
Punze Offline OP
Lurker
Punze  Offline OP
Lurker
P
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
Re: Problems with mySQL while upgrading from 6.5 to 7 [Re: Punze] #312791
01/19/2007 10:50 AM
01/19/2007 10:50 AM
Joined: Mar 2000
Posts: 25,587
Texas
AllenAyres Offline
I type Like navaho
AllenAyres  Offline
I type Like navaho
Joined: Mar 2000
Posts: 25,587
Texas
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?
Re: Problems with mySQL while upgrading from 6.5 t [Re: AllenAyres] #313028
02/01/2007 8:23 PM
02/01/2007 8:23 PM
Joined: Oct 2000
Posts: 2,518
navahoville! :D
N
navaho Offline
Veteran
navaho  Offline
Veteran
N
Joined: Oct 2000
Posts: 2,518
navahoville! :D
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.
Re: Problems with mySQL while upgrading from 6.5 t [Re: navaho] #313047
02/02/2007 3:39 PM
02/02/2007 3:39 PM
Joined: May 2000
Posts: 1,820
Istanbul, Turkey
Burak Offline
Addict
Burak  Offline
Addict
Joined: May 2000
Posts: 1,820
Istanbul, Turkey
You can alter the charset and collation of the table:

Code
ALTER TABLE <table> DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci




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
· Blue Host
· Interserver.net
Visit Us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,170
Joined: July 2001
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,448
Posts293,484
Members13,793
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,938
Greg Hard 5,533
Top Posters(30 Days)
isaac 4
Today's Statistics
Currently Online 732
Topics Created 0
Posts Made 0
Users Online 2
Birthdays 21
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180611.dev)
Page Time: 0.033s Queries: 15 (0.010s) Memory: 3.2417 MB (Peak: 3.3801 MB) Zlib enabled. Server Time: 2018-06-21 23:56:26 UTC