Critical error when select file:/ include/function.inc.php line 167

[cpg_newbie]

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?

[onthepike]

http://forum.coppermine-gallery.net/index.php/topic,55415.msg270616.html#msg270616

[Joachim Müller]

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.

[cpg_newbie]

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. 

[Joachim Müller]

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