× If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html

Search result pagination problem

More
7 years 8 months ago - 7 years 8 months ago #3959 by lars.butveit
Search result pagination problem was created by lars.butveit
I have this problem with pagination on search result on one of my Joodb databases. Page two of certain filtered results show "No data - The result was empty" where there should have been data.

Please have a look at this database and observe that pagination is working when the results have not been filtered (using Groupselect with |1|1)
tamiyabase.com/index.php?option=com_jood...w=catalog&Itemid=775

Then add "Main category" filter as "5 digit parts":
tamiyabase.com/index.php?option=com_jood...rt_sub_cat%5D%5B%5D=
The pagination still works fine.

Then add the second Groupselect "Sup category" and choose "Body & body parts"
tamiyabase.com/index.php?option=com_jood...=Body+%26+body+parts

The pagination no longer works. Page 2 and onwards show "No data - The result was empty"
also notice the "Sub category" filter is now removed (after selecting page 2)

The same setup works fine on another database, for example this:
tamiyabase.com/index.php?option=com_jood...=false&Itemid=776&gs[model_group][0]=58000&gs[model_kittype][0]=%Assembly%20kit%&gs[model_type][0]=&gs[model_chassisref][0]=&gs[model_body][0]=&limitstart=0

Please help me with solving this problem.
Last edit: 7 years 8 months ago by lars.butveit.

Please Log in to join the conversation.

More
7 years 8 months ago #3960 by lars.butveit
Replied by lars.butveit on topic Search result pagination problem
Hang on...
I think I stumbled upon the cause of the problem:
The "no data" error only shows when I select filters where the filter (group) name includes a "&".
I assume the "&" mess up the URL or something.

I will update the database later today and remove the "&" characters and see if that solves it.

Please Log in to join the conversation.

More
7 years 8 months ago #3970 by lars.butveit
Replied by lars.butveit on topic Search result pagination problem
Yep, the "&" in the filter text was the problem.

Case closed. :-)

Please Log in to join the conversation.

Moderators: Dirkjoest