Textpattern CMS support forum

You are not logged in. Register | Login | Help

#31 2018-11-16 13:15:13

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 8,458
Website

Re: transfer over 1600 articles

colak wrote #315312:

I had that issue with lists too!

Glad it’s not just me! If it was reproducible under controlled circumstances I’d report it as a bug. EDIT: I’ve opened a separate topic to investigate.

I have used sed_textile_upgrade and no cigar:(

Damn. It shouldn’t be hard to programmatically go through each article and run the raw body+excerpt through textile then update the row and stuff the result in the cooked columns. That’s all Steve’s plugin does, but maybe the fields are different now or something. The plugin is five years old.

is there a way to check if the structure of the sql textpattern table is OK…

Yes. You can do a repair (rss_db_admin_manager has this feature) but I doubt it’ll help. If the structure was not intact, Textpattern would fall over big time.

Last edited by Bloke (2018-11-16 13:24:33)


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#32 2018-11-16 16:20:56

jakob
Moderator
From: Germany
Registered: 2005-01-20
Posts: 3,160
Website

Re: transfer over 1600 articles

colak wrote #315312:

p68 for example has 9 articles, p 70, only two… These are just from random clicks.

Can you put on debugging and check the tag trace. If there’s a way to see what the SQL query is, that might give you a clue. If the query already has incorrect offset and limit, you don’t need to search any further in the individual articles.

Another / a further option – if you think it’s something about the article content – might be to simplify your form for the moment to just output txp:title (and also your txp:article / article_custom tag) and see if it still occurs. If not, start adding back in the parts of your form until you discover where it might be tripping up.

FWIW: p68 seems fine to me but p70, 71, 72 are all short as you say.


TXP Builders – finely-crafted code, design and txp

Offline

#33 2018-11-16 16:54:14

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 6,912
Website

Re: transfer over 1600 articles

Hi,

I have the tag trace for p72 on the pastebin.

I see some info there which does not exist, either on the article or the database.

ie Textpattern Notice: Form not found. opportunities while parsing form <strong>None</strong> on page <strong>Blog</strong>. Neither the old site nor the new one have a form called opportunities although 10 years ago i think that I was using override forms and opportunities might have been the name of an article form.


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | NeMe @ github

Offline

#34 2018-11-16 17:05:10

jakob
Moderator
From: Germany
Registered: 2005-01-20
Posts: 3,160
Website

Re: transfer over 1600 articles

colak wrote #315318:

I have the tag trace for p72 on the pastebin.

Thanks. The offset and limit of the query seems to be correct at least.

… 10 years ago i think that I was using override forms and opportunities might have been the name of an article form.

That might be a hint. Have a look at the database in phpMyAdmin or Sequel Pro or similar, and try sorting the textpattern table by the column override_form (possibly also filter by section blog if you are using override forms elsewhere). Then check if those articles with an override form are among those that are missing.
Alternatively try and locate the blog articles from the date where you think some are missing, and see if you can determine whether a missing article using override form…


TXP Builders – finely-crafted code, design and txp

Offline

#35 2018-11-16 17:24:29

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 6,912
Website

Re: transfer over 1600 articles

I deleted all 51 override form names in PhPMyAdmin but a debug view of the same page is insisting…

[SQL: SELECT Form FROM txp_form WHERE name = 'opportunities' AND skin = 'neme960' ]

I am wondering if it will make any difference if I change all 'opportunities' in the sql backup of the table to '' and then replace the table via the terminal.


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | NeMe @ github

Offline

#36 2018-11-16 17:50:08

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 6,912
Website

Re: transfer over 1600 articles

That seems to have done it!

A note for others who may face the same problem.

Changing the column content in PhpMyAdmin does not seem to be having any effect.

I actually searched and replaced all records in TextEdit, dropped the textpattern table in phpMyadmin and re-uploaded the modified one using the terminal. Random clicks now all appear to be having 10 articles.


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | NeMe @ github

Offline

#37 2018-11-16 17:58:48

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 6,912
Website

Re: transfer over 1600 articles

And hopefully a last post for this thread.

jakob wrote #315093:

Your site needs to have the sections, categories, etc. that you have in your new site, or you may need to be willing to change them.

I guess the etc did matter:)

The issue was that in the new db the override form was appearing empty and saving the article did not make any difference.

Thank you all for the very detailed advice!!!


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | NeMe @ github

Offline

#38 2018-11-16 21:36:46

jakob
Moderator
From: Germany
Registered: 2005-01-20
Posts: 3,160
Website

Re: transfer over 1600 articles

Glad you got it all working, and thanks for detailing what other facing the same issue might face.

One possible take-out: Should Textpattern behave differently when it encounters an override form that doesn’t exist? By the sounds of Yiannis’ experiences, it outputs nothing, but maybe it should output the default and throw a warning??


TXP Builders – finely-crafted code, design and txp

Offline

#39 2018-11-17 06:40:53

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 6,912
Website

Re: transfer over 1600 articles

jakob wrote #315327:

One possible take-out: Should Textpattern behave differently when it encounters an override form that doesn’t exist? By the sounds of Yiannis’ experiences, it outputs nothing, but maybe it should output the default and throw a warning??

Considering that I have re-saved those articles, the override form should have been overridden to ''. I also believe that an error should also be shown in the write tab, in the same way we have the duplicate url only title warning.


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | NeMe @ github

Offline

#40 2018-11-17 11:08:49

etc
Developer
Registered: 2010-11-11
Posts: 2,949
Website

Re: transfer over 1600 articles

colak wrote #315333:

Considering that I have re-saved those articles, the override form should have been overridden to ''.

If we do it silently, you would likely even not notice the problem. Isn’t it what debug mode is for? And I’m still for exposing the debug info to logged-in users only.

I also believe that an error should also be shown in the write tab, in the same way we have the duplicate url only title warning.

Then we should check also for missing sections, categories and so on, which would be query-expensive.


etc_[ query | search | pagination | date | tree | cache ]

Offline

Board footer

Powered by FluxBB