- Posts: 6
- Home
- Forum
- Community Forum
- Questions
- User Finish Paying Balance of Reservation
erreur lors de l'installation
- pierreleroy
- Topic Author
- Offline
Less
More
6 years 6 months ago - 6 years 6 months ago #12100
by pierreleroy
erreur lors de l'installation was created by pierreleroy
Hello,
I wanted to install solidres and here is the error message:
JInstaller: :Install: erreur SQL Can't create table 'db750962101.#__sr_geo_states' (errno: 121)
Extension Installer : Erreur SQL de traitement de la requête : Fonction DB échouée avec le numéro d'erreur 1005
Can't create table 'db750962101.#__sr_geo_states' (errno: 121)
SQL =
CREATE TABLE IF NOT EXISTS `#__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 `#__sr_countries` (`id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
an idea ?
I wanted to install solidres and here is the error message:
JInstaller: :Install: erreur SQL Can't create table 'db750962101.#__sr_geo_states' (errno: 121)
Extension Installer : Erreur SQL de traitement de la requête : Fonction DB échouée avec le numéro d'erreur 1005
Can't create table 'db750962101.#__sr_geo_states' (errno: 121)
SQL =
CREATE TABLE IF NOT EXISTS `#__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 `#__sr_countries` (`id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
an idea ?
Last edit: 6 years 6 months ago by pierreleroy.
Please Log in or Create an account to join the conversation.
- solidres
-
- Away
Less
More
- Posts: 2956
6 years 6 months ago #12104
by solidres
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Replied by solidres on topic erreur lors de l'installation
Hi,
Please raise a new support ticket and provide us your website info, including your database info, we will check it for you.
Regards,
Please raise a new support ticket and provide us your website info, including your database info, we will check it for you.
Regards,
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Please Log in or Create an account to join the conversation.
Moderators: solidres