I have Joomla 3.8.5 stable version. The code I am tring to execute is: Pastebin SQL code (I am tring to install the 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?