Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
textpattern table crash after upgrading to mysql 5.0.18
Hi,
my ISP upgraded our MySQL database to 5.0.18 from 4.xx
Browsing the site and the admin pages all work ok until I post a change to an existing article, at which point the textpattern table crashes and the admin pages become unuseable (an error about being unable to find the parse() function – sorry I didn’t grab it when it happened).
This is reproduceable every time and the only way to fix it is to restore the database from backup.
Any ideas?
Channing
Offline
#2 2006-03-11 10:39:12
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: textpattern table crash after upgrading to mysql 5.0.18
Not being able to find the parse() function could mean you’re either missing a file (/textpattern/publish.php), or perhaps you’ve got the wrong site path in your settings.
Can you post your diagnostics tab details?
Offline
Re: textpattern table crash after upgrading to mysql 5.0.18
Hi, my diagnostics are below. (The site works after restoring the db and worked ok under MySQL 4.)
Textpattern version: 4.0.3 (r1188)
last_update: 2006-01-09 20:59:54/2006-01-09 20:59:34
Document root: /home/raedan/public_html
$path_to_site: /home/raedan/public_html
Textpattern path: /home/raedan/public_html/textpattern
Permanent link mode: section_id_title
Temp folder: /tmp
Site URL: www.stateofflow.com
PHP version: 4.4.2-0.dotdeb.1
Server time: 2006-03-11 10:54:45
MySQL: 5.0.18-Debian_3.dotdeb.1-log
Locale: en_GB.UTF-8
Server: Apache
Apache version: Apache
PHP mode: apache
Operating System: Linux 2.6.8-k8-smp-64g
.htaccess file contents:
————————————
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#RewriteBase /relative/web/path/
<IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]
RewriteRule ^(.*) index.php </IfModule>php_value register_globals 0
————————————
Offline
Re: textpattern table crash after upgrading to mysql 5.0.18
hmm…my htaccess ReWriteBase option doesn’t look right..?
Offline
#5 2006-03-11 11:09:49
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: textpattern table crash after upgrading to mysql 5.0.18
RewriteBase is commented out (the #), so that’s not a problem. :)
D’you think you can intentionally cause the error again, then paste here any/all error messages you get?
It may be that something changed between 4 and 5 that’s not supported by Textpattern yet (and Alex or Sencer, etc likely know more about that than I), but that thing about not being able to find the parse() function is weird…
Offline
Re: textpattern table crash after upgrading to mysql 5.0.18
Of course now I can’t reproduce it after being able to do so several times today! I’ll post back when/if it happens again.
Channing
Last edited by channing (2006-03-11 12:10:46)
Offline