Hi

First, well done on a great component Tom! The Bible Study component is really excellent. Thank you very much for making it available!

The issue is that the list of studies does not display on an unfiltered page *if* i am logged in. It displays fine if I am not logged in.

We have been using it successfully for a few months now. But all of sudden, and for no apparent reason, the sermon list at this page www.baycfc.org.au/index.php?option=com_b...slist&Itemid=138 does not display *when logged into the front end*. It displays perfectly when not logged in.

Interestingly, if you go to one of the other links (like Speaker: Pastor Nick) when logged in it displays fine. Indeed all the other Bible Study lists dislplay fine when logged in ... except when i show the list with no filtering applied.

I have created another menu option to check whether that was the problem but it made no difference. So it seems like something with Bible Study.

I thought it may have been a corrupted Bible Study entry. But it seems to display all entries one way or another.

I wondered whether anyone could offer some suggestions as to why this might be happening or suggest some troubleshooting tips. I am software programmer (but not in PHP) so i am happy to have a poke around.

Thanks
Andrew

Hi Andrew - glad you like the component. Honestly, I'm not sure what would do that. Could you contact me directly and give me a user/pass so I can see this happening? It would also be helpful to turn on debugging on your site temporarily, run the list logged on and off and see if the query changes "SELECT jos_bsms_studies.* ... "

Tom

Thanks for your reply Tom! I am not sure about the debug. I will check that out. Never done it before.

I have set you up an account. Will contact you directly with the details.

Thanks!
Andrew

Thanks for your other email Tom. I will come back to that.

Today i discovered that the sermons on the unfiltered page had now disappeared even when i wasnt logged in. It turns out that i can make the sermons reappear when logged in if i unpublish all bar 18-19 of them. That is, they will show if i publish the 18 most recent (but not more than 18) or 19 of the oldest (but not more). Strange.

Sadly there is no overlap there so it is not a particular study that is the problem. And i can pick a mixture of sermons across those two ranges and they display ok as long as i dont pick too many.

So it seemed like the problem is due to the total number of messages displayed. I did change the total to display to 30 in the menu setup and parameter setup. I change them back to 20 but hasnt helped. It didnt make any difference and the number of sermons displayed remained at what i set it.

Ok, i can reproduce and 'fix' the problem now. i didnt realise that Bible Study remembered the 'number of sermons to display' setting when set in the front end. If i set this to something less than 20 all is well. 20 and above seems to stop the 'Catalogued Sermons' from displaying. I suspect it will do it elsewhere if the number of sermons are too great. To see what I mean:

1. Visit this page: www.baycfc.org.au/index.php?option=com_b...slist&Itemid=150 it should display fine because it only has a few sermons.

2. Change the number to display to 10

3. Visit the 'Catalogued Sermons' page. It should display fine too.

4. Change the number to display to 20 or above. The BS content should disappear. Because it is gone there is no way to get it back until you change the number to display back again to 15 or below via one of the other pages.

I think it is now doing it whether you are logged in or not.

Does that help in troubleshooting? I am trying to get the debug thing sorted.

Thanks
Andrew

I'll take another look. Is it okay if I turn on debug briefly to troubleshoot? The setting in biblestudy on number of studies does not function. The Joomla pagination is set in the global parameters. We're working on ways around that - we are using the standard pagination model in Joomla - and it does cause some problems.

Tom

I forgot - I can't set debug on in your site due to some Forbidden error. There does seem to be something going on with pagination and the LIMIT variable. It would be great to capture that information through site debug. Can you get it to work and email me the results of the queries? I bet we get a 500 error with LIMIT set above 20. It will then tell us where in the query the problem is.

I'll also add this to the bug report on pagination (on our development site)

Tom