"Trashed" is not really a Fabrik thing, it's a J! thing. On the back end when you have "lists of things" which you can trash, typically they don't get immediately deleted, they stay in a "trashed" state until you specifically empty the trash. Where that is applicable, you'll get a "Select status" filter that lets you see your trashed items, which you can then "Empty trash" on.
NOTE - be VERY careful when emptying Fabrik's trash when it asks you what you want to delete. For instance, when deleting trashed element, we will ask if you also want to drop the underlying database table column. If the element you are trashing was a "child" and there are other elements still using that column, don't do it!
Of course, as you can't display the page, you can't do any of this.
2048M is excessive. I've never found anything in Fabrik which needs more than 128M.
So it sounds like something may have gotten messed up in your metadata.
My best suggestion is try this. Edit ./administrator/components/com_fabrik/models/elements.php, around line 144 you'll find this:
Code:
// Work out the element ids so we can limit the fullname subquery
$db->setQuery($query, $start = $this->getState('list.start'), $this->getState('list.limit'));
$elementIds = $db->loadColumn();
Dump out the actual query like this:
Code:
// Work out the element ids so we can limit the fullname subquery
$db->setQuery($query, $start = $this->getState('list.start'), $this->getState('list.limit'));
var_dump((string)$query);exit;
$elementIds = $db->loadColumn();
... and try and load the elements page again. It should dump out some SQL that looks like this:
Code:
string(448) " SELECT e.*, e.ordering AS ordering,(SELECT COUNT(*) FROM #__fabrik_jsactions AS js WHERE js.element_id = e.id) AS numJs,e.id FROM #__{package}_elements AS e LEFT JOIN #__users AS u ON checked_out = u.id LEFT JOIN #__{package}_groups AS g ON e.group_id = g.id LEFT JOIN #__{package}_formgroup AS fg ON fg.group_id = e.group_id LEFT JOIN #__{package}_lists AS l ON l.form_id = fg.form_id WHERE (e.published IN (0, 1)) ORDER BY ordering LIMIT 0, 20"
Try running that SQL by hand in phpMyAdmin (you'll have to replace #__ with your J! table prefix) and see how many rows it returns. It should be 20 (or whatever your pagination display limit is/was set to).
Assuming that returns the correct number of rows, move that var_dump() line down to around 174, just before the end of the function where we "return $query" (so before that return line).
That again should only return 20 rows.
-- hugh
