Database table not found after installing component

Question

Hi

I didn't have FTP access to the website I'm fixing (it also has a small limit on form uploads) so I used Install From URL. It told me the install was OK but I get a message when going to the Chronoforms compenent saying: Table 'clarkeresidenti.hw9nf_chronoengine_chronoforms' doesn't exist SQL=DESCRIBE `hw9nf_chronoengine_chronoforms`

hw9nf is the table prefix and clarkeresidenti is the database.

Any ideas please?

Thanks

Dan

GreyHead · Accepted Answer

Hi Dan,

Here is the SQL for creating the tables

--
-- Table structure for table `#__chronoengine_extensions`
--

CREATE TABLE IF NOT EXISTS `#__chronoengine_extensions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `addon_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `ordering` int(4) NOT NULL,
  `settings` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `#__chronoengine_forms`
--

CREATE TABLE IF NOT EXISTS `#__chronoengine_chronoforms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `params` text NOT NULL,
  `extras` longtext NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `app` varchar(255) NOT NULL DEFAULT '',
  `form_type` int(1) NOT NULL DEFAULT '1',
  `content` longtext NOT NULL,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;

Bob