backup error 1.3.2

Error: Access denied for user 'brockha1_brock'@'localhost' to database ''brockha1_ocdb'
Error No: 1044
SHOW TABLES FROM `'brockha1_ocdb`

i get this error when trying to do a backup from opencart backend

Any ideas.

Stewart

I also have this problem

Error: Access denied for user

the error log and backup

Same problem for me. Any ideas??

Edit - Nevermind. Figured it out. The lookup had an extra single apostrophe in the backup.php file.

I found this problem a while back and thought I posted it to the forum...I can't find the link to it but here is the solution for those who run into it.

Edit this file:

admin/model/tool/backup.php

Edit line ~16
It's hard to see but right after FROM there is ` then ' and then ". Get rid of the second one, the '

Save and away you go.

thank you for the fix

Thanks For this Kev,

Helped a lot.

Stewart

Hello, after applying this fix, I wanted to test the restore portion... and this is what I get:
Warning: file_get_contents() [function.file-get-contents]: Filename cannot be empty in /home/home2/public_html/store/admin/controller/tool/backup.php on line 13Warning: Cannot modify header information - headers already sent by (output started at /home/home2/public_html/store/admin/index.php:57) in /home/home2/public_html/store/system/engine/controller.php on line 23

Please help!

What I have suggested to fix the export issue does not interfere with the issue you are having. Seeing you are changing a query string in model/tool/backup.php. You will see near the top that the only thing present for restore is the public function. This merely takes what is in the file and breaks up the information contained in the CSV file you are importing.

I have tried to duplicate your issue by submitting the form without choosing a file. It states that I have imported the file successfully. So it can't be you submitting no CSV file.

I then went looking for the handler for the file upload form. I found this:

admin/controller/tool/backup.php

The form itself is coded to upload the file directly to the server. tmp_name contains the path to the temporary file(the CSV file that was just uploaded) that resides on the server. The file should exist on the server in a temporary directory with a temporary name. This sounds to be a server configuration problem. What type of web server are you using? (Linux/Windows)

I am running Linux. It is interesting, because I ran a previous install of OC and I don't have this problem.

But is the line I quoted the same line you have in your backup.php file?

Im having this backup error and I have doen the fix but it is still saying access denied error 1044. any suggestions?

i did it again and it worked

kdmp wrote:...Edit this file: admin/model/tool/backup.php
Edit line ~16...

Thank you, kdmp. Worked for me too.