Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#13 2005-08-19 23:30:40
- TheUsability
- Member
- Registered: 2005-05-03
- Posts: 51
Re: Getting Pagination to work with Offsets
nope, I’m hardcore and using mysql command line without phpmyadmin ;)
what needs to be changed is a certain override type to non override.
Offline
#14 2005-08-20 00:04:05
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Getting Pagination to work with Offsets
Only a certain type or just tell all not to use one? If only a certain form name, tell me the name(s) and replacement(s) you need.
If you just want all set to none, then it’d be:
<pre><code>UPDATE `textpattern` SET `override_form` = ‘’;</code></pre>
(Don’t forget to add a prefix to the tablename if you used one.)
Offline
#15 2005-08-20 01:17:00
- TheUsability
- Member
- Registered: 2005-05-03
- Posts: 51
Re: Getting Pagination to work with Offsets
Well, that was easy :-) Thanks, mate!
Is there an overview of SQL commands / columns one can change within TXP this way?
Offline
#16 2005-08-20 02:18:24
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Getting Pagination to work with Offsets
No formal list, if that’s what you mean. I use the setup sql file (txpsql.php) for reference.
Offline
Re: Getting Pagination to work with Offsets
you could just use the plugin zem_nth to output a form every nth step of a certain number of times that the article form is called.
Offline
#18 2005-08-20 03:54:49
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Getting Pagination to work with Offsets
Care to share an example?
Offline
#19 2005-08-20 12:10:08
- TheUsability
- Member
- Registered: 2005-05-03
- Posts: 51
Re: Getting Pagination to work with Offsets
I know this is the wrong post, but Mary, have you checked out my diag here:
http://forum.textpattern.com/viewtopic.php?id=10476
My “other” last problem ;)
Offline
#20 2005-10-17 03:09:36
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: Getting Pagination to work with Offsets
Is there a problem with the way Textpattern handles offsets and pagination, or is this a square peg round hole thing?
Unless there’s a bug, offset/limit/pg should all work together, even when there are multiple article tags on the page. <txp:article offset=2 limit=5 /> should show articles 3-7 when pg=1, 8-12 when pg=2, etc.
(I know this is an old thread, I’ve been meaning to follow it up to see if there’s something that needs fixing)
[edit]
Oh, I geddit. Each article tag pages individually, rather than the whole list (of three article tags) paging as a set of 10.
Last edited by zem (2005-10-17 03:17:21)
Alex
Offline