Login empty 'index.php', Apache2 process goes wild

desmidus · 2006-02-19 18:47:19

I’ve tried running textpattern 4 after being a longtime user of previous versions, and I’m running into what seems to be a pretty rare problem. I have Apache2 2.0.55, php4.4, and mysql5 all installed and running fine.

After installation, which goes smoothly, I get stuck at the login screen where inputting the right password gets me 15-20 seconds of ‘loading’ and then returns nothing, or an empty index.php which firefox wants to download via the download manager, depending on the browser. Inputting the wrong user/pass gets me a wrong user/pass response, so it’s obviously checking against the db. Running ‘top’ while attempting to login I notice that the apache2 process goes wild and bumps itself up to 97% CPU use, and stays there until I close the page.

I’ve tried the stable and development versions of txp and I get the same thing.

Any ideas?

zem · 2006-02-19 22:34:49

Any hints in the logs?

desmidus · 2006-02-19 23:27:30

I decided to upgrade to php5 and see if that made any difference. Now instead of just nothing happening it works for 30 seconds and then spits out:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 100 bytes) in /var/www/kubicki.org-stefan/textpattern/lib/txplib_db.php on line 159

Which is sort of what I figured was going on. I checked the mysql logs and what’s happening on login is:

* * * *

at 2273689
15:24:11 server id 1 end_log_pos 2273859 Query thread_id=633 exec_time=0 error_code=0
SET TIMESTAMP=1140380651;
update `txp_category` set lft=28254, rgt=28255 where name=‘hope-for-the-future’ and type=‘article’;
at 2273859
15:24:11 server id 1 end_log_pos 2274026 Query thread_id=633 exec_time=0 error_code=0
SET TIMESTAMP=1140380651;
update `txp_category` set lft=28256, rgt=28257 where name=‘meaningful-labor’ and type=‘article’;
at 2274026
15:24:11 server id 1 end_log_pos 2274197 Query thread_id=633 exec_time=0 error_code=0
SET TIMESTAMP=1140380651;
update `txp_category` set lft=28258, rgt=28259 where name=‘reciprocal-affection’ and type=‘article’;

* * * *

It just keeps looping that over and over.

Last edited by desmidus (2006-02-19 23:28:23)

zem · 2006-02-20 00:54:21

Looks like you have some kind of inconsistency or corruption in your txp_category table. Take a look with phpMyAdmin.

desmidus · 2006-02-20 01:05:34

Interesting resolution. Deleting the installation and reinstalling in the same way didn’t fix anything, but then I installed it from typing in the /textpattern address instead of the usual /textpattern/setup. This seems to have created the proper tables, as I noticed that there were 18 tables in the db as opposed to the 17 that were being created earlier.

Weird. But it works now.

zem · 2006-02-20 01:57:44

Interesting resolution. Deleting the installation and reinstalling in the same way didn’t fix anything, but then I installed it from typing in the /textpattern address instead of the usual /textpattern/setup.

I’m confused. Was this an upgrade or install from scratch? Your initial post made it sound like an upgrade. You don’t run the installer for an upgrade.

desmidus · 2006-02-20 02:08:49

It was a scratch install, I meant that I deleted the entire install which was causing problems and redid it, and for some reason it worked this time around.

Textpattern CMS

Textpattern CMS support forum

#1 2006-02-19 18:47:19

Login empty 'index.php', Apache2 process goes wild

#2 2006-02-19 22:34:49

Re: Login empty 'index.php', Apache2 process goes wild

#3 2006-02-19 23:27:30

Re: Login empty 'index.php', Apache2 process goes wild

#4 2006-02-20 00:54:21

Re: Login empty 'index.php', Apache2 process goes wild

#5 2006-02-20 01:05:34

Re: Login empty 'index.php', Apache2 process goes wild

#6 2006-02-20 01:57:44

Re: Login empty 'index.php', Apache2 process goes wild

#7 2006-02-20 02:08:49

Re: Login empty 'index.php', Apache2 process goes wild

Board footer