• Resolved Daniel Kozina

    (@webcraftersstudio)


    Hello,

    We have a problem with creating tables in our database. An example error is: Failed to create table cssjs! SQL: CREATE TABLE IF NOT EXISTS el_litespeed_cssjs () DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;.

    Best regards,
    Daniel

Viewing 7 replies - 1 through 7 (of 7 total)
  • CREATE TABLE IF NOT EXISTS el_litespeed_cssjs —-> (may not be empty) <—- DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

    Plugin Support qtwrk

    (@qtwrk)

    Hi,

    May I know what is your database and version ?

    Best regards,

    Thread Starter Daniel Kozina

    (@webcraftersstudio)

    Hi,

    This problem is existing on some of my web pages. For example, I have the next error:

    CREATE TABLE IF NOT EXISTS wj_litespeed_img_optming () DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

    My database info:
    innodb_version
    5.7.30-33
    protocol_version
    10
    slave_type_conversions
    tls_version
    TLSv1,TLSv1.1,TLSv1.2
    version
    5.7.30-33
    version_comment
    Source distribution
    version_compile_machine
    x86_64
    version_compile_os
    Linux
    version_suffix

    Thread Starter Daniel Kozina

    (@webcraftersstudio)

    I have this problem when I move the page from localhost. For example my address on localhost: https://xyz.pl and end domain is the same. When I install a new web page with installed LiteSpeed Cache and I try to save some changes in the plugin I have these problems. I checked it a few times.

    Maybe the problem is with my database on Xampp? which coding I should use on Xampp and the final domain?

    Plugin Support qtwrk

    (@qtwrk)

    hmmm

    I don’t know much about XAMPP , but on my cPanel server, DB shows as utf8mb4_unicode_520_ci

    Plugin Support qtwrk

    (@qtwrk)

    Hi,

    I’m going to mark this topic “Resolved”, due to lack of activity.

    If you still need help, please feel free to re-open it.

    When re-open it, please also change the topic status to “not solved”

    Best regards,

    Thread Starter Daniel Kozina

    (@webcraftersstudio)

    Hi,

    I have this issue in some of my projects. I think the problem is with database migration (localhost -> live server). Where I can find SQL create tables instruction for every functionality? (for example: wp_litespeed_cssjs) I will add them manually.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Problem with create tables in database’ is closed to new replies.