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


Joined: Jun 10, 2007
Posts: 6

PostPost subject: Re: A database error has occurred
Posted: Sun Jun 10, 2007 11:14 am
Reply with quote

see the document i have inclosed

bartp's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
CMS Version 9.1.2.1 , PHP Version 4.3.9 , MySQL Version 4.1.20 (client: 4.1.20) , GD Version bundled (2.0.28 compatible)
Back to top
View user's profile Visit poster's website
Eestlane
I18N / L10N Lead Dev


Joined: Apr 06, 2005
Posts: 1406
Location: Estonia

PostPost subject: Re: A database error has occurred
Posted: Sun Jun 10, 2007 11:17 am
Reply with quote

Oh, OK, then there is an error indeed. But the real error is sent to your e-mail.

Eestlane's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.0.63/5.0.67/5.2.8/9.2.1
Back to top
View user's profile Send e-mail Visit poster's website
bartp
Newbie


Joined: Jun 10, 2007
Posts: 6

PostPost subject: Re: A database error has occurred
Posted: Sun Jun 10, 2007 11:31 am
Reply with quote

I wish that it was true, becauce i dont get a email, i also try to install a complete new version in an other dir, and get the same problem ??

bartp's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
CMS Version 9.1.2.1 , PHP Version 4.3.9 , MySQL Version 4.1.20 (client: 4.1.20) , GD Version bundled (2.0.28 compatible)
Back to top
View user's profile Visit poster's website
Eestlane
I18N / L10N Lead Dev


Joined: Apr 06, 2005
Posts: 1406
Location: Estonia

PostPost subject: Re: A database error has occurred
Posted: Sun Jun 10, 2007 11:32 am
Reply with quote

Then maybe the error is in the very end of the page, though I'm afraid it's cut out. Try disabling coppermine's debug and DF's debugs, only select the warnings and stuff...

Eestlane's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.0.63/5.0.67/5.2.8/9.2.1
Back to top
View user's profile Send e-mail Visit poster's website
bartp
Newbie


Joined: Jun 10, 2007
Posts: 6

PostPost subject: Re: A database error has occurred
Posted: Sun Jun 10, 2007 12:29 pm
Reply with quote

it is still not working i can't create albums or sort them, and get the same message, if you want some extra info, i hear it from you.

bartp's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
CMS Version 9.1.2.1 , PHP Version 4.3.9 , MySQL Version 4.1.20 (client: 4.1.20) , GD Version bundled (2.0.28 compatible)
Back to top
View user's profile Visit poster's website
Eestlane
I18N / L10N Lead Dev


Joined: Apr 06, 2005
Posts: 1406
Location: Estonia

PostPost subject: Re: A database error has occurred
Posted: Sun Jun 10, 2007 12:35 pm
Reply with quote

I mean that if you disable the debug, then it should show the real error message, but if showing these warning messages then error messages may not be shown.

Sorry for my not understandable {expletive removed} sentences Razz


Eestlane's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.0.63/5.0.67/5.2.8/9.2.1
Back to top
View user's profile Send e-mail Visit poster's website
bartp
Newbie


Joined: Jun 10, 2007
Posts: 6

PostPost subject: Re: A database error has occurred
Posted: Sun Jun 10, 2007 12:38 pm
Reply with quote

I have disable the debug in Dragonfly and in coppermine, but does not get error message's except the one i got before.

bartp's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
CMS Version 9.1.2.1 , PHP Version 4.3.9 , MySQL Version 4.1.20 (client: 4.1.20) , GD Version bundled (2.0.28 compatible)
Back to top
View user's profile Visit poster's website
NanoCaiordo
Developer


Joined: Jun 29, 2004
Posts: 3678
Location: Melbourne, AU

PostPost subject: Re: A database error has occurred
Posted: Sun Jun 10, 2007 10:46 pm
Reply with quote

Forums/viewtopic/t=19139.html
_________________
.:: I met php the 03 December 2003 :: Unforgettable day! ::.

NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
MySQL 5.1 / PHP 5.3 / NextGen()
Back to top
View user's profile Visit poster's website
bartp
Newbie


Joined: Jun 10, 2007
Posts: 6

PostPost subject: Re: A database error has occurred
Posted: Mon Jun 11, 2007 7:46 am
Reply with quote

Thanks this fix the problem for me.

bartp's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
CMS Version 9.1.2.1 , PHP Version 4.3.9 , MySQL Version 4.1.20 (client: 4.1.20) , GD Version bundled (2.0.28 compatible)
Back to top
View user's profile Visit poster's website
Bluefin221
Silver Supporter


Joined: Sep 12, 2005
Posts: 399
Location: Centre of the Earth

PostPost subject: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1
Posted: Wed Jun 13, 2007 7:00 pm
Reply with quote

Glad I found this fix, went onto my album and seen the error, I have over 5000 pictures on my album and went along to add this years, well over another 1500 so far.
_________________
Have a look at my new chat home: www.worldwidechatters.com
Looking for hosting www.caltonhosting.com

Bluefin221's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
ocala-kaylee
Newbie


Joined: Jun 16, 2007
Posts: 5

PostPost subject: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1
Posted: Sat Jun 16, 2007 3:38 am
Reply with quote

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


ocala-kaylee's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
winxp/iis 6/mysql5.0/php5.2/9.1.2.1
Back to top
View user's profile Visit poster's website
mactabilis
Newbie


Joined: Jun 15, 2007
Posts: 38

PostPost subject: CMS coppermine warning
Posted: Sat Jun 16, 2007 9:42 am
Reply with quote

After install when i veiw coppermine,
Code:
includes/db/db.php

    * CMS Warning line 75: On /public_html/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: /var/www/localhost/htdocs/public_html/modules/coppermine/albmgr.php on line: 111


mactabilis's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
/Linux_Gentoo/Apache 2.2/mysql 14.12/PHP 5.2.2-pl1-gentoo/CPGNuke 9.1.2.1/
Back to top
View user's profile
sarah
Debugger


Joined: Mar 25, 2005
Posts: 2131

PostPost subject: Re: CMS coppermine warning
Posted: Sat Jun 16, 2007 9:57 am
Reply with quote

It is my hope that the ancient art of searching will not become lost to the ages
_________________
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
sarahwjfc
Newbie


Joined: Jun 15, 2007
Posts: 1

PostPost subject: Re: CMS coppermine warning
Posted: Sat Jun 16, 2007 10:42 am
Reply with quote

Thats fine but what do we do with it!!

I havent got a clue and this site just boggles me with all the technical talk!! I have the same problem and have absolutely no idea how to fix it.

Please help a thickett LOL


sarahwjfc's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
www.westhoughtonjuniors.com/php
Back to top
View user's profile Visit poster's website
sarah
Debugger


Joined: Mar 25, 2005
Posts: 2131

PostPost subject: Re: CMS coppermine warning
Posted: Sat Jun 16, 2007 10:54 am
Reply with quote

Get the file in that post and upload 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
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 4 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.3634 seconds with 16 DB Queries in 0.0885 seconds
Memory Usage: 3.2 MB
Interactive software released under GNU GPL, Code Credits, Privacy Policy