Problems with mySQL 5.0.19

juniormint · 2006-03-25 23:08:13

I just installed Textpattern last week, and everything has been working great until yesterday when my host upgraded the mySQL server. Since the upgrade (from 4.X to 5.0.19) it’s not possible to 1) post a comment 2) change anything under “presentation” in the admin 3) change any settings in the plugin list. In FF, any of the actions mentioned just return a blank page. In Safari, I get an error message about “not able to read any data”. The funny thing is, I can write and publish a post.

Does anyone have a clue what the problem might be, and what can be done to resolve it? I’ve tried to re-install TXP, and to restore the DB with no luck.

I just switched to TXP from MT, and would like to continue to use it. Thanks in advance. Diagnostic info below:

iTextpattern version: 4.0.3 (r1188)
last_update: 2006-03-16 11:51:46/2006-03-25 22:46:50
Document root: /smi/web/juniormint.se
$path_to_site: /smi/web/juniormint.se
Textpattern path: /smi/web/juniormint.se/textpattern
Permanent link mode: section_title
Temp folder: /var/tmp
Site URL: juniormint.se
PHP version: 5.1.2
Register globals: 1
server_time: 2006-03-25 23:59:07
MySQL: 5.0.19
Locale: en_US.UTF-8
Server: Apache/2.2.0
Apache version: Apache/2.2.0
php_sapi_mode: apache2handler
os_version: FreeBSD 5.4-RELEASE-p12

.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

zem · 2006-03-25 23:29:12

You can force a table check by switching to high detail diagnostics. You don’t need to post them here, but see if it reports any errors.

Textpattern turns on all error reporting in the admin interface, so a blank page indicates there’s something fundamentally wrong. Your host might have some error logs that are relevant.

juniormint · 2006-03-26 08:32:21

Hello!

Thanks for the reply. I’ve checked diagnostics with high detail, but it doesn’t show any errors . I could post it here if it helps. Very strange. Could it be that TXP “doesn’t like” mySQL 5.x?

I will, as you suggested, talk to my host about error logs if the problem remains tomorrow.

zem · 2006-03-26 10:13:26

Could it be that TXP â€œdoesnâ€™t likeï¿½? mySQL 5.x?

Textpattern works with 5.x, but there might be some config settings that break it. I don’t know the details I’m afraid.

[edit] Probably some of these (thank Sencer).

Last edited by zem (2006-03-26 10:15:10)

juniormint · 2006-03-26 15:32:55

Ok, so I’ve talked to my host. According to them, the problem isn’t caused by the updated mySQL (no errors in the mysql log). Instead it seems to be related to the php version that was also updated (to 5.1.2). This is the information I’ve received from my host:

– When someone previews a comment (or any of the actions mentioned above), Apache dies (evil kernel: pid 17984 (httpd), uid juniormint: exited on signal 10). That explains the blank page.

In order to resolve the problem (or to understand what’s wrong), my support would like to know what “sql process” occur (sorry for my bad English) when a comment is previewed.

In another mail (got alot from them when I reported my problems), they believe the problem can be related to gzip or zend optimization. They also refers to a theory that cookies can problems in php 5.1.2.

My host has tested my site on another server to exclude problems with the current server: same problem. I’ve tried to resolve the problem by upgrading TXP to the latest branch: no luck. I will try the crockery branch later today as well (or is that a bad idea?).

Now, this is a bit over my head. Any suggestions on what to do? Is there a problem with the TXP/php 5.1.2 combination?

Elenita · 2006-03-26 16:36:11

<blockquote>I will try the crockery branch later today as well (or is that a bad idea?).</blockquote>

From the <a href=“http://textpattern.com/faq/103/how-do-i-fetch-the-current-development-version”>FAQ</a>:

<blockquote><strong>/development/crockery/</strong> â€“ this is our playground for the next major release (4.1). Anything goes here: itâ€™s experimental, unreliable, and subject to change. Do not use this for a live site, donâ€™t point it at a live database, and donâ€™t expect it to work perfectly (or at all).</blockquote>

Definitely stay with the 4.0.x branch.

Last edited by Elenita (2006-03-26 16:36:41)

Sencer · 2006-03-26 17:12:38

Iâ€™ve tried to resolve the problem by upgrading TXP to the latest branch: no luck.

Playing with Textpattern will not solve your problem. As you write:

When someone previews a comment (or any of the actions mentioned above), Apache dies (evil kernel: pid 17984 (httpd), uid juniormint: exited on signal 10).

No php-script should be able to do that, so the bug is in either apache or php (given that it’s used as a module). Textpattern has always been working fine on the php5.x branch, whether there is a special problem with new bugs in php5.1.2 – I don’t know.

juniormint · 2006-03-26 17:18:11

Sencer wrote:

No php-script should be able to do that, so the bug is in either apache or php (given that it’s used as a module). Textpattern has always been working fine on the php5.x branch, whether there is a special problem with new bugs in php5.1.2 – I don’t know.

Thanks for the information. I will tell my host that it’s not a Textpattern related problem.

Textpattern CMS

Textpattern CMS support forum

#1 2006-03-25 23:08:13

Problems with mySQL 5.0.19

#2 2006-03-25 23:29:12

Re: Problems with mySQL 5.0.19

#3 2006-03-26 08:32:21

Re: Problems with mySQL 5.0.19

#4 2006-03-26 10:13:26

Re: Problems with mySQL 5.0.19

#5 2006-03-26 15:32:55

Re: Problems with mySQL 5.0.19

#6 2006-03-26 16:36:11

Re: Problems with mySQL 5.0.19

#7 2006-03-26 17:12:38

Re: Problems with mySQL 5.0.19

#8 2006-03-26 17:18:11

Re: Problems with mySQL 5.0.19

Board footer