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 . "`");
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 . "`");
Who is online
Users browsing this forum: No registered users and 6 guests