Error 1146 after table name changed "by itself"

[nils99]

Hi there,
I have students who build Joomla websites as part of their training and something super weird happened to one of them:
she got error 1146 and it said that the table 'assets' doesn't exist in the DB.
At first I couldn't believe that the table didn't exist so I looked for other solutions, but eventually when I looked in the DB it hit me that the table 'assets' is called now 'asset'
After changing the table name it all went back to normal. puuh!

this was the exact error message: Table 'XXX.xxx_assets' doesn't exist SQL=SELECT b.rules FROM ja1fq_assets AS a LEFT JOIN ja1fq_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft

Since it is shocking and since I don't understand why it happened and therefore can't help her from repeating the error I wanted to ask here if anyone has had a similar problem and can help me get some insight to the cause.

general background: before the error she didn't do anything strange. one thing that she said was that at a certain point at her work she was asked to purge the cahce. afterwards she still worked well and only today this error occurred.

she has of course installed several plugins, modules and components during the time she was working in the site, but nothing next to the problem, so I didn't want to list them all here...

hope anyone will have an idea!
thanks a lot!
nils

[itoctopus]

We once had a similar problem, where the #__assets table was completely corrupted. It turned out it was a 3rd party extension that was manipulating the data wrongly.

I believe that the issue was caused by an extension that she installed, where the extension, under a certain condition, wiped out the #__assets table and then re-created it under a different name. You need to be very careful with 3rd party extensions, especially the lesser known ones.

It would be a good idea if you can post the list of extensions that she used here as this is a very serious issue.

[nils99]

as far as I can see the extensions that were installed so far are:
(and please excuse me if I put anything in that is part of the joomla core or just a part of an extension's package...)

Admintools
Akeeba (and AkeebaStrapper)
AllVideos (by JoomlaWorks)
JCE
CodeMirror
Advanced Module Manager (NoNumber)
Responsive CSS3 Slider
DJ-ImageSlider
JEvents Calendar
n3t Coming Soon

additional templates:
Stylusson1.6
racho

thanks a lot!
nils

[JAVesey]

I would go to Admin and then into the each component in turn, saving the component's settings. Also in Admin, go into Global Configuration and save that too.

When I've had an error like this it's been after updating/upgrading and existing component and doing the above for the component solved the issue.

[Addy43+]

So scary! 1146 errors - Jeez - I really hope a third party extensions isn't interfering with the database

My Administrator Control Panel is really screwed up. I can't open the articles or menus. Now I need to read these replies. I'm scared I will make matters worse.

[JAVesey]

So scary! 1146 errors - Jeez - I really hope a third party extensions isn't interfering with the database

Depends what you mean by "interfering" - if you mean "writing to the database" then yes, of course they are. They shouldn't, however, by writing to other components' database tables. The installation process, including registering the component with the Joomla core, means that some core tables will be added to or amended. This is perfectly normal.

Like I've said, I've seen 1146 errors on updating a component and this has been solved by completing the update by saving the updated component's configuration after update.

I'd start by saving Global Config then clearing your site and browser caches, then go through the components one-by-one in Admin saving their individual configurations.

[Addy43+]

Thanks! I will try this.

I think I need to go to the database for the configuration or FTP since Global Configuration on back-end prompts, " 404 component not found"