| Author |
Message |
bartp


Joined: Jun 10, 2007 Posts: 6
|
Post subject: Re: A database error has occurred Posted: Sun Jun 10, 2007 11:14 am |
|
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 |
|
 |
Eestlane


Joined: Apr 06, 2005 Posts: 1406 Location: Estonia
|
Post subject: Re: A database error has occurred Posted: Sun Jun 10, 2007 11:17 am |
|
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 |
|
 |
bartp


Joined: Jun 10, 2007 Posts: 6
|
Post subject: Re: A database error has occurred Posted: Sun Jun 10, 2007 11:31 am |
|
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 |
|
 |
Eestlane


Joined: Apr 06, 2005 Posts: 1406 Location: Estonia
|
Post subject: Re: A database error has occurred Posted: Sun Jun 10, 2007 11:32 am |
|
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 |
|
 |
bartp


Joined: Jun 10, 2007 Posts: 6
|
Post subject: Re: A database error has occurred Posted: Sun Jun 10, 2007 12:29 pm |
|
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 |
|
 |
Eestlane


Joined: Apr 06, 2005 Posts: 1406 Location: Estonia
|
Post subject: Re: A database error has occurred Posted: Sun Jun 10, 2007 12:35 pm |
|
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
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 |
|
 |
bartp


Joined: Jun 10, 2007 Posts: 6
|
Post subject: Re: A database error has occurred Posted: Sun Jun 10, 2007 12:38 pm |
|
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 |
|
 |
NanoCaiordo


Joined: Jun 29, 2004 Posts: 3678 Location: Melbourne, AU
|
Post subject: Re: A database error has occurred Posted: Sun Jun 10, 2007 10:46 pm |
|
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 |
|
 |
bartp


Joined: Jun 10, 2007 Posts: 6
|
Post subject: Re: A database error has occurred Posted: Mon Jun 11, 2007 7:46 am |
|
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 |
|
 |
Bluefin221


Joined: Sep 12, 2005 Posts: 399 Location: Centre of the Earth
|
Post subject: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Posted: Wed Jun 13, 2007 7:00 pm |
|
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 |
|
 |
ocala-kaylee


Joined: Jun 16, 2007 Posts: 5
|
Post subject: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1 Posted: Sat Jun 16, 2007 3:38 am |
|
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 |
|
 |
mactabilis


Joined: Jun 15, 2007 Posts: 38
|
Post subject: CMS coppermine warning Posted: Sat Jun 16, 2007 9:42 am |
|
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 |
|
 |
sarah


Joined: Mar 25, 2005 Posts: 2131
|
|
| Back to top |
|
 |
sarahwjfc


Joined: Jun 15, 2007 Posts: 1
|
Post subject: Re: CMS coppermine warning Posted: Sat Jun 16, 2007 10:42 am |
|
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 |
|
 |
sarah


Joined: Mar 25, 2005 Posts: 2131
|
Post subject: Re: CMS coppermine warning Posted: Sat Jun 16, 2007 10:54 am |
|
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 |
|
 |