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: Critical error when select file:/ include/function.inc.php line 167  (Read 11469 times)

0 Members and 1 Guest are viewing this topic.

cpg_newbie

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Critical error when select file:/ include/function.inc.php line 167
« on: March 11, 2010, 05:29:05 am »
Im new here. few days ago i installed cpg version 1.4.2

when i want to click on the Home, My Gallery and Album List, the error below return

"While executing query "SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN ()GROUP BY a.aid" on 0

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')GROUP BY a.aid' at line 1"

it stated that the error in this paths : /include/functions.inc.php - Line: 167

can anyone help me how to solve this?
Logged

onthepike

  • Guest
Re: Critical error when select file:/ include/function.inc.php line 167
« Reply #1 on: March 11, 2010, 05:40:34 am »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Critical error when select file:/ include/function.inc.php line 167
« Reply #2 on: March 11, 2010, 07:18:28 am »
Quote from: cpg_newbie on March 11, 2010, 05:29:05 am
few days ago i installed cpg version 1.4.2
That's a bad idea: most recent stable release currently is cpg1.4.26. Subsequently, cpg1.4.2 is running 24 versions behind.
Logged

cpg_newbie

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: Critical error when select file:/ include/function.inc.php line 167
« Reply #3 on: March 11, 2010, 04:31:33 pm »
im sorry for the inconvenience, actually the version is 1.4.26. n the my database, sql version is 5.1.37. just checked it.  :-[
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Critical error when select file:/ include/function.inc.php line 167
« Reply #4 on: March 11, 2010, 05:35:09 pm »
...and for what reason do you keep ignoring onthepike's posting? You won't get far if you don't pay attention to supporter's advice and if you don't respect board rules. The mySQL version is completely unrelated and doesn't matter at all.
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.02 seconds with 19 queries.