0
Warning
JInstaller: :Install: Error SQL You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `completed` boolean NOT NULL default false, `color` varchar(255), `price`' at line 7
Extension Install: SQL error processing query: DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `completed` boolean NOT NULL default false, `color` varchar(255), `price`' at line 7
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 ,
`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;
×
Error
Error installing component
This is what I get when I try to install the papershape. Please advise thank you.
JInstaller: :Install: Error SQL You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `completed` boolean NOT NULL default false, `color` varchar(255), `price`' at line 7
Extension Install: SQL error processing query: DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `completed` boolean NOT NULL default false, `color` varchar(255), `price`' at line 7
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 ,
`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;
×
Error
Error installing component
This is what I get when I try to install the papershape. Please advise thank you.
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 »