Post by southernbusiness » Sun Jan 19, 2014 11:39 pm

Hi,

I have increased my product database to about 14,000 and wanted to have it up to over 20,000. But the module won't allow me to export a copy of my products and so rather than changing via my spreadsheet I will have to manually type in the products and adjust prices.

I have been looking on the forums but can't find a solution. Does anyone know how to fix this?
Thanks


Posts

Joined
Tue Jun 25, 2013 7:07 pm

Post by southernbusiness » Mon Jan 20, 2014 12:23 am

There is no error in my logs after receiving this page and my host said I have the following memory
Memory Limit 4GB
Post Max Size - 100m
Upload max file size - 100m


Posts

Joined
Tue Jun 25, 2013 7:07 pm

Post by butte » Mon Jan 20, 2014 2:21 pm

memory_limit = 512M;
max_execution_time = 36000;
post_max_size = 999M;
upload_max_filesize = 998M;

Note that post exceeds upload, that is required.

Try phpinfo.php to see what the server thinks is going on. The tiny one-line utility phpinfo.php (here: http://forum.opencart.com/download/file.php?id=18153) can be uploaded into OC (or your account, public) and addressed in the browser. Put it in both your OC root and your /admin/. Address it as usual, but after domain/whatever/phpinfo.php (and domain/whatever/admin/phpinfo.php).

You do NOT need to wade through these just to set the foregoing, but they'll give you your bearings.

On php.exe and php.ini:
http://forum.opencart.com/viewtopic.php ... ni#p426535
On master php.ini:
http://forum.opencart.com/viewtopic.php ... 80#p444711
http://forum.opencart.com/viewtopic.php ... r+#p445305

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by southernbusiness » Wed Jan 22, 2014 6:42 am

erm... does that ... not sure what that means. Sorry, but is there any chance I could pay you to get it going again?


Posts

Joined
Tue Jun 25, 2013 7:07 pm

Post by butte » Thu Jan 23, 2014 4:04 am

PM sent.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by nvedia » Thu Jan 23, 2014 8:48 pm

Using PHPExcel library cache mechanism would solve the problem as phpexcel save method inherently has a bug that when it timeouts there is no error thrown

Donate here to show support if you think I have helped you today!

Opencart Documentation


User avatar
Active Member

Posts

Joined
Sun May 22, 2011 12:54 pm

Post by butte » Thu Jan 23, 2014 11:59 pm

That is subject to a php setting and is not a bug, the thing needs settable memory ceiling and time to do what it does.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by southernbusiness » Fri Jan 24, 2014 12:23 am

Solved. Thank you so much. It works!!


Posts

Joined
Tue Jun 25, 2013 7:07 pm

Post by nvedia » Fri Jan 24, 2014 12:49 am

butte wrote:That is subject to a php setting and is not a bug, the thing needs settable memory ceiling and time to do what it does.
Sorry for putting it in different way
I meant without caching it only works till 14K rows and throws no errors and no warnings when it times out
Not sure if error can still be thrown

Donate here to show support if you think I have helped you today!

Opencart Documentation


User avatar
Active Member

Posts

Joined
Sun May 22, 2011 12:54 pm

Post by butte » Fri Jan 24, 2014 1:32 am

That is good, southernbusiness, go ahead and edit your opening title Solved.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am
Who is online

Users browsing this forum: No registered users and 3 guests