mySQL update 4.0.27 to 4.1.22 breaks code pls help!

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
gilk9
Forum Newbie
Posts: 2
Joined: Sun Aug 16, 2009 1:08 am

mySQL update 4.0.27 to 4.1.22 breaks code pls help!

Post by gilk9 »

Hi,
have had a mySQL database running on Godaddy shared linux host for 3 years without problem.
Thought I would like to do some enhancement on it but not wanting to stuff up a working system I thought I would create another mySQL database to test the changes before committing them to go live.
Problem is that the authentication on new DB does not work. Identical code except for the new database name and password.
Using cookie session and password hashing.
The connection obviously occurs because the login window appears, But when the username and password are entered, the query dies and I am returned to the login page.
Since constructing the initial working database, Godaddy is now offering mySQL versions of 4.1.22 or version 5.
The original DB which I dumped and imported into new DB is still in 4.0.27. I Know the password hashing algorithm has changed, and the field size has to be increased to 41 chrs to accommodate this. I can see everything in new DB OK in MySQLFront, and phpMyAdmin, just cant connect via firefox, ie or safari.
Can anyone help me as to where I should look to fix this issue.
TIA
gilk9
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: mySQL update 4.0.27 to 4.1.22 breaks code pls help!

Post by Eran »

I Know the password hashing algorithm has changed
generate a new password or reset it for your main user. if you can't do it yourself, ask your provider to do it for you
gilk9
Forum Newbie
Posts: 2
Joined: Sun Aug 16, 2009 1:08 am

Re: mySQL update 4.0.27 to 4.1.22 breaks code pls help!

Post by gilk9 »

pytrin wrote:
I Know the password hashing algorithm has changed
generate a new password or reset it for your main user. if you can't do it yourself, ask your provider to do it for you
Thanks for the reply, but it is not relevant because I can do all that thru phpMyAdmin, and even create new test users with the new 41 character hashed password but still the problem continues.....The connection obviously occurs because the login window appears, But when the username and password are entered, the query dies and the user is returned to the login page.
Any more thoughts???
gilk9
Post Reply