SOLVED Possible Corruption
-
-
- beyud
- Sr. Rocketeer
- Posts: 185
- Thanks: 4
-
I recently logged into one of my sites to check up on it and found this snippet from my Joomla Bible Study Library.
500 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM.....
When I go to my plug-ins in the backend to uninstall the failed module. I get something similar.
1054
UNKNOWN COLUMN 'A.ID' IN 'WHERE CLAUSE' SQL=SELECT STUDY.ID, STUDY.PUBLISHED, STUDY.STUDYDATE.....
What concerns me is that A.ID. it seems to be out of place, but I could be wrong.
My question is. I was thinking of just copying over a clean coppy of Joomla full package and overwrite the bad files because that is what is seems to be pointing to. Which package to do download and copy over? My Rocketlauncher template full package or the generic Joomla full package?
Thanks
Tom - Last Edit: 9 years 1 month ago by beyud.
-
-
-
- MrT
- Preeminent Rocketeer
- Posts: 101084
- Thanks: 13484
- Web Designer/Developer
-
This may be counter-intuitive but what I'd actually do is to install the failed plugin again first before you then attempt to uninstall it. I'd also suggest trying the "fix" button on extensions > manage > database.
Overwriting Joomla files would be a very last resort as you can break things even more.
Regards, Mark. - Please search forums before posting. Please make sure your post includes the version of the CMS you are using and a link to the problem. Annotations on screenshots can also be helpful to explain problems/goals. Please use the "secure" tab for confidential information.
-
-
-
- beyud
- Sr. Rocketeer
- Posts: 185
- Thanks: 4
- Didn't actually figure out what the problem was and took your recommendation, but I just installed Joomla 3.4.8 and it fixed the issue. Oddly enough, Joomla didn't tell me that I needed an update. I ran my site through myjoomla and it showed I needed an update.
-
Time to create page: 0.058 seconds