List Manager Forum

Fatal error

Usuario moon_524 2012-05-30 21:31:07

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /storage/content/94/144694/hxxxxxxt.com/public_html/components/com_listmanager/models/listmanager.php on line 271

I try to import a large series of records (100 000) but it stops with the error.

What to do?

Moonsoft support 2012-05-31 09:45:46

Hello,
it seems you have reached the limit on one of your server variables,you can try to solve it increasing the value of the memory variable.

Go to site->System information->PHP information. There you can check which are the limits applied for your site, looking at the value of these variables:

max_execution_time : It limits the time of execution of a single process. To handle a big amount of information, you may need to increase this value as well
memory_limit : Memory limit you're exceeding.


If you haven't available any helper/control panel to do it, you can also try to insert the change at the source code, to try to increase it at execution time, although we want to warn you some hostings don't allow this instruction, to avoid clients use more resources than given by default. These are the lines:

ini_set("memory_limit","100M");
ini_set("max_execution_time","0"); //to disable this limit

to handle backend import, you can try it at the file

joomla\administrator\components\com_listmanager\models\listing.php

just at the beginning of the import function:

function insertDataCSV($idlisting) {

ini_set("memory_limit","100M");
ini_set("max_execution_time","0");




Hope this helps, regards
Moonsoft Team

Usuario moon_524 2012-05-31 15:35:22

Cant find the lines?

Edited by MSTeam - 31.05.2012 17:07

Moonsoft support 2012-05-31 17:11:23

Hello,
seems you have opened the wrong file (so deleted contents from your reply). The file you paste seems to be this one

joomla\components\com_listmanager\models\listing.php

and not the one on the administrator site:


joomla\administrator\components\com_listmanager\models\listing.php

Please double-check the path. Inside this last one you should find the insertDataCSV function.

Hope this helps, regards

Usuario moon_524 2012-06-01 07:52:22

Now I find the csv import ...........

But where insert?
Directly after line 541
function insertDataCSV($idlisting) {

?

Moonsoft support 2012-06-01 09:33:46

Hello,
right, it should look like this:

function insertDataCSV($idlisting) {

ini_set("memory_limit","100M");
ini_set("max_execution_time","0");



Regards

Usuario moon_524 2012-06-02 10:47:59

Sorry
Doesn't work

Moonsoft support 2012-06-02 10:54:23

Hello,
then manual changing of the server variables is not allowed for your site. Your only option is to ask your hosting provider to increase the values, or split your data into smaller sections to keep you inside your execution limits.

Regards
Moonsoft Team