PHP 5.2.9
WinXP
MySQL 5.1.33

I have such error on fresh install drupa7-rc3 (after db configuration form):

SQLSTATE[HY000]: General error: 1005 Can't create table 'drupal7.variable' (errno: 121)

After this error there is no any tables in db.

Tested on users with pass and without pass.

Db name, user, pass are correct (if I make purposely error in user/pass - I have "Failed to connect to your database server").

Comments

edhel’s picture

edhel commented
Status: Active » Closed (fixed)

Seems it was problem with innodb data files. Error in mysql_error.log:

InnoDB: Error: table `drupal7`.`variable` already exists in InnoDB internal dictionary. Have you deleted the .frm file and not used DROP TABLE? Have you used DROP DATABASE for InnoDB tables in MySQL version <= 3.23.43?

I create another db and installation go further. I suppose, that I've deleted old drupal7 installation by delete mysql/data/drupal7 folder without DROP DATABASE.

sivaji_ganesh_jojodae’s picture

sivaji_ganesh_jojodae commented

If you encounter this problem, drop the database and re-create it.

hermick’s picture

hermick commented
Version: 7.0-rc3 » 7.14
Category: bug » support
Status: Closed (fixed) » Active

I am encountering a similar problem, except installing Drupal 7.14 and with errno 135:

SQLSTATE[HY000]: General error: 1005 Can't create table '.variable' (errno: 135)

I'm just getting started with this, and hardly a web configuration guru, so specifics are helpful. I've tried deleting and recreating my database, but to no avail.

Version: 7.14 » 7.x-dev

Core issues are now filed against the dev versions where changes will be made. Document the specific release you are using in your issue comment. More information about choosing a version.

Status: Active » Closed (outdated)

Automatically closed because Drupal 7 security and bugfix support has ended as of 5 January 2025. If the issue verifiably applies to later versions, please reopen with details and update the version.