Out of memory on creating menu item

Phoca Download - download manager
rolandd

Out of memory on creating menu item

Post by rolandd »

Hello,

When I create a menu entry for a category in Phoca Download I get the following error
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 524288 bytes) in /xx/administrator/components/com_phocadownload/elements/phocadownloademail.php on line 29
This happens because Phoca is loading the full user table, with my table over 40,000 users this becomes a memory problem.

For now I fixed it by changing the query in administrator/components/com_phocadownload/elements/phocadownloademail.php to read

Code: Select all

$query = 'SELECT id, name' .	' FROM #__users';
since only these 2 fields are used.

A more elegant solution might be an AJAX interface :)
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Out of memory on creating menu item

Post by Jan »

Hi, thank your for this info.

Jan
If you find Phoca extensions useful, please support the project
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Out of memory on creating menu item

Post by Jan »

Fixed in 1.3.9
If you find Phoca extensions useful, please support the project
Post Reply