Hi,

When we have a very large amount of articles, the Joomla backend article manager is broken with the following error message:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /path to my website/libraries/joomla/database/driver/mysqli.php on line 886

There's more than 140000 articles in my database, wich is big enough, but i set the pagination to 20 articles by page.

BUT the joomla pagination parameter is NOT taken into account by the cck_storage_location plugin (which is called by seblod here) and more precisely by the file cck_storage_location/joomla_article/classes/integration.php

We don't understant WHY this plugin is called here though.

In this plugin a simple query is executed at line 79 ( and one line 72 - 76, if multilanguage is enabled,...) =>

SELECT pk, cck FROM #__cck_core WHERE storage_location="joomla_article"

without the LIMIT (matching the backend joomla article manager pagination parameter)

I do know that i could "solve" my problem with a temporary solution like adding some memory space in my php / sql configuration, but the problem will come up later anyway.

==>> Therefore I'm asking if we could add a simple limit to this query, in the purpose to make it working with large amount of data ?

Thanks in advance,

Hurin