×
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
- lars.butveit
- Topic Author
- Offline
Less
More
- Posts: 89
- Thank you received: 4
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.
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.
- lars.butveit
- Topic Author
- Offline
Less
More
- Posts: 89
- Thank you received: 4
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.
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.
- lars.butveit
- Topic Author
- Offline
Less
More
- Posts: 89
- Thank you received: 4
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. :-)
Case closed. :-)
Please Log in to join the conversation.
Moderators: Dirk, joest