Error loading Trash

When attempting to look in the Trash we're getting the following error:


Could not load children: error while getting response: [ASSERT EXCEPTION] Asset "page_custom_loader" is not installed on the system, unable to include its source file [SYS0320] File: [SYSTEM_ROOT]_3_14_3_ssv/core/include/assertions.inc Line:510



Any ideas how to resolve / install page_custom_loader??



I think we've got a few Oracle / Trash issues. A reindex of the entire system fails with a fatal error when trying to index an asset that has already been deleted. And when I say deleted it was moved to the Trash AND the Trash was purged.



I also accidently created myself as a backend user but then trashed my account (including purging the trash) so I could recreate my account as a sys admin however it said the account already existed?



Now we get an error purging the trash - the error also refers to an asset that doesn't exist i.e. has already been deleted.

It means that you used to have an asset type called "page_custom_loader" and there is still an asset of that type in the trash. However, you have removed the code for that asset type from the system, so Matrix now cannot purge the trash.


It does sound like you have some Trash issues. You may have to contact Squiz support so that we can help you erase these assets from your database directly.

[quote]It means that you used to have an asset type called "page_custom_loader" and there is still an asset of that type in the trash. However, you have removed the code for that asset type from the system, so Matrix now cannot purge the trash.


You may have to contact Squiz support so that we can help you erase these assets from your database directly.[/quote]



Thanks we deleted the asset from the SQ_ASSET table in the Oracle database and now we can load the trash without error and purge it. We also successfully reindexed the entire system which was crashing when it reached this troublesome asset.



Just wondering when you have to delete assets like this from the Oracle database what tables should we look for the asset in and delete from? Other than SQ_ASSET?



Thanks

Sarah

Just about every other table has a reference to an asset ID. You'd need to wade through all of them to find out, but if you purged the trash and reindexed, you're probably okay.