Table wp_toolset_post_guid_id is not having primary key

This support ticket is created 3 years, 11 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Kolkata (GMT+05:30)

Tagged: Types plugin

This topic contains 1 reply, has 2 voices.

Last updated by Minesh 3 years, 11 months ago.

Assisted by: Minesh.

Author

Posts

January 20, 2021 at 8:58 am #1911675

sjC-2

Hi, I want to move my WP database to managed database and for the same, I have been informed that all my tables need to have a primary key. On checking the DB, I found that the table wp_toolset_post_guid_id is not having a primary key. Can I add a new column for the primary key and if so will toolset continue to work properly. Kindly suggest.

January 20, 2021 at 11:38 am #1911977

Minesh

Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hello. Thank you for contacting the Toolset support.

The table "wp_toolset_post_guid_id" is used when rendering Types image fields.

I just checked by adding a ID as primary key (auto increment) to the table wp_toolset_post_guid_id.

I do not see site is broken or it stop working.

It seems there will not be any issue BUT I strongly suggest testing this in a staging environment before applying in production.

In addition to that, I've also filed a feature request to add a primary key column to "wp_toolset_post_guid_id". It will be added in near future release, please note that there is no ETA on it.