[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
Mahyla
Newbie


Joined: Sep 14, 2007
Posts: 46

PostPost subject: Error when trying to upload files/add Albums in coppermine
Posted: Sun Dec 09, 2007 5:27 pm
Reply with quote

Hey Everyone,

I have recieved an error that wasn't there
before. I am not sure about what caused it,
but I believe it might be my fault... I did
try to upload images directly through ftp on
the coppermine
public_html/modules/coppermine/albums

However, it didn't show them at all when i
tried linking them inside the site. The idea
behind uploading them directly instead through
dragonfly was that I didn't want those images
listed as my personal album. I wanted to have
them in a folder as kind of an content not for
personal... Anyway, now I have an error that is
throwing this things at me when I try to acess
the admin of coppermine to upload images or add
or edit albums as well:

includes/db/db.php

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

I am sure my MySQL didn't change, but I also asked
them yesterday. I hope I receive the answere soon, but
I do hope that the mistake is not really the MYSQL, but
something else...

Can anyone help me with this error?

Thanks a lot

Mahyla


Mahyla's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/4.1.22-standard/4.4.7/Version 9.1.2.1
Back to top
View user's profile Visit poster's website
rlgura
1000+ Posts Club


Joined: Mar 27, 2006
Posts: 1148
Location: Cleveland, OH USA

PostPost subject: Re: Error when trying to upload files/add Albums in coppermine
Posted: Sun Dec 09, 2007 7:30 pm
Reply with quote

This is a known bug with DF 9.1.2.1
Search is your friend Smile

dragonflycms.org/Forum...ic/t=19139

_________________
Admin - Great Lakes Web Designs
Theme Designer - WebSite Guru Designs
Site Admin - Families with Food Allergies

rlgura's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux 2.6.27-grsec/Apache 2.2.11/MySQL 5.0.67-community-log/PHP 5.2.8/DF 9.2.1
Back to top
View user's profile Visit poster's website
layingback
Forum Admin


Joined: Apr 19, 2004
Posts: 953

PostPost subject: Re: Error when trying to upload files/add Albums in coppermi
Posted: Sun Dec 09, 2007 7:50 pm
Reply with quote

Link actually is dragonflycms.org/Forums/viewtopic/t=19139.html

But anyway, it's at top of this Forum as a "Sticky."

_________________
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
Mahyla
Newbie


Joined: Sep 14, 2007
Posts: 46

PostPost subject: Re: Error when trying to upload files/add Albums in coppermi
Posted: Sun Dec 09, 2007 8:06 pm
Reply with quote

Thank you, everyone! I had used search but didn't
seemingly look for the right thing... T_T Search
may be your friend but I seem to stupid to use it
XD. Thanks a lot and sorry for this post... T_T

I never thought I'd be one of these "Guess don't
they know how to use the search tool" people, but
I guess I am Embarassed Embarassed

Mahyla


Mahyla's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/4.1.22-standard/4.4.7/Version 9.1.2.1
Back to top
View user's profile Visit poster's website
layingback
Forum Admin


Joined: Apr 19, 2004
Posts: 953

PostPost subject: Re: Error when trying to upload files/add Albums in coppermi
Posted: Sun Dec 09, 2007 9:08 pm
Reply with quote

Ha, ha. Don't sweat it! I had trouble finding it when I need it the other day - and I knew it was here!

Trying to use Search is akin to using a Dictionary to spell a word!!! You need to know a good bit of the answer in order to first get the question right ...

_________________
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
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
Page 7 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.5719 seconds with 16 DB Queries in 0.5686 seconds
Memory Usage: 2.89 MB
Interactive software released under GNU GPL, Code Credits, Privacy Policy