Updating Mango Blog - db upgrade issues
Couple of tips when you're updating Mango Blog and you're running into vague "Couldn't upgrade database" messages with no further information.
Tip #1: Make sure your db user has the appropriate permissions (insert, update, select, delete, create, alter, drop).
Tip #2: Make sure that the DSN that is logging in as that db user has the appropriate permission:
Tip #3: After you're done updating, remember to remove Alter, Drop, Create.
Aaron West wrote on 02/19/10 1:02 PM
I like Mango and for a while I liked it's one-click button upgrade. Now I simply can't stand it. I've tried upgrading from 1.3.x to 1.4 several times now. I've done all the things you mention to ensure the DSN and user have appropriate access and still the upgrading fails displaying the message you mention. In fact, it fails so miserably that I've had to nuke my entire directory structure, drop my database, restore DB from backup, and FTP all the code back up (also from a backup).It's nuts. I've mentioned my problem on the Mango forums and never got anywhere. I've pretty much given up on upgrading and will probably move that particular site to BlogCFC in the future.