• The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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