CPG Dragonfly™ CMS

IgorMM · Post subject: 9.1.2.1 coppermine problem Posted: Mon Apr 02, 2007 4:21 pm

hi i just instaled the 9.1.2.1. version, and only problem that i have is with coppermine when i click on the options Albums this error shows:

Code:

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/clubmyst/public_html/modules/coppermine/albmgr.php on line: 111

i ceacked and allfiles are uploaded. so how to fix this problem.

layingback · Joined: Apr 19, 2004 Posts: 953

Look here http://dragonflycms.org/Forums/viewtopic/t=19139.html

IgorMM · Post subject: Re: 9.1.2.1 coppermine problem Posted: Mon Apr 02, 2007 4:47 pm

IgorMM

this fix isnt wery good. the problem isnt solwed 100%, yes the option Album worsk, but when you create a album, and go propertis for that album and when you chouse the option:
Visitors can upload pictures YES and change to NO and clikc update album, then again it shows YES and cant be changet to NO. and all the time the album shows that there are no pictures in the album, (but the pictures Are in the album). like you can se in the picture:

sarah · Joined: Mar 25, 2005 Posts: 2131

That's a different issue than the one described in this thread. Please enable all debugging options ( admin.php?op=settings&s=8 ) and post the error when you try to change options.

IgorMM

here are the all errors that show for the coppermine:

Quote:

modules/coppermine/include/load.inc

* 0.0004 - LINE 81: SELECT prefix, dirname FROM cms_cpg_installs ORDER BY cpg_id
* 0.0004 - LINE 98: SELECT value FROM cms_cpg_config WHERE name='nice_titles'

includes/coppermine/init.inc

* 0.0006 - LINE 52: SELECT * FROM cms_cpg_config
* 0.0008 - LINE 72: SELECT * FROM cms_cpg_usergroups WHERE group_id = 3

modules/coppermine/modifyalb.php

* 0.0004 - LINE 360: SELECT * FROM cms_cpg_albums WHERE aid='4'
* 0.0006 - LINE 329: SELECT aid, IF(username IS NOT NULL, CONCAT('(', username, ') ', title), CONCAT(' - ', title)) AS title FROM cms_cpg_albums AS a LEFT JOIN cms_users AS u ON category = (10000 + user_id) ORDER BY title
* 0.0005 - LINE 48: SELECT cid, catname, description FROM cms_cpg_categories WHERE parent = '0' AND cid != 1 ORDER BY pos
* 0.0005 - LINE 177: SELECT pid, filepath, filename, url_prefix FROM cms_cpg_pictures WHERE aid='4' AND approved='YES' ORDER BY filename
* 0.0005 - LINE 260: SELECT group_id, group_name FROM cms_cpg_usergroups WHERE 1

includes/cssmainmenu.php

* 0.0007 - LINE 42: SELECT m.title as link, m.custom_title as title, m.view, m.active, m.inmenu, m.cat_id, m.pos AS linkpos, c.name, c.image, c.pos AS catpos, c.link AS catlnk, c.link_type AS cattype FROM cms_modules AS m LEFT JOIN cms_modules_cat c ON (c.cid = m.cat_id)
* 0.0006 - LINE 58: SELECT l.title, l.link, l.link_type, l.view, l.active, l.cat_id, l.pos AS linkpos, c.name, c.image, c.pos AS catpos, c.link AS catlnk, c.link_type AS cattype FROM cms_modules_links AS l LEFT JOIN cms_modules_cat c ON (c.cid = l.cat_id)

lovelyd · Joined: Apr 22, 2007 Posts: 8

Please help, this error message appears when I attempt to create alblums:

includes/db/db.php

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: modules/coppermine/albmgr.php on line: 111

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

dragonflycms.org/Forum...tml#124359

andres25cba · Joined: May 29, 2007 Posts: 6

Quote:

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 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/users/92/darksite/www/www.darkb.com.ar/modules/coppermine/albmgr.php on line: 111

this happens when i try to go to the ALBUMS section.

Any idea?

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

I am presuming the fix is in this thread - you provide absolutely no helpful info in your server specs to help us help you. "5986" is extremely meaningless.

andres25cba · Joined: May 29, 2007 Posts: 6

mmm... this is my zip code.

I dk why it is there..

what do you want to know?

andres25cba · Joined: May 29, 2007 Posts: 6

sarah wrote:

Code:

$cat = intval(isset($_POST['cat']) ? $_POST['cat'] : (isset($_GET['cat']) ? $_GET['cat'] : 0));

Done! Ty So Much!!!!

Problem fixed.

bartp · Joined: Jun 10, 2007 Posts: 6

After a new installation of Dragonfly, when trying to use the album link, i get this error, does someone know what is wrong

thanks,

Debug information:

Array
(
[theme] => wsg_ZoneCopper
[session_time] => 1181456391
[session_start] => 1181449535
[comments] => Array
(
[mode] =>
[order] => 0
[thold] => 0
)

[admin] => Array
(
[page] =>
)

[user] => Array
(
[page] => coppermine
[file] => albmgr
[uri] => /nl/index.php?name=coppermine&file=albmgr&cat=0
)

[update_monitor] => Array
(
[current] => 9.1.2.1
=> 1
[msg] => Array
(

=> Array
(
[vers] => 9.1.2.1
[title] => 9.1.2.1 Released
[desc] => [url=http://dragonflycms.org/Downloads/details/id=28.html]Download Here] => dragonflycms.org/Downl...id=28.html
[num] => 1
[msg] => Array
(

=> Array
(
[vers] => 9.1.2.1
[title] => 9.1.2.1 Released
[desc] => [url=http://dragonflycms.org/Downloads/details/id=28.html]Download Here
[date] => 1174348968
)

)

)

)

Eestlane · Joined: Apr 06, 2005 Posts: 1406 Location: Estonia

That is not an error. It is Coppermine's allery Debug information. You can disable it by going to Coppermine's settings and disabling debug setting, which is the bottom of page.

Eestlane · Joined: Apr 06, 2005 Posts: 1406 Location: Estonia

Some typos...

That is not an error. It is Coppermine's Gallery Debug information. You can disable it by going to Coppermine's settings and disabling debug setting, which is in the bottom of page.

CPG Dragonfly™ CMS

DedicatedNow