forum.coppermine-gallery.net
Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: ojohn on November 17, 2003, 07:45:15 pm
-
HELP!
everytime i click on a image to view it give me this error:
There was an error while processing a database query
-
Turn debug mode on in config, reproduce the error, then post the message you get if you still can't resolve the problem.
-
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
-
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
-
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
-
There is no user_name field in the pictues table, maybe you mean owner_name.
-
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?
-
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