forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: ojohn on November 17, 2003, 07:45:15 pm

Title: There was an error while processing a database query
Post 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

Title: There was an error while processing a database query
Post by: Nibbler on November 17, 2003, 07:47:01 pm

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

Title: There was an error while processing a database query
Post by: ojohn on November 17, 2003, 08:39:29 pm

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

Title: There was an error while processing a database query
Post by: Oasis on November 17, 2003, 08:42:33 pm

Quote from: "ojohn"

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

Title: There was an error while processing a database query
Post by: Joachim Müller on November 17, 2003, 08:44:30 pm

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

Title: There was an error while processing a database query
Post by: Nibbler on November 17, 2003, 08:45:41 pm

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

Title: There was an error while processing a database query
Post by: Oasis on November 17, 2003, 08:51:05 pm

Quote from: "gaugau"

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?

Title: There was an error while processing a database query
Post by: ojohn on November 17, 2003, 09:12:14 pm

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