Author Topic: access denied upon upgrade  (Read 1491 times)

dbowen1

  • Posts: 19
    • View Profile
access denied upon upgrade
« 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

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
access denied upon upgrade
« Reply #1 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
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting