PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro Bug Reports

Photopost Pro Bug Reports Post post installation PhotoPost Pro problems here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old October 1st, 2006, 09:03 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Dec 2005
Posts: 83
PP5.5 Error when View: Group By Members

Error when View: Group By Members

Errors:
An error was encountered during execution of the query:

SELECT id, bigimage, cat, storecat, height, width FROM pp_photos WHERE approved=1 AND userid=35 AND cat=all ORDER BY date DESC LIMIT 1

The query returned with an errorcode of:

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 'all ORDER BY date DESC LIMIT 1' at line 1
JoeWho is offline   Reply With Quote
Old October 1st, 2006, 09:53 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,806
Are you hitting the view all images link on index page then doing group by member?

Basically I can see that you can not group all photos by member if there is not a numeric cat to do so with. It will take a few to ponder our options here
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old October 1st, 2006, 11:43 AM   #3 (permalink)
Member
Verified Customer
 
Join Date: Dec 2005
Posts: 83
Quote:
Originally Posted by Chuck S View Post
Are you hitting the view all images link on index page then doing group by member?

Basically I can see that you can not group all photos by member if there is not a numeric cat to do so with. It will take a few to ponder our options here
Hi Chuck,

See attached photo(s):

The first one is the location that I clicked on " View: Group By Members", the second is what I get and I receive a bunch of emails reporting the error. I hope this will help in finding the problem?

PS... I can PM you with my web-address.

Thanks.
Attached Images
File Type: jpg PP5.5-1.jpg (88.5 KB, 3 views)
File Type: jpg PP5.5-2.jpg (95.9 KB, 3 views)

Last edited by JoeWho; October 1st, 2006 at 11:59 AM.
JoeWho is offline   Reply With Quote
Old October 1st, 2006, 12:35 PM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,806
Yep we know where it is happening we just need to know the best way to handle it. I can stop the error but using the all link is not compatible with group by member so we need to decide how to proceed thats it
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old October 1st, 2006, 05:34 PM   #5 (permalink)
mjm
Ultimate Member
Verified Customer
 
Join Date: May 2002
Posts: 1,066
... while your pondering this issue ...

I'd like to set the default for categories in our artists gallery as Group by Member, but would also like to give the viewer the option to view all photos by all members in a category, chronologically, as the standard default.

Group by Member ensures the individual integrity of each artist, (which is why I need to make this the default viewing), but it is more user friendly to the viewer to also have the option to view all pics by all members in a category, without having to go to each members portfolio.

For viewers who have seen all the pics in a category, then viewing by Group by Member based on latest uploads would be the standard mode of viewing.

Thanks for considering
(Note I'm using the Members Gallery setting - see all user pics)
mjm is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PP5.3: view gallery in categories not working snoopy5 Photopost Pro How Do I...? 6 June 13th, 2006 10:19 AM
PP5.1 Members Gallery Thumb DJT Photopost Pro Bug Reports 6 June 13th, 2005 10:11 AM
PP5.1: Members Gallery THumb Not PResent DJT Photopost Pro Bug Reports 7 June 11th, 2005 12:51 PM
Pp5 and vB3 Banned users still can view Geiri Photopost Pro How Do I...? 2 March 12th, 2005 05:28 PM
1 group full access, 1 group view thumbs only? how? sross Photopost Pro How Do I...? 1 February 3rd, 2005 03:03 PM


All times are GMT -5. The time now is 03:42 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0