- Posts: 2
- Home
- Forum
- Community Forum
- Feature requests / Suggestions
- Complex tariff - set % rate based on base rate
1005 Can't create table
- frankzoo
- Topic Author
- Offline
Less
More
11 years 1 month 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
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.
- vietvh
-
- Offline
Less
More
- Posts: 1553
11 years 1 month 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 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.
- frankzoo
- Topic Author
- Offline
Less
More
- Posts: 2
11 years 1 month 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.
- vietvh
-
- Offline
Less
More
- Posts: 1553
11 years 1 month 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