General ⇒ FAQ (Frequently Answered Questions) :: Archives ⇒ Coppermine error :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexFAQ (Frequently Answered Questions)

Archived ⇒ Coppermine error


Hi guys,

I encountered an error after installing the DF two days ago. Still under maintenance, I was setting up my coppermine stuff when I encountered this error: includes\db\db.php * CMS Warning line 75: On /index.php?name=coppermine&file=albmgr&cat=1 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: C:\Inetpub\vhosts\yckakis.com\httpdocs\modules\coppermine\albmgr.php on line: 111 any ideas? I have had knowledge with DF before, I was using this on other forums, then I stopped for a while to test on IPB but that failed me miserably, not up to my expectations. So now I am back but using the 9121 setup, and this problem comes out when I clicked "Albums" or "Create/Order my Albums" in the photo gallery tasks menu. Thank you! Smile

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
WinOS2003/IIS/SQL4/4/9.1.2.1


here (sticky at top of coppermine forum).

Pro_News CM™ - Content Management for Dragonfly CMS™

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / 1.3.39 - 2.4.9 / 5.5.42 - 5.6.16 / 5.4.37 - 5.5.11 / 9.4

All times are UTC