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

Archived ⇒ Album Problem after upgrading


After upgrading to 9.1.2.1, 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: www.rchelicoptertown.com
Khmer Community: www.angkorthom.us

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,
dragonflycms.org/Forum...19139.html

There was a small issue with the css menu Sad

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

All times are UTC