Before I disturb the forum - I have read few hours and I could not resolve the memory problem:
I have set PHP memory limit to 512M, but there is the error message:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 72 bytes) in ......./system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 126
At first - PHP info reported 512M, but the function says 64M? And it says too - tried to alocate 72 bytes only.
What I have to do?
And please, would you like to post here example files of the export?
Apply one of solutions below to increase the limit to 64MB, 128MB, 256MB or 512MB, depeinding on your host.
Edit php.ini
Or put code below to .htaccess
If you still get this error and the solution above isn’t working, contact your host. In most shared hosting, there is maximum memory_limit, e.g. you can’t set the memory-limit to 64Mb if the web host has a restriction of 32Mb.
Edit php.ini
Code: Select all
memory_limit = 128M;
Or put code below to .htaccess
Code: Select all
php_value memory_limit 128M
If you still get this error and the solution above isn’t working, contact your host. In most shared hosting, there is maximum memory_limit, e.g. you can’t set the memory-limit to 64Mb if the web host has a restriction of 32Mb.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Apply one of solutions below to increase the limit to 64MB, 128MB, 256MB or 512MB, depending on your host.
Edit php.ini
Or put code below to .htaccess
If you still get this error and the solution above isn’t working, contact your host. In most shared hosting, there is maximum memory_limit, e.g. you can’t set the memory-limit to 64Mb if the web host has a restriction of 32Mb.
Edit php.ini
Code: Select all
memory_limit = 128M;
Or put code below to .htaccess
Code: Select all
php_value memory_limit 128M
If you still get this error and the solution above isn’t working, contact your host. In most shared hosting, there is maximum memory_limit, e.g. you can’t set the memory-limit to 64Mb if the web host has a restriction of 32Mb.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I have updated to OC 1.5.6.1 and updated Export/Import at the same time and it has gone from the menu.
I tried VQmod and it didn't work so I went in and edited the 3 files manually as instructed but still nothing?
Help please...
I tried VQmod and it didn't work so I went in and edited the 3 files manually as instructed but still nothing?
Help please...
Send me a PM with your FTP and OpenCart login details, and I can take a look at it.jewellerstore wrote:I have updated to OC 1.5.6.1 and updated Export/Import at the same time and it has gone from the menu.
I tried VQmod and it didn't work so I went in and edited the 3 files manually as instructed but still nothing?
Help please...
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi, i am new here, only just started using opencart for the last 2 hours...
I have installed this mod, got to this point in the instructions.
"System > Users > User Group
From there, select 'Top Administrator', then click on the 'Edit' link to the right.
This will open up an edit window with multichoice dropdown lists for 'Access' and 'Modify' rights.
In both of them, you'll see a new entry for 'tool/export' which you can select by clicking
on their check boxes."
All seems good, now how do I access this feature??? what and where in the admin backend?
lol, can you tell i am new?
I have installed this mod, got to this point in the instructions.
"System > Users > User Group
From there, select 'Top Administrator', then click on the 'Edit' link to the right.
This will open up an edit window with multichoice dropdown lists for 'Access' and 'Modify' rights.
In both of them, you'll see a new entry for 'tool/export' which you can select by clicking
on their check boxes."
All seems good, now how do I access this feature??? what and where in the admin backend?
lol, can you tell i am new?
Now sorted.JNeuhoff wrote:Send me a PM with your FTP and OpenCart login details, and I can take a look at it.jewellerstore wrote:I have updated to OC 1.5.6.1 and updated Export/Import at the same time and it has gone from the menu.
I tried VQmod and it didn't work so I went in and edited the 3 files manually as instructed but still nothing?
Help please...
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi there
please assist me here,
i have installed the Export/Import tool for OpenCart 1.5.5.x as per instruction, where on the previous version of OC 1.5.6 was working fine, and now i get this error:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 16680227 bytes) in /home/iongear/public_html/vqmod/vqcache/vq2-admin_view_template_tool_error_log.tpl on line 18
could you assist me in correcting this?
kind regards
please assist me here,
i have installed the Export/Import tool for OpenCart 1.5.5.x as per instruction, where on the previous version of OC 1.5.6 was working fine, and now i get this error:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 16680227 bytes) in /home/iongear/public_html/vqmod/vqcache/vq2-admin_view_template_tool_error_log.tpl on line 18
could you assist me in correcting this?
kind regards
Hello,
I have an issue here. I installed the extensions 2 days ago for 1.5.5.1 after a few failures with 1.5.6 and it worked good the first day, but I found out that we should use fcgi to run the script so we got that going, but now I have a problem, the import works (it gets the success message) but the products/categories/manufacturers are not imported, all the website got empty from the first import of the xlsx. I don't have experience with fcgi and it's required to use it here apparently so I don't know what is going on and how to debug a success message.
#!/bin/sh
PHP_FCGI_MAX_REQUESTS=10000
export PHP_FCGI_MAX_REQUESTS
export PHP_FCGI_CHILDREN=0
exec /usr/lib/cgi-bin/php-site "$@"
This is the fcgi file for the website, now my question is, do I need to add some lines here that would help work ? Is it a conflict between PHPExcel and fcgi or is there another issue that I'm not aware of ? Any bit of help would be really appreciated, thank you.
I have an issue here. I installed the extensions 2 days ago for 1.5.5.1 after a few failures with 1.5.6 and it worked good the first day, but I found out that we should use fcgi to run the script so we got that going, but now I have a problem, the import works (it gets the success message) but the products/categories/manufacturers are not imported, all the website got empty from the first import of the xlsx. I don't have experience with fcgi and it's required to use it here apparently so I don't know what is going on and how to debug a success message.
#!/bin/sh
PHP_FCGI_MAX_REQUESTS=10000
export PHP_FCGI_MAX_REQUESTS
export PHP_FCGI_CHILDREN=0
exec /usr/lib/cgi-bin/php-site "$@"
This is the fcgi file for the website, now my question is, do I need to add some lines here that would help work ? Is it a conflict between PHPExcel and fcgi or is there another issue that I'm not aware of ? Any bit of help would be really appreciated, thank you.
Your issue has nothing to do with FastCGI.
Other than that, I am un able to help you because you simply don't provide enough details on what exactly you did.
Other than that, I am un able to help you because you simply don't provide enough details on what exactly you did.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thank you for your quick response.
On further investigation on local vs remote machine in system/mysql.php I printed $sql and on local it gave me a huge query when I imported the file (which it should) but on remote the query wasn't executed, only success message and no querry. Do you have any idea of this behaviour ? Or what more details should I give you on the matter so you could try and help ? I would be really grateful.
On further investigation on local vs remote machine in system/mysql.php I printed $sql and on local it gave me a huge query when I imported the file (which it should) but on remote the query wasn't executed, only success message and no querry. Do you have any idea of this behaviour ? Or what more details should I give you on the matter so you could try and help ? I would be really grateful.
dragos.m wrote:Thank you for your quick response.
On further investigation on local vs remote machine in system/mysql.php I printed $sql and on local it gave me a huge query when I imported the file (which it should) but on remote the query wasn't executed, only success message and no querry. Do you have any idea of this behaviour ? Or what more details should I give you on the matter so you could try and help ? I would be really grateful.
Check for any entries in your logs, e.g. OpenCart's system/logs/error.txt, server's error_log (ask webhost for it)
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Dear JNeuhoff
i am having error when i export it.
i am using opencart 1.5.6 and have about 30,000 product on bluehost.com.
i use your extension (opencart-1-5-5-x-export-import-17.zip and opencart-1-5-6-x-export-import-17.zip)
i increase everything that i can to make it work.
some people told me to follow the default suggested setting, but it doesn't work for me.
here is my post.
http://forum.opencart.com/viewtopic.php?f=119&t=122676
if you have commercial extension for this export extension, i am willing to pay.
can you help me fix this error?
i am having error when i export it.
i am using opencart 1.5.6 and have about 30,000 product on bluehost.com.
i use your extension (opencart-1-5-5-x-export-import-17.zip and opencart-1-5-6-x-export-import-17.zip)
i increase everything that i can to make it work.
some people told me to follow the default suggested setting, but it doesn't work for me.
here is my post.
http://forum.opencart.com/viewtopic.php?f=119&t=122676
if you have commercial extension for this export extension, i am willing to pay.
can you help me fix this error?
Chances are it won't work with 30000 products, certainly ona shared web hosting account like bluehost.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi,
I have installed the import/export extension tool as per instruction and made sure my PHP settings are correct "memory_limit 512M" and when I click on "export" the window is only loading if I check the Error Log I receive this error:
2014-04-10 9:24:59 - PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 72 bytes) in /home/devbeads/public_html/system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 123
Not sure what I am doing wrong?
Any help would be appreciated.
I have installed the import/export extension tool as per instruction and made sure my PHP settings are correct "memory_limit 512M" and when I click on "export" the window is only loading if I check the Error Log I receive this error:
2014-04-10 9:24:59 - PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 72 bytes) in /home/devbeads/public_html/system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 123
Not sure what I am doing wrong?
Any help would be appreciated.
--
South Africa, Johannesburg GMT +2
You have to seriously increase the memory_limit. If it already fails during an Export, you probably have no chance of using the Import, you probably got way too many products.markuswest wrote:Hi,
I have installed the import/export extension tool as per instruction and made sure my PHP settings are correct "memory_limit 512M" and when I click on "export" the window is only loading if I check the Error Log I receive this error:
2014-04-10 9:24:59 - PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 72 bytes) in /home/devbeads/public_html/system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 123
Not sure what I am doing wrong?
Any help would be appreciated.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi @JNeuhoff
I have increased my memory to 1024M in the WHM manager and I still receive an error:
2014-04-10 15:07:26 - PHP Fatal Error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 32 bytes) in /home/devbeads/public_html/system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 126
I think it could be from other tables in the database, my website has allot of custom modifications, and I have 2875 products at this point in time, do you think other custom tables can be a problem?
I have increased my memory to 1024M in the WHM manager and I still receive an error:
2014-04-10 15:07:26 - PHP Fatal Error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 32 bytes) in /home/devbeads/public_html/system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 126
I think it could be from other tables in the database, my website has allot of custom modifications, and I have 2875 products at this point in time, do you think other custom tables can be a problem?
--
South Africa, Johannesburg GMT +2
Allowed memory size of 1073741824 bytes exhausted (tried to allocate 32 bytes)
I have the same problem when trying to export. Not many modifications in database, only Journal theme if it's somehow related... Import works like a charm, exporting is an issue.
~3300 products here.
I have the same problem when trying to export. Not many modifications in database, only Journal theme if it's somehow related... Import works like a charm, exporting is an issue.
~3300 products here.
Who is online
Users browsing this forum: No registered users and 4 guests
