:: Forums ⇒

[fixed] Error Creating/Modifying Albums with 9.1.2.1

#76: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Author: NanoCaiordo, Location: Melbourne, AU

Posted: Sun Jun 24, 2007 8:41 pm
----
dragonflycms.org/Forum...tml#124359

#77: Coppermine Database errors on MySQL 5.0.27 Author: SwordmanJr,

Posted: Tue Jul 31, 2007 12:13 pm
----
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

#78: Coppermine Error Author: Thraxion,

Posted: Fri Aug 03, 2007 4:28 am
----
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.

#79: Re: Coppermine Database errors on MySQL 5.0.27 Author: museo8bits, Location: Madrid, Spain

Posted: Mon Aug 20, 2007 6:59 pm
----
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.

#80: Re: Coppermine Database errors on MySQL 5.0.27 Author: NanoCaiordo, Location: Melbourne, AU

Posted: Mon Aug 20, 2007 11:12 pm
----
dragonflycms.org/Forum...tml#124359

#81: Re: Coppermine album error. Author: IS_Webbie, Location: Cedar Rapids, IA

Posted: Thu Aug 23, 2007 9:09 pm
----
I'd like to know what forum cuz i am an idiot and cant find it or sumthin.

#82: Moved: Coppermine SQL Error Author: retroactiv,

Posted: Sun Aug 26, 2007 4:24 am
----
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

#83: Re: Coppermine SQL Error Author: Jeruvy, Location: Canada

Posted: Mon Aug 27, 2007 4:39 pm
----
Please use the search function, this question has already been answered and now even has it's own sticky.

#84: Problem: Create / order my albums! Author: huynhvhai, Location: Da Nang

Posted: Sun Nov 25, 2007 7:04 am
----
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!

#85: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Author: Phoenix, Location: Netizen

Posted: Sun Nov 25, 2007 9:59 am
----
The fix is in this Coppermine topic that your post has been moved to.

#86: coppermine warning (error) after install Author: warden, Location: North Carolina

Posted: Fri Nov 30, 2007 5:29 pm
----
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

#87: Re: coppermine warning (error) after install Author: layingback,

Posted: Fri Nov 30, 2007 7:03 pm
----
Try this (Sticky at top of Coppermine Forum).

#88: Coppermine error received after installing? Author: magnuscanada, Location: Prince George BC Canada

Posted: Mon Dec 03, 2007 11:51 pm
----
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

#89: Re: Gallery Issues - New user - recently installed Author: Mel, Location: Eastern Time Zone

Posted: Tue Dec 04, 2007 12:00 am
----
Welcome to df community

moved to help section.

Wink

#90: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Author: Phoenix, Location: Netizen

Posted: Tue Dec 04, 2007 1:04 am
----
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.

-> Coppermine

All times are GMT

Go to page Previous 1, 2, 3, 4, 5, 6, 7 Next :| |: Page 6 of 7