Post by onelouder » Tue Aug 18, 2009 11:39 pm

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?

New member

Posts

Joined
Tue May 26, 2009 10:15 pm

Post by onelouder » Wed Aug 19, 2009 12:19 am

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?

New member

Posts

Joined
Tue May 26, 2009 10:15 pm

Post by onelouder » Wed Aug 19, 2009 3:04 am

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 . "`");

New member

Posts

Joined
Tue May 26, 2009 10:15 pm

Post by jules_nz » Wed Aug 19, 2009 5:16 am

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

Your fix worked perfectly
Thanks onelouder

Active Member

Posts

Joined
Tue Aug 11, 2009 12:58 pm
Who is online

Users browsing this forum: No registered users and 22 guests