Forum Replies Created

Viewing 9 replies - 1 through 9 (of 9 total)
  • Thread Starter mavillen

    (@mavillen)

    It’s now it works.

    Thread Starter mavillen

    (@mavillen)

    This query executed right in phpMyAdmin!!!

    The table has been created.

    Thread Starter mavillen

    (@mavillen)

    I’m sorry.

    But it throws the same error:

    #1709 – Index column size too large. The maximum column size is 767 bytes.

    Thread Starter mavillen

    (@mavillen)

    Throws this error:

    #1709 – Index column size too large. The maximum column size is 767 bytes.

    Thread Starter mavillen

    (@mavillen)

    big5 Big5 Traditional Chinese big5_chinese_ci 2
    dec8 DEC West European dec8_swedish_ci 1
    cp850 DOS West European cp850_general_ci 1
    hp8 HP West European hp8_english_ci 1
    koi8r KOI8-R Relcom Russian koi8r_general_ci 1
    latin1 cp1252 West European latin1_swedish_ci 1
    latin2 ISO 8859-2 Central European latin2_general_ci 1
    swe7 7bit Swedish swe7_swedish_ci 1
    ascii US ASCII ascii_general_ci 1
    ujis EUC-JP Japanese ujis_japanese_ci 3
    sjis Shift-JIS Japanese sjis_japanese_ci 2
    hebrew ISO 8859-8 Hebrew hebrew_general_ci 1
    tis620 TIS620 Thai tis620_thai_ci 1
    euckr EUC-KR Korean euckr_korean_ci 2
    koi8u KOI8-U Ukrainian koi8u_general_ci 1
    gb2312 GB2312 Simplified Chinese gb2312_chinese_ci 2
    greek ISO 8859-7 Greek greek_general_ci 1
    cp1250 Windows Central European cp1250_general_ci 1
    gbk GBK Simplified Chinese gbk_chinese_ci 2
    latin5 ISO 8859-9 Turkish latin5_turkish_ci 1
    armscii8 ARMSCII-8 Armenian armscii8_general_ci 1
    utf8 UTF-8 Unicode utf8_general_ci 3
    ucs2 UCS-2 Unicode ucs2_general_ci 2
    cp866 DOS Russian cp866_general_ci 1
    keybcs2 DOS Kamenicky Czech-Slovak keybcs2_general_ci 1
    macce Mac Central European macce_general_ci 1
    macroman Mac West European macroman_general_ci 1
    cp852 DOS Central European cp852_general_ci 1
    latin7 ISO 8859-13 Baltic latin7_general_ci 1
    utf8mb4 UTF-8 Unicode utf8mb4_general_ci 4
    cp1251 Windows Cyrillic cp1251_general_ci 1
    utf16 UTF-16 Unicode utf16_general_ci 4
    utf16le UTF-16LE Unicode utf16le_general_ci 4
    cp1256 Windows Arabic cp1256_general_ci 1
    cp1257 Windows Baltic cp1257_general_ci 1
    utf32 UTF-32 Unicode utf32_general_ci 4
    binary Binary pseudo charset binary 1
    geostd8 GEOSTD8 Georgian geostd8_general_ci 1
    cp932 SJIS for Windows Japanese cp932_japanese_ci 2
    eucjpms UJIS for Windows Japanese eucjpms_japanese_ci 3

    • This reply was modified 6 years, 1 month ago by mavillen.
    • This reply was modified 6 years, 1 month ago by mavillen.
    Thread Starter mavillen

    (@mavillen)

    How can I check that?

    Thread Starter mavillen

    (@mavillen)

    Web server:

    PHP Version 7.4

    Database server:

    Server Version: 10.0.38-MariaDB – MariaDB Server
    Protocol: 10

    Thread Starter mavillen

    (@mavillen)

    Another strange thing is that when I press the Gather Image Data button after destroying all optimization data Litespeed creates a new table in the database called wp_litespeed_img_optm but also fails and shows the previous message:

    Failed to create table img_optming! SQL: CREATE TABLE IF NOT EXISTS wp_litespeed_img_optming (id bigint (20) unsigned NOT NULL AUTO_INCREMENT, post_id bigint (20) unsigned NOT NULL DEFAULT ‘0’,optm_status tinyint (4) NOT NULL DEFAULT ‘0 ‘, src varchar (1000) NOT NULL DEFAULT’ ‘,server_info text NOT NULL, PRIMARY KEY (id), KEYpost_id (post_id), KEYoptm_status (optm_status), KEY src (src)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci ;.

    And the optimization process ends.

    Thread Starter mavillen

    (@mavillen)

    I have reviewed the mysql configuration, the database and the user and yes it does have all kinds of permissions to create, delete and modify tables.

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