• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Strange Plan Sync Error Message

MorrisC

Basic Pleskian
When I am syncing plans with subscription, it shows

Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '16-servicePlanId' for key 'PRIMARY'

Which table should I check for the problem in mysql database?

Thanks

Morris
 
Hi MorrisC,

you find the definition "servicePlanId" in the psa - database - table: "longtaskparams"
 
Thanks, UFHH01,

I found there are so many longtasks params and in long tasks, therefore, I delete all of them from the record.
I then move customers to another plan and delete the original plan. And create the plan again and move them back.
No more sync problem message anymore.

From my understanding, since the primary key should be unique, therefore, deleting records in longtasks and longtakparams tables should resolve the issues.
 
Last edited:
Back
Top