[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
NanoCaiordo
Developer


Joined: Jun 29, 2004
Posts: 3211
Location: -37.805°, 145.036°

PostPost subject: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1
Posted: Sun Jun 24, 2007 8:41 pm
Reply with quote

dragonflycms.org/Forum...tml#124359
_________________
.:: I called myself but someone else answered ::.

NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
CentOS / Apache 2.2 / MySQL 5.0 / PHP 5.1 / Bleeding Edge
Back to top
View user's profile Visit poster's website Yahoo Messenger
SwordmanJr
Newbie


Joined: Jul 31, 2007
Posts: 1

PostPost subject: Coppermine Database errors on MySQL 5.0.27
Posted: Tue Jul 31, 2007 12:13 pm
Reply with quote

Could someone tell me what this means, and how to fix it?

This is what I get when trying to create an album in a category:

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 dfy_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/tpascout/public_html/modules/coppermine/albmgr.php on line: 111


SwordmanJr's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
UNIX/apache 1.3.37/mysql 5.0.27/php 5.1.6/
Back to top
View user's profile Visit poster's website
Thraxion
Newbie


Joined: Jul 31, 2007
Posts: 19

PostPost subject: Coppermine Error
Posted: Fri Aug 03, 2007 4:28 am
Reply with quote

I am getting this error

Code:
MS 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: /home/content/t/h/r/thraxion/html/modules/coppermine/albmgr.php on line: 111

I know there is a fix for this error:
http://dragonflycms.org/Forums/viewtopic/t=19139/start=16.html

But even after installing the fix, I am still haveing the problem. I have searched and still, nothing.

Help would be greatly appreciated, thanks.


Thraxion's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
4.4
Back to top
View user's profile Visit poster's website
museo8bits
Newbie


Joined: Aug 20, 2007
Posts: 1
Location: Madrid, Spain

PostPost subject: Re: Coppermine Database errors on MySQL 5.0.27
Posted: Mon Aug 20, 2007 6:59 pm
Reply with quote

I have equal problem, but solution is simple. Edit albmgr.php and at line 106 :

REMOVED BY NANO

And all OK
Remember do make first a backup of the file.

_________________
---
Saludos
Miguel Durán
www.museo8bits.com
wiki.museo8bits.es
www.dominiopublico.org

museo8bits's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux Ubuntu 7.04/Apache 2.2.3-3.2ubuntu/MySQL 5.0.38/PHP 5.2.1/9.1.2.1
Back to top
View user's profile Visit poster's website
NanoCaiordo
Developer


Joined: Jun 29, 2004
Posts: 3211
Location: -37.805°, 145.036°

PostPost subject: Re: Coppermine Database errors on MySQL 5.0.27
Posted: Mon Aug 20, 2007 11:12 pm
Reply with quote

dragonflycms.org/Forum...tml#124359
_________________
.:: I called myself but someone else answered ::.

NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
CentOS / Apache 2.2 / MySQL 5.0 / PHP 5.1 / Bleeding Edge
Back to top
View user's profile Visit poster's website Yahoo Messenger
IS_Webbie
Newbie


Joined: Aug 17, 2007
Posts: 33
Location: Cedar Rapids, IA

PostPost subject: Re: Coppermine album error.
Posted: Thu Aug 23, 2007 9:09 pm
Reply with quote

I'd like to know what forum cuz i am an idiot and cant find it or sumthin.

IS_Webbie's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Red Hat / Apache 2.0 / MySQL 5.0 / PHP 5.0 / CPG 9.1.2.1
Back to top
View user's profile Visit poster's website AIM Address MSN Messenger Yahoo Messenger
retroactiv
Newbie


Joined: Aug 26, 2007
Posts: 3

PostPost subject: Moved: Coppermine SQL Error
Posted: Sun Aug 26, 2007 4:24 am
Reply with quote

I'm getting this error on coppermine after a user who has never uploaded a picture before uploaded a picture. I've been using coppermine for quite sometime and have never had a problem. Any ideas?


Quote:
CMS Warning line 75: On /coppermine/albmgr/cat=1.html 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: /webroot/r/e/retro004/www/modules/coppermine/albmgr.php on line: 111


retroactiv's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache 1.3/5.0.46-enterprise-gpl-log (client: 5.0.42)/4.4.7-pl0-gentoo/9.1.2.1
Back to top
View user's profile Visit poster's website
Jeruvy
Security Team


Joined: Apr 23, 2004
Posts: 1433
Location: Canada

PostPost subject: Re: Coppermine SQL Error
Posted: Mon Aug 27, 2007 4:39 pm
Reply with quote

Please use the search function, this question has already been answered and now even has it's own sticky.
_________________
J.
j e r u v y a t y a h o o d o t c o m

Need help? Look here: www.dragonflycms.org/W...d=112.html
Need to chat? Look for me on irc.freenode.net

Jeruvy's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Ubuntu7.10/Debian3.1 - 2.2.3/1.3.37 - 5.0.38/4.0.27 - 5.2.1/4.4.7 - CVS/9.1.2}
Back to top
View user's profile ICQ Number Yahoo Messenger
huynhvhai
Newbie


Joined: Nov 25, 2007
Posts: 1
Location: Da Nang

PostPost subject: Problem: Create / order my albums!
Posted: Sun Nov 25, 2007 7:04 am
Reply with quote

This warning appear when i click "Create / order my albums" - Module Photo Galery
----------------------------
includes/db/db.php

* CMS Warning line 75: On /photo/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: /home/trangchu/public_html/photo/modules/coppermine/albmgr.php on line: 111
------------------------------
Help me!



err.jpg
 Description:
Error Image
 Filesize:  161.23 KB
 Viewed:  200 Time(s)

err.jpg



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


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

PostPost subject: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1
Posted: Sun Nov 25, 2007 9:59 am
Reply with quote

The fix is in this Coppermine topic that your post has been moved to.

Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
warden
Silver Supporter


Joined: Dec 16, 2004
Posts: 192
Location: North Carolina

PostPost subject: coppermine warning (error) after install
Posted: Fri Nov 30, 2007 5:29 pm
Reply with quote

I just updated a site from 9061 to 9.1.2.1. The upgrade produces this error in coppermine. The albums that were created by the administrator admin account are fine, but on the only album created by a user, the same admin account, it shows this message when trying to edit the album.
Also, and I don't know if it is related but, the only way to view the album(s) is to have the "Show first level album thumbnails in categories" set to yes. With this set to "No", the links to the album will load the album page but there are no albums to view, only empty space. However, with this set to yes, they show normally, except the user gallery, which does not show anything.

Can anybody advise what is wrong or what needs to be corrected with this error?

Quote:
CMS Warning line 75: On /coppermine/albmgr/cat=0.html While executing query "SELECT aid, title, pos, description, thumb FROM fun_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/account-name/public_html/modules/coppermine/albmgr.php on line: 111

_________________


warden's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
layingback
500+ Posts Club


Joined: Apr 19, 2004
Posts: 666

PostPost subject: Re: coppermine warning (error) after install
Posted: Fri Nov 30, 2007 7:03 pm
Reply with quote

Try this (Sticky at top of Coppermine Forum).
_________________
Pro_News: The complete article module for Dragonfly - now available as version 3.2

layingback's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
2.4.21 - 2.6.22 / 1.3.39 - 2.2.8 / 4.4.7 - 5.2.5 / 9.1.2.1 - 9.2.1
Back to top
View user's profile Visit poster's website
magnuscanada
Newbie


Joined: Dec 03, 2007
Posts: 1
Location: Prince George BC Canada

PostPost subject: Coppermine error received after installing?
Posted: Mon Dec 03, 2007 11:51 pm
Reply with quote

Here is the error:
includes/db/db.php

* CMS Warning line 75: On /index.php?name=coppermine&file=albmgr&cat=0 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/.mimmi/joosting/magnuscanada.com/modules/coppermine/albmgr.php on line: 111


****
I'm new to dragonfly so I'm not really sure where to be posting this. I'm also impatient because I can't always figure out why something isn't working...but if someone points it out I can definitely rectify a problem if pointed in the right direction.

My php version is 5.5.2 and mysql is the latest. I didn't have any troubles with the install. I am just figuring that I missed a step? Any help would be appreciated.

Frustrated in Canada! Embarassed


magnuscanada's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
I have no idea.
Back to top
View user's profile Visit poster's website
Melinda
Forum Admin


Joined: Jul 21, 2004
Posts: 1390
Location: Eastern Time Zone

PostPost subject: Re: Gallery Issues - New user - recently installed
Posted: Tue Dec 04, 2007 12:00 am
Reply with quote

Welcome to df community

moved to help section.

Wink


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


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

PostPost subject: Re: [fixed] Error Creating/Modifying Albums with 9.1.2.1
Posted: Tue Dec 04, 2007 1:04 am
Reply with quote

Actually, despite the very un-helpful "I have no idea" server specs, a quick search reveals the answer lies in this top-listed sticky topic.

Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
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  Next
Page 6 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 can download files in this forum

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

Welcome Anonymous

Nickname
Password
(Register)

Languages [x]

Community [x]

Support for DragonflyCMS in a other languages:

Dansk
Deutsch
Eesti
Italia
Norsk

Testimonials [x]
I just did the phpNuke 7.4 to CPG-Nuke CVS conversion. Was very easy. ... Found everything I needed to help me along the way with a few searches.
The most unexpected and best thing I have found after switching was the increased speed. I used to think I needed to change hosts--since switching to CPG-Nuke all my users have commented on how much faster pages load

Whit

i was running phpnuke and have almost 30,000 members apache and sql both running at 99% usage, server crashed when 50 ppl online, Host wanted me off shared hosting as many customers complaining i was crashing a p4 3.2 with 2gig ram, i converted to cpg and now i have less than a 50% server load cpg saved me $300 USD a month offshore dedicated servers cost $$ thx guys
one decision i dont regreat is CPGNUKE

Korben
www.datastreamz.net
It's like this - I was working with Oldsmobiles when I was workin with HTML. Then I moved up to Mazda's and Audi's with PHP Nuke. But now my friends I am riding in style with Benz's and Porche's. The diffrence is that noticable immediatly. The Install is so simple once you get it and the site is so secure its like fort knox. Thank you - And you all can expect to see alot more of me around - suggesting ideas and helping where I can. Peace out all - and enjoy newbies. It's really worth it to use CPGNuke.
- Kid_Creation

One thing I've noticed about CPG-Nuke... it is fast and clean. Impressive. One of my 'customers' liked it so much she wanted everything changed to CPG-Nuke!
- valis
awebware.com

The conversion from phpNuke 7.4 to CPG-Nuke (CVS) was a piece of cake. The data conversion took about two hours. Hit a few snags--but nothing a few forum searches couldn't fix. Probably the best compliment I got from my users--"Did you change hosts?" The speed improvement over phpNuke is quite noticable. Kudos to the developement team! Thanks for helping me get away from the phpNuke tease.
- Whit
endofropegang.com

Thanks for the Great program! I never regret migrating from PhpNuke. My site is so much faster and more secure. Now I spend time managing my site instead of the site software. Keep up the good work!
- Rod
www.gentle.org

Now that we are running CPG Nuke this is the first time I've travelled without having to worry about hacking, monitoring the site daily, etc. Thanks for CPG Nuke and everyone that made it possible. We are running a consumer advocacy site at householdwatch.com and the site is very busy. CPG Nuke is doing the job and doing it well.
NukeFind

CPG is Fast, Secure & Free Since installing it's been much easier to work with as an admin. Better admin features but not as many modules that phpnuke offers. Built for speed and reliability. Admin of 3 prominent sites that combined receive 6 million hits annually. CPGnuke is hands down the best CMS out there.
- djdevon3

I just made the switch to CPG, from phpNuke.
The install was easy, simple when following well written instructions. My site has dramatically increased in speed, it really is a day and nite difference.
Thanks to everyone who is a part of the CPG-Nuke project and for offering this CMS as a great alternative to the other *Nukes.
I look forward to being a part of the community.
Kristin
"I made the switch!"

I managed to stumble onto this remake of phpnuke type CMS and have been VERY pleased ever since... I'm very glad it's the system I'm using to make a web site.
4est
Great sense of community around CPG Nuke! Thanks for your hard work Cheers!
roRisc
To the Dev team. You guys rock keep up the good work. Hopefully I'll get good enough at this quickly so that I'll be able to start posting some solutions and tips as well. Cup-A-Cino
I want to thank everyone who help me to build my cpgnuke, know the final layout look great, makes the user want to register.....thanks alot guys
TRANCEBUDHA
Hey thanks for the quick replies..hehe.. ya I am trying to check out cpg-nuke on the same server.. anyways.. www.sizzle.no-ip.com /ufo just a test site main php-nuke is www.sizzle.no-ip.com and forums www.sizzle.no-ip.com /forums It seems so far that cpg-nuke is quit a bit faster than php-nuke.. thanks again
sixpack
CPG-Nuke and its support community ROCKS!
James D Kirk
CPGNuke is making phpnuke look like hammered dog-crap so far...
Persistence
Just installed the latest version of CPG and I'm lovin' it!
square
love CPG!
Mecro
man i just took a look at the demo ADMIN and you guys truly did a remarkable job.. this blows PHPNuke away...
dirtbag
Thank You, cpgnuke. Thank You All that are behind that wonderful script.
Truden
Excellent Coppermine with safemod :) Work fine with safemod nice Job
Reha
Thank You, cpgnuke. I am amazed at what CPG Nuke has to offer...
JamesSelvage
Great site. Great software.
ShermD3
Well I got my first CPGNuke site up! (huzzah?) I must say of the 5 site I run, 4 of which are PHP-Nuke sites I'm most impressed
GeoffM
This install was SOOO smooth. Great job guys! I love it!
dcorwin
Hey CPG-Nuke Dev Team!! Wow!!!!...pretty much sums it up. I love cpgnuke and I've only had it a couple days now.
sabione
Great system you developed here. Thanks !
cwweb

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.3192 seconds with 18 DB Queries in 0.932 seconds
Memory Usage: 3.38 MB
Interactive software released under GNU GPL, Code Credits, Privacy Policy