error

[unplug]

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

[Joachim Müller]

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

[Anonymous]

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

[Joachim Müller]

seems like you run phpnuke port, I moved your thread here for this reason.
Please provide a link to your gallery, too.

GauGau

[sengsara]

It's the 'name' field . There's no name field.

Just change it to 'namee' in the appropriate lines and you're golden!

[unplug]

yes. I'm using phpnuke port.  I will try to rename the field and see whether it works or not.  Thanks!