ocala-kaylee wrote:

I have updated cssmainmenu.php and i still get includes\db\db.php CMS 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: C:\http\modules\coppermine\albmgr.php on line: 111 help ocala kaylee

As you see in my post! I downloaded the file i put it in the correct location, and still have the error!!!!!!

What's on line 159 of the one on your site?

Line 159 of which file? My error is in line 111 of albmgr.php and it reads $result = $db->sql_query("SELECT aid, title, pos, description, thumb FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = ORDER BY pos ASC");

Please forgive me for I am very new to this stuff.

cssmainmenu.php

158 $content .= $CLASS['adminmenu']->display($ccat, 'cssmenu');
159 }
160
161 $content .= "\n</ul>\n";

yes i put the file in the includes and im getting this error now,

Code::

Notice: Undefined variable: ccat in /var/www/localhost/htdocs/public_html/includes/cssmainmenu.php on line 92

I get it when i try to upload a image.

It's just a notice. Does the image not upload?

sarah wrote:

It's just a notice. Does the image not upload?

No the image does not upload i just get that message ,I thought it would be the fact that the site was still running on my localhost,But in theory it should still upload maybe i have permission problem somewhere?
Any help would be great thanks

My error is from when I try to make the album.
This is starting to get aggravating.

Thanks for all the help I get.

Hi folks,
I just installed the Dragon 9.2.1 when trying to create public albums, would someone help me to understand and share with me the hints ot fix it?

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

I use php 5.1.6 and MySQL 5.0.27

I found the fix. Hey everybody don't do like I did. Search first. I feel shame now. Again Dragonfly Development team is alwasys the best.

you ask for a fix, find a fix yet dont share the fix on the forum? dont you think it would be respectful to share your knowledge with others?

@Wizzard308: heliown probably search our forums and he found the fix by him self.

Hint: dragonflycms.org/Forums/search.html

Wizzard308, what NanoCaiordo is right it is not my fix it is a fix on this forum that I should have searched it. What I can say is I admire and owe the Dragon community so much that I would do whatever I can to help. So don't worry if I know anything, I'll share.

I get the exact same error when I try to create a new album

any ideas?