Store Import Issue

Store Builder in detail Issues & Troubleshooting
#1

I have a 2.2.5 store with a very large database. When I try to import into 4.1.4, it seems to time out during the initial import. CS-Cart support suggested I change the mysql.connect_timeout setting, but that's not something my host will do. I could run the import on an internal server, but I'm concerned about actualizing the data before the new store launches. I can't afford to shut down my store for a whole day while the import runs. Any suggestions?

#2

For what it's worth, the import seems to get hung on the cscart_new_orders table. That table has 1.8 million records going back to January 2009.

#3

I have a 2nd store that's failing to import. The store import logs show it fails at the same place every time.


1400267838 - Updating data
1400267838 - Upgrading to 301
1400267838 - 1
1400267838 - Importing data
1400267838 - 1
1400267838 - Importing data
1400267838 - 12
1400267838 -
Importing data
1400267838 -
Creating table: IF
1400267838 -
Importing data
1400267838 -
Importing data
1400267839 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data




“Upgrading to 301” is the last thing that pops up on screen before the store import progress disappears.

#4

Do you have third party addons installed? You may have to disable those. In the end I had to have CS-Cart support do the import for me when moving to 3.0.6 from 2.x.

#5

I don't have any third party addons in this store. The import script seems to stop after 359 or 360 seconds every time. I'm not sure if that's a PHP setting or something.

#6

Possibly server time out setting to 360 sec for mod_fcgi



John

#7

I'm still dealing with these timeout issues. Now, it's happening in 2 separate stores on 2 separate servers. I asked CS-Cart support for assistance, and they were able to import in a local environment and upload the database. But, I still need to actualize the data to pull new customers and orders since then. When I try to actualize, it seems to stop at random. Sometimes it's a few minutes - sometimes it's close to an hour. This is on a separate server from the first site I was having trouble with. I've deleted several thousand orders from this new store, but I still have 60,000+ to import.



Does anyone have any further advice or troubleshooting suggestions? Both the store owner and me are getting very frustrated.