[NanoCaiordo]

dragonflycms.org/Forum...tml#124359

[SwordmanJr]

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]

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]

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]

dragonflycms.org/Forum...tml#124359

[IS_Webbie]

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

[retroactiv]

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]

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

[huynhvhai]

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]

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

[warden]

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]

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!

[Mel]

Welcome to df community

moved to help section.

[Phoenix]

Actually, despite the very un-helpful "I have no idea" server specs, a quick search reveals the answer lies in this top-listed sticky topic.