error by most viewed and new comments in the categories

[olivers]

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

[gtroll]

in function.inc.php find

Code Select Expand

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

Code Select Expand

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

[olivers]

Hey Scott

I have allreade the namee inside....

but it has this error still

please help

cheers

oli

[gtroll]

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

[olivers]

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

[gtroll]

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....