coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 (BBS) Integration / Bridging => Topic started by: arrs on October 04, 2004, 02:08:15 PM

Title: Small problem with member galleries
Post by: arrs on October 04, 2004, 02:08:15 PM
I have just enabled member galleries and tested it which at first all seemed fine.

But then if I logout and try and access the member galleries I get

"Critical error"

"There was an error while processing a database query"

the site is www.southwest50s.co.uk (http://www.southwest50s.co.uk)
To login the gallery you have to login the message board
username: test
password: test

any ideas?

James
Title: Re: Small problem with member galleries
Post by: Nibbler on October 04, 2004, 02:41:31 PM
Enable debug mode and post the actual mysql error message.
Title: Re: Small problem with member galleries
Post by: arrs on October 04, 2004, 09:43:02 PM
 :o 2 problems in one day woohoo.

Heres the second problem. if you goto www.southwest50s.co.uk/gallery the videos bit isnt right. now whys that?

Thanks

James
Title: Re: Small problem with member galleries
Post by: arrs on October 04, 2004, 09:46:46 PM
oh yea if im logged in its fine  ???

The videos are surposed to be for the members group only. So they shouldnt be there at all for non mbrs. Thats another thing I cant find the box in the albums to set pemissions. ??? ???
Title: Re: Small problem with member galleries
Post by: Joachim Müller on October 04, 2004, 10:19:22 PM
do as suggested and post the error message, not the debug output.

Joachim
Title: Re: Small problem with member galleries
Post by: Casper on October 05, 2004, 12:13:43 AM
The gallery is probably reacting to the colour scheme.  Warning, sunglasses required.  ;D

Seriously, please do as asked, and provide the actual error message, and a description of what failed when.
Title: Re: Small problem with member galleries
Post by: Tranz on October 05, 2004, 12:17:07 AM
I second Casper's suggestion regarding the color. :)
Title: Re: Small problem with member galleries
Post by: arrs on October 05, 2004, 03:28:18 PM
Well I have been changing stuff around and the second problem has now gone.  ???

The first problem was when I enabled user galleries the public/unlogged user get this.

Critical error

There was an error while processing a database query.

While executing query "SELECT count(*) FROM sw50gallery_albums as a WHERE category = '1' and AND a.aid NOT IN (2,4,8) " on 0

mySQL error: 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 'AND a.aid NOT IN (2,4,8)' at line 1

File: /homepages/43/d94096769/htdocs/southwest50s.co.uk/gallery/include/functions.inc.php - Line: 110

Title: Re: Small problem with member galleries
Post by: arrs on October 05, 2004, 03:36:43 PM
Sorry to a pain guys but i have some other problem like if I select gallery in offline mode and click continue it doesnt go in offline mode, also the picture rotate and resize doesnt work.

If turn debug on and get the error messages will that help?

Thanks guys

James(Another dum-ass newbie)
Title: Re: Small problem with member galleries
Post by: Tranz on October 05, 2004, 03:45:12 PM
Did you log out of the gallery as admin? You need to log out to test offline mode.

One question per thread, please.

P.S. If you want people to view your site, let alone help you with it, please do not use such a bright red.  :-\\ It hurts our eyes and the first instinct is to close the window. I don't want to be mean, but that color really is difficult to look at when there's so much of it.
Title: Re: Small problem with member galleries
Post by: Nibbler on October 05, 2004, 05:22:38 PM
Upgrade to 1.3.2 might help, always a good idea to run the latest stable version.