coppermine-gallery.com/forum

Support => Older/other versions => cpg1.1d PHPnuke Support (deprecated) => Topic started by: unplug on September 30, 2003, 04:43:30 PM

Title: error
Post by: unplug on September 30, 2003, 04:43:30 PM
Hi,

  I found that there is an error when I click "Last uploads","Last comments","Most viewed" or "Top rated" sometimes.  It showed the error message below.

There was an error while processing a database query

How can I fix it?

unplug
Title: error
Post by: Joachim Müller on September 30, 2003, 06:17:13 PM
switch on debug_mode and copy'n'paste the url and the debug output here, so we can take a look. I don't want to make this easy on us and say it's not a bug, but it could very likely also be a server misconfiguration issue.

GauGau
Title: error
Post by: Anonymous on October 01, 2003, 09:04:15 AM
Quote from: "gaugau"switch on debug_mode and copy'n'paste the url and the debug output here, so we can take a look. I don't want to make this easy on us and say it's not a bug, but it could very likely also be a server misconfiguration issue.

GauGau

Below is the message in debug mode.

There was an error while processing a database query.

While executing query "SELECT cid, name, description FROM cpg_categories WHERE parent = '10002'"

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

file: /home/portal/lacosta/html/modules/coppermine/include/functions.inc.php - line: 97

unplug
Title: error
Post by: Joachim Müller on October 01, 2003, 09:14:07 AM
seems like you run phpnuke port, I moved your thread here for this reason.
Please provide a link to your gallery, too.

GauGau
Title: error
Post by: sengsara on October 01, 2003, 11:13:47 AM
It's the 'name' field . There's no name field.

Just change it to 'namee' in the appropriate lines and you're golden!
Title: error
Post by: unplug on October 01, 2003, 06:51:15 PM
yes. I'm using phpnuke port.  I will try to rename the field and see whether it works or not.  Thanks!