General Discussion
Topic: User logins after MySQL version change

Hi there,

For whatever reasons, I had to move from a box that I was running my site on PHP 4.4.4 and MySQL 4.1.22-standard to another one with PHP 5.1.6 and MySQL 5.0.22

I mainly use my site for articles, and users need to login to submit articles under their name.

I can login as the administrator of the site, and there are a couple of minor problems, nothing major.

The only major problem I need to sort out is for users to login as their attempts are failing.

I have used search here to determine any SQL queries to be run, but haven't been able to get the fix suggested as I see the user is no longer using this CMS.

I have tried running the info on http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html

and have run mysql_upgrade executes the following commands:


Which gives me:



Request assistance as to how to get users to login after the change in MySQL versions.

Regards.


-----------------
Cyrus
PromotionData.com
(A division of ThePromotionGroup network)

When our server hosts updated the servers to MySQL 5 it took my "technical bod" 4 days of tinkering to get it fixed. Eventually we got our server hosts to sort it out, and to this day they haven't told us what they did to sort it out (they never do).

So basically I can't help, but only sympathise!


-----------------

One thing I DO remember was that it appeared that the server wasn't storing "cookies" - HENCE THE LOG-IN PROBLEMS!

Trying to get there....have updated pages from the CVS and manually have to change user passwords.

If I try to get too elaborate in my post I'm being knocked off as a s....er.

Have had to go back a version of mainfile as the latest CVS one did not display my page columns.

Had to go back to the original memberlist as the new one did not display.

Lets see if this post comes up!

Same thing happened to my site. After upgrade to Mysql5:

1. User cant login
2. User become Deleted User

Solution: the only solution is downgrade back to Mysql4.

Any other solution (or patch)?

If you're with a web host, they will upgrade MySQL and your database should be covered for new priveleges and features.

With regards to PHP I guess that you will have to update from the CVS here.

In my case, I have my own box that I loaded with PHP and MySQL 5. It's controlled by the Virtualmin Professional control panel (Absolutely fabulous I have to say)on CentOS and I imported mpn from an old cPanel host I was using who were still running 4.

So, my solution is to allocate fresh passwords when I get a query stating that a user cannot login. I'm sure there's another way, but am not aware.

The person on this forum who was advertising some updates for 5 is no longer running mpn. I tried to contact him but got no response.

A few issues still don't work like archives and a few other bits and pieces, but I can put up with that. I use mpn mainly for articles, and do not use the forum, chat, etc.

Regards.


-----------------
Cyrus
PromotionData.com
(A division of ThePromotionGroup network)

Will someone create a patch for this matter.... this is urgent issue

I would appreciate a solution to this too.