The story began a few weeks ago while I was in koh-samui. My host of choice had a SAN failure and ended up having 4 days of downtime. Unacceptable under any circumstances, so I've started looking at other hosts. I setup a test site on godaddy for one of my clients, but as GoDaddy was also the DNS server, they moved the site as soon as it was setup leaving me with a choice of fixing the DNS back to the existing host, or moving the site in a hurry to godaddy. As my customer wasn't paying for hosting I decided to most the hosting to GoDaddy. Bad move.

The reliability on GoDaddy was perfect, the speed even wasn't bad (not as fast as my locally hosted box, as you'd expect, but not bad).  The issue came because my client was complaining that every facebook share, sometimes the descriptions wouldn't appear in the shared post, and almost always the image was missing.

I went through everything a few times and discovered that if I shrank the featured thumbnail presented to facebook to 100x100, the chance of it appearing increased to about 50%, but was still unacceptable. The links were fine, and my browser was able to see the image_src and pick the image up.

I finally gave up and moved the site back to the old host and immediately it started working correctly. Strange. Lesson learnt - cheap hosting just isn't worth it.

SELECT
wpp.post_title,
wpp.guid,
wpp.post_date,
CONCAT(wpo_su.option_value,
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(wpo.option_value,'%year%',date_format(wpp.post_date,'%Y'))
,'%monthnum%',date_format(wpp.post_date,'%m'))
,'%day%',date_format(wpp.post_date,'%d'))
,'%postname%',wpp.post_name )
,'%category%',wpc.slug )
) as permalink
FROM
wp_posts wpp
INNER JOIN wp_options wpo on wpo.option_name='permalink_structure' and wpo.blog_id=0
INNER JOIN wp_options wpo_su on wpo_su.option_name='siteurl' and wpo_su.blog_id=wpo.blog_id
INNER JOIN (
select wtr.object_id ID, max(wpt.slug) slug
from wp_term_relationships wtr
inner join wp_term_taxonomy wtt on wtt.term_taxonomy_id=wtr.term_taxonomy_id and wtt.taxonomy='category'
inner join wp_terms wpt on wpt.term_id=wtt.term_id
group by  wtr.object_id
) wpc on wpc.ID=wpp.ID
WHERE wpp.post_type = 'post' AND wpp.post_status = 'publish'
ORDER BY
wpp.post_date DESC

update 9/2 - appended %category% join and replace

[facebook_ilike]

Get in contact with me !

[facebook_ilike]

Name:
Email:
Phone:
Message:	Questions? Comments? Enter them here (no HTML please)...
	I can't read the text, please reset it.
	Powered by Quick Contact