Problems, problems...solutions?

[Base4]

Hi,

Here's a couple for ya,



Problem 1

We have tried to customise fields for use with our gallery. We have successfully implemented this with one of our galleries but are having problems with this implementation.

We type in the extra field names in the edit category pages and this is seems all fine, however when we go to upload photos into a category that has extra fields in we just get a blank page after pressing the submit/upload page.

Why is this?

Problem 2

Ok call us daft… but we want to allow unregistered users to browse our galleries, however each time they try, they get the “sorry not authorised to view” pp error message. How can we solve this?

We have turned OFF “users need to be registered in order to view gallery” option and the category options for unregistered; these "users can view images" seems to allow access, this appears to be correct from the top of the category tree downwards.

Please can someone help us with these niggling problems, as we would be extremely grateful…

If any pp admin wish to pm for login access please feel free.

many thanks in advance,

Jon

P.s My post from last week about hiding categories has still not been solved either.

FYI
----------
pp ver 5.13
Linux shared hosting

[Chuck S]

Originally Posted by Base4

Hi,
Problem 1

We have tried to customise fields for use with our gallery. We have successfully implemented this with one of our galleries but are having problems with this implementation.

We type in the extra field names in the edit category pages and this is seems all fine, however when we go to upload photos into a category that has extra fields in we just get a blank page after pressing the submit/upload page.

Why is this?

Maybe you get a blank page by uploading a real large image? I can use extra fields so you can PM admin login with category info

Originally Posted by Base4

Problem 2

Ok call us daft… but we want to allow unregistered users to browse our galleries, however each time they try, they get the “sorry not authorised to view” pp error message. How can we solve this?

We have turned OFF “users need to be registered in order to view gallery” option and the category options for unregistered; these "users can view images" seems to allow access, this appears to be correct from the top of the category tree downwards.

In admin options if you do want unregistered users able to view images you need to set this to yes

but then I see you already solved this one as I can see that photos

http://www.base4gardening.com/galler...to.php/photo/2

[Base4]

Originally Posted by omegatron

Maybe you get a blank page by uploading a real large image? I can use extra fields so you can PM admin login with category info

No the images were only 6.7k. I have pm'd you the login details you require.

Originally Posted by omegatron

In admin options if you do want unregistered users able to view images you need to set this to yes

Sorry, I probably confused you (I did myself) the option was Admin panel --> registration options -->

Require users to be registered to view images? no/yes - We set this to NO - on base4art.com

Originally Posted by omegatron

but then I see you already solved this one as I can see that photos

http://www.base4gardening.com/galler...to.php/photo/2

He he, yes I have confused you With this site - www.base4gardening.com - we do NOT want unregistered users to be able to view images.

With this site we do want unregistered users to be able to view images - www.base4art.com.

Now you might be thinking hang on a minute there's only two possible options to this problem and your trying to solve both!! - yes we are but the installs are both different versions base4gardening (5.1) and base4art (5.13) and so seem to behaving differently - maybe we should swap the sites around!

[Chuck S]

I would simply suggest you upgrade the old site so your not running any bugs that have been fixed

[Chuck S]

You definately have some issues with the base install

You have unregistered set to view so I simple set it to no

Now as I suggested before make sure on both installs to upgrade and make sure to upload all files except the config files. Notice how regardless of whether you set style your page is no template styles. definately some weird happenings there

http://www.base4art.co.uk/gallery/

[Base4]

Hello again,

All the following issues refer to www.base4gardening.com.

Here is the latest lowdown...

Originally Posted by omegatron

I would simply suggest you upgrade the old site so your not running any bugs that have been fixed

Ok I have just upgraded the site to version 5.13.

Some problems have been fixed some have not.

Problems fixed
===========

If you are an unregistered user you can now no longer view images.

Exception when you click on members galleries link you can still see thumbnails of uploaded images next to members name - Is this supposed to happen - we would prefer if you could not see the thumbs?

Problems NOT fixed
==============

MySQL (warning) error message in "showgallery.php" when browsing as an unregistered user is shown at top of screen.


Upgrade procedure
==============

Just so you know what I did in order to upgrade I have listed my steps below.

Uploaded all (5.13) files except, Config-inc.php and Install.php to pp installation folder
Ran the upgrade script and clicked on, 5.0X upgrade
Script Upgraded database to ver. 5.10
Script then upgraded database to 5.11
All upgrades successful.


Jon

[Chuck S]

Again as I have stated in another thread you need to run any necessary upgrades. Your other install you had not ran the upgrade script which caused you issues. This is the query and you are missing something so run the query in phpmyadmin to see what your missing and then run the necessary upgrade

