Post by kickweb » Sun Oct 04, 2015 1:35 am

Hey Guys.

Ok, been on this 3 weeks now and finally realised I'm not going to work this out without some extra help.

I have a oc shop with 45000+ products.

Been using import/export for some time and had it working great.

Recently changed php handler to suPHP and had a few problems but this was fixed by simply copying the htaccess settings to php.ini as suPHP uses php.ini to reference settings.

Suddenly 3 weeks ago I'm unable to import or export.

Really could do with some help here as looking at the error logs just created when trying to run an export I'm rather stuck and confused.

Error log here: http://s000.tinyupload.com/index.php?fi ... 8510163569

any ideas would be great here as not been able to update products for 3 weeks now.

Thanks guys

:D

Newbie

Posts

Joined
Sun Apr 19, 2015 3:06 am

Post by IP_CAM » Sun Oct 04, 2015 2:18 am

By use of this Line, I found a huge amount of such postings:
Error: Got error 28 from storage engine<br />Error No: 1030
and most all where replied to with more or less the same answer, NOT ENOUGH RESSOURCES, to do this Job:
Contact your Hoster, to find a way, to use large AMOUNTS of Server Memory, momentarely, to do this task.

https://www.google.com/search?q=Error%3 ... 8&oe=utf-8

Good Luck
Ernie
openshop.li/shop/

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by kickweb » Sun Oct 04, 2015 3:08 am

Thanks buddy

Thats what I thought but the resources are already set very high.

The site is on a Quad Core VPS with 4Gb RAM

Resources set as below

magic_quotes_gpc = Off
magic_quotes_runtime = Off
magic_quotes_sybase = Off
extension=pdo.so
extension=pdo_mysql.so
register_globals = Off;
default_charset = UTF-8;
memory_limit = 3000M;
max_execution_time = 36000;
upload_max_filesize = 999M;
post_max_size = 999M;


among other settings.....


Hence why I'm very stuck.

Newbie

Posts

Joined
Sun Apr 19, 2015 3:06 am

Post by JNeuhoff » Sun Oct 04, 2015 5:41 am

Or you could simply export and import in smaller batches, this will avoid the memory_limit errors, and will be less resource-hungry.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am

Who is online

Users browsing this forum: No registered users and 11 guests