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
in function.inc.php find
$result = db_query("SELECT name
, parent FROM {$CONFIG['TABLE_CATEGORIES']} WHERE cid = '$cat'");
replace with$result = db_query("SELECT namee
, parent FROM {$CONFIG['TABLE_CATEGORIES']} WHERE cid = '$cat'");
Hey Scott
I have allreade the namee inside....
but it has this error still
please help
cheers
oli
I went to the freestyle 2003 categoryand clicked on the lastcom link and topn link no problem, no error, should I consider this fixed?
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
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....