Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: transfer over 1600 articles
colak wrote #315216:
It seems that there are no duplicate urls in the old db any more and I think that I changed all urls which also exist in the new site. I also normalised the cf order/titles and moved all entries using adi_matrix. Donkey work is over!
Excellent. It looks like I’ll have to try adi_matrix sometime. That’s one I don’t know. Might there still be a possibility that you have duplicate urls once you merge the databases. I guess you’ll know if that is a likely proposition.
I tried to use Sequel Pro (which I had installed in my computer for use in KG) but I can not make it to connect to Webfaction. :(
You need to use your SSH connection details to access mySQL remotely with webfaction. The MySQL host and SSH host is your server number, e.g. web###.webfaction.com.
My next step, on Thursday, will be to add 2000 to a copy of the new db, and change the few ids I have in the page templates for some static pages.
I much prefer doing that offline where it’s easier to remedy mistakes and make db copies at each step so it’s easy to go back a step if you make a mistake. One innopportune search and replace can be a headache to revert; it’s much easier to simply reload the step before and try again.
TXP Builders – finely-crafted code, design and txp
Offline
Re: transfer over 1600 articles
colak wrote #315216:
It seems that there are no duplicate urls in the old db any more
Sorry, Yiannis, I am not sure not is working well in <txp:if_different /> (kinda special case). Check with
<txp:article_custom section="news" limit="99999" sort="article_url_title" break="br">
<txp:if_different>
<!-- <txp:article_url_title /> -->
<txp:else />
<txp:article_id />: <txp:article_url_title />
</txp:if_different>
</txp:article_custom>Offline
Re: transfer over 1600 articles
Hi
Have you considered using jmd_csv plugin for your task ?
Cheers.
Offline
Re: transfer over 1600 articles
Hi Dragondz,
the truth is that I did not. I have now merged the 2 dbs but I am still working on the images and the layout as the old db was on a non adaptive site. I hope to finish by the end of the week.
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: transfer over 1600 articles
I have now merged the 2 dbs
Well done!
TXP Builders – finely-crafted code, design and txp
Offline
Re: transfer over 1600 articles
and it is online:)
I still need to do a lot of work though:(
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: transfer over 1600 articles
TXP Builders – finely-crafted code, design and txp
Offline
Re: transfer over 1600 articles
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: transfer over 1600 articles
A new problem appeared with some phantom img tag appearing in a short-tag preventing validations from all pages which include a vimeo cookie.
“Sample page”
That empty img tag should not be there!
Got it!
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: transfer over 1600 articles
The rubber duck strikes again!
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: transfer over 1600 articles
There seems to be a problem.
In the article_list of the blog section. All articles are listed just fine (10/page) up to p56 but from p57 onwards the number of articles appearing seems to be random
for example
p57 shows 7 articles
p60 just 1
p63 shows 3 articles
I have no idea why this is happening unless I made a mistake when I was merging the dbs.
As a second point, according to the count using <txp:article_custom section="blog" pageby="1" pgonly /> the blog section in theory has 1662 articles so the 167 pages is correct.
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: transfer over 1600 articles
Please humour me a moment. If you know of an article that you expect to show up on those pages with missing entries, find it in the admin side, open it in the Write panel and just save it. Does it then appear in the list on the site?
If so, it’s a random textile encoding issue that we see from time to time. Never got to the bottom of it.
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
Re: transfer over 1600 articles
Bloke wrote #315288:
Please humour me a moment. If you know of an article that you expect to show up on those pages with missing entries, find it in the admin side, open it in the Write panel and just save it. Does it then appear in the list on the site?
If so, it’s a random textile encoding issue that we see from time to time. Never got to the bottom of it.
Good catch Stef! Indeed it does… So I’ll have to re-save over 1000 articles again? Or is there a way to do this automatically?
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: transfer over 1600 articles
colak wrote #315289:
So I’ll have to re-save over 1000 articles again? Or is there a way to do this automatically?
Ouch, 1000 articles is going to hurt. You could try sed_textile_upgrade after backing up. I’ve had mixed results. Sometimes it works a treat and other times it doesn’t. You might be lucky: it trawls through your database and fakes a “save” on all articles.
There might be a better way to do it.
I really wish I understood why this happens. But then I also wish I understood why Textile sometimes screws up simple lists and renders things like:
1. item 1
2. item 2
# item 3
4. item 4
...Deleting the ‘#’ marks and newlines surrounding the broken entry, then typing them in again and saving the article fixes it. Merely saving again doesn’t. Does the same with asterisk lists sometimes too… but not all the time. Does it in articles and on the forum here for me occasionally. Totally weird.
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
Re: transfer over 1600 articles
I had that issue with lists too! I always thought that it was a problem with my server.
I have used sed_textile_upgrade and no cigar:( I have also saved 1000+ articles again… Some of the pages with problems are OK now but there still seem to be a lot which are not appearing in the list view
p68 for example has 9 articles, p 70, only two… These are just from random clicks.
I used to use a lot of html in my posts in the early days, and I am not sure if that is part of the issue.
I’ll have to do some digging in, and report back.
Meanwhile, is there a way to check if the structure of the sql textpattern table is OK, or would it just not work if there was a problem there?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline