OpenCart Community

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

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/

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.

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