Mandatory information about my setup:
Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Didn't see any
Joomla! version: 2.5.8
PHP version: 5.3.16
MySQL version: 5.1.62
Host: lunarpages
Admin Tools version: 2.4.2
Description of my issue:
Hello,
I just found out today that I have a Database error on my site. I am running Joomla 2.5, with Jomsocial. The issue is occurring when trying to link to a video in JomSocial. I get this error:
DB function failed with error number 1054
Unknown column 'alias' in 'where clause' SQL=SELECT id FROM snfxv_assets WHERE alias = 'root'
The error occurs for all guests, and registered users. As a Super Admin however, I am able to see the video and not get an error.
I can't imagine that Admin Tools caused it, but I'm grasping at straws. I just updated Admin tools, and then a user mentioned that teh error was occuring. Coincidence? Possibly...just not sure. So, any ideas what might be causing this?
Here is a link to a video list. Click any video on the page, and it'll show the error. http://tiny url.com/cdvhmex
============
Side question: There are these table prefixes that also have _assets. Should there be so many prefixes? (Again, please excuse my noobishness)
fyvp_assets
jos_assets
x0i4t_assets
y8ce4_assets
zn7si_assets