I upgraded from 1.5.6 to 1.5.6.1 and was using "opencart-1-5-6-x-export-import-16 version" and it worked just fine.
After I upgraded to "opencart-1-5-6-x-export-import-17 version", I have not been able to export a file without getting the error "...system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 123" with existing limit settings:
memory_limit = 999M;
max_execution_time = 36000;
upload_max_filesize = 999M;
post_max_size 256M;
I commented out line 126 and was able to export file, but I still get a error when I attempt to import file.
Can't understand why process works great with prior version. Any help would be appreciated.
Thanks,
Ibparn
After I upgraded to "opencart-1-5-6-x-export-import-17 version", I have not been able to export a file without getting the error "...system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 123" with existing limit settings:
memory_limit = 999M;
max_execution_time = 36000;
upload_max_filesize = 999M;
post_max_size 256M;
I commented out line 126 and was able to export file, but I still get a error when I attempt to import file.
Can't understand why process works great with prior version. Any help would be appreciated.
Thanks,
Ibparn
This won't work:
memory_limit = 999M; should be in powers of two, 2,4,8,16,32,64,128,256,512,1024 and you should not need 1024
max_execution_time = 36000; is fine if your host allows it but usually not
upload_max_filesize = 999M; must be at least slightly less than post_max_size or you lose all benefit of setting it high
post_max_size 256M; is pitiful, raise it.
Retry with
memory_limit = 512M;
max_execution_time = 36000;
post_max_size 999M;
upload_max_filesize = 998M;
Then if need be drop
max_execution_time = 36000;
to
max_execution_time = 300;
memory_limit = 999M; should be in powers of two, 2,4,8,16,32,64,128,256,512,1024 and you should not need 1024
max_execution_time = 36000; is fine if your host allows it but usually not
upload_max_filesize = 999M; must be at least slightly less than post_max_size or you lose all benefit of setting it high
post_max_size 256M; is pitiful, raise it.
Retry with
memory_limit = 512M;
max_execution_time = 36000;
post_max_size 999M;
upload_max_filesize = 998M;
Then if need be drop
max_execution_time = 36000;
to
max_execution_time = 300;
Short memory, only 27787264, <32M and not a power of two. In php.ini (both), and in host control panel if you can:
memory_limit = 512M;
max_execution_time = 300;
post_max_size = 999M;
upload_max_filesize = 998M;
Note that post exceeds upload, that is required. And as noted above, if you're already getting away with the higher value good, but you can drop execution to 300.
memory_limit = 512M;
max_execution_time = 300;
post_max_size = 999M;
upload_max_filesize = 998M;
Note that post exceeds upload, that is required. And as noted above, if you're already getting away with the higher value good, but you can drop execution to 300.
Thanks for the insite and these are my settings:
memory_limit = 512M;
max_execution_time = 300;
post_max_size 999M;
upload_max_filesize = 998M;
The puzzling part is if I run with prior version, I have no problems. Go figure ...
Thanks again,
Ibparn
memory_limit = 512M;
max_execution_time = 300;
post_max_size 999M;
upload_max_filesize = 998M;
The puzzling part is if I run with prior version, I have no problems. Go figure ...
Thanks again,
Ibparn
Hello,
i install this extension on my opencart ve. 1.5.6.1. For the importing i don't have any problem, but i have a problems when i wan to export to list.
up to 70 product i don't face a problem but if more then 70 product i can not export it. But import still works well..
Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in /home/elektron/public_html/system/PHPExcel/Classes/PHPExcel.php on line 813
i already modified my PHP.ini and i confirm the "memory_limit" are successfully changed via phpifo.php.
I would be very grateful if you could help me, thanks in advance....
i install this extension on my opencart ve. 1.5.6.1. For the importing i don't have any problem, but i have a problems when i wan to export to list.
up to 70 product i don't face a problem but if more then 70 product i can not export it. But import still works well..
Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in /home/elektron/public_html/system/PHPExcel/Classes/PHPExcel.php on line 813
i already modified my PHP.ini and i confirm the "memory_limit" are successfully changed via phpifo.php.
I would be very grateful if you could help me, thanks in advance....
Hi everyone,
I couldn't export products from the database. Can you help me? Thanks
Log:
I couldn't export products from the database. Can you help me? Thanks
Log:
Code: Select all
2014-02-26 17:03:53 - PHP Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/home/users/....../:/usr/share/pear/) in /home/users/.....cz/sub/eshop/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 175
2014-02-26 17:03:53 - PHP Warning: tempnam(): open_basedir restriction in effect. File() is not within the allowed path(s): (/home/users/..../:/usr/share/pear/) in /home/users/....../sub/eshop/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 176
2014-02-26 17:03:53 - PHP PHPExcel_Writer_Exception: Could not close zip file php://output. in /home/users/......cz/sub/eshop/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 348
I've been struggling to get this fantastic tool working for the last week, and I've always been getting the same "Allowed memory size" error despite having 2GB of dedicated RAM and fiddling about with all sorts of PHP settings.
I managed to get it working with 1.5.6.1, simply by downgrading to 1.5.4.x. So far I haven't seen any issues, however I imagine some will popup soon.
If you're using 1.5.6.1, downgrade to the 1.5.4.x version. I'm not 100% sure if it's perfect yet, but I've actually been able to export my products for the first time in ages!
I managed to get it working with 1.5.6.1, simply by downgrading to 1.5.4.x. So far I haven't seen any issues, however I imagine some will popup soon.
If you're using 1.5.6.1, downgrade to the 1.5.4.x version. I'm not 100% sure if it's perfect yet, but I've actually been able to export my products for the first time in ages!
Hi
I just have this tool installed in one shop, and now when i try to install in a new shop with a different version (1.5.6.1) with vqmod, and only the admin page do not work, and give this message:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@lediluminacao.pt and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Someone have this problem ? And how can i solved it ?
Thanks
I just have this tool installed in one shop, and now when i try to install in a new shop with a different version (1.5.6.1) with vqmod, and only the admin page do not work, and give this message:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@lediluminacao.pt and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Someone have this problem ? And how can i solved it ?
Thanks
Have installed this extension to my opencart, with the Qvmod Xml.
Did not get the link in the administration headed.
Frustrated had to manually edit the files to get link to import export tool.
Once I had exported my products. found there was a lot of fields that had the entry repeated 2,3 or 4 timed eg
Checked the database via phpadmin to find if it was the database. Database fine must be due to the export process
Spent ages cleaning up export file.
Made necessary edits to products.
Saved as xlsx and tried to import
Not happy. Would have been quicker to do the edits via the administration portal.
May have to un-install and un-edit the files!
Did not get the link in the administration headed.
Frustrated had to manually edit the files to get link to import export tool.
Once I had exported my products. found there was a lot of fields that had the entry repeated 2,3 or 4 timed eg
Code: Select all
<p>Ceramic iridescent pink heart necklace, threaded onto green leather.</p>
<p>Ceramic iridescent pink heart necklace, threaded onto green leather.</p>
<p>Ceramic iridescent pink heart necklace, threaded onto green leather.</p>
<p>Ceramic iridescent pink heart necklace, threaded onto green leather.</p>
Spent ages cleaning up export file.
Made necessary edits to products.
Saved as xlsx and tried to import
Code: Select all
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!
May have to un-install and un-edit the files!
Who is online
Users browsing this forum: No registered users and 102 guests