Unknown column 'm.user_name'
fellow - March 24, 2007 - 13:50
| Project: | Mugshot |
| Version: | 5.x-1.x-dev |
| Component: | Miscellaneous |
| Category: | bug report |
| Priority: | critical |
| Assigned: | bonvga |
| Status: | closed |
Jump to:
Description
Every time I navigate in Mugshot gallery:
user warning: Unknown column 'm.user_name' in 'field list' query: SELECT m.mid, m.path, m.timestamp, m.visible, u.uid, u.name AS registered_name, m.sid, m.user_name FROM mugshot m INNER JOIN users u ON m.uid = u.uid WHERE m.preview = 0 ORDER BY m.timestamp DESC LIMIT 0, 24 in /home/ymessro/public_html/includes/database.mysql.inc on line 167.
I can take images from my web camera but they don't appear anywhere.
#1
There is a database upgrade available.
See the 'Status report' in the administration panel for upgrade.
#2
Sorry your solution is "See the 'Status report' in the administration panel for upgrade." is not clear. I coluld only see the php errors here. Can you please be more specific as this appears to be a common problem
#3
My status raport looks good. I don't see any database upgrade message.
There is another problem when I press shoot button : "No webcam detected".
In test link provided I can upload images - so there isn't any problem with my webcam.
The "Unknown column 'm.user_name'" error still appear at Mugshot gallery.
#4
I have found the bug in the install script and corrected it.
Thank's for your help.