I just checkout HEAD and try to install on WinXP xampp setup: the apache process crash in php_pdo_mysql.dll. Dismiss the crash dialog, the browser returns this error:

PDOException: 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:\drupal\drupal-HEAD\includes\database\database.inc on line 597 Call Stack: 0.0062 433952 1. {main}() C:\drupal\drupal-HEAD\install.php:0 0.0113 730496 2. install_main() C:\drupal\drupal-HEAD\install.php:1125 4.0140 8281104 3. drupal_install_system() C:\drupal\drupal-HEAD\install.php:150 4.0335 8956256 4. module_invoke() C:\drupal\drupal-HEAD\includes\install.inc:576 4.0336 8956656 5. call_user_func_array() C:\drupal\drupal-HEAD\includes\module.inc:492 4.0336 8956680 6. system_install() C:\drupal\drupal-HEAD\includes\module.inc:0 4.0337 8958152 7. drupal_install_schema() C:\drupal\drupal-HEAD\modules\system\system.install:335 4.0344 9036016 8. db_create_table() C:\drupal\drupal-HEAD\includes\common.inc:3748 4.0345 9036672 9. DatabaseSchema->createTable() C:\drupal\drupal-HEAD\includes\database\database.inc:2047 4.0347 9041184 10. update_sql() C:\drupal\drupal-HEAD\includes\database\schema.inc:469 4.0348 9041384 11. DatabaseConnection->query() C:\drupal\drupal-HEAD\includes\database\database.inc:1974

My memory_limit = 128M, PHP 5.28, MySQL 5.1.30.

Is there anything I can do to overcome this?

Comments

mattyoung’s picture

mattyoung CreditAttribution: mattyoung commented

Problem solved. Turns out this is a bug in XAMPP 1.7.0 PHP and the fix is already there.

To fix the problem:

in "xampp\apache\bin"
copy libmysql_5.0.51a.dll libmysql.dll

in "xampp\php"
copy libmysql_5.0.51a.dll libmysql.dll

in "xampp\php\ext"
copy php_mysql_5.0.51a.dll php_mysql.dll
copy php_mysqli_5.0.51a.dll php_mysqli.dll

Note: you may want to rename the orginal file before copy so you have something to go back to just in case.

This fix the PDO exception problem. Also make everything run crazy fast.

It would be nice if somebody can rename this thread to "D7 HEAD install PDOException/Crash on XAMPP" or something like this just so it's clear this is a XAMPP Windows 1.70 problem and not thing wrong with D7. Anyone with XAMPP will run into this problem sooner or later.

Dave Reid’s picture

Dave Reid
he/him
Primary language English
Location Nebraska USA
CreditAttribution: Dave Reid commented
Title: Unable to install D7 HEAD » XAMPP 1.7.0 for Windows PDO exception
Status: Active » Fixed
emackn’s picture

emackn CreditAttribution: emackn commented

When I do this under winxp, apache dies. I get Apache HTTP Server dialog error boxes with:

AppName: apache.exe AppVer: 2.2.11.0 ModName: php5ts.dll
ModVer: 5.2.8.8 Offset: 0000ac5a

hitting phpadmin or drupal blows up the server.

emackn’s picture

emackn CreditAttribution: emackn commented
Status: Fixed » Active
mattyoung’s picture

mattyoung CreditAttribution: mattyoung commented

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

kathyh’s picture

kathyh CreditAttribution: kathyh commented

Ran into same issue on winxp, however, Post #1 from mattyoung instructions worked fine to correct this issue.

Error statement below:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'variable' already exists

aspilicious’s picture

aspilicious CreditAttribution: aspilicious commented
Status: Active » Fixed

this is a apache bug not a drupal bug

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

marcvangend’s picture

marcvangend
he/him
Primary language Dutch
Location Amsterdam
CreditAttribution: marcvangend commented

If it helps anyone: I just got the same error (SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'variable' already exists) on a WampServer environment when trying to install Drupal in an empty database (all tables dropped) that had been used before. Problem was solved by completely dropping the database and re-creating it.

jeremyo’s picture

jeremyo CreditAttribution: jeremyo commented

A +1 to those who found this to be the solution: #1 worked for me. It took me a long time to find this post, though, so I'm hoping to give it some google-juice for the terms I was searching for by mentioning Windows 7, XAMPP 1.7.0, Drupal 7 alpha, Apache crash and "Parent: child process exited with status 255 -- Restarting". Swopping out/renaming the files mentioned in #1 fixed the issue for me without causing any new problems.
Thanks to mattyoung for the fix.

jspotswood’s picture

jspotswood CreditAttribution: jspotswood commented

Another way to resolve this issue is to upgrade to newer version of XAMPP. Version 1.7.3 worked for me with the Windows Vista OS.

mstrelan’s picture

mstrelan CreditAttribution: mstrelan commented

#1 has worked for me and like #11 I had a hard time finding the problem. I would have jumped straight to #12 however I need XAMPP 1.7.0 because it has PHP 5.2, which I need for my Drupal 6 sites, otherwise I get all sorts of errors.

hellowahab’s picture

hellowahab CreditAttribution: hellowahab commented

This problem is specific to 1.7.0 you can find a proper solution here
http://hellowahab.wordpress.com/2012/02/09/xampp-1-7-0-for-windows-pdo-exception-apache-crashed/