mysql cooked?

squaredeye · 2008-11-06 21:43:39

This is an old site I built about two years ago, now we’re seeing issues,

Here’s the errors I get upon trying to access the Textpattern directory :

Warning: Table ‘txp_lang’ is marked as crashed and should be repaired select name, data from txp_lang where lang=‘en-us’ in /home/13956/domains/btpolympia.org/html/textpattern/lib/txplib_db.php on line 81

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/13956/domains/btpolympia.org/html/textpattern/lib/txplib_misc.php on line 180

Warning: Table ‘txp_lang’ is marked as crashed and should be repaired select name, data from txp_lang where lang=‘en-gb’ in /home/13956/domains/btpolympia.org/html/textpattern/lib/txplib_db.php on line 81

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/13956/domains/btpolympia.org/html/textpattern/lib/txplib_misc.php on line 180

Warning: Cannot modify header information – headers already sent by (output started at /home/13956/domains/btpolympia.org/html/textpattern/lib/txplib_db.php:81) in /home/13956/domains/btpolympia.org/html/textpattern/include/txp_auth.php on line 194

Warning: Cannot modify header information – headers already sent by (output started at /home/13956/domains/btpolympia.org/html/textpattern/lib/txplib_db.php:81) in /home/13956/domains/btpolympia.org/html/textpattern/include/txp_auth.php on line 201

And here are the diagnostics:

Textpattern version: 4.0.6 (r2805)
Last Update: 2008-11-06 21:40:51/2008-11-06 21:26:41
Document root: /home/13956/domains/btpolympia.org/html
$path_to_site: /home/13956/domains/btpolympia.org/html
Textpattern path: /home/13956/domains/btpolympia.org/html/textpattern
Permanent link mode: section_title
Temporary directory path: /home/13956/domains/btpolympia.org/html/textpattern/tmp
Site URL: btpolympia.org
PHP version: 4.4.8
GD Image Library: bundled (2.0.28 compatible); supported formats: GIF, JPG, PNG.
Server Local Time: 2008-11-06 13:41:22
MySQL: 4.1.25-Debian_mt1
Locale: en_US.UTF-8
Server: Apache/2.0.54
PHP Server API: cgi-fcgi
RFC 2616 headers:
Server OS: Linux 2.6.20.2-1
Active plugins: pap_contact_cleaner-0.1, zem_contact_reborn-4.0.3.17, zem_contact_lang-4.0.3.03m, upm_file_packets-0.3.2, upm_img_popper-1.3.3, Postmaster-0.3, jnm_audio-0.2, upm_image-0.6, Postmaster_library-0.1

Pre-flight check:
————————————
mysql_table_errors: txp_lang: error: Size of indexfile is: 1024 Should be: 55296, txp_lang: error: Corrupt
————————————

.htaccess file contents:
————————————
#DirectoryIndex index.php index.html

#Options +FollowSymLinks
#Options -Indexes

<IfModule mod_rewrite.c> RewriteEngine On #RewriteBase /relative/web/path/

RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]

RewriteRule ^(.*) index.php

RewriteCond %{HTTP:Authorization} !^$ RewriteRule .* – [E=REMOTE_USER:%{HTTP:Authorization}]
</IfModule>

#php_value register_globals 0

————————————

graeme · 2008-11-06 22:48:53

squaredeye wrote:

This is an old site I built about two years ago, now we’re seeing issues, Here’s the errors I get upon trying to access the Textpattern directory

Matthew, as said in the diagnostics txp_lang: error: Corrupt

Might be a sign things are going to get worst so I would start by backing up the mysql data directory (look for .MYI, .MYD and .frm files) – if you have access to them. Then would try do a SQL dump of all the data through phpmyadmin – you may have to do this one table at a time.

If you’re able to export everything important to you (articles, templates, etc..) I would delete it all and start afresh and reimport the data. If not I would try to recreate the textpattern table structure starting with txp_lang and go from there.

Data recovery is never fun but shoot me an email if you need a hand.

squaredeye · 2008-11-07 21:41:42

thanks Graeme,
I’ll let you know how it goes

Textpattern CMS

Textpattern CMS support forum

#1 2008-11-06 21:43:39

mysql cooked?

#2 2008-11-06 22:48:53

Re: mysql cooked?

#3 2008-11-07 21:41:42

Re: mysql cooked?

Board footer