Moved domains, articles are there - but don't show

babyben · 2007-08-06 20:35:22

Hiya,

Got a strange problem.. I was working a textpattern site locally on my XP machine and I’ve transferred to my Linux hosting and all seems well except no articles display. They are still listed in my CP and can be edited etc etc, but only when I post a brand-new article does it show on the website.

I moved my installation by taking a SQL dump, putting the original copy (also tried a fresh copy) of the files onto the server, then importing the SQL dump into the new DB, and correcting the config.php file and the site preference locations.

Any ideas?

Edit: Had a look around and wondered if it could be “a bug in MySQL that causes auto_increment fields to be lost when migrating data to a new server or restoring a backup.” From: http://forum.textpattern.com/viewtopic.php?id=17614

I don’t really know much about databases, can anyone help how I found try and sort this problem?

Last edited by babyben (2007-08-06 21:17:30)

Mary · 2007-08-07 05:54:04

If you can edit the articles just fine, then you’re not missing the auto_increment value (that is, the article ID# is not missing).

Almost always, start with a tag trace.

babyben · 2007-08-07 11:33:30

This from my front-page.. (I’ve snipped out my IP address)

<!-- Runtime:    0.1272 -->
<!-- Query time: 0.123012 -->
<!-- Queries: 11 -->
<!-- Memory: 2051Kb, <txp:body /> -->
<!-- txp tag trace: 
[SQL (0.003694): select name from txp_lang where lang='en-gb' limit 1]
[SQL (0.086956): select name, data from txp_lang where lang='en-gb' AND ( event='public' OR event='common')]
[SQL (0.002278): select name, code, version from txp_plugin where status = 1]
[SQL (0.009213): select * from txp_section where name = 'default' limit 1]
[SQL (0.004251): select host from txp_log where ip='*[snip]*' limit 1]
[SQL (0.004876): insert into txp_log set `time`=now(),page='/',ip='*[snip]*',host='*[snip]*',refer='',status='200',method='GET']
[SQL (0.005461): select user_html from txp_page where name='home']
[Page: home]
<txp:page_title/>
<txp:css format="link" />
<txp:if_article_list>
	[<txp:if_article_list>: true]
	<txp:article status="sticky" limit=1 />
		[SQL (0.000474): select name from txp_section where on_frontpage != '1']
		[SQL (0.003787): select *, unix_timestamp(Posted) as uPosted from textpattern where 1 and Status = 5 and Posted <= now() and Section != 'about' and Section != 'courses' and Section != 'classic' and Section != 'guided' and Section != 'self-guides' and Section != 'custom' order by Posted desc limit 0, 1]
		[article 4]
		[SQL (0.000843): select Form from txp_form where name='default']
		[Form: default]
		<txp:title/>
		<txp:body/>
</txp:if_article_list>
[ ~~~ secondpass ~~~ ]
 -->

Internal Page:

<!-- Runtime:    0.4534 -->
<!-- Query time: 0.448624 -->
<!-- Queries: 13 -->
<!-- Memory: 2054Kb, <txp:body /> -->
<!-- txp tag trace: 
[SQL (0.009175): select name from txp_lang where lang='en-gb' limit 1]
[SQL (0.092312): select name, data from txp_lang where lang='en-gb' AND ( event='public' OR event='common')]
[SQL (0.003064): select name, code, version from txp_plugin where status = 1]
[SQL (0.003866): select name from txp_section where `name` like 'about' limit 1]
[SQL (0.012451): select * from txp_section where name = 'about' limit 1]
[SQL (0.020737): select host from txp_log where ip='*[snip]* limit 1]
[SQL (0.086938): insert into txp_log set `time`=now(),page='/about',ip='*[snip]*',host='*[snip]*',refer='',status='200',method='GET']
[SQL (0.068303): select user_html from txp_page where name='default']
[Page: default]
<txp:page_title/>
	[SQL (0.011578): select title from txp_section where name='about']
<txp:css format="link" />
<txp:if_article_list>
	[<txp:if_article_list>: true]
	<txp:article status="sticky" limit=1 />
		[SQL (0.049386): select *, unix_timestamp(Posted) as uPosted from textpattern where 1 and Status = 5 and Posted <= now() and Section = 'about' order by Posted desc limit 0, 1]
		[article 2]
		[SQL (0.061184): select Form from txp_form where name='default']
		[Form: default]
		<txp:title/>
		<txp:body/>
</txp:if_article_list>
<txp:recent_articles break="li" label="" section="about" sort="Title asc"  />
	[SQL (0.005049): select *, id as thisid, unix_timestamp(Posted) as posted from textpattern where Status = 4  and Section = 'about'  and Posted <= now() order by Title asc limit 0,10]
[ ~~~ secondpass ~~~ ]
 -->

Last edited by babyben (2007-08-07 11:34:05)

ruud · 2007-08-07 12:12:02

Does perhaps the newly added article have a status “sticky”, while the older articles all have the status “live”?

babyben · 2007-08-07 18:05:50

ruud wrote:

Does perhaps the newly added article have a status “sticky”, while the older articles all have the status “live”?

Neither sticky or live ‘pre-move’ articles show – when I write an article after the move they display without a problem. It’s very strange.

ruud · 2007-08-07 18:55:44

<txp:article status="sticky" limit=1 /> will only show one sticky article… and looking at the tag trace, that happens.

If you compare a tag trace from your local textpattern install with that on the live server, do you see any differences?

babyben · 2007-08-07 22:45:03

I’ll do a tag trace from the local install next time I’m there – It does look like the sticky article is posted (but it simply doesn’t appear!)

Textpattern CMS

Textpattern CMS support forum

#1 2007-08-06 20:35:22

Moved domains, articles are there - but don't show

#2 2007-08-07 05:54:04

Re: Moved domains, articles are there - but don't show

#3 2007-08-07 11:33:30

Re: Moved domains, articles are there - but don't show

#4 2007-08-07 12:12:02

Re: Moved domains, articles are there - but don't show

#5 2007-08-07 18:05:50

Re: Moved domains, articles are there - but don't show

#6 2007-08-07 18:55:44

Re: Moved domains, articles are there - but don't show

#7 2007-08-07 22:45:03

Re: Moved domains, articles are there - but don't show

Board footer