CPG Dragonfly™ CMS

NanoCaiordo · Joined: Jun 29, 2004 Posts: 3678 Location: Melbourne, AU

SwordmanJr · Joined: Jul 31, 2007 Posts: 1

Could someone tell me what this means, and how to fix it?

This is what I get when trying to create an album in a category:

includes/db/db.php
CMS Warning line 75: On /index.php?name=coppermine&file=albmgr While executing query "SELECT aid, title, pos, description, thumb FROM dfy_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/tpascout/public_html/modules/coppermine/albmgr.php on line: 111

Thraxion · Joined: Jul 31, 2007 Posts: 19

I am getting this error

Code:

MS 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: /home/content/t/h/r/thraxion/html/modules/coppermine/albmgr.php on line: 111

I know there is a fix for this error:
http://dragonflycms.org/Forums/viewtopic/t=19139/start=16.html

But even after installing the fix, I am still haveing the problem. I have searched and still, nothing.

Help would be greatly appreciated, thanks.

museo8bits · Joined: Aug 20, 2007 Posts: 1 Location: Madrid, Spain

I have equal problem, but solution is simple. Edit albmgr.php and at line 106 :

REMOVED BY NANO

And all OK
Remember do make first a backup of the file.

NanoCaiordo · Joined: Jun 29, 2004 Posts: 3678 Location: Melbourne, AU

dragonflycms.org/Forum...tml#124359

IS_Webbie · Joined: Aug 17, 2007 Posts: 33 Location: Cedar Rapids, IA

I'd like to know what forum cuz i am an idiot and cant find it or sumthin.

retroactiv · Joined: Aug 26, 2007 Posts: 3

I'm getting this error on coppermine after a user who has never uploaded a picture before uploaded a picture. I've been using coppermine for quite sometime and have never had a problem. Any ideas?

Quote:

CMS Warning line 75: On /coppermine/albmgr/cat=1.html 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: /webroot/r/e/retro004/www/modules/coppermine/albmgr.php on line: 111

Jeruvy · Joined: Apr 23, 2004 Posts: 1433 Location: Canada

Please use the search function, this question has already been answered and now even has it's own sticky.

huynhvhai · Joined: Nov 25, 2007 Posts: 1 Location: Da Nang

This warning appear when i click "Create / order my albums" - Module Photo Galery
----------------------------
includes/db/db.php

* CMS Warning line 75: On /photo/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: /home/trangchu/public_html/photo/modules/coppermine/albmgr.php on line: 111
------------------------------
Help me!

Phoenix · Joined: Apr 19, 2004 Posts: 8729 Location: Netizen

The fix is in this Coppermine topic that your post has been moved to.

warden · Joined: Dec 16, 2004 Posts: 196 Location: North Carolina

I just updated a site from 9061 to 9.1.2.1. The upgrade produces this error in coppermine. The albums that were created by the administrator admin account are fine, but on the only album created by a user, the same admin account, it shows this message when trying to edit the album.
Also, and I don't know if it is related but, the only way to view the album(s) is to have the "Show first level album thumbnails in categories" set to yes. With this set to "No", the links to the album will load the album page but there are no albums to view, only empty space. However, with this set to yes, they show normally, except the user gallery, which does not show anything.

Can anybody advise what is wrong or what needs to be corrected with this error?

Quote:

CMS Warning line 75: On /coppermine/albmgr/cat=0.html While executing query "SELECT aid, title, pos, description, thumb FROM fun_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/account-name/public_html/modules/coppermine/albmgr.php on line: 111

layingback · Joined: Apr 19, 2004 Posts: 953

Try this (Sticky at top of Coppermine Forum).

magnuscanada

Here is the error:
includes/db/db.php

* 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/.mimmi/joosting/magnuscanada.com/modules/coppermine/albmgr.php on line: 111

****
I'm new to dragonfly so I'm not really sure where to be posting this. I'm also impatient because I can't always figure out why something isn't working...but if someone points it out I can definitely rectify a problem if pointed in the right direction.

My php version is 5.5.2 and mysql is the latest. I didn't have any troubles with the install. I am just figuring that I missed a step? Any help would be appreciated.

Frustrated in Canada! Embarassed