There was an error while processing a database query

[ojohn]

HELP!

everytime i click on a image to view it give me this error:

There was an error while processing a database query

[Nibbler]

Turn debug mode on in config, reproduce the error, then post the message you get if you still can't resolve the problem.

[ojohn]

Critical error

There was an error while processing a database query.


While executing query "SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, title, caption, user_name from cpg11d_pictures WHERE aid='1' AND approved='YES'  ORDER BY filename ASC " on 0

mySQL error: Unknown column 'user_name' in 'field list'



File: /web/public_html/photos/include/functions.inc.php - Line: 105

[Oasis]

mySQL error: Unknown column 'user_name' in 'field list'

Did you make changes to functions.inc.php?
There shouldn't be a query for user_name
It doesn't exist in TABLE_PICTURES

[Joachim Müller]

use phpMyAdmin to check if you actually have 'user_name' in cpg11d_pictures (or whatever your prefix is). If you don't have it, your install didn't work properly.
Also give us your php and mySQL-versions (while in debug mode and logged in as admin, click "advanced debug" at the very bottom of the page) to find out about those vars.

GauGau

[Nibbler]

There is no user_name field in the pictues table, maybe you mean owner_name.

[Oasis]

use phpMyAdmin to check if you actually have 'user_name' in cpg11d_pictures (or whatever your prefix is). If you don't have it, your install didn't work properly.

But there IS no user_name in CPG1.2
Maybe a half-added mod or hack?

[ojohn]

Thank for your help i found out what it was i try this hack/addon were it shows the user name . I think i never finish going thought the steps but now it works thank alot everybody