OpenCart Community

Hello, After using hcamelion steps to upgrade from 1.3.0 to 1.3.2 and running the db_changes.sql file it worked fine. But now when i try to back up the database i get the following error below. User group permissions are set.

Error: Access denied for user 'xxxxxx'@'%' to database ''xxxxxx'
Error No: 1044
SHOW TABLES FROM `'xxxxxx`

Is anyone else who used the same instructions to upgrade to 1.3.2 from 1.3.0 having the same problem when trying to back up there database?

I beleive the problem is that i used a different username and password for the fresh database different from my old database. So its referencing it somewhere? I've checked the config.php in the main dir and the admin config.php theres no reference to them in there, is there any other files where this could be?

Sorted!
It was an issue with a stray quote in admin/model/tool/backup.php

The original line was:
$table_query = $this->db->query("SHOW TABLES FROM `'" . DB_DATABASE . "`");

which needs to be:
$table_query = $this->db->query("SHOW TABLES FROM `" . DB_DATABASE . "`");

I just tried it and I got the same error (I was v1.3.0 - 1.3.2)

Your fix worked perfectly
Thanks onelouder