1005 Can't create table

More
10 years 1 week ago #4008 by frankzoo
1005 Can't create table was created by frankzoo
i've install (and unistall) several times Solidres_Full_Package_v0.6.1 2 also v0.6.2 on Joomla! 3.2.2 Stable
befor install i've this error:

1005 Can't create table 'Sql572917_2.blysm_sr_geo_states' (errno: 121) SQL=--
-- Table `blysm_sr_geo_states` --
CREATE TABLE IF NOT EXISTS `blysm_sr_geo_states` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `country_id` INT(11) UNSIGNED NOT NULL DEFAULT 0 , `name` VARCHAR(45) NOT NULL , `code_2` VARCHAR(10) NOT NULL , `code_3` VARCHAR(10) NOT NULL , `state` TINYINT(3) NOT NULL DEFAULT 0 , PRIMARY KEY (`id`) , INDEX `fk_sr_geo_states_sr_countries1_idx` (`country_id` ASC) , CONSTRAINT `fk_sr_geo_states_sr_countries1` FOREIGN KEY (`country_id` ) REFERENCES `blysm_sr_countries` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;

Information system:
PHP attivo su Linux webxc32s02.ad.aruba.it 2.6.32-431.5.1.el6.x86_64 #1 SMP Wed Feb 12 00:41:43 UTC 2014 x86_64
Versione database 5.5.36-34.0-log
Collation database utf8_general_ci
Versione PHP 5.3.28
Web Server Apache/2.4.7 (Unix) mod_fcgid/2.3.9
WebServer interfaccia PHP cgi-fcgi
Versione di Joomla! Joomla! 3.2.2 Stable [ Ember ] 6-February-2014 16:00 GMT
Versione piattaforma Joomla! Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_2) AppleWebKit/537.74.9 (KHTML, like Gecko) Version/7.0.2 Safari/537.74.9

How i can risolve it? Thank you

Please Log in or Create an account to join the conversation.

More
10 years 1 week ago #4012 by vietvh
Replied by vietvh on topic 1005 Can't create table
Hi,

Please make sure that you are using a dedicated database, your Joomla should not use the same database with other Joomla installations because it will create duplicate table's constraints.

Please Log in or Create an account to join the conversation.

More
10 years 1 week ago #4017 by frankzoo
Replied by frankzoo on topic 1005 Can't create table
sure, i using a dedicated database.

Please Log in or Create an account to join the conversation.

More
10 years 1 week ago #4018 by vietvh
Replied by vietvh on topic 1005 Can't create table
You can attach a screenshot of your database with phpmyadmin so that we can see all tables in your database. You can hide the phpmyadmin url in your screenshot.

Please Log in or Create an account to join the conversation.

Moderators: solidres
Powered by Kunena Forum

All the things you need to make your work easier. Did you like Solidres?