:: Forums ⇒

[fixed] Error Creating/Modifying Albums with 9.1.2.1

#61: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Author: ocala-kaylee,

Posted: Sat Jun 16, 2007 6:24 pm
----

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

#62: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Author: sarah,

Posted: Sat Jun 16, 2007 7:03 pm
----
What's on line 159 of the one on your site?

#63: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Author: ocala-kaylee,

Posted: Sat Jun 16, 2007 8:48 pm
----
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.

#64: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Author: sarah,

Posted: Sat Jun 16, 2007 8:55 pm
----
cssmainmenu.php

#65: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Author: ocala-kaylee,

Posted: Sat Jun 16, 2007 8:58 pm
----
158 $content .= $CLASS['adminmenu']->display($ccat, 'cssmenu');
159 }
160
161 $content .= "\n</ul>\n";

#66: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Author: mactabilis,

Posted: Sun Jun 17, 2007 10:53 pm
----
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.

#67: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Author: sarah,

Posted: Mon Jun 18, 2007 12:29 am
----
It's just a notice. Does the image not upload?

#68: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Author: mactabilis,

Posted: Mon Jun 18, 2007 9:22 am
----

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 Smile

#69: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Author: ocala-kaylee,

Posted: Mon Jun 18, 2007 10:24 am
----
My error is from when I try to make the album.
This is starting to get aggravating.

Thanks for all the help I get.

#70: Coppermine album error. Author: heliown, Location: USA

Posted: Fri Jun 22, 2007 2:56 am
----
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

#71: Re: Coppermine album error. Author: heliown, Location: USA

Posted: Fri Jun 22, 2007 3:16 am
----
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.

#72: Re: Coppermine album error. Author: Wizzard308, Location: Tennessee

Posted: Sun Jun 24, 2007 6:50 am
----
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?

#73: Re: Coppermine album error. Author: NanoCaiordo, Location: Melbourne, AU

Posted: Sun Jun 24, 2007 7:52 am
----
@Wizzard308: heliown probably search our forums and he found the fix by him self.

Hint: dragonflycms.org/Forums/search.html

#74: Re: Coppermine album error. Author: heliown, Location: USA

Posted: Sun Jun 24, 2007 4:20 pm
----
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.

#75: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Author: MemoryDump, Location: Ontario, Canada

Posted: Sun Jun 24, 2007 8:38 pm
----
I get the exact same error when I try to create a new album Sad

any ideas?

-> Coppermine

All times are GMT

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