[ocala-kaylee]

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!!!!!!

[sarah]

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

[ocala-kaylee]

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.

[sarah]

cssmainmenu.php

[ocala-kaylee]

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

[mactabilis]

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.

[sarah]

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

[mactabilis]

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

[ocala-kaylee]

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

Thanks for all the help I get.

[heliown]

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

[heliown]

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.

[Wizzard308]

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?

[NanoCaiordo]

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

Hint: dragonflycms.org/Forums/search.html

[heliown]

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.

[MemoryDump]

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

any ideas?