Multiple primary key defined error when installing Jomestate plugin

Question

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?

Answer 1

(Your question might get a better answer on the main stackexchange site, since it's really a SQL question/issue more than a Joomla one.)

I'd look at what the primary key of that table is now. If one exists, drop/remove it, and then try the query again. If the current primary key IS id already, you could instead remove ADD PRIMARY KEY (id), from your query.

Before you do any of that you should back up the table (in case stuff hits the fan).

Answer 2

This code causes the issue:

ALTER TABLE `#__cddir_jomestate`
ADD PRIMARY KEY (`id`), <- this line

Remove the line; it's totally unnecessary. Do the same for the other ALTER TABLE commands if necessary.