[fixed] Error Creating/Modifying Albums with 9.1.2.1
Post new topic   This topic is locked: you cannot edit posts or make replies.   Printer Friendly Page     Forum IndexCoppermine
Author Message
hdsoltau
Newbie


Joined: Mar 21, 2007
Posts: 44

PostPost subject: Re: Error Creating/Modifying Albums with 9.1.2.1
Posted: Thu Mar 22, 2007 2:38 pm
Reply with quote

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
View user's profile
Phoenix
Site Admin


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

PostPost subject: Re: Error Creating/Modifying Albums with 9.1.2.1
Posted: Thu Mar 22, 2007 3:27 pm
Reply with quote

Nano's fix is here, includes/cssmainmenu.php,
dragonflycms.org/cvs/h....php?g=1.2

_________________
DonationsPro for DragonflyCMS, SMF, MyBB, vBulletin

Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
layingback
Forum Admin


Joined: Apr 19, 2004
Posts: 953

PostPost subject: Re: Error Creating/Modifying Albums with 9.1.2.1
Posted: Thu Mar 22, 2007 3:40 pm
Reply with quote

THANKS! That was quick - never seen "11 minutes" since update in CVS before Wink

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
View user's profile Visit poster's website
Phoenix
Site Admin


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

PostPost subject: Re: Error Creating/Modifying Albums with 9.1.2.1
Posted: Thu Mar 22, 2007 3:44 pm
Reply with quote

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
View user's profile Visit poster's website
sarah
Debugger


Joined: Mar 25, 2005
Posts: 2131

PostPost subject: Re: Error Creating/Modifying Albums with 9.1.2.1
Posted: Thu Mar 22, 2007 4:31 pm
Reply with quote

Doh! Oh that CSS menu. Laughing 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
View user's profile Send e-mail Visit poster's website
hdsoltau
Newbie


Joined: Mar 21, 2007
Posts: 44

PostPost subject: Re: Error Creating/Modifying Albums with 9.1.2.1
Posted: Thu Mar 22, 2007 4:49 pm
Reply with quote

sarah wrote:
Doh! Oh that CSS menu. Laughing 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
View user's profile
hdsoltau
Newbie


Joined: Mar 21, 2007
Posts: 44

PostPost subject: Re: Error Creating/Modifying Albums with 9.1.2.1
Posted: Thu Mar 22, 2007 4:53 pm
Reply with quote

layingback wrote:
THANKS! That was quick - never seen "11 minutes" since update in CVS before Wink
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
View user's profile
sparky
Nice poster


Joined: Oct 19, 2004
Posts: 51
Location: England

PostPost subject: Coppermine error
Posted: Sat Mar 24, 2007 1:42 pm
Reply with quote

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
View user's profile Visit poster's website
Conkersm98fr
Newbie


Joined: Apr 21, 2004
Posts: 36
Location: Manchester, England

PostPost subject: Re: Coppermine error
Posted: Sat Mar 24, 2007 2:51 pm
Reply with quote

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
View user's profile Visit poster's website
sparky
Nice poster


Joined: Oct 19, 2004
Posts: 51
Location: England

PostPost subject: Re: Coppermine error
Posted: Sat Mar 24, 2007 3:03 pm
Reply with quote

Thanks for the reply i tried this and no luck cleared Cache just to be sure but no joy Sad

sparky's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Fedora2/2.0.51/ 3.23.58/4.3.8/cpg9
Back to top
View user's profile Visit poster's website
sarah
Debugger


Joined: Mar 25, 2005
Posts: 2131

PostPost subject: Re: Coppermine error
Posted: Sat Mar 24, 2007 4:03 pm
Reply with quote

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
View user's profile Send e-mail Visit poster's website
sparky
Nice poster


Joined: Oct 19, 2004
Posts: 51
Location: England

PostPost subject: Re: Coppermine error
Posted: Sat Mar 24, 2007 4:21 pm
Reply with quote

Thanks for that sarah all seems sorted now. Mr. Green

sparky's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Fedora2/2.0.51/ 3.23.58/4.3.8/cpg9
Back to top
View user's profile Visit poster's website
tubbs
Newbie


Joined: Feb 13, 2007
Posts: 2
Location: hungary

PostPost subject: error connecting to data base
Posted: Tue Mar 27, 2007 2:24 pm
Reply with quote

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 Smile

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.
Smile


tubbs's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
9.1.1
Back to top
View user's profile Visit poster's website
dreamer
Newbie


Joined: Mar 29, 2007
Posts: 8

PostPost subject: Re: error connecting to data base
Posted: Fri Mar 30, 2007 11:28 pm
Reply with quote

i have the same problem Sad

dreamer's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
dragonlfy
Back to top
View user's profile Visit poster's website
sarah
Debugger


Joined: Mar 25, 2005
Posts: 2131

PostPost subject: Re: error connecting to data base
Posted: Fri Mar 30, 2007 11:37 pm
Reply with quote

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
View user's profile Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   This topic is locked: you cannot edit posts or make replies.   Printer Friendly Page     Forum IndexCoppermine All times are GMT
Go to page Previous  1, 2, 3, 4, 5, 6, 7  Next
Page 2 of 7


Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Dedicated Server & Bandwidth Sponsored by DedicatedNOW
User Info [x]

Welcome Anonymous

Nickname
Password
(Register)

Last CVS commits [x]

Languages [x]

Community [x]

Support for DragonflyCMS in a other languages:

Deutsch
Español

X-links [x]
UltraEdit Browse Happy logo Firefox MySQL PostgreSQL Valid CSS! Valid XHTML 1.0! Unicode Encoded Badge NukeBiz Resources Raven DragonflyCMS Dedicated Now InsideSupport Lampe Berger

Preview theme [x]
Each user can view the site with a different theme.
Themes marked with a * also change the forum look.


You are seeing squares or questionmarks on this page?

All content of this website is copyrighted by the Creative Commons NC-SA
The logos and trademarks used on this site are the property of their respective owners
We are not responsible for comments posted by our users, as they are the property of the poster.
Our server runs on a P3 1.2GHz with 512MB RAM with no accelerators
Support GoPHP5.org
This page generated in 0.7984 seconds with 16 DB Queries in 0.1639 seconds
Memory Usage: 3.2 MB
Interactive software released under GNU GPL, Code Credits, Privacy Policy