Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: error by most viewed and new comments in the categories  (Read 6329 times)

0 Members and 1 Guest are viewing this topic.

olivers

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
error by most viewed and new comments in the categories
« 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
Logged

gtroll

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 618
    • CPG-Nuke
Unknown column 'name' in 'field list'
« Reply #1 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'");
                         

olivers

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
error by most viewed and new comments in the categories
« Reply #2 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
Logged

gtroll

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 618
    • CPG-Nuke
error by most viewed and new comments in the categories
« Reply #3 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?

olivers

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
error by most viewed and new comments in the categories
« Reply #4 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
Logged

gtroll

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 618
    • CPG-Nuke
error by most viewed and new comments in the categories
« Reply #5 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....
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 19 queries.