I would like to install D7 but the install process causes the apache server to crash.

environment:
winXP sp3 + XAMPP 1.7.0 beta 4
# Apache (2.2.11)
# MySQL (5.1.30)
# PHP (5.2.8)

the db tables are created correctly,
the crash happens when system_theme_data() is called, which makes a db query

database.inc DatabaseStatementBase->execute()
on line 1464:

$return = parent::execute($args);

data:

$this->dbh = DatabaseConnection_mysql
$this->queryString = SELECT filename, name, type, status, schema_version, weight FROM system WHERE type = ?
$args[0] = theme

that select does not return any rows, but that should not cause a crash..

I do not know what else should I try to solve the problem.

Comments

Crell’s picture

Crell commented

Hm. MySQL 5.1 has had inconsistent reports as to its ability to not break. :-) Can you try with MySQL 5.0.x and see if it still dies? It could be a bug in MySQL specifically. (I recently ran across a Views-breaking bug in MySQL 5.0.32, for which the only solution was to not use that version of MySQL: #341401: No data returned for glossary-style view)

pasqualle’s picture

pasqualle
Location 🇭🇺 Budapest
commented
Status: Active » Fixed

Ok, I was able to install D7 on environment:
winXP sp3 + XAMPP 1.6.8
# Apache 2.2.9
# MySQL 5.0.67
# PHP 5.2.6

Hm.

Crell’s picture

Crell commented
Status: Fixed » Postponed (maintainer needs more info)

Great. That means that there's some sort of fatal issue with that version of MySQL 5.1. We should probably figure out what and document it. (Dagnabbit, MySQL, stop breaking things!)

ainigma32’s picture

ainigma32 commented

@Crell: Did you manage to find the time to what that fatal issue was?

- Arie

Crell’s picture

Crell commented

Sadly no. I don't have a MySQL 5.1 installation available to test with at present.

Does this issue exist with Drupal 6 as well, or just Drupal 7? We may have to end up reporting it as a bug to MySQL, so the more information we have the better.

pasqualle’s picture

pasqualle
Location 🇭🇺 Budapest
commented

the test environment where I was unable to install D7 worked well with D6 (at least I did not find any problem at that short time it was on my computer)

leehunter’s picture

leehunter commented

I'm having the same problem with a similar XAMP setup on Windows XP

MySQL 5.1.3
PHP 5.2.8
Apache 2.2.11

Drupal 6 works fine and the January 18th nightly build of D7 won't install.

Fatal error: Uncaught exception 'PDOException' with message 'CREATE TABLE {variable} ( `name` VARCHAR(128) NOT NULL DEFAULT '', `value` LONGTEXT NOT NULL, PRIMARY KEY (name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ - Array ( ) SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'variable' already exists' in C:\xampp\htdocs\drupal-7.x-dev\includes\database\database.inc:587 Stack trace: #0 C:\xampp\htdocs\drupal-7.x-dev\includes\database\database.inc(1978): DatabaseConnection->query('CREATE TABLE {v...') #1 C:\xampp\htdocs\drupal-7.x-dev\includes\database\schema.inc(461): update_sql() #2 C:\xampp\htdocs\drupal-7.x-dev\includes\database\database.inc(2051): DatabaseSchema->createTable('CREATE TABLE {v...') #3 C:\xampp\htdocs\drupal-7.x-dev\includes\common.inc(3558): db_create_table(Array, 'variable', Array) #4 C:\xampp\htdocs\drupal-7.x-dev\modules\system\system.install(335): drupal_install_schema(Array, 'variable', Array) #5 C:\xampp\htdocs\drupal-7.x-dev\includes\module.inc(492): system_install('system') #6 C: in C:\xampp\htdocs\drupal-7.x-dev\includes\database\database.inc on line 587

Crell’s picture

Crell commented

I don't think Lee's error in #8 is related. The table already existing is a legit error and an exception is the correct response. The original issue is a SELECT query dying when it shouldn't.

leehunter’s picture

leehunter commented

Just for the heck of it, I tried installing other versions back to 7 unstable 1 and got the same results.

david strauss’s picture

david strauss
he/him
commented

I cannot replicate this on CentOS 5.2 with Apache 2.2.3, PHP 5.2.8, MySQL 5.1.30, and Drupal HEAD.

Crell’s picture

Crell commented

Could this possibly be related to #355496: List all available databases, even if only one is available? It could be that PDO is just not as stable on Windows or Mac in some versions. That's an issue to take up with php.net directly if so.

asimmonds’s picture

asimmonds commented

I've been running Apache 2.2.10, PHP 5.2.8, MySQL 5.1.30 on Windows for the last 4 or 5 weeks and have had no problems at all with HEAD crashing Apache or Mysql, reinstalling Drupal quite often while trying different patches etc. My install is built up from the different components and not a packaged solution like XAMPP.

Could it be something like eAccelerator or another PHP extension causing this. I do use Xdebug which has been known to crash PHP/Apache sometimes (but not recently)

leehunter’s picture

leehunter commented

Thanks asimmonds, that prompted me to do a little more digging and it seems like one or both of these problems (my #8 and the original) might be related to the version of XAMP. I found this post which provides a fix

http://www.apachefriends.org/f/viewtopic.php?f=16&t=32617

Haven't had a chance to try it myself.

david strauss’s picture

david strauss
he/him
commented
Status: Postponed (maintainer needs more info) » Closed (won't fix)

I'm marking this as "won't fix" because it seems to be an issue with XAMP.

mechler’s picture

mechler commented

#14 was a confirmed fix for me in Vista environment.

tanoshimi’s picture

tanoshimi commented

Wow! That's annoying... I've been downloading the Drupal-7.x-dev tarball every week or so for a while now in order to upgrade my modules to it, and every time it's crashed Apache on installation, which I've always assumed was caused by issues because it was still only a dev release etc. etc.so I've left it alone again - it never occurred to me that it would require a patch to Apache to run!

For anybody else finding this - the patch in #14 also fixed it for me - Apache was crashing every time on Drupal 7 install, with an unhandled exception in php_pdo_mysql.dll. The problem is that, having applied the patch, my Drupal 6 sites now no longer run....

This is an irritation at best to have to switch between patches on your own development machine, but I'm not quite sure what implications this has for how easy it will be to deploy Drupal 7 to production hosts though...

pasqualle’s picture

pasqualle
Location 🇭🇺 Budapest
commented

XAMPP 1.7.1 (contains Apache/2.2.11 PHP/5.2.9) works correctly with D6 and D7

wubbl’s picture

wubbl commented

Confirmed solved after PHP update (#14) in Windows 7 (x64) ...

csedev’s picture

csedev commented

I copied the libmysql.dll into Apache/bin and this solved my problem.

marxarelli’s picture

marxarelli commented

I had an issue like this (process segfault) when using pdo_mysql compiled against libmysql (not mysqlnd). In case this is indeed the same bug, have a look here.

http://drupal.org/node/772740#comment-4466916
http://bugs.php.net/bug.php?id=54733