| Author |
Message |
hdsoltau


Joined: Mar 21, 2007 Posts: 44
|
Post subject: Re: Error Creating/Modifying Albums with 9.1.2.1 Posted: Thu Mar 22, 2007 2:38 pm |
|
worx, regarding all of the cpg stuff.
created albums, modified albums, etc.. n prob.
thx sarah!
hdsoltau's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Solaris/1.3.31/5.x/5.x/9.1.2.1 |
|
| Back to top |
|
 |
Phoenix


Joined: Apr 19, 2004 Posts: 8729 Location: Netizen
|
|
| Back to top |
|
 |
layingback


Joined: Apr 19, 2004 Posts: 953
|
Post subject: Re: Error Creating/Modifying Albums with 9.1.2.1 Posted: Thu Mar 22, 2007 3:40 pm |
|
THANKS! That was quick - never seen "11 minutes" since update in CVS before 
Main menu! Explains why the rest of us never saw this one!!!
I appreciate the effort that many people put into finding or helping find this one. Cheers All!
_________________ Pro_News: The complete module for Dragonfly - now available as version 3.3
layingback's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) 2.6 - 3.6 / 1.3.42 - 2.2.12 / 5.0.92 - 5.1.37 - 5.1.54 / 4.4.49 - 5.2.17 - 5.3 / 9.2.1 |
|
| Back to top |
|
 |
Phoenix


Joined: Apr 19, 2004 Posts: 8729 Location: Netizen
|
Post subject: Re: Error Creating/Modifying Albums with 9.1.2.1 Posted: Thu Mar 22, 2007 3:44 pm |
|
Problem was $cat was set as a global in there, no idea why - anyway $cat changed to $ccat ( thought about using $scat) for good measure.
_________________ • DonationsPro for DragonflyCMS, SMF, MyBB, vBulletin •
Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
 |
|
| Back to top |
|
 |
sarah


Joined: Mar 25, 2005 Posts: 2131
|
Post subject: Re: Error Creating/Modifying Albums with 9.1.2.1 Posted: Thu Mar 22, 2007 4:31 pm |
|
Doh! Oh that CSS menu. I would have never found that.
_________________ Diagon Alley - Top Design
sarah's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux/1.3.37/4.1.21-standard/4.4.4/9.1.1 |
|
| Back to top |
|
 |
hdsoltau


Joined: Mar 21, 2007 Posts: 44
|
Post subject: Re: Error Creating/Modifying Albums with 9.1.2.1 Posted: Thu Mar 22, 2007 4:49 pm |
|
sarah wrote:
Doh! Oh that CSS menu.  I would have never found that.
never mind doode, your fix helped me on the short run, well done, thank you!
hdsoltau's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Solaris/1.3.31/5.x/5.x/9.1.2.1 |
|
| Back to top |
|
 |
hdsoltau


Joined: Mar 21, 2007 Posts: 44
|
Post subject: Re: Error Creating/Modifying Albums with 9.1.2.1 Posted: Thu Mar 22, 2007 4:53 pm |
|
layingback wrote:
THANKS! That was quick - never seen "11 minutes" since update in CVS before
this is usual for CVS fixes. however, DragonflyCMS 9.1.2.1 Released january 8th according to the webpage, and Sat Mar 17, 2007 4:54 pm according to the downoad site. so this is about 5 days for the fix, not 11 minutes.
and, btw, the mainpage still has not been updatet!
now come on doodes, how should anyone notice there is a bug in album creation?
hdsoltau's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Solaris/1.3.31/5.x/5.x/9.1.2.1 |
|
| Back to top |
|
 |
sparky


Joined: Oct 19, 2004 Posts: 51 Location: England
|
Post subject: Coppermine error Posted: Sat Mar 24, 2007 1:42 pm |
|
I just done a fresh new install(9.1.2.1)and i am getting this error when trying to create album in coppermine
Code:
A database error has occurred
The webmaster has been notified of the error
Code:
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: /var/www/html/tkd/public_html/modules/coppermine/albmgr.php on line: 111
thanks for any help
sparky's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Fedora2/2.0.51/ 3.23.58/4.3.8/cpg9 |
|
| Back to top |
|
 |
Conkersm98fr


Joined: Apr 21, 2004 Posts: 36 Location: Manchester, England
|
Post subject: Re: Coppermine error Posted: Sat Mar 24, 2007 2:51 pm |
|
Hi, I've just had this problem as part of my upgrade and I solved it quite be accident.
Go into the Coppermine Config and change the theme from 'default' to 'Maze'.
It worked for me, it may just work for you
Conkersm98fr's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Dragonfly 9.1.1 /Linux/Apache 1.3.37(UNIX)/PHP 4.4.3/MySQL 4.0.27-Standard |
|
| Back to top |
|
 |
sparky


Joined: Oct 19, 2004 Posts: 51 Location: England
|
Post subject: Re: Coppermine error Posted: Sat Mar 24, 2007 3:03 pm |
|
Thanks for the reply i tried this and no luck cleared Cache just to be sure but no joy
sparky's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Fedora2/2.0.51/ 3.23.58/4.3.8/cpg9 |
|
| Back to top |
|
 |
sarah


Joined: Mar 25, 2005 Posts: 2131
|
Post subject: Re: Coppermine error Posted: Sat Mar 24, 2007 4:03 pm |
|
See this thread: dragonflycms.org/Forum...rt=15.html
The problem was being caused by the CSS menu, there is a fixed CSS menu you can replace yours with, that will solve it.
_________________ Diagon Alley - Top Design
sarah's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux/1.3.37/4.1.21-standard/4.4.4/9.1.1 |
|
| Back to top |
|
 |
sparky


Joined: Oct 19, 2004 Posts: 51 Location: England
|
Post subject: Re: Coppermine error Posted: Sat Mar 24, 2007 4:21 pm |
|
Thanks for that sarah all seems sorted now.
sparky's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Fedora2/2.0.51/ 3.23.58/4.3.8/cpg9 |
|
| Back to top |
|
 |
tubbs


Joined: Feb 13, 2007 Posts: 2 Location: hungary
|
Post subject: error connecting to data base Posted: Tue Mar 27, 2007 2:24 pm |
|
I am getting this error when selecting the album section in the coppermine block.
cms version 9.1.2.1 and this is the only problem i've had since i upgraded
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: /hsphere/local/home/fatman/pencilheads.co.uk/modules/coppermine/albmgr.php on line: 111
could someone explain how to rectify this?
thanks in advance.
tubbs's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) 9.1.1 |
|
| Back to top |
|
 |
dreamer


Joined: Mar 29, 2007 Posts: 8
|
Post subject: Re: error connecting to data base Posted: Fri Mar 30, 2007 11:28 pm |
|
i have the same problem
dreamer's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) dragonlfy |
|
| Back to top |
|
 |
sarah


Joined: Mar 25, 2005 Posts: 2131
|
Post subject: Re: error connecting to data base Posted: Fri Mar 30, 2007 11:37 pm |
|
Four posts down: dragonflycms.org/Forum...rt=15.html
_________________ Diagon Alley - Top Design
sarah's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux/1.3.37/4.1.21-standard/4.4.4/9.1.1 |
|
| Back to top |
|
 |