Support ⇒ Upgrades :: Archives ⇒ Album Problem after upgrading :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexUpgrades

Archived ⇒ Album Problem after upgrading

After upgrading to, I went through and checked everything. Everything seems to work fine except when I clicked on Album and I got the SQL error message below. Anybody can help me with a fix? Thank you.

CMS Warning line 75: On /index.php?name=coppermine&file=albmgr&cat=0 While executing query "SELECT aid, title, pos, description, thumb FROM cms_cpg_albums WHERE category = ORDER BY pos ASC" the following error occured: 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 'ORDER BY pos ASC' at line 1 In: /home/angkorth/public_html/modules/coppermine/albmgr.php on line: 111

RC heli hobby:
Khmer Community:

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Mysql 5.1.41/php 5.2.5/CPGNuke 9.2.1

You will need to apply the fix listed in this topic,

There was a small issue with the css menu Sad

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

All times are UTC