There are 3 unavoidable facts to life, death, taxes and the first time that someone registers and posts on a tech forum its because they've got a problem they can't solve.
In keeping with #3, I've had the following error when attempting to action an upgrade to 4.2 -
Error during upgrade: failed to execute statement ALTER TABLE mt_entry ADD entry_ping_count integer DEFAULT 0: Access denied for user 'visvoice'@'localhost' to database 'visvoice_mt' at lib/MT/Upgrade.pm line 2553.
The error message occurs at this stage of the automated upgrade -
* Upgrading database from version 3.1.
* Upgrading table for MT::Blog::Meta records...
* Upgrading table for Tag Placement records...
* Upgrading table for MT::Comment::Meta records...
* Upgrading table for Configuration records...
* Upgrading table for Entry records...
I'm struggling to find exactly where the problem is in the upgrade file, as to why access should be denied at this point. I'm hopeful someone rather more knowledgeable than me in the ways of MT may be able to assist me.
I don't suppose there's a sql file upgrade route, rather than the automated system?
Reported on Movable Type 4.2
The "Acess denied" error is saying that you have a MySQL user ("visvoice") that doesn't have full rights to the database to make table alterations. You need to grant permissions in MySQL to this user to do that, then access MT again, which will cause the upgrade process to resume where it left off.
Doh, my bad, you'd think I'd have spotted that what with it being in CAPS!
2 minutes in MyAdmin and all is good, thanks Brad!
Hi Nawang,
I gather that your glitch is solved!
Is that right?
Kind Regards,
Mihai