if ( is_numeric($cat) ) {
$query = "SELECT c.id,c.catname,c.thumbs,c.cattype,c.parent,c.theme,
c.sortorder,c.frames,c.intro,c.introtitle,c.introcopy,c.ratingtype,c.takevotes,c.ismember,n.userid
FROM {$Globals['pp_db_prefix']}categories c
LEFT JOIN {$Globals['pp_db_prefix']}notify n ON (n.userid={$User['userid']} AND n.photo=c.id AND n.type=1)
WHERE c.id=$cat";
$ctitleq = ppmysql_query($query, $link);

list( $thecatid, $thecatname, $catthumbs, $cattype, $catparent, $cattheme, $catsortorder, $frames, $hasintro, $introtitle, $introcopy, $ratingtype, $takevotes, $ismember, $notify ) = mysql_fetch_row($ctitleq);
ppmysql_free_result( $ctitleq );

[Base4]

Originally Posted by omegatron

Again as I have stated in another thread you need to run any necessary upgrades.

...but I thought I have just run the upgrades...(see last post) is there something I am missing?

The site (www.base4gardening.com) worked to some extent (not how we wanted) before I ran the upgrades now after running the upgrade script it is in the same state as (www.base4art.com)

Originally Posted by omegatron

Your other install you had not ran the upgrade script which caused you issues...

I ran the same upgrade procedure (see last post) on this www.base4art.com (2 weeks ago) as I just have on www.base4gardening.com - except base4art was upgraded in several parts i.e 5.03 --> 5.1 --> 5.11 - these were done via upgrade script using the 5.12 zipped files. So 5.12? --> 5.13 was done by just uploading the necessary (5.13 zipped) files as per michael's post for upgrading.

Originally Posted by omegatron

This is the query and you are missing something so run the query in phpmyadmin to see what your missing and then run the necessary upgrade

if ( is_numeric($cat) ) {
$query = "SELECT c.id,c.catname,c.thumbs,c.cattype,c.parent,c.theme,
c.sortorder,c.frames,c.intro,c.introtitle,c.introcopy,c.ratingtype,c.takevotes,c.ismember,n.userid
FROM {$Globals['pp_db_prefix']}categories c
LEFT JOIN {$Globals['pp_db_prefix']}notify n ON (n.userid={$User['userid']} AND n.photo=c.id AND n.type=1)
WHERE c.id=$cat";
$ctitleq = ppmysql_query($query, $link);

list( $thecatid, $thecatname, $catthumbs, $cattype, $catparent, $cattheme, $catsortorder, $frames, $hasintro, $introtitle, $introcopy, $ratingtype, $takevotes, $ismember, $notify ) = mysql_fetch_row($ctitleq);
ppmysql_free_result( $ctitleq );

I have just run your query but it seems to throw a syntax error. Possible missing curly brace? Forgive my ignorance I do not know much SQL.

Thanks

Jon

[Chuck S]

This is the query you would run in the sql box of phpmyadmin. You dont include php code. You need to replace the with the proper table prefix but this should tell you whats missing

Content visible to verified customers only.

All I know is on the other install I noticed an issue and ran the upgrade and that site was then fine. So for whichever reason your either not running all the upgrades you needed to run. Only thing I can say when your missing fields that are added when running an upgrade script.

[Base4]

Originally Posted by omegatron

This is the query you would run in the sql box of phpmyadmin. You dont include php code. You need to replace the with the proper table prefix but this should tell you whats missing

Content visible to verified customers only.

Ok thanks I tried putting in verbatim what is above and it says it has excuted successfully. Not sure what the result means though.

Originally Posted by omegatron

All I know is on the other install I noticed an issue and ran the upgrade and that site was then fine...

Base4art? - Yes I was going to ask you about that, I wondered what you had changed because now you get what seems like a cookies problem (i.e. you cant log in.). PP says login is successful - but you haven't logged in. We have had to close the gallery down, www.base4art.co.uk but pm me and I'll remove the holding page.

Thanks

Jon

[Chuck S]

Make sure you upload all the files. Replace your wowbb integration file etc

If you ran the upgrades the only thing I can suggest is to why the query fails for unregistered users is your missing this important part in the wowbb file which sets userid to 0 for unregistered users

$User['userid'] = 0;

Thats why its so important to ensure your files are right

[Base4]

Hi,

ok I will try this (uploading all the files to base4art) within the next few hours and then get back to you.



Thanks

Jon

P.s Is there anyway to backtrack from what you changed to at least get the gallery (www.base4art.co.uk/gallery/) partially operational?

[Chuck S]

What do you mean in your PS?

You need to set the necessary options you want in the admin options.

http://www.base4art.co.uk/gallery/

Surely looks operational to me and I beleive any questions regarding this gallery have been answered as you had not ran your upgrade script. Now you need to set the settings you want.

[Base4]

Originally Posted by omegatron

What do you mean in your PS?

You need to set the necessary options you want in the admin options.

http://www.base4art.co.uk/gallery/

Surely looks operational to me and I beleive any questions regarding this gallery have been answered as you had not ran your upgrade script. Now you need to set the settings you want.

No, no it is not operational - use the login authorisation I gave you and you will see you cannot login as an administrator - so there is no chance of changing any admin options. I have tried this from two different locations with no success.

Many Thanks

Jon

[Chuck S]

Did you make sure when you installed where it stated on install to set your wowbb cookie name?

If it is set check your other cookie settings as surely not set

cookie prefix should be empty

cookie domain should be .base4art.co.uk

cookie path should be /

If you correct this situation login should be recognized. If the cookies are set right then the only other thing it can be is as we have previously discussed an old wowbb.php file

[Base4]

Originally Posted by omegatron

Did you make sure when you installed where it stated on install to set your wowbb cookie name?

If it is set check your other cookie settings as surely not set

cookie prefix should be empty

cookie domain should be .base4art.co.uk

cookie path should be /

If you correct this situation login should be recognized. If the cookies are set right then the only other thing it can be is as we have previously discussed an old wowbb.php file

Ok I looked up settings in phpMyAdmin and cookie name was not set - you were right - and now its working, thanks.

However, there is some loss of stylesheet formatting, BUT putting that aside I am sorry to say the original problem is still there - i.e. unregistered users cannot see public galleries - even though all settings seem to be in their favour AND extra fields don't work because you cannot upload AND we are still getting the MySQL warning error message.

Thanks

Jon

[Chuck S]

You have members portfolio set for unregistered not to view images in that category. If you want them to then you need to change this in category permissions

Your style is set when I login.

PM me your ftp access so I can see whats wrong with your files. You continue to get a showgallery error even when you say files are all new