Author Topic: Extracts not working after store move  (Read 4554 times)

Offline jcschott

  • Newbie
  • *
  • Posts: 17
  • Karma: +6/-0
    • View Profile
Extracts not working after store move
« on: March 06, 2017, 02:16:59 PM »
We just moved our cart to a new host. Everything works well and followed the steps in http://forum.abantecart.com/index.php/topic,426.0.html. I am trying to do a product extract to do some bulk pricing updates and it will download the tar.gz file but it comes through as a corrupted page. Winzip & 7ZIP won't open the file (no errors while downloading).
I've tried other exports and the same error. My old cart has no issues exporting the product file and I've tried 3 different computers with 3 different firewalls with no success. Have any ideas why the export suddenly fails after a server move?

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5819
  • Karma: +274/-2
    • View Profile
Re: Extracts not working after store move
« Reply #1 on: March 07, 2017, 12:46:04 AM »
Hi.
Check export file size if it is zero it may indicate export not work at all.
And check errors/warnings in the log

Offline jcschott

  • Newbie
  • *
  • Posts: 17
  • Karma: +6/-0
    • View Profile
Re: Extracts not working after store move
« Reply #2 on: March 07, 2017, 09:37:35 AM »
The file size looks about right (comparing to my previous store) and if i try just exporting a few products using the file soze goes way down so it appears the extract is working but generating a corupt file.

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2048
  • Karma: +319/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Extracts not working after store move
« Reply #3 on: March 08, 2017, 03:15:51 AM »
what about anti-virus software on your side? Can it corrupt file?
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline jcschott

  • Newbie
  • *
  • Posts: 17
  • Karma: +6/-0
    • View Profile
Re: Extracts not working after store move
« Reply #4 on: March 08, 2017, 06:31:19 PM »
Still had no impacts as all three had different AV and I tried disabling it on one to download. I can extract on the old site still just not the new site.

Offline jcschott

  • Newbie
  • *
  • Posts: 17
  • Karma: +6/-0
    • View Profile
Re: Extracts not working after store move
« Reply #5 on: March 11, 2017, 07:38:47 PM »
Any other ideas? I am close to try a fresh install and re-importing the data set of about 1800 products but don't really want to start fresh with a live site (however the lack of being able to extract is a big issue for bulk update). I've attached a sample of about 15 product export corrupted file.


Offline jcschott

  • Newbie
  • *
  • Posts: 17
  • Karma: +6/-0
    • View Profile
Re: Extracts not working after store move
« Reply #6 on: March 13, 2017, 12:34:19 AM »
I ended up doing a fresh install, after installing another install on the same domain but different directory and successfully downloading products after the database restore. But after pulling in the configuration files again it corrupts the file on export.

Here are the steps I did:
1) Rename folder of store installed (/shop to shop1)
2) Install new abantecart through CPANEL softacuolous using the same table prefix as the original install
3) Truncated all tables through phpmyadmin (get rid of sample data)
4) Restored database through phpmydmin
5) Update system/config.php
 updated salt and Encryption key
6)    Upload following files from other directory:
   ○ Resources/image
      ○    storefront/view/default/image
      ○    image/thumbnails
      ○    storefront/view/default/stylesheet/style.css
7) Try to export again and it corrupted.

Offline jcschott

  • Newbie
  • *
  • Posts: 17
  • Karma: +6/-0
    • View Profile
Re: Extracts not working after store move
« Reply #7 on: March 13, 2017, 10:59:56 PM »
SOLVED: (not sure of the root cause) I did realize my error the second time. On the second reinstall I copied over the config file instead of just replacing the salt/encryption keys so it was still pulling from the old database. Once I corrected it everything seems to be working correctly. Still not sure what was causing the issue with the original install but a reinstall did actually correct the problem

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5819
  • Karma: +274/-2
    • View Profile
Re: Extracts not working after store move
« Reply #8 on: March 14, 2017, 01:08:52 AM »
Thank you, jcschott for update

 

Powered by SMFPacks Social Login Mod