0
Hello, i can't install your component;... an error appears :
JInstaller: :Install: erreur SQL Unknown column 'timeSpent' in 'CHECK'
Extension Installer : Erreur SQL de traitement de la requête : Fonction DB échouée avec le numéro d'erreur 1054
Unknown column 'timeSpent' in 'CHECK'
SQL =
CREATE TABLE IF NOT EXISTS `#__papershape_projects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` text,
`date_start` DATE DEFAULT NULL,
`date_limit` DATE DEFAULT NULL,
`time_spent` bigint(15) NOT NULL default 0 CHECK (`timeSpent` > 0),
`completed` boolean NOT NULL default false,
`color` varchar(255),
`price` decimal(12,4) NOT NULL default 0,
`user_id` int(11) NOT NULL,
`default_task_category_id` INT(11) NOT NULL DEFAULT 0,
`contact_id` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Thanks for help
JInstaller: :Install: erreur SQL Unknown column 'timeSpent' in 'CHECK'
Extension Installer : Erreur SQL de traitement de la requête : Fonction DB échouée avec le numéro d'erreur 1054
Unknown column 'timeSpent' in 'CHECK'
SQL =
CREATE TABLE IF NOT EXISTS `#__papershape_projects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` text,
`date_start` DATE DEFAULT NULL,
`date_limit` DATE DEFAULT NULL,
`time_spent` bigint(15) NOT NULL default 0 CHECK (`timeSpent` > 0),
`completed` boolean NOT NULL default false,
`color` varchar(255),
`price` decimal(12,4) NOT NULL default 0,
`user_id` int(11) NOT NULL,
`default_task_category_id` INT(11) NOT NULL DEFAULT 0,
`contact_id` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Thanks for help
Responses (11)
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
0I am having literally this exact same problem how can we address this issue. I am referring to the installation error not the translation to French.-
Germinal Campsmore than a month agowell, this is odd. We corrected this error and we uploaded the fixed version. I just downloaded it just to make sure, and the error is corrected.. so I can't figure out why you're getting the error.
Did you download the installable package from your "my downloads" area?
-
-
Accepted Answer
0yes, I downloaded it directly from the download area on your site.
I have another thread that is running it is here
https://www.joomlathat.com/support/papershape/installation-error#reply-40812
please respond on that thread as that is one i actually started and has my screenshots.
but that withstanding how do we move forward. -
Accepted Answer
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »