loic @ cloudinary

Hi @spidiman,

Thanks for your update.

Do you mind creating a ticket to [email protected] with the information asked in my first reply?

Thanks in advance.
Best,
Loic

Hi @skome,

To be more general, the error occurs due to limitation of the DB engine which depends on your MySQL version.

Here is the code to use for any MySQL version:

CREATE TABLE IF NOT EXISTS {{wp_prefix}}_cloudinary_relationships (
    id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    post_id bigint(20) DEFAULT NULL,
    public_id varchar(500) DEFAULT NULL,
    parent_path varchar(500) DEFAULT NULL,
    sized_url varchar(500) DEFAULT NULL,
    width int(11) DEFAULT NULL,
    height int(11) DEFAULT NULL,
    format varchar(12) DEFAULT NULL,
    sync_type varchar(10) DEFAULT NULL,
    post_state varchar(12) DEFAULT NULL,
    transformations text DEFAULT NULL,
    signature varchar(5) DEFAULT NULL,
    PRIMARY KEY (id),
    UNIQUE KEY sized_url (sized_url(190)),
    KEY post_id (post_id),
    KEY parent_path (parent_path(190)),
    KEY public_id (public_id(190)),
    KEY sync_type (sync_type)
) ENGINE=INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci

You will need to replace the {{wp_prefix}} with the prefix in your database, by default it is wp but it can change depending on your setup. So before running the query, I recommend checking your prefix and then filling the value in the query above.

Best,
Loic

• This reply was modified 4 years, 5 months ago by loic @ cloudinary.

Hi @spidiman,

Thanks for reaching out.

Would you mind creating a support ticket to [email protected] with the following information:

* WordPress version.
* Cloudinary Plugin’s version.
* The theme that you use and its version.
* A full list of all other plugins that you have installed on your environment.
* Page builders that you actively use.
* A screenshot of your Media Library in list mode.
* A screenshot of your Site Health under the Tools Section.
* Hosting providers & Plan (AWS, WP-Engine, etc..)
* Multisite environment (subdomain/subdirectory)
* Do you have access to the WP-CLI?
* Screenshot of your General Settings section.

Note that since version 2.7.0, you can use the new system report feature in order to generate all the information above except the screenshots. If you can also add some assets to your report as explained here that could be helpful as well.

Once provided, we will take a deeper look into it on our end, trying to reproduce the issue to better understand the root cause for it.

In case it will be necessary, will you be willing to provide us with temporary access to a sandbox environment of your site where we can take a look and debug if needed?

Thanks in advance.
Best,
Loic

• This reply was modified 4 years, 6 months ago by loic @ cloudinary.

Hi @anebi85,

I am closing this thread since we discussed this matter and found the issue via our ticket system.

Loic

• This reply was modified 4 years, 6 months ago by loic @ cloudinary.

Hi @danielkoch95,

Could you please create a ticket to [email protected] with a system report attached?

Normally, you should only go to Cloudinary > Getting Started > Connect and click on Switch Cloud. From there, you can enter the new URL and it should start syncing the assets to the new cloud.

Thanks in advance.
Best,
Loic

Hi @alfonso100,

Thanks for reaching out.

This code won’t be relevant in our next release so the error won’t occur anymore.

Hope that helps.
Best,
Loic

Hi @prodport,

Glad you found it helpful and that it is now working.

Please let me know if you need anything else.
Best,
Loic