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.

Comments

bonvga’s picture

bonvga commented
Assigned: Unassigned » bonvga
Status: Active » Postponed (maintainer needs more info)

There is a database upgrade available.

See the 'Status report' in the administration panel for upgrade.

limited1’s picture

limited1 commented

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

fellow’s picture

fellow commented

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.

bonvga’s picture

bonvga commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

I have found the bug in the install script and corrected it.

Thank's for your help.