Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
edhel CreditAttribution: edhel commentedSeems 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.
Comment #2
Sivaji_Ganesh_Jojodae CreditAttribution: Sivaji_Ganesh_Jojodae commentedIf you encounter this problem, drop the database and re-create it.
Comment #3
hermick CreditAttribution: hermick commentedI 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.