Installation failing at "setup database" step

Java_Chump - June 1, 2008 - 20:56

Hi All,

Hoping you can help with a rather ambiguous issue I seem to be exepriencing trying to install Drupal. My current config:
Apache 2.2
PHP 5.2.6
Drupal 6.2
MySQL 5.1

Once I provide database, user and password and click "Save and Continue" some activity seems to occur before Apache crashes. I can see some tables have been created in the MySQL DB. When I review the Apache log I can only see PHP warnings regarding the existence of tables. I have dropped all the tables, and also tried dropping and recreating the whole database schema. Everytime I get the same Apache crash - with very little info as to why:

== Apache Error Log Output ==
[Sun Jun 01 21:36:09 2008] [notice] Child 1164: Starting thread to listen on port 8088.
[Sun Jun 01 21:36:12 2008] [error] [client 127.0.0.1] PHP Warning:  Table &#039;variable&#039; already exists\nquery: CREATE TABLE variable (\n`name` VARCHAR(128) NOT NULL DEFAULT &#039;&#039;, \n`value` LONGTEXT NOT NULL, \nPRIMARY KEY (name)\n) /*!40100 DEFAULT CHARACTER SET UTF8 */ in H:\\Apache2.2\\htdocs\\drupal-6.2\\includes\\database.mysqli.inc on line 128, referer: http://localhost:8088/drupal-6.2/install.php?profile=default&locale=en
... 41 similar warnings ...

[Sun Jun 01 21:36:12 2008] [error] [client 127.0.0.1] PHP Warning:  Table &#039;vocabulary_node_types&#039; already exists\nquery: CREATE TABLE vocabulary_node_types (\n`vid` INT unsigned NOT NULL DEFAULT 0, \n`type` VARCHAR(32) NOT NULL DEFAULT &#039;&#039;, \nPRIMARY KEY (type, vid), \nINDEX vid (vid)\n) /*!40100 DEFAULT CHARACTER SET UTF8 */ in H:\\Apache2.2\\htdocs\\drupal-6.2\\includes\\database.mysqli.inc on line 128, referer: http://localhost:8088/drupal-6.2/install.php?profile=default&locale=en
[Sun Jun 01 21:36:15 2008] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Sun Jun 01 21:36:16 2008] [notice] Apache/2.2.8 (Win32) PHP/5.2.6 configured -- resuming normal operations
[Sun Jun 01 21:36:16 2008] [notice] Server built: Jan 18 2008 00:37:19
[Sun Jun 01 21:36:16 2008] [notice] Parent: Created child process 544
[Sun Jun 01 21:36:17 2008] [notice] Child 544: Child process is running
[Sun Jun 01 21:36:17 2008] [notice] Child 544: Acquired the start mutex.
[Sun Jun 01 21:36:17 2008] [notice] Child 544: Starting 64 worker threads.
[Sun Jun 01 21:36:17 2008] [notice] Child 544: Starting thread to listen on port 8088.
== End Apache Error Log Output ==

Not sure if it is related, but originally in accordance with the instructions on the site I had only enabled the following extensions:
extension=php_gd2.dll
extension=php_pdo.dll

However the Drupal install script complained about the lack of php_mbstring.dll and did not recognise a database configuration until I also uncommented:
extension=php_mbstring.dll
extension=php_mysqli.dll

Thanks in advance,

Kevin

» Login or register to post comments

The apache error reported in

Java_Chump - June 2, 2008 - 19:27

The apache error reported in windows is:
AppName: httpd.exe AppVer: 2.2.8.0 ModName: php_mysqli.dll
ModVer: 5.2.6.6 Offset: 00002beb

And a whole host of hex :( - not very helpful but sounds like something in the mysql mod is not playing ball as it's actually crashing apache and having to restart?

Any ideas anyone?

Has no one seen this problem

Java_Chump - June 3, 2008 - 19:50

Has no one seen this problem before? Or no ideas how to progress the issue?

Really would appreciate some help

Been away from the home PC

Java_Chump - June 6, 2008 - 21:02

Been away from the home PC for a few days, but I am going to try and get Drupal working this weekend - for a php CMS it really should not be this hard!

I welcome any help that can be provided and am somewhat disappointed no one has been able to contribute anything of note to this topic!

Table Exists

HotDrupal.com - June 6, 2008 - 22:22

I see all the table exists ... you get these even after you delete the database, create a new one, then trying install?

Steve

tried creating brand new mysql db

Java_Chump - June 7, 2008 - 22:03

Hi Steve,

Yeah I've just retried creating a brand new mysql databse schema and executing the install script. Again once entering the database name, username and password the install script goes off and then proceeds to crash the apache webserver and the log file contains only information about duplicate tables as identified previously. If I review the db schema in MySQL administrator I can see 43 tables have been created.

If I restart apache and attempt to access the install script apache crashes until I stop and drop all tables from the database schema.

Not sure of this is of any

Java_Chump - June 7, 2008 - 22:14

Not sure of this is of any help but when I tried enabling php_mysql, instead of php_mysqli the following error appeared in the Apache Error log:

zend_mm_heap corrupted
Error in my_thread_global_end(): 66 threads didn't exit

Looks like using this package is not even getting as far as creating the database tables

Solved

Java_Chump - June 8, 2008 - 10:31

Finally got the install to execute.

I downloaded the latest php_mysqli.dll from the
MySQL website and replaced the existing mysqli extension in the PHP 5.x windows distribution and it worked.

Still Having the same Problem

jerrywein - April 16, 2009 - 19:34

I've been experiencing the same problem as Java_Chump and I have even upgraded my PHP to 5.2.9.2. I still get the same errors Java_Chump listed. Does anyone have an idea on what else might be going on. I've been trying to resolve this for three days and have exhausted all the options I can think of. This is my first time using Drupal and it's getting to the point of not being worth installing.

JC- That's great that you resolved it with new MySQLI

webguynow - April 16, 2009 - 19:48

I'm going to try the same thing - and I'm hopeful.
We are using supported components so I'm really suprised Drupal has this install bug to begin with. I'm a new user too, but expected more out of such a highly recommended product.

FYI: The same bug was originally posted to the Install forum, posted by ticketmanbob
Topic: Drupal install fails - tables apparently already exist, also appears to crash apache

Still having Apache Crash

jerrywein - April 17, 2009 - 00:58

Well, I downloaded Drupal again and the install failed the same was as before with Apache crashing. I'm running Apache 2.2.11, PHP 5.2.9.2, MySQL 5.1, and Drupal 6.10. I've even tried the PHP 5.3 RC1 and had the same results so I moved back to PHP 5.2.9.2. I'm out of ideas on how to get this resolved, if anyone has any clue about where else I should look I'd be gratefull.

Thanks, Jerry

Chump- How'd you fix this ?

webguynow - April 18, 2009 - 14:46

You provided a link to mysql mysqlnd page, but I wasn't sure what you downloaded - mysqli or mysqlnd ? And I went looking, but couldn't find either very easily. I'm going to check my php5.2.x version and see what's compatible. Then I'll need to find a link to these downloads.
Finally, I'll compare with what I currently have.

I ended up at the php.net site and realized I had a choice php: thread-safe or non-thread-safe
Left me a little confused. I guess I'll run a phpinfo() and see if that throws any light on this.

Fix! ...?

ResolutionX - September 1, 2009 - 17:13

Dude... I had this Problem You using incompatable Apache and PHP versions.

PHP 5.2.* will not work with Apache 2.2.*

You need to downgrade your Apache to 2.0.*

Once you've done that should fix it. :)