[fixed] Error Creating/Modifying Albums with 9.1.2.1 :: Archived

NanoCaiordo

SwordmanJr · Newbie Offline 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 · Newbie Offline 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

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 · Posted: Thu Aug 23, 2007 9:09 pm Post subject: Re: Coppermine album error.

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

retroactiv · Newbie Offline 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 · Posted: Mon Aug 27, 2007 4:39 pm Post subject: Re: Coppermine SQL Error

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 · Forum Admin Offline Joined: Apr 19, 2004 Posts: 1040

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

Mel

Welcome to df community

moved to help section.

Wink

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.