Textpattern CMS

#1 2011-09-23 01:56:33

lozmatic

Member

From: Melbourne, Australia

Registered: 2006-08-27

Posts: 259

Website

Issue with CloudFlare?

I’m getting something this for all my TXP installations (all hosted on MediaTemple)

Some Textpattern files have been modified:
…/textpattern/index.php ?
mysql_table_errors:
arch_textpattern: error: Table upgrade required. Please do “REPAIR TABLE `…`” or dump/reload to fix it!,
arch_txp_css: error: Table upgrade required. Please do “REPAIR TABLE `…`” or dump/reload to fix it!,
arch_txp_discuss_ipban: error: Table upgrade required. Please do “REPAIR TABLE `…`” or dump/reload to fix it!,
arch_txp_discuss_nonce: error: Table upgrade required. Please do “REPAIR TABLE `…`” or dump/reload to fix it!,
arch_txp_file: error: Table upgrade required. Please do “REPAIR TABLE `…`” or dump/reload to fix it!,
arch_txp_form: error: Table upgrade required. Please do “REPAIR TABLE `…`” or dump/reload to fix it!,
arch_txp_image: error: Table upgrade required. Please do “REPAIR TABLE `..`” or dump/reload to fix it!,
arch_txp_lang: error: Table upgrade required. Please do “REPAIR TABLE `…`” or dump/reload to fix it!,
arch_txp_link: error: Table upgrade required. Please do “REPAIR TABLE `…`” or dump/reload to fix it!,
arch_txp_log: error: Table upgrade required. Please do “REPAIR TABLE `..`” or dump/reload to fix it!,
arch_txp_page: error: Table upgrade required. Please do “REPAIR TABLE `..`” or dump/reload to fix it!,
arch_txp_plugin: error: Table upgrade required. Please do “REPAIR TABLE `…`” or dump/reload to fix it!,
arch_txp_prefs: error: Table upgrade required. Please do “REPAIR TABLE `…`” or dump/reload to fix it!,
arch_txp_section: error: Table upgrade required. Please do “REPAIR TABLE `…`” or dump/reload to fix it!,
arch_txp_users: error: Table upgrade required. Please do “REPAIR TABLE `…`” or dump/reload to fix it! ?

The only thing I can think of is that I’ve set up CloudFlare (http://www.cloudflare.com), a “service that makes any website faster, safer, and smarter” by acting as a proxy (I think). I activated this following MediaTemple’s offer to Supercharge your (mt) Website with CloudFlare

Some website that I haven’t ‘supercharged’ are also experiencing these errors, though.

Sites are working fine. In some cases Iget an error when looking at the vsiitor logs. Fore eample:

Warning: Table ‘./…/txp_log’ is marked as crashed and should be repaired delete from txp_log where time < date_sub(now(), interval 7 day) in …./textpattern/lib/txplib_db.php on line 81

Warning: Table ‘./…/txp_log’ is marked as crashed and should be repaired select count(*) from txp_log where 1 in …/textpattern/lib/txplib_db.php on line 81

Could the errors be related?

Cheers,

Lawrence

---

architxt.net

#2 2011-09-23 06:53:03

Pat64

Plugin Author

From: France

Registered: 2005-12-12

Posts: 1,634

GitHub Twitter

Re: Issue with CloudFlare?

Hi Lawrence.

I tried cloudflare last month (free plan) and I leave it now for some strange reasons.

Despite the fact that CDN servers on cloudflare seems very effective, I never noticed reporting errors as you had seen: all worked fine for me except with jQuery (all my scripts were broken) and with google font link (@fontface wasn’t rendering). I tried to purge cache several times (tab cloudflare settings -> purge cache) but without any effects.
Note that my experience isn’t relevant for you because I have a shared server (MT is too expensive for me :)

Cheers,

Last edited by Pat64 (2011-09-23 07:04:35)

---

Patrick.

Github | CodePen | Codier | Simplr theme | Wait Me: a maintenance theme | [\a mi.ni.ma]: a “Low Tech” simple Blog theme.