After updating our test server with the latest toolset version we are getting the following error:
WordPress database error: [Index column size too large. The maximum column size is 767 bytes.]
CREATE TABLE wp_toolset_post_guid_id ( `guid` varchar(255) NOT NULL DEFAULT '', `post_id` bigint(20) NOT NULL, UNIQUE KEY `post_id` (`post_id`), KEY `guid` (`guid`) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
When I try to upload a new media I'm getting more toolset related errors:
WordPress database error: [Index column size too large. The maximum column size is 767 bytes.]
CREATE TABLE wp_toolset_post_guid_id ( `guid` varchar(255) NOT NULL DEFAULT '', `post_id` bigint(20) NOT NULL, UNIQUE KEY `post_id` (`post_id`), KEY `guid` (`guid`) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [Table 'db_dom18913.wp_toolset_post_guid_id' doesn't exist]
SELECT post_id FROM wp_toolset_post_guid_id WHERE guid='<em><u>hidden link</u></em>' LIMIT 1
WordPress database error: [Table 'db_dom18913.wp_toolset_post_guid_id' doesn't exist]
SELECT guid FROM wp_toolset_post_guid_id WHERE post_id=13904 LIMIT 1
WordPress database error: [Table 'db_dom18913.wp_toolset_post_guid_id' doesn't exist]
INSERT INTO wp_toolset_post_guid_id (guid,post_id) VALUES ('<em><u>hidden link</u></em>',13904)
Could you please help us? Thanks.
Minesh
Supporter
Languages:
English (English )
Timezone:
Asia/Kolkata (GMT+05:30)
So, what do you suggest? Making changes in the database configuration for either collation or settings to allow index for larger columns?
I don;t think this is viable.
Does the guid column need to be that large?
Minesh
Supporter
Languages:
English (English )
Timezone:
Asia/Kolkata (GMT+05:30)
Could you please update your Types plugin to 2.2.13 version which is published with the hotfix for the issue you have having.
You can download the latest Types plugins from plugins page:
=> https://toolset.com/home/types-manage-post-types-taxonomy-and-custom-fields/
After installing the upgrade the issue was solved.
Thank you vert much.