Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: [Solved] Pagination problem
Hey Patrick,
Did you solve this one?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: [Solved] Pagination problem
No… (see here: https://editions-du-26-octobre.com/occasions/?pg=10)
Thank you for your interest Yiannis.
Last edited by Pat64 (2020-08-22 06:38:33)
Patrick.
Github | CodePen | Codier | Simplr theme | Wait Me: a maintenance theme | [\a mi.ni.ma]: a “Low Tech” simple Blog theme.
Offline
Re: [Solved] Pagination problem
Until somebody with more knowledge comes in, could you try if this works for you?
> Edit. I wish I could read french. I love some of the titles.
Last edited by colak (2020-08-22 07:22:41)
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: [Solved] Pagination problem
I tried your solution without any good results (that’s extrainly strange)…
colak wrote #325513:
I wish I could read french. I love some of the titles.
The website owner do some french authors reprints (mainly XIX century) rares and sometimes forgotten.
Patrick.
Github | CodePen | Codier | Simplr theme | Wait Me: a maintenance theme | [\a mi.ni.ma]: a “Low Tech” simple Blog theme.
Offline
Re: [Solved] Pagination problem
A wrong number of pages generally means it is set not where you expect it: by some other <txp:article /> tag or with wrong attributes (time?). We should add a debug trace to see where the number of pages is defined.
Offline
Re: [Solved] Pagination problem
Thank you lot for your interest, Oleg (I promise you to send a contribution if you solve this behaviour).
After an upgrade to pre-4.8.3 version (following a request here on the forum: we are testers too), unfortunatly “debug” mode do not show nothing (only a blank page).
So here is the results from a local (PC MAMP serveur PHP 7.4) with the expective rendering (no problems found) :
<!-- Trace summary:
Runtime : 434,05 ms
Query time: 223,75 ms
Queries : 36
Memory (*): 5416 kB
-->
<!-- Trace log:
Time(ms) | Duration | Trace
8,81 | 8,76 | [PHP includes, stage 1]
20,64 | 11,75 | [PHP includes, stage 2]
23,80 | | [Textpattern autoload dir: 'vendors']
24,09 | | [Textpattern autoload dir: 'lib']
32,44 | 1,40 | [SQL: SELECT nonce, name, RealName, email, privs FROM txp_users WHERE name = 'admin' ]
33,85 | | [Rows: 1]
33,89 | 4,83 | [SQL: SELECT name, val FROM txp_prefs WHERE user_name IN ('','admin') ORDER BY FIELD(user_name, '','admin') ]
38,73 | | [Rows: 180]
39,63 | 23,52 | [Loading plugins]
40,06 | 3,76 | [SQL: SELECT name, version, load_order FROM txp_plugin WHERE status = 1 AND type IN (0,1,5) ORDER BY load_order ASC, name ASC ]
43,83 | | [Rows: 8]
45,03 | 18,12 | [Loading plugin: 'etc_pagination' version '0.5.0']
49,12 | 6,32 | [Load: 'vendors/Textpattern/Tag/Registry.php']
53,05 | 2,37 | [Load: 'vendors/Textpattern/Container/ReusableInterface.php']
55,44 | | [Class loaded: 'Registry']
57,48 | 2,61 | [Load: 'vendors/Txp.php']
59,56 | 0,51 | [Load: 'vendors/Textpattern/Container/FactoryInterface.php']
60,08 | | [Class loaded: 'Txp']
61,07 | 2,05 | [Load: 'vendors/Textpattern/Container/Container.php']
62,61 | 0,49 | [Load: 'vendors/Textpattern/Container/ContainerInterface.php']
63,11 | | [Class loaded: 'Container']
63,16 | 0,00 | [Callback_event: 'pretext', step='', pre='1']
63,26 | 1,10 | [SQL: SELECT * FROM txp_section WHERE 1 ]
64,37 | | [Rows: 16]
64,42 | 20,30 | [PHP includes, stage 3]
85,97 | 0,95 | [Load: 'vendors/Textpattern/Date/Timezone.php']
86,92 | | [Class loaded: 'Timezone']
87,00 | 31,97 | [Loading plugins]
87,23 | 5,20 | [Loading plugin: 'com_connect' version '4.6.0']
92,44 | 1,09 | [Loading plugin: 'ext_com_connect_verify' version '0.1']
93,53 | 8,92 | [Loading plugin: 'ied_plugin_composer' version '1.2.1']
102,47 | 1,68 | [Loading plugin: 'pap_comconnect' version '0.1.2']
104,16 | 4,14 | [Loading plugin: 'pat_speeder' version '1.1.2']
108,31 | 4,77 | [Loading plugin: 'smd_thumbnail' version '0.5.3']
113,09 | 5,87 | [Loading plugin: 'glz_custom_fields' version '2.0 beta']
118,98 | 5,32 | [Callback_event: 'pretext', step='', pre='0']
120,40 | 3,85 | [Load: 'vendors/Textpattern/Type/TypeCallable.php']
123,61 | 0,62 | [Load: 'vendors/Textpattern/Type/TypeInterface.php']
124,24 | | [Class loaded: 'TypeCallable']
124,27 | 0,01 | [Call function: 'etc_pagination_url']
124,30 | 0,00 | [Call function: 'ied_plugin_download']
125,72 | 1,84 | [Load: 'vendors/Textpattern/L10n/Lang.php']
127,55 | | [Class loaded: 'Lang']
130,51 | 3,48 | [SQL: SELECT name, data FROM txp_lang WHERE lang = 'fr' AND name != '' AND (event IN ('public','common') OR owner != '') ]
133,99 | | [Rows: 795]
135,10 | 0,01 | [Callback_event: 'pretext_end', step='', pre='0']
135,12 | 0,00 | [Callback_event: 'log_hit', step='', pre='0']
135,13 | 0,00 | [Callback_event: 'textpattern', step='', pre='0']
135,16 | 188,94 | [SQL: SELECT user_html FROM txp_page WHERE name = 'occasions' AND skin = 'v1' ]
324,10 | | [Rows: 1]
324,12 | | [Page: 'v1.occasions']
324,17 | | [true]
324,67 | 8,36 | <txp::detect_devices />
324,77 | 0,94 | [SQL: SELECT Form FROM txp_form WHERE name ='detect_devices' AND skin = 'v1' ]
325,72 | | [Rows: 1]
325,73 | | [Form: 'v1.detect_devices']
325,74 | | [Nesting forms: 'detect_devices']
325,74 | | [true]
325,77 | 7,23 | <txp:php>
333,01 | | </txp:php>
333,03 | 41,79 | <txp::doctype />
333,09 | 0,44 | [SQL: SELECT Form FROM txp_form WHERE name ='doctype' AND skin = 'v1' ]
333,54 | | [Rows: 1]
333,56 | | [Form: 'v1.doctype']
333,56 | | [Nesting forms: 'doctype']
333,57 | | [true]
334,21 | 0,80 | <txp::config />
334,25 | 0,30 | [SQL: SELECT Form FROM txp_form WHERE name ='config' AND skin = 'v1' ]
334,56 | | [Rows: 1]
334,57 | | [Form: 'v1.config']
334,57 | | [Nesting forms: 'doctype' / 'config']
334,58 | | [true]
334,78 | 0,01 | <txp:hide>
334,79 | | </txp:hide>
334,79 | 0,05 | <txp:variable name="discount" value="0.00" />
334,85 | 0,00 | <txp:hide>
334,86 | | </txp:hide>
334,86 | 0,05 | <txp:variable name="paypal_account" value="editionsdu26octobre@gmail.com" />
334,92 | 0,00 | <txp:hide>
334,92 | | </txp:hide>
334,93 | 0,02 | <txp:variable name="rss_pages" value="catalogue-general" />
334,95 | 0,00 | <txp:hide>
334,96 | | </txp:hide>
334,96 | 0,05 | <txp:variable name="pages_rejected" value="actualites,alert,cancel,conditions-generales-ventes,contact,fb-instant,mentions-legales,prochainement,recherche,retours,rss-feed,rss-sitemap,sitemap,thank-you" />
335,02 | 0,03 | <txp:pat_speeder enable="1" gzip="1" />
335,05 | 0,50 | <txp:if_variable name="device" value="mobile">
335,07 | | [false]
335,10 | 0,28 | <txp:if_article_list>
335,10 | | [true]
335,11 | 0,26 | <txp:if_section name="">
335,14 | | [false]
335,16 | 0,20 | <txp:evaluate query='substring("<txp:section title="1" />", 1, 69)' escape="trim" />
335,18 | 0,07 | [attribute 'query']
335,18 | | [true]
335,20 | 0,05 | <txp:section title="1" />
335,25 | | [/attribute]
335,36 | 0,01 | <txp:site_name />
335,38 | | </txp:if_section>
335,38 | | </txp:if_article_list>
335,38 | 0,15 | <txp:if_article_list>
335,39 | | [true]
335,40 | 0,14 | <txp:if_section name="">
335,41 | | [false]
335,42 | 0,11 | <txp:evaluate query='substring("<txp:meta_description format="" />", 1, 144)' escape="trim" />
335,45 | 0,05 | [attribute 'query']
335,45 | | [true]
335,47 | 0,02 | <txp:meta_description format="" />
335,50 | | [/attribute]
335,54 | | </txp:if_section>
335,54 | | </txp:if_article_list>
335,55 | | </txp:if_variable>
335,55 | 0,02 | <txp:if_individual_article>
335,55 | | [false]
335,57 | | </txp:if_individual_article>
335,57 | 27,33 | <txp:css format="flat.url" name="global" />
337,14 | 12,77 | [Load: 'vendors/Textpattern/Skin/Css.php']
340,38 | 7,20 | [Load: 'vendors/Textpattern/Skin/AssetBase.php']
343,13 | 3,00 | [Load: 'vendors/Textpattern/Skin/CommonBase.php']
345,56 | 0,55 | [Load: 'vendors/Textpattern/Skin/CommonInterface.php']
346,13 | | [Class loaded: 'CommonBase']
347,10 | 0,46 | [Load: 'vendors/Textpattern/Skin/AssetInterface.php']
347,57 | | [Class loaded: 'AssetBase']
349,21 | 0,68 | [Load: 'vendors/Textpattern/Skin/CssInterface.php']
349,91 | | [Class loaded: 'Css']
351,29 | 9,95 | [Load: 'vendors/Textpattern/Skin/Skin.php']
358,32 | 2,89 | [Load: 'vendors/Textpattern/Skin/SkinInterface.php']
361,24 | | [Class loaded: 'Skin']
361,29 | 1,54 | [SQL: SELECT val FROM txp_prefs WHERE name = 'skin_editing' AND (user_name = '' OR user_name = 'admin') ORDER BY user_name LIMIT 1 ]
362,85 | | [Rows: 1]
362,91 | 0,03 | <txp:site_url />
362,94 | 0,01 | <txp:site_url />
362,95 | 0,05 | <txp:if_section name="ebooks">
362,99 | | [false]
363,00 | | </txp:if_section>
363,00 | 0,03 | <txp:page_url type="images_root" />
363,04 | 0,07 | <txp:php>
363,11 | | </txp:php>
363,11 | 0,81 | <txp:css format="flat.url" name="global" />
363,17 | 0,71 | [SQL: SELECT val FROM txp_prefs WHERE name = 'skin_editing' AND (user_name = '' OR user_name = 'admin') ORDER BY user_name LIMIT 1 ]
363,89 | | [Rows: 1]
363,93 | 0,75 | <txp:css format="flat.url" name="minicart" />
364,00 | 0,65 | [SQL: SELECT val FROM txp_prefs WHERE name = 'skin_editing' AND (user_name = '' OR user_name = 'admin') ORDER BY user_name LIMIT 1 ]
364,66 | | [Rows: 1]
364,69 | 0,01 | <txp:site_url />
364,71 | 0,06 | <txp:page_url context="id, s" />
364,77 | 0,01 | <txp:site_name />
364,78 | 0,01 | <txp:site_url />
364,79 | 0,01 | <txp:site_url />
364,80 | 0,01 | <txp:site_url />
364,81 | 0,01 | <txp:site_url />
364,82 | 0,00 | <txp:site_url />
364,83 | 0,48 | <txp::above_fold />
364,86 | 0,40 | [SQL: SELECT Form FROM txp_form WHERE name ='above_fold' AND skin = 'v1' ]
365,27 | | [Rows: 1]
365,28 | | [Form: 'v1.above_fold']
365,29 | | [Nesting forms: 'doctype' / 'above_fold']
365,29 | | [true]
365,31 | 1,30 | <txp::social_metas />
365,35 | 0,30 | [SQL: SELECT Form FROM txp_form WHERE name ='social_metas' AND skin = 'v1' ]
365,65 | | [Rows: 1]
365,66 | | [Form: 'v1.social_metas']
365,67 | | [Nesting forms: 'doctype' / 'social_metas']
365,67 | | [true]
366,19 | 0,11 | <txp:if_article_list>
366,20 | | [true]
366,21 | 0,01 | <txp:site_url />
366,23 | 0,07 | <txp:if_section name="">
366,24 | | [false]
366,25 | 0,04 | <txp:section link="0" title="0" />
366,29 | | </txp:if_section>
366,30 | | </txp:if_article_list>
366,30 | 0,05 | <txp:if_article_list>
366,31 | | [true]
366,32 | 0,04 | <txp:section title="1" trim />
366,36 | | </txp:if_article_list>
366,36 | 0,06 | <txp:if_article_list>
366,36 | | [true]
366,37 | 0,05 | <txp:meta_description format="" trim escape="trim" />
366,42 | | </txp:if_article_list>
366,43 | 0,01 | <txp:if_individual_article>
366,43 | | [false]
366,44 | | </txp:if_individual_article>
366,44 | 0,06 | <txp:if_article_list>
366,45 | | [true]
366,45 | 0,01 | <txp:site_url />
366,46 | 0,04 | <txp:if_section name="">
366,47 | | [false]
366,48 | 0,02 | <txp:section link="0" title="0" />
366,50 | | </txp:if_section>
366,50 | | </txp:if_article_list>
366,51 | 0,04 | <txp:if_article_list>
366,51 | | [true]
366,52 | 0,02 | <txp:section title="1" trim />
366,54 | | </txp:if_article_list>
366,55 | 0,04 | <txp:if_article_list>
366,55 | | [true]
366,56 | 0,03 | <txp:meta_description format="" trim escape="trim" />
366,59 | | </txp:if_article_list>
366,59 | 0,01 | <txp:if_individual_article>
366,60 | | [false]
366,61 | | </txp:if_individual_article>
366,62 | 8,21 | <txp::JSON_LD />
366,65 | 0,30 | [SQL: SELECT Form FROM txp_form WHERE name ='JSON_LD' AND skin = 'v1' ]
366,95 | | [Rows: 1]
366,96 | | [Form: 'v1.JSON_LD']
366,97 | | [Nesting forms: 'doctype' / 'JSON_LD']
366,98 | | [true]
367,36 | 0,04 | <txp:site_name escape="json" />
367,41 | 0,02 | <txp:site_url escape="json" />
367,43 | 4,86 | <txp:authors name="Arnaud">
369,04 | 0,89 | [Load: 'vendors/Textpattern/Tag/Syntax/Authors.php']
369,92 | | [Class loaded: 'Authors']
369,99 | 2,27 | [SQL: SELECT user_id as id, name, RealName as realname, email, privs, last_access FROM txp_users WHERE 1 = 1 AND name IN ('Arnaud') ORDER BY name ASC ]
372,27 | | [Rows: 0]
372,29 | | </txp:authors>
372,30 | 0,05 | <txp:site_url escape="json" />
372,36 | 0,02 | <txp:site_url escape="json" />
372,39 | 0,05 | <txp:variable name="JSON_counter" value="1" />
372,45 | 2,32 | <txp:if_article_list>
372,45 | | [true]
372,47 | 2,29 | <txp:section_list include_default="1" sections="catalogue-general,occasions,prochainement,actualites,contact" break=",">
372,56 | 1,48 | [SQL: SELECT name, title, description FROM txp_section WHERE name IN ('catalogue-general','occasions','prochainement','actualites','contact','default') ORDER BY name != 'default', FIELD(name, 'catalogue-general','occasions','prochainement','actualites','contact','default') ]
374,04 | | [Rows: 6]
374,07 | | [true]
374,09 | 0,04 | <txp:variable name="JSON_counter" />
374,14 | 0,02 | <txp:variable name="JSON_counter" add />
374,17 | 0,06 | <txp:section url="1" escape="json" />
374,23 | 0,04 | <txp:section title="1" escape="json" />
374,27 | | [true]
374,28 | 0,01 | <txp:variable name="JSON_counter" />
374,29 | 0,01 | <txp:variable name="JSON_counter" add />
374,31 | 0,02 | <txp:section url="1" escape="json" />
374,34 | 0,02 | <txp:section title="1" escape="json" />
374,37 | | [true]
374,38 | 0,01 | <txp:variable name="JSON_counter" />
374,39 | 0,01 | <txp:variable name="JSON_counter" add />
374,40 | 0,03 | <txp:section url="1" escape="json" />
374,43 | 0,02 | <txp:section title="1" escape="json" />
374,46 | | [true]
374,47 | 0,01 | <txp:variable name="JSON_counter" />
374,48 | 0,01 | <txp:variable name="JSON_counter" add />
374,49 | 0,02 | <txp:section url="1" escape="json" />
374,52 | 0,02 | <txp:section title="1" escape="json" />
374,55 | | [true]
374,56 | 0,01 | <txp:variable name="JSON_counter" />
374,57 | 0,01 | <txp:variable name="JSON_counter" add />
374,58 | 0,02 | <txp:section url="1" escape="json" />
374,61 | 0,02 | <txp:section title="1" escape="json" />
374,64 | | [true]
374,64 | 0,01 | <txp:variable name="JSON_counter" />
374,66 | 0,01 | <txp:variable name="JSON_counter" add />
374,67 | 0,02 | <txp:section url="1" escape="json" />
374,70 | 0,02 | <txp:section title="1" escape="json" />
374,76 | | </txp:section_list>
374,77 | | </txp:if_article_list>
374,77 | 0,04 | <txp:if_section name="catalogue-general,ebooks">
374,80 | | [false]
374,82 | | </txp:if_section>
374,84 | 4,23 | <txp:article limit="3" stock='1'>
375,03 | | [filterAtts accepted]
375,05 | 1,60 | [SQL: SELECT COUNT(*) FROM textpattern WHERE 1 AND `Posted` <= from_unixtime(1598685912) AND (Expires IS NULL OR from_unixtime(2147483647) <= Expires) AND Section IN ('occasions') AND Status IN (4) AND (custom_6 LIKE '1') ]
376,65 | | [Rows: 1]
376,70 | 1,08 | [SQL: SELECT *, UNIX_TIMESTAMP(Posted) AS uPosted, UNIX_TIMESTAMP(Expires) AS uExpires, UNIX_TIMESTAMP(LastMod) AS uLastMod FROM textpattern WHERE 1 AND `Posted` <= from_unixtime(1598685912) AND (Expires IS NULL OR from_unixtime(2147483647) <= Expires) AND Section IN ('occasions') AND Status IN (4) AND (custom_6 LIKE '1') ORDER BY Posted DESC LIMIT 0, 3 ]
377,79 | | [Rows: 3]
377,82 | | [Article: '20']
377,86 | | [true]
377,89 | 0,11 | <txp:title trim="/(.*)(@\s?)(.*)/" replace='$1 de $3' escape="json" />
378,01 | 0,02 | <txp:if_article_image>
378,02 | | [false]
378,03 | | </txp:if_article_image>
378,03 | 0,05 | <txp:if_description>
378,04 | | [false]
378,04 | 0,03 | <txp:title trim="/(.*)(@\s?)(.*)/" replace='$1 de $3' escape="json" />
378,08 | | </txp:if_description>
378,08 | 0,02 | <txp:site_name escape="json" />
378,10 | 0,28 | <txp:if_custom_field name="prix">
378,12 | | [true]
378,13 | 0,02 | <txp:site_url escape="json" />
378,15 | 0,02 | <txp:section />
378,18 | 0,03 | <txp:page_url type="pg" escape="json" />
378,21 | 0,08 | <txp:custom_field name="prix" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1.$2' escape="json" />
378,24 | | [true]
378,29 | 0,06 | <txp:custom_field name="prix" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1,$2' escape="json" />
378,32 | | [true]
378,35 | 0,03 | <txp:custom_field name="prix" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1.$2' escape="json" />
378,36 | | [true]
378,39 | | </txp:if_custom_field>
378,41 | | [Article: '19']
378,43 | | [true]
378,44 | 0,02 | <txp:title trim="/(.*)(@\s?)(.*)/" replace='$1 de $3' escape="json" />
378,47 | 0,01 | <txp:if_article_image>
378,47 | | [false]
378,48 | | </txp:if_article_image>
378,49 | 0,04 | <txp:if_description>
378,49 | | [false]
378,50 | 0,02 | <txp:title trim="/(.*)(@\s?)(.*)/" replace='$1 de $3' escape="json" />
378,52 | | </txp:if_description>
378,53 | 0,01 | <txp:site_name escape="json" />
378,54 | 0,17 | <txp:if_custom_field name="prix">
378,55 | | [true]
378,56 | 0,01 | <txp:site_url escape="json" />
378,57 | 0,01 | <txp:section />
378,59 | 0,02 | <txp:page_url type="pg" escape="json" />
378,61 | 0,03 | <txp:custom_field name="prix" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1.$2' escape="json" />
378,62 | | [true]
378,65 | 0,03 | <txp:custom_field name="prix" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1,$2' escape="json" />
378,66 | | [true]
378,68 | 0,03 | <txp:custom_field name="prix" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1.$2' escape="json" />
378,69 | | [true]
378,72 | | </txp:if_custom_field>
378,73 | | [Article: '18']
378,75 | | [true]
378,76 | 0,02 | <txp:title trim="/(.*)(@\s?)(.*)/" replace='$1 de $3' escape="json" />
378,79 | 0,01 | <txp:if_article_image>
378,79 | | [false]
378,80 | | </txp:if_article_image>
378,80 | 0,03 | <txp:if_description>
378,81 | | [false]
378,81 | 0,02 | <txp:title trim="/(.*)(@\s?)(.*)/" replace='$1 de $3' escape="json" />
378,84 | | </txp:if_description>
378,84 | 0,01 | <txp:site_name escape="json" />
378,86 | 0,17 | <txp:if_custom_field name="prix">
378,87 | | [true]
378,87 | 0,01 | <txp:site_url escape="json" />
378,89 | 0,01 | <txp:section />
378,90 | 0,02 | <txp:page_url type="pg" escape="json" />
378,92 | 0,03 | <txp:custom_field name="prix" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1.$2' escape="json" />
378,93 | | [true]
378,96 | 0,03 | <txp:custom_field name="prix" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1,$2' escape="json" />
378,97 | | [true]
378,99 | 0,03 | <txp:custom_field name="prix" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1.$2' escape="json" />
379,00 | | [true]
379,03 | | </txp:if_custom_field>
379,06 | | </txp:article>
379,07 | 0,01 | <txp:site_name escape="json" />
379,09 | 0,01 | <txp:site_url escape="json" />
379,10 | 0,01 | <txp:site_url escape="json" />
379,11 | 0,01 | <txp:site_url />
379,13 | 1,22 | <txp::nav />
379,16 | 0,40 | [SQL: SELECT Form FROM txp_form WHERE name ='nav' AND skin = 'v1' ]
379,57 | | [Rows: 1]
379,58 | | [Form: 'v1.nav']
379,59 | | [Nesting forms: 'nav']
379,59 | | [true]
380,03 | 0,31 | <txp:if_variable name="device" value="desktop">
380,07 | | [true]
380,10 | 0,04 | <txp:if_section name="">
380,12 | | [false]
380,13 | 0,01 | <txp:site_url />
380,14 | | </txp:if_section>
380,14 | 0,01 | <txp:site_url />
380,15 | 0,02 | <txp:if_section name="catalogue-general">
380,17 | | [false]
380,17 | | </txp:if_section>
380,18 | 0,01 | <txp:site_url />
380,19 | 0,02 | <txp:if_section name="prochainement">
380,20 | | [false]
380,21 | | </txp:if_section>
380,21 | 0,01 | <txp:site_url />
380,22 | 0,01 | <txp:if_section name="ebooks">
380,23 | | [false]
380,23 | | </txp:if_section>
380,23 | 0,01 | <txp:site_url />
380,24 | 0,02 | <txp:if_section name="occasions">
380,26 | | [true]
380,26 | | </txp:if_section>
380,26 | 0,01 | <txp:site_url />
380,27 | 0,02 | <txp:if_section name="actualites">
380,29 | | [false]
380,29 | | </txp:if_section>
380,29 | 0,01 | <txp:site_url />
380,30 | 0,02 | <txp:if_section name="contact">
380,32 | | [false]
380,32 | | </txp:if_section>
380,32 | 0,01 | <txp:page_url />
380,34 | | </txp:if_variable>
380,35 | 0,56 | <txp::breadcrumb />
380,38 | 0,27 | [SQL: SELECT Form FROM txp_form WHERE name ='breadcrumb' AND skin = 'v1' ]
380,66 | | [Rows: 1]
380,67 | | [Form: 'v1.breadcrumb']
380,68 | | [Nesting forms: 'breadcrumb']
380,68 | | [true]
380,79 | 0,12 | <txp:if_section name="">
380,80 | | [false]
380,81 | 0,01 | <txp:site_url />
380,82 | 0,03 | <txp:section link="0" url="1" />
380,86 | 0,01 | <txp:if_article_list>
380,86 | | [true]
380,87 | | </txp:if_article_list>
380,87 | 0,01 | <txp:section title="1" />
380,89 | 0,01 | <txp:if_individual_article>
380,89 | | [false]
380,90 | | </txp:if_individual_article>
380,91 | | </txp:if_section>
380,91 | 0,01 | <txp:section title="1" />
380,93 | 0,53 | <txp:if_article_list>
380,93 | | [true]
380,94 | 0,52 | <txp:search_input form="search_books" match="any" section="occasions" />
380,99 | 0,23 | [SQL: SELECT Form FROM txp_form WHERE name ='search_books' AND skin = 'v1' ]
381,22 | | [Rows: 1]
381,23 | | [Form: 'v1.search_books']
381,23 | | [true]
381,37 | 0,01 | <txp:site_url />
381,39 | 0,02 | <txp:section />
381,41 | 0,01 | <txp:if_search>
381,41 | | [false]
381,42 | | </txp:if_search>
381,42 | 0,02 | <txp:if_section name="catalogue-general,ebooks">
381,44 | | [false]
381,44 | | </txp:if_section>
381,44 | 0,01 | <txp:if_search_results>
381,45 | | </txp:if_search_results>
381,46 | | </txp:if_article_list>
381,48 | 24,48 | <txp:article breakby="3" limit="3" searchall="0" sort="Posted asc">
381,59 | | [filterAtts accepted]
381,61 | 0,68 | [SQL: SELECT *, UNIX_TIMESTAMP(Posted) AS uPosted, UNIX_TIMESTAMP(Expires) AS uExpires, UNIX_TIMESTAMP(LastMod) AS uLastMod FROM textpattern WHERE 1 AND `Posted` <= from_unixtime(1598685912) AND (Expires IS NULL OR from_unixtime(2147483647) <= Expires) AND Section IN ('occasions') AND Status IN (4) ORDER BY Posted asc LIMIT 0, 3 ]
382,29 | | [Rows: 3]
382,31 | | [Article: '10']
382,33 | | [true]
382,34 | 22,07 | <txp::occasions_default />
382,37 | 0,22 | [SQL: SELECT Form FROM txp_form WHERE name ='occasions_default' AND skin = 'v1' ]
382,59 | | [Rows: 1]
382,60 | | [Form: 'v1.occasions_default']
382,61 | | [Nesting forms: 'occasions_default']
382,61 | | [true]
382,71 | 20,16 | <txp:if_article_image>
382,71 | | [true]
382,72 | 20,15 | <txp:images>
382,77 | 0,88 | [SQL: SELECT * FROM txp_image WHERE id IN (6) ORDER BY FIELD(id, 6) ]
383,66 | | [Rows: 1]
383,69 | | [true]
383,71 | 17,90 | <txp:smd_thumbnail type="occasion" display="url" id='<txp:image_info type="id" />' />
383,73 | 1,12 | [attribute 'id']
383,74 | | [true]
383,76 | 1,08 | <txp:image_info type="id" />
383,80 | 1,00 | [SQL: SELECT title FROM txp_category WHERE name = '' AND type = 'image' ]
384,80 | | [Rows: 0]
384,85 | | [/attribute]
384,87 | 0,22 | [SQL: SELECT * FROM txp_image WHERE id = 6 limit 1 ]
385,10 | | [Rows: 1]
385,12 | 0,79 | [SQL: SELECT * FROM smd_thumbnail WHERE name='occasion' ]
385,92 | | [Rows: 1]
385,94 | 0,01 | [Callback_event: 'sanitize_for_url', step='', pre='0']
401,62 | 1,17 | <txp:smd_thumbnail type="occasion">
401,70 | 0,34 | [SQL: SELECT * FROM smd_thumbnail WHERE name='occasion' ]
402,04 | | [Rows: 1]
402,06 | 0,01 | [Callback_event: 'sanitize_for_url', step='', pre='0']
402,42 | 0,01 | [Callback_event: 'sanitize_for_url', step='', pre='0']
402,72 | | [true]
402,74 | 0,05 | <txp:smd_thumbnail_info item='w' />
402,79 | | </txp:smd_thumbnail>
402,80 | 0,04 | <txp:image_info type="alt" />
402,87 | | </txp:images>
402,87 | | </txp:if_article_image>
402,87 | 0,05 | <txp:title trim="/(.*)(@\s?)(.*)/" replace='«$1» <br><em class="nwf #888-color">$3</em>' />
402,93 | 0,03 | <txp:custom_field name="etat" />
402,97 | 0,04 | <txp:custom_field name="neuf" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1,$2' />
403,01 | 0,04 | <txp:custom_field name="prix" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1,$2' />
403,06 | 0,04 | <txp:custom_field name="port" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1,$2' />
403,11 | 0,02 | <txp:if_variable name="future" value="">
403,13 | | [false]
403,13 | | </txp:if_variable>
403,14 | 1,27 | <txp::cart_occasions_form />
403,17 | 0,38 | [SQL: SELECT Form FROM txp_form WHERE name ='cart_occasions_form' AND skin = 'v1' ]
403,56 | | [Rows: 1]
403,57 | | [Form: 'v1.cart_occasions_form']
403,58 | | [Nesting forms: 'occasions_default' / 'cart_occasions_form']
403,58 | | [true]
403,74 | 0,04 | <txp:if_custom_field name="stock">
403,77 | | [false]
403,78 | | </txp:if_custom_field>
403,78 | 0,03 | <txp:title trim="/(.*)(@\s?)(.*)/" replace="$1, $3" />
403,82 | 0,45 | <txp:evaluate query='<txp:custom_field name="prix" trim="/(\d*)(\,)(\d*)/" replace=''$1.$3'' escape="float" /> + <txp:custom_field name="port" trim="/(\d*)(\,)(\d*)/" replace=''$1.$3'' escape="float" />' escape="float" />
403,93 | 0,30 | [attribute 'query']
403,93 | | [true]
404,03 | 0,13 | <txp:custom_field name="prix" trim="/(\d*)(\,)(\d*)/" replace='$1.$3' escape="float" />
404,07 | | [true]
404,16 | 0,06 | <txp:custom_field name="port" trim="/(\d*)(\,)(\d*)/" replace='$1.$3' escape="float" />
404,19 | | [true]
404,22 | | [/attribute]
404,27 | 0,01 | <txp:site_url />
404,28 | 0,01 | <txp:article_id />
404,29 | 0,01 | <txp:site_url />
404,30 | 0,07 | <txp:if_variable name="sold" value="true">
404,32 | | [false]
404,34 | 0,03 | <txp:if_custom_field name="prix">
404,35 | | [true]
404,37 | | </txp:if_custom_field>
404,38 | | </txp:if_variable>
404,38 | 0,02 | <txp:if_variable name="sold" value="true">
404,39 | | [false]
404,40 | | </txp:if_variable>
404,45 | | [Article: '14']
404,48 | | [true]
404,50 | 0,68 | <txp::occasions_default />
404,51 | | [Form: 'v1.occasions_default']
404,51 | | [Nesting forms: 'occasions_default']
404,52 | | [true]
404,53 | 0,02 | <txp:if_article_image>
404,54 | | [false]
404,55 | | </txp:if_article_image>
404,55 | 0,03 | <txp:title trim="/(.*)(@\s?)(.*)/" replace='«$1» <br><em class="nwf #888-color">$3</em>' />
404,58 | 0,02 | <txp:custom_field name="etat" />
404,61 | 0,03 | <txp:custom_field name="neuf" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1,$2' />
404,65 | 0,03 | <txp:custom_field name="prix" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1,$2' />
404,68 | 0,02 | <txp:custom_field name="port" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1,$2' />
404,71 | 0,02 | <txp:if_variable name="future" value="">
404,72 | | [false]
404,72 | | </txp:if_variable>
404,73 | 0,44 | <txp::cart_occasions_form />
404,74 | | [Form: 'v1.cart_occasions_form']
404,74 | | [Nesting forms: 'occasions_default' / 'cart_occasions_form']
404,75 | | [true]
404,80 | 0,02 | <txp:if_custom_field name="stock">
404,81 | | [false]
404,82 | | </txp:if_custom_field>
404,83 | 0,02 | <txp:title trim="/(.*)(@\s?)(.*)/" replace="$1, $3" />
404,85 | 0,18 | <txp:evaluate query='<txp:custom_field name="prix" trim="/(\d*)(\,)(\d*)/" replace=''$1.$3'' escape="float" /> + <txp:custom_field name="port" trim="/(\d*)(\,)(\d*)/" replace=''$1.$3'' escape="float" />' escape="float" />
404,86 | 0,12 | [attribute 'query']
404,86 | | [true]
404,87 | 0,06 | <txp:custom_field name="prix" trim="/(\d*)(\,)(\d*)/" replace='$1.$3' escape="float" />
404,88 | | [true]
404,93 | 0,05 | <txp:custom_field name="port" trim="/(\d*)(\,)(\d*)/" replace='$1.$3' escape="float" />
404,94 | | [true]
404,98 | | [/attribute]
405,04 | 0,01 | <txp:site_url />
405,06 | 0,01 | <txp:article_id />
405,07 | 0,01 | <txp:site_url />
405,08 | 0,07 | <txp:if_variable name="sold" value="true">
405,09 | | [false]
405,10 | 0,04 | <txp:if_custom_field name="prix">
405,12 | | [true]
405,14 | | </txp:if_custom_field>
405,14 | | </txp:if_variable>
405,15 | 0,01 | <txp:if_variable name="sold" value="true">
405,16 | | [false]
405,17 | | </txp:if_variable>
405,22 | | [Article: '15']
405,25 | | [true]
405,25 | 0,65 | <txp::occasions_default />
405,27 | | [Form: 'v1.occasions_default']
405,27 | | [Nesting forms: 'occasions_default']
405,28 | | [true]
405,29 | 0,02 | <txp:if_article_image>
405,30 | | [false]
405,31 | | </txp:if_article_image>
405,31 | 0,02 | <txp:title trim="/(.*)(@\s?)(.*)/" replace='«$1» <br><em class="nwf #888-color">$3</em>' />
405,34 | 0,02 | <txp:custom_field name="etat" />
405,37 | 0,03 | <txp:custom_field name="neuf" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1,$2' />
405,40 | 0,03 | <txp:custom_field name="prix" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1,$2' />
405,44 | 0,02 | <txp:custom_field name="port" trim="/([0-9]{1,3})(?:.?)([0-9]{1,2})*(\s*)?(\€)?/" replace='$1,$2' />
405,46 | 0,01 | <txp:if_variable name="future" value="">
405,47 | | [false]
405,48 | | </txp:if_variable>
405,48 | 0,41 | <txp::cart_occasions_form />
405,49 | | [Form: 'v1.cart_occasions_form']
405,50 | | [Nesting forms: 'occasions_default' / 'cart_occasions_form']
405,50 | | [true]
405,52 | 0,02 | <txp:if_custom_field name="stock">
405,54 | | [false]
405,55 | | </txp:if_custom_field>
405,55 | 0,03 | <txp:title trim="/(.*)(@\s?)(.*)/" replace="$1, $3" />
405,58 | 0,17 | <txp:evaluate query='<txp:custom_field name="prix" trim="/(\d*)(\,)(\d*)/" replace=''$1.$3'' escape="float" /> + <txp:custom_field name="port" trim="/(\d*)(\,)(\d*)/" replace=''$1.$3'' escape="float" />' escape="float" />
405,59 | 0,12 | [attribute 'query']
405,59 | | [true]
405,60 | 0,06 | <txp:custom_field name="prix" trim="/(\d*)(\,)(\d*)/" replace='$1.$3' escape="float" />
405,62 | | [true]
405,67 | 0,04 | <txp:custom_field name="port" trim="/(\d*)(\,)(\d*)/" replace='$1.$3' escape="float" />
405,68 | | [true]
405,71 | | [/attribute]
405,76 | 0,01 | <txp:site_url />
405,77 | 0,01 | <txp:article_id />
405,78 | 0,01 | <txp:site_url />
405,79 | 0,08 | <txp:if_variable name="sold" value="true">
405,81 | | [false]
405,82 | 0,04 | <txp:if_custom_field name="prix">
405,84 | | [true]
405,87 | | </txp:if_custom_field>
405,87 | | </txp:if_variable>
405,87 | 0,02 | <txp:if_variable name="sold" value="true">
405,89 | | [false]
405,89 | | </txp:if_variable>
405,96 | | </txp:article>
405,97 | 18,98 | <txp::paginator />
406,01 | 0,47 | [SQL: SELECT Form FROM txp_form WHERE name ='paginator' AND skin = 'v1' ]
406,48 | | [Rows: 1]
406,50 | | [Form: 'v1.paginator']
406,50 | | [Nesting forms: 'paginator']
406,51 | | [true]
406,82 | 18,13 | <txp:pages pg showalways="2" evaluate="5,2,8,4,6">
406,87 | | [true]
406,92 | 17,49 | <txp:pages>
406,98 | | [true]
406,99 | 17,40 | <txp:yield item="page" />
408,50 | 15,85 | [Load: 'vendors/Textpattern/Tag/Syntax/Partial.php']
424,35 | | [Class loaded: 'Partial']
424,42 | | </txp:pages>
424,43 | 0,08 | <txp:newer shift link="">
424,49 | | [false]
424,50 | | </txp:newer>
424,51 | 0,12 | <txp:older shift link="">
424,55 | | [true]
424,56 | 0,02 | <txp:yield item="url" />
424,58 | 0,01 | <txp:yield item="page" />
424,60 | 0,01 | <txp:yield item="page" />
424,61 | 0,01 | <txp:yield item="page" />
424,63 | | </txp:older>
424,63 | 0,06 | <txp:newer total shift="2" link="">
424,67 | | [false]
424,68 | | [false]
424,69 | | [false]
424,70 | | </txp:newer>
424,70 | 0,05 | <txp:older total shift="2" link="">
424,73 | | [false]
424,73 | | [false]
424,74 | | [false]
424,75 | | </txp:older>
424,76 | 0,04 | <txp:newer showalways link="">
424,79 | | [false]
424,80 | | </txp:newer>
424,80 | 0,04 | <txp:newer shift="-2" link="">
424,84 | | </txp:newer>
424,85 | 0,03 | <txp:older shift="-2" link="">
424,87 | | </txp:older>
424,88 | 0,06 | <txp:older showalways link="">
424,91 | | [true]
424,92 | 0,01 | <txp:yield item="url" />
424,94 | | </txp:older>
424,95 | | </txp:pages>
424,96 | 8,67 | <txp::footer />
425,00 | 0,35 | [SQL: SELECT Form FROM txp_form WHERE name ='footer' AND skin = 'v1' ]
425,35 | | [Rows: 1]
425,37 | | [Form: 'v1.footer']
425,37 | | [Nesting forms: 'footer']
425,38 | | [true]
425,68 | 0,02 | <txp:site_url />
425,70 | 0,03 | <txp:if_section name="mentions-legales">
425,72 | | [false]
425,73 | | </txp:if_section>
425,73 | 0,01 | <txp:site_url />
425,74 | 0,02 | <txp:if_section name="conditions-generales-ventes">
425,76 | | [false]
425,77 | | </txp:if_section>
425,77 | 0,01 | <txp:site_url />
425,78 | 0,02 | <txp:if_section name="retours">
425,79 | | [false]
425,80 | | </txp:if_section>
425,80 | 0,29 | <txp:if_section name="ebooks">
425,81 | | [false]
425,82 | 0,27 | <txp::paypal_logo />
425,85 | 0,20 | [SQL: SELECT Form FROM txp_form WHERE name ='paypal_logo' AND skin = 'v1' ]
426,06 | | [Rows: 1]
426,07 | | [Form: 'v1.paypal_logo']
426,07 | | [Nesting forms: 'footer' / 'paypal_logo']
426,07 | | [true]
426,09 | | </txp:if_section>
426,10 | 0,08 | <txp:php>
426,18 | | </txp:php>
426,18 | 0,01 | <txp:site_name />
426,19 | 0,07 | <txp:if_section name="catalogue-general,ebooks,occasions">
426,22 | | [true]
426,23 | 0,01 | <txp:site_url />
426,24 | 0,02 | <txp:section />
426,27 | | </txp:if_section>
426,27 | 0,34 | <txp::social_links />
426,30 | 0,27 | [SQL: SELECT Form FROM txp_form WHERE name ='social_links' AND skin = 'v1' ]
426,57 | | [Rows: 1]
426,58 | | [Form: 'v1.social_links']
426,59 | | [Nesting forms: 'footer' / 'social_links']
426,59 | | [true]
426,62 | 0,02 | <txp:page_url />
426,65 | 6,95 | <txp:output_form form="global.js" format="flat.script" async />
427,93 | 3,79 | [Load: 'vendors/Textpattern/Skin/Form.php']
429,79 | 0,50 | [Load: 'vendors/Textpattern/Skin/FormInterface.php']
431,24 | 0,46 | [Load: 'vendors/Textpattern/Container/FactorableInterface.php']
431,72 | | [Class loaded: 'Form']
431,77 | 1,11 | [SQL: SELECT val FROM txp_prefs WHERE name = 'skin_editing' AND (user_name = '' OR user_name = 'admin') ORDER BY user_name LIMIT 1 ]
432,88 | | [Rows: 1]
433,02 | 0,41 | [SQL: SELECT val FROM txp_prefs WHERE name = 'skin_editing' AND (user_name = '' OR user_name = 'admin') ORDER BY user_name LIMIT 1 ]
433,43 | | [Rows: 1]
433,60 | 0,02 | <txp:if_section name="occasions">
433,62 | | [true]
433,62 | | </txp:if_section>
433,65 | | [ ~~~ secondpass (1) ~~~ ]
433,69 | | [true]
434,00 | 0,01 | <txp:if_search_results>
434,01 | | </txp:if_search_results>
* 434,01 | | [ ~~~ secondpass (2) ~~~ ]
* 434,05 | 0,00 | [Callback_event: 'textpattern_end', step='', pre='0']
-->
<!-- Query log:
Duration | Query
1,40 | [SQL: SELECT nonce, name, RealName, email, privs FROM txp_users WHERE name = 'admin' ]
4,83 | [SQL: SELECT name, val FROM txp_prefs WHERE user_name IN ('','admin') ORDER BY FIELD(user_name, '','admin') ]
3,76 | [SQL: SELECT name, version, load_order FROM txp_plugin WHERE status = 1 AND type IN (0,1,5) ORDER BY load_order ASC, name ASC ]
1,10 | [SQL: SELECT * FROM txp_section WHERE 1 ]
3,48 | [SQL: SELECT name, data FROM txp_lang WHERE lang = 'fr' AND name != '' AND (event IN ('public','common') OR owner != '') ]
188,94 | [SQL: SELECT user_html FROM txp_page WHERE name = 'occasions' AND skin = 'v1' ]
0,94 | [SQL: SELECT Form FROM txp_form WHERE name ='detect_devices' AND skin = 'v1' ]
0,44 | [SQL: SELECT Form FROM txp_form WHERE name ='doctype' AND skin = 'v1' ]
0,30 | [SQL: SELECT Form FROM txp_form WHERE name ='config' AND skin = 'v1' ]
1,54 | [SQL: SELECT val FROM txp_prefs WHERE name = 'skin_editing' AND (user_name = '' OR user_name = 'admin') ORDER BY user_name LIMIT 1 ]
0,71 | [SQL: SELECT val FROM txp_prefs WHERE name = 'skin_editing' AND (user_name = '' OR user_name = 'admin') ORDER BY user_name LIMIT 1 ]
0,65 | [SQL: SELECT val FROM txp_prefs WHERE name = 'skin_editing' AND (user_name = '' OR user_name = 'admin') ORDER BY user_name LIMIT 1 ]
0,40 | [SQL: SELECT Form FROM txp_form WHERE name ='above_fold' AND skin = 'v1' ]
0,30 | [SQL: SELECT Form FROM txp_form WHERE name ='social_metas' AND skin = 'v1' ]
0,30 | [SQL: SELECT Form FROM txp_form WHERE name ='JSON_LD' AND skin = 'v1' ]
2,27 | [SQL: SELECT user_id as id, name, RealName as realname, email, privs, last_access FROM txp_users WHERE 1 = 1 AND name IN ('Arnaud') ORDER BY name ASC ]
1,48 | [SQL: SELECT name, title, description FROM txp_section WHERE name IN ('catalogue-general','occasions','prochainement','actualites','contact','default') ORDER BY name != 'default', FIELD(name, 'catalogue-general','occasions','prochainement','actualites','contact','default') ]
1,60 | [SQL: SELECT COUNT(*) FROM textpattern WHERE 1 AND `Posted` <= from_unixtime(1598685912) AND (Expires IS NULL OR from_unixtime(2147483647) <= Expires) AND Section IN ('occasions') AND Status IN (4) AND (custom_6 LIKE '1') ]
1,08 | [SQL: SELECT *, UNIX_TIMESTAMP(Posted) AS uPosted, UNIX_TIMESTAMP(Expires) AS uExpires, UNIX_TIMESTAMP(LastMod) AS uLastMod FROM textpattern WHERE 1 AND `Posted` <= from_unixtime(1598685912) AND (Expires IS NULL OR from_unixtime(2147483647) <= Expires) AND Section IN ('occasions') AND Status IN (4) AND (custom_6 LIKE '1') ORDER BY Posted DESC LIMIT 0, 3 ]
0,40 | [SQL: SELECT Form FROM txp_form WHERE name ='nav' AND skin = 'v1' ]
0,27 | [SQL: SELECT Form FROM txp_form WHERE name ='breadcrumb' AND skin = 'v1' ]
0,23 | [SQL: SELECT Form FROM txp_form WHERE name ='search_books' AND skin = 'v1' ]
0,68 | [SQL: SELECT *, UNIX_TIMESTAMP(Posted) AS uPosted, UNIX_TIMESTAMP(Expires) AS uExpires, UNIX_TIMESTAMP(LastMod) AS uLastMod FROM textpattern WHERE 1 AND `Posted` <= from_unixtime(1598685912) AND (Expires IS NULL OR from_unixtime(2147483647) <= Expires) AND Section IN ('occasions') AND Status IN (4) ORDER BY Posted asc LIMIT 0, 3 ]
0,22 | [SQL: SELECT Form FROM txp_form WHERE name ='occasions_default' AND skin = 'v1' ]
0,88 | [SQL: SELECT * FROM txp_image WHERE id IN (6) ORDER BY FIELD(id, 6) ]
1,00 | [SQL: SELECT title FROM txp_category WHERE name = '' AND type = 'image' ]
0,22 | [SQL: SELECT * FROM txp_image WHERE id = 6 limit 1 ]
0,79 | [SQL: SELECT * FROM smd_thumbnail WHERE name='occasion' ]
0,34 | [SQL: SELECT * FROM smd_thumbnail WHERE name='occasion' ]
0,38 | [SQL: SELECT Form FROM txp_form WHERE name ='cart_occasions_form' AND skin = 'v1' ]
0,47 | [SQL: SELECT Form FROM txp_form WHERE name ='paginator' AND skin = 'v1' ]
0,35 | [SQL: SELECT Form FROM txp_form WHERE name ='footer' AND skin = 'v1' ]
0,20 | [SQL: SELECT Form FROM txp_form WHERE name ='paypal_logo' AND skin = 'v1' ]
0,27 | [SQL: SELECT Form FROM txp_form WHERE name ='social_links' AND skin = 'v1' ]
1,11 | [SQL: SELECT val FROM txp_prefs WHERE name = 'skin_editing' AND (user_name = '' OR user_name = 'admin') ORDER BY user_name LIMIT 1 ]
0,41 | [SQL: SELECT val FROM txp_prefs WHERE name = 'skin_editing' AND (user_name = '' OR user_name = 'admin') ORDER BY user_name LIMIT 1 ]If you prefer, I can open an account for you within the real server.
Last edited by Pat64 (2020-08-22 10:42:29)
Patrick.
Github | CodePen | Codier | Simplr theme | Wait Me: a maintenance theme | [\a mi.ni.ma]: a “Low Tech” simple Blog theme.
Offline
Re: [Solved] Pagination problem
Hi Patrick,
testing betas is already a great and sufficient contribution, thanks! I have just added a debug entry to 4.8.3 branch, you can download just publish.php from there.
Seemingly, the pagination data is set by the first <txp:article limit="3" stock='1'> tag, is this what you expect?
Offline
Re: [Solved] Pagination problem
Thank you much Oleg ;)
After making lot of tests and changing things, I found the origin of the problem :D
Textpattern pre-4.8.3.
The pagination fails when the limit attribute is set to 6:
<txp:article breakby="3" limit="6" searchall="0" sort="Posted asc">
...
</txp:article>The pagination works perfectly as expected when the limit attribute is set to 3 (the same value as the breakby attribute):
<txp:article breakby="3" limit="3" searchall="0" sort="Posted asc">
...
</txp:article>Last edited by Pat64 (2020-08-22 14:12:05)
Patrick.
Github | CodePen | Codier | Simplr theme | Wait Me: a maintenance theme | [\a mi.ni.ma]: a “Low Tech” simple Blog theme.
Offline
Re: [Solved] Pagination problem
Pat64 wrote #325519:
The pagination works perfectly as expected when the
limitattribute is set to3(the same value as thebreakbyattribute):
<txp:article breakby="3" limit="3" searchall="0" sort="Posted asc">...
I don’t think it’s related, but glad you have solved it. You’d better check, however, if there is a second <txp:article /> tag on this page which had a different limit value.
Offline
Re: [Solved] Pagination problem
etc wrote #325524:
[…] You’d better check, however, if there is a second
<txp:article />tag on this page which had a differentlimitvalue.
Thank you lot. You are a Master, Oleg! The winner of the “First Place Gold Medal“🥇
(There was an another <txp:article /> tag before the main content in use for my JSON-LD scripts. This thread title changed to “Solved”)
Patrick.
Github | CodePen | Codier | Simplr theme | Wait Me: a maintenance theme | [\a mi.ni.ma]: a “Low Tech” simple Blog theme.
Offline
Re: [Solved] Pagination problem
etc wrote #325524:
You’d better check, however, if there is a second
<txp:article />tag on this page which had a differentlimitvalue.
Pat64 wrote #325536:
Thank you lot. You are a Master, Oleg! The winner of the “First Place Gold Medal“🥇
(There was an another
<txp:article />tag before the main content in use for my JSON-LD scripts. This thread title changed to “Solved”)
Thank heavens for the forum!! That I still have hair on my head is thanks to your two remarks!
I too had a snippet in my head section that grabbed the meta details from the first article in the list should there be no meta details provided in the section. It was intended as a helpful fallback but that limit="1" screwed up my pagination entirely, so it has come out.
Now it works 😅
TXP Builders – finely-crafted code, design and txp
Offline
Re: [Solved] Pagination problem
jakob wrote #332096:
Thank heavens for the forum!!
Definitely. I solved a similar problem thanks to some reply in another tread some while ago.
Textpattern forum = cure for keeping blood pressure within acceptable limits.
Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern
phiw13 on Codeberg
Offline
Re: [Solved] Pagination problem
phiw13 wrote #332105:
Textpattern forum = cure for keeping blood pressure within acceptable limits.
:-) Sometimes I find the search a bit and miss. To be fair, it may be my memory of some or other thread is a bit hit and miss, but I often wish I could narrow down my searches a bit more by including “must have” search terms or matches that don’t include some other term. Is there a trick I’m not aware of for searching more effectively?
Sometimes I often get no results, other times I get many many pages of search results that I have to trawl through before I find what I’m looking for.
TXP Builders – finely-crafted code, design and txp
Offline
Re: [Solved] Pagination problem
I totally agree, Julian & Philippe! 👌
Do not forget, the best Textpattern users are our Devs! 🙂
Patrick.
Github | CodePen | Codier | Simplr theme | Wait Me: a maintenance theme | [\a mi.ni.ma]: a “Low Tech” simple Blog theme.
Offline
Re: [Solved] Pagination problem
jakob wrote #332115:
I often wish I could narrow down my searches a bit more by including “must have” search terms or matches that don’t include some other term. Is there a trick I’m not aware of for searching more effectively?
Only to use an actual search engine rather than the rather loose search tool built into the forum.
site:forum.textpattern.com "Two textpattern instances"That way you can use negative keywords too.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Hire Txp Builders – finely-crafted code, design and Txp
Offline