Print Page - error by most viewed and new comments in the categories

Title: error by most viewed and new comments in the categories
Post by: olivers on October 10, 2003, 06:17:14 PM

Hi All

we have coppermine installed and it works fine, except one little crazy error.

http://www.4riders.com

when we want to see the most viewd pics in the main menu - it works...
when we click 'most viewed' or new comments in the a category we get this error message:

--------comment----------

While executing query "SELECT name FROM cpg_categories WHERE cid = '25'"

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

Datei: /home/extremesport/public_html/modules/coppermine/include/functions.inc.php - Zeile: 97

Debug info
USER:
Array
(
[ID] => 748e616475e2fdbec040aac403214e06
[am] => 1
)

GET :
Array
(
[name] => coppermine
[file] => thumbnails
[album] => toprated
[cat] => 25
)

POST :
Array
(
)

-------end comment-----------

please help !

thanks upfront for your help !

cheers

oli

Title: Unknown column 'name' in 'field list'
Post by: gtroll on October 10, 2003, 09:29:04 PM

in function.inc.php find

Code Select

$result = db_query("SELECT name
, parent FROM {$CONFIG['TABLE_CATEGORIES']} WHERE cid = '$cat'");

replace with

Code Select

$result = db_query("SELECT namee
, parent FROM {$CONFIG['TABLE_CATEGORIES']} WHERE cid = '$cat'");

Title: error by most viewed and new comments in the categories
Post by: olivers on October 11, 2003, 06:39:47 PM

Hey Scott

I have allreade the namee inside....

but it has this error still

please help

cheers

oli

Title: error by most viewed and new comments in the categories
Post by: gtroll on October 11, 2003, 09:14:36 PM

I went to the freestyle 2003 categoryand clicked on the lastcom link and topn link no problem, no error, should I consider this fixed?

Title: error by most viewed and new comments in the categories
Post by: olivers on October 13, 2003, 08:28:02 AM

hm...

if i click on it , i receive still this error

here's the direct link

http://4riders.com/modules.php?name=coppermine&file=thumbnails&album=lastcom&cat=25

cheers

oli

Title: error by most viewed and new comments in the categories
Post by: gtroll on October 13, 2003, 10:00:20 AM

Is there any comments in that category? I wasn't able to post (not a member). The most viewed or topr worked fine... If you don't have any results you may get that error message....

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.1d PHPnuke Support (deprecated) => Topic started by: olivers on October 10, 2003, 06:17:14 PM