OpenCart Community

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.

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.

My mistake.
I missed to notice another php.ini located in admin-folder. But 256M was not enough for 800 products, 512M was ok.
Thank you, the export was successful

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...

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...

Send me a PM with your FTP and OpenCart login details, and I can take a look at it.

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?

JNeuhoff wrote:

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...

Send me a PM with your FTP and OpenCart login details, and I can take a look at it.

Now sorted.

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

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.

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.

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.

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)

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?

Chances are it won't work with 30000 products, certainly ona shared web hosting account like bluehost.

how about bluehost dedicated server?

is your script not working with 30,000 product ? or limited ability from server?

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.

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.

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.

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?

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.