Forums / Cotonti / Support / Pagination does not work in list

foxhound
#1 2009-06-05 02:30
I have been working on this for days, re-imported the DB 4 times now following Lombi's upgrade tutorials step by step and by importing the DB in different ways but all fails. I do not get the pagination in list to work.

Please have a look at this page:
http://www.armaholic.com/testers/armaholictest/list.php?c=addons_islands

It shows 15 lines, but the pagination says this:
Page 1/ 0 - 15 lines per page - 0 lines in this section
Not to mention this section contains 66 lines in the database (Original Seditio website).
This happens with all our list sections, nowhere does it show the correct number of pages in that section and neither does it show pagination to go to page 2, 3, 4, etc.


I have created a test site, with an empty DB, just a clean Cotonti install and there using the skin I use on the other site the pagination shows correctly:
http://www.armaholic.com/testers/cotonti/list.php?c=files2

So, what is going on? Really I have spend days and days on this but I give up. I have no clue what is causing this other than a DB error since it fails to read number of pages in my current DB but can read number of pages in a clean DB.
Any help would be very much appreciated.
<img src="http://www.armaholic.com/datas/thumbs/green-sea-battalion-uniforms-version-03-preview_4.jpg" alt="green-sea-battalion-uniforms-version-03-" />
Dayver
#2 2009-06-05 03:56

May be ...

Pavlo Tkachenko aka Dayver
pieter
#3 2009-06-05 04:01
now that you mentioned it, I have the same:
http://www.kruisstraat89.be/list.php?c=huis

Pagina 1/ 1 - 20 regels per pagina - 8 regels in deze sectie
It is showing more, but not ALL
This is also in sed-light - skin.

UPDATE

Thx DAyver, this solved the problem
... can we help you ...
This post was edited by pieter (2009-06-05 04:03, 15 years ago)
foxhound
#4 2009-06-05 04:06
:-/

That fixed all, thats just.............incredible :)
And annoying too as I spend so many days on just this.

Can you explain what this "resync" actually does? Does it resync to the TPL? Or does it have to do somethnig with the DB?
I did try to empty the cache as in other topics I saw that was a fix for other stuff, I never thought of clicking "resync".

But thanks a lot for the help, you have made me a happy man again. I was beginning to doubt myself :)
<img src="http://www.armaholic.com/datas/thumbs/green-sea-battalion-uniforms-version-03-preview_4.jpg" alt="green-sea-battalion-uniforms-version-03-" />
pieter
#5 2009-06-05 04:09
good that you were going to doubt about yourself and not about Cotonti. :-D
... can we help you ...
Kilandor
#6 2009-06-05 04:57
Resync Simply recounts the pages, and stores it in the db on the cat.

used to page counts was calculated on every page load, the new method saves alot of resources, especially if you have alot of pages.
foxhound
#7 2009-06-05 06:54
# Kilandor : Resync Simply recounts the pages, and stores it in the db on the cat.

used to page counts was calculated on every page load, the new method saves alot of resources, especially if you have alot of pages.

Ok, thanks for clearing that up. Does that mean I should "resync" the pages every now and than? Or is it only required like now for the first time using cotonti?
<img src="http://www.armaholic.com/datas/thumbs/green-sea-battalion-uniforms-version-03-preview_4.jpg" alt="green-sea-battalion-uniforms-version-03-" />
Kilandor
#8 2009-06-05 11:31
Nope you only need to resync it if the counts are incorrect (but that should never really happen)