More than 50 per page on category

Question

So I increased my limit beyond 50 on the category page but when I load it, 50 is the max. Then the paginition takes me to the number I set beyond 50 plus one. So that means that the pagination knows my new limit but the list questions does not. How do I fix this?

Comments

Can you be more specific? How did you increase it beyond 50? If you set it higher it will change to 50 because that is the max.

---

If you go straight to the database you can change the max number beyond 50. Also there is code in the admin panel php default file you can change to make the max higher. For sake of the example I set it to 200. The page still only shows 50 max. But when I hit 2 on the pagination it takes me to a second page starting with record 201. So the pagination sees the new max but the first page is still only showing 50 questions regardless. I am sure there is a way to change this but there is a ton of files to dig through to figure it out. Hoping some one knows where the magic is.

---

The max number is kept at 50 for performance as well as usability reasons. Better not to increase this.

In case you want to...
Currently you're changing the pagination size. You must also change the number of records being fetched from the db -- I guess it should be either in the page code in the lists function or in the db/selects.php

---

I know it may slow it down but that is fine by me for my purposes. I just cannot find where the fetch limit is. I am working through the code and learning hopefully I will find soon.

---

Haha after I indexed the whole thing locally and I spent an hour and a half but it is set under maxima.php under db qa_db_retrieve_qs_as . Thanks for all the responses!

---

Great you found it.

Answer 1

Yes you shouldn't manually update the database or any of the core code. The options in the maxima.php file can be overridden in your qa-config.php like this:

define('QA_DB_RETRIEVE_QS_AS', 200);

Then you can set the value up to 200 in the options, and pagination will work correctly.