Author Topic: Can't upgrade to 1.1.8 or above; no SQL dump?  (Read 5446 times)

Offline marshallasl

  • Newbie
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Can't upgrade to 1.1.8 or above; no SQL dump?
« on: June 02, 2014, 10:49:12 PM »
I repeatedly receive the error message, "Error: Can't create sql dump of database during backup" when I try to upgrade my shopping cart to 1.1.8, either through the package installer or through extension upload. I only created the cart recently and it was set up with version 1.1.7. I don't know what to do at this point! I've read through the forums and support documentation but nothing answers my question. Do you know how to fix this? Could it be it a problem with my softalicious installation? Does something need to be changed in the setup?
« Last Edit: June 02, 2014, 11:02:13 PM by marshallasl »

Offline marshallasl

  • Newbie
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Can't upgrade to 1.1.8 or above; no SQL dump?
« Reply #1 on: June 02, 2014, 11:00:27 PM »
I get the same error when I attempt to back up my cart. I was able to download a compressed tar.gz file of the backup, so something worked -- but I keep getting the error message whenever I run a backup, a few minutes after the backup is completed.

Offline llegrand

  • Hero Member
  • *****
  • Posts: 1798
  • Karma: +520/-7
    • View Profile
Re: Can't upgrade to 1.1.8 or above; no SQL dump?
« Reply #2 on: June 02, 2014, 11:35:08 PM »
did you change your file permissions to the correct settings?

In the documentation are the files that often need changing  http://www.abantecart.com/ecommerce-documentation/20-installation

One of them if admin/sysem/backup/  needs to be 0777

check out those permissions and see if that solves your issue.

Lee

Offline marshallasl

  • Newbie
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Can't upgrade to 1.1.8 or above; no SQL dump?
« Reply #3 on: June 03, 2014, 02:06:25 AM »
Thank you for that link -- I installed through softalicious (which the documentation mentions at the end) and yet I am encountering this error. Where can I go (in PHPmyAdmin?) to change the setting that might be causing the issue? In my file directory, the folder that you mention looks like this and it appears that the permissions are correct...? (See right-hand side of screenshot.) Thanks again!
« Last Edit: June 03, 2014, 02:10:12 AM by marshallasl »

Offline llegrand

  • Hero Member
  • *****
  • Posts: 1798
  • Karma: +520/-7
    • View Profile
Re: Can't upgrade to 1.1.8 or above; no SQL dump?
« Reply #4 on: June 03, 2014, 08:26:00 AM »
the screen shot is off your backup file.

Here's where you need to be checking the permissions:
cPanel
File Manager
select public_html
 If you have your abantecart in a directory - select that directory
Then  -  open Admin, open system
Check the permissions on BACKUP - needs to be 777, if not -
Highlight backup (by clicking on it)   select Change Permission from tool ribbon above, add check marks in the box until you have the permissions you need (takes all of them)-

It is not a setting within phpMyAdmin.

« Last Edit: June 03, 2014, 08:30:34 AM by llegrand »

Offline marshallasl

  • Newbie
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Can't upgrade to 1.1.8 or above; no SQL dump?
« Reply #5 on: June 03, 2014, 08:31:33 PM »
Thank you so much for all of your direction! I have followed your instructions but it still appears that everything is already correct.

The screenshot shows how it was already set up without changing anything. I'm baffled. Is there something else that may be set up incorrectly? Because I'm thinking it's not the permissions. :(
« Last Edit: June 03, 2014, 10:05:38 PM by marshallasl »

Offline smileyrebs

  • Newbie
  • *
  • Posts: 6
  • Karma: +1/-0
    • View Profile
Re: Can't upgrade to 1.1.8 or above; no SQL dump?
« Reply #6 on: June 03, 2014, 09:50:00 PM »
Hi there, I am also having issues upgrading and am getting the same error. I have changed all the permissions but keep getting the same error.

 

Powered by SMFPacks Social Login Mod