ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: dbowen1 on August 11, 2005, 04:21:46 pm

Title: access denied upon upgrade
Post by: dbowen1 on August 11, 2005, 04:21:46 pm

Dean,

I get the following error when I try to upgrade to 1.83.

Upgrade detected!
Please wait while your database is updated
It is very important that you do not interrupt this process
DB Version: 1.77  New DB Version: 1.83
0Access denied for user: 'xxx@localhost' to database 'xxx'

After that nothing happens... no status bar progress.

What to do?

Thanks,
Dan

Title: access denied upon upgrade
Post by: DW on August 11, 2005, 09:42:30 pm

The error occurs on line 597 of upgrade.php

mysql_query("ALTER TABLE $utable CHANGE user1 user1 TEXT NOT NULL") or die('0'.mysql_error());

It would appear that your MySQL user does not have permission to use the "ALTER TABLE" MySQL function.  Please look in your control panel or talk to you host about getting access.

Regards