PP5.5 Error when View: Group By Members

JoeWho · October 1st, 2006, 09:03 AM

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

Chuck S · October 1st, 2006, 09:53 AM

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

JoeWho · October 1st, 2006, 11:43 AM

Quote:

Originally Posted by Chuck S

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.

Chuck S · October 1st, 2006, 12:35 PM

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

mjm · October 1st, 2006, 05:34 PM

... 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)