Joomla : Multiple primary key defined error when installing plugin

by Bog Alt   Last Updated March 08, 2018 13:10 PM

I have Joomla 3.8.5 stable version. The code I am tring to execute is: Pastebin SQL code (I am tring to install JOMESTATE plugin)

I get the following error:

JInstaller: :Install: Error SQL Multiple primary key defined Extension Install: SQL error processing query: DB function failed with error number 1068 Multiple primary key defined SQL =

ALTER TABLE `#__cddir_jomestate`
ADD PRIMARY KEY (`id`), 
ADD KEY `fk_#__cddir_content_#__categories` (`categories_id`), 
ADD KEY `fk_#__cddir_content_#__users1` (`users_id`), 
ADD KEY `fk_#__cddir_content_#__assets1` (`asset_id`), 
ADD KEY `categories_address_id` (`categories_address_id`), 
ADD KEY `categories_type_id` (`categories_type_id`), 
ADD KEY `title` (`title`), 
ADD KEY `company_id` (`company_id`), 
ADD KEY `access` (`access`), 
ADD KEY `fulladdress` (`fulladdress`), 
ADD KEY `published` (`published`), 
ADD KEY `approved` (`approved`);

Any idea?



Related Questions