search

bishop335 / subtext

Automatically exported from code.google.com/p/subtext
0 stars 0 forks source link

Category archive are all empty #221

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Seems like all the archive pages for a category are empty
http://haacked.com/category/42.aspx
http://haacked.com/category/49.aspx
http://codeclimber.net.nz/category/1.aspx

Original issue reported on code.google.com by simone.chiaretta on 7 Jun 2010 at 8:38

GoogleCodeExporter commented 8 years ago 
Just debugged locally on a new database and with a standard skin, and posts per 
category are working fine.
Cannot get the db from my server now, I'll have to debug on it later.
Going in the admin the list of posts per category works fine online.

Original comment by simone.chiaretta on 8 Jun 2010 at 10:09

GoogleCodeExporter commented 8 years ago 
the SP that retrieves the posts changed from
SET ROWCOUNT 0
to
SELECT TOP 0

ROWCOUNT 0 means ALL
TOP 0 means 0
that's why it didn't work

Original comment by simone.chiaretta on 8 Jun 2010 at 9:19

GoogleCodeExporter commented 8 years ago 
Fixed in r4062

Original comment by simone.chiaretta on 8 Jun 2010 at 9:21