PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Database-Problems while activating plugin

  1. Hi,

    got a lot of database-errors after installation an while activating the plugin:

    CREATE TABLE wp_rg_form ( id mediumint(8) unsigned not null auto_increment, title varchar(150) not null, date_created datetime not null, is_active tinyint(1) not null default 1, PRIMARY KEY (id) ) DEFAULT CHARACTER SET utf8 COLLATE utf8

    WordPress database error: [Unknown collation: 'utf8']
    CREATE TABLE wp_rg_form_meta ( form_id mediumint(8) unsigned not null, display_meta longtext, entries_grid_meta longtext, PRIMARY KEY (form_id) ) DEFAULT CHARACTER SET utf8 COLLATE utf8

    WordPress database error: [Table 'db1156263-ergotherapie.wp_rg_form_meta' doesn't exist]
    SHOW INDEX FROM wp_rg_form_meta WHERE Key_name='form_id'

    WordPress database error: [Unknown collation: 'utf8']
    CREATE TABLE wp_rg_form_view ( id bigint(20) unsigned not null auto_increment, form_id mediumint(8) unsigned not null, date_created datetime not null, ip char(15), count mediumint(8) unsigned not null default 1, PRIMARY KEY (id), KEY form_id (form_id) ) DEFAULT CHARACTER SET utf8 COLLATE utf8

    WordPress database error: [Unknown collation: 'utf8']
    CREATE TABLE wp_rg_lead ( id int(10) unsigned not null auto_increment, form_id mediumint(8) unsigned not null, post_id bigint(20) unsigned, date_created datetime not null, is_starred tinyint(1) not null default 0, is_read tinyint(1) not null default 0, ip varchar(39) not null, source_url varchar(200) not null default '', user_agent varchar(250) not null default '', currency varchar(5), payment_status varchar(15), payment_date datetime, payment_amount decimal(19,2), transaction_id varchar(50), is_fulfilled tinyint(1), created_by bigint(20) unsigned, transaction_type tinyint(1), status varchar(20) not null default 'active', PRIMARY KEY (id), KEY form_id (form_id), KEY status (status) ) DEFAULT CHARACTER SET utf8 COLLATE utf8

    WordPress database error: [Unknown collation: 'utf8']
    CREATE TABLE wp_rg_lead_notes ( id int(10) unsigned not null auto_increment, lead_id int(10) unsigned not null, user_name varchar(250), user_id bigint(20), date_created datetime not null, value longtext, PRIMARY KEY (id), KEY lead_id (lead_id), KEY lead_user_key (lead_id,user_id) ) DEFAULT CHARACTER SET utf8 COLLATE utf8

    WordPress database error: [Unknown collation: 'utf8']
    CREATE TABLE wp_rg_lead_detail ( id bigint(20) unsigned not null auto_increment, lead_id int(10) unsigned not null, form_id mediumint(8) unsigned not null, field_number float not null, value varchar(200), PRIMARY KEY (id), KEY form_id (form_id), KEY lead_id (lead_id) ) DEFAULT CHARACTER SET utf8 COLLATE utf8

    WordPress database error: [Unknown collation: 'utf8']
    CREATE TABLE wp_rg_lead_detail_long ( lead_detail_id bigint(20) unsigned not null, value longtext, PRIMARY KEY (lead_detail_id) ) DEFAULT CHARACTER SET utf8 COLLATE utf8

    WordPress database error: [Table 'db1156263-ergotherapie.wp_rg_lead_detail_long' doesn't exist]
    SHOW INDEX FROM wp_rg_lead_detail_long WHERE Key_name='lead_detail_key'

    WordPress database error: [Unknown collation: 'utf8']
    CREATE TABLE wp_rg_lead_meta ( id bigint(20) unsigned not null auto_increment, lead_id bigint(20) unsigned not null, meta_key varchar(255), meta_value longtext, PRIMARY KEY (id), KEY meta_key (meta_key), KEY lead_id (lead_id) ) DEFAULT CHARACTER SET utf8 COLLATE utf8

    WordPress database error: [Table 'db1156263-ergotherapie.wp_rg_lead_detail' doesn't exist]
    select * from wp_rg_lead_detail where value= '!'

    Thats bad :(....

    Posted 11 years ago on Monday July 2, 2012 | Permalink
  2. Do you have access to phpMyAdmin and are you comfortable issuing SQL commands there? This is a MySQL configuration issue, and we need to get to the bottom of it. You might also need assistance from your host.

    Thanks.

    Posted 11 years ago on Monday July 2, 2012 | Permalink
  3. Hi,

    yes I do. But that's not the "customer-friendly-way" :( ...

    G,
    Jan

    Posted 11 years ago on Monday July 2, 2012 | Permalink
  4. This is not really an issue with Gravity Forms. It's a database issue and the first time I've seen in reported in these forums. We would love to help you resolve it. You can contact your host and see about the utf8 collation missing in you configuration, but I would also be happy to help you issue a few non-destructive commands in phpMyAdmin to determine the source of the problem. We are not going to touch your database and risk damaging your installation.

    You might want to contact your host about this MySQL error:

    #1273 - Unknown collation: 'utf8'

    It's possible you just have an old version of MySQL. That is one of the things we would use phpMyAdmin for.

    Posted 11 years ago on Monday July 2, 2012 | Permalink
  5. If you'd like to begin troubleshooting this yourself, please open phpMyAdmin and issue these two non-destructive commands separately:

    SHOW VARIABLES LIKE "%version%";
    SHOW COLLATION;

    Please post the information here once you have it.

    Posted 11 years ago on Monday July 2, 2012 | Permalink
  6. Hi,

    ISP says: "utf8 isn't a valid collation. The collations, which have an encoding-name included have supplementary components, in this case may be 'utf8_general_ci'. Further information can be found at http://dev.mysql.com/doc/refman/5.0/en/charset-collations.html or http://forum.mysqldumper.de/die-umlautproblematik-was-wieso-was-tun-t2313.html {german}".

    Results to your queries:

    1. SHOW VARIABLES LIKE "%version%";
    protocol_version 10
    slave_type_conversions
    version 5.5.25-1~dotdeb.0-log
    version_comment (Debian)
    version_compile_machine x86_64
    version_compile_os debian-linux-gnu

    2. SHOW COLLATION;

    big5_chinese_ci big5 1 Yes Yes 1
    big5_bin big5 84 Yes 1
    dec8_swedish_ci dec8 3 Yes Yes 1
    dec8_bin dec8 69 Yes 1
    cp850_general_ci cp850 4 Yes Yes 1
    cp850_bin cp850 80 Yes 1
    hp8_english_ci hp8 6 Yes Yes 1
    hp8_bin hp8 72 Yes 1
    koi8r_general_ci koi8r 7 Yes Yes 1
    koi8r_bin koi8r 74 Yes 1
    latin1_german1_ci latin1 5 Yes 1
    latin1_swedish_ci latin1 8 Yes Yes 1
    latin1_danish_ci latin1 15 Yes 1
    latin1_german2_ci latin1 31 Yes 2
    latin1_bin latin1 47 Yes 1
    latin1_general_ci latin1 48 Yes 1
    latin1_general_cs latin1 49 Yes 1
    latin1_spanish_ci latin1 94 Yes 1
    latin2_czech_cs latin2 2 Yes 4
    latin2_general_ci latin2 9 Yes Yes 1
    latin2_hungarian_ci latin2 21 Yes 1
    latin2_croatian_ci latin2 27 Yes 1
    latin2_bin latin2 77 Yes 1
    swe7_swedish_ci swe7 10 Yes Yes 1
    swe7_bin swe7 82 Yes 1
    ascii_general_ci ascii 11 Yes Yes 1
    ascii_bin ascii 65 Yes 1
    ujis_japanese_ci ujis 12 Yes Yes 1
    ujis_bin ujis 91 Yes 1
    sjis_japanese_ci sjis 13 Yes Yes 1
    sjis_bin sjis 88 Yes 1
    hebrew_general_ci hebrew 16 Yes Yes 1
    hebrew_bin hebrew 71 Yes 1
    tis620_thai_ci tis620 18 Yes Yes 4
    tis620_bin tis620 89 Yes 1
    euckr_korean_ci euckr 19 Yes Yes 1
    euckr_bin euckr 85 Yes 1
    koi8u_general_ci koi8u 22 Yes Yes 1
    koi8u_bin koi8u 75 Yes 1
    gb2312_chinese_ci gb2312 24 Yes Yes 1
    gb2312_bin gb2312 86 Yes 1
    greek_general_ci greek 25 Yes Yes 1
    greek_bin greek 70 Yes 1
    cp1250_general_ci cp1250 26 Yes Yes 1
    cp1250_czech_cs cp1250 34 Yes 2
    cp1250_croatian_ci cp1250 44 Yes 1
    cp1250_bin cp1250 66 Yes 1
    cp1250_polish_ci cp1250 99 Yes 1
    gbk_chinese_ci gbk 28 Yes Yes 1
    gbk_bin gbk 87 Yes 1
    latin5_turkish_ci latin5 30 Yes Yes 1
    latin5_bin latin5 78 Yes 1
    armscii8_general_ci armscii8 32 Yes Yes 1
    armscii8_bin armscii8 64 Yes 1
    utf8_general_ci utf8 33 Yes Yes 1
    utf8_bin utf8 83 Yes 1
    utf8_unicode_ci utf8 192 Yes 8
    utf8_icelandic_ci utf8 193 Yes 8
    utf8_latvian_ci utf8 194 Yes 8
    utf8_romanian_ci utf8 195 Yes 8
    utf8_slovenian_ci utf8 196 Yes 8
    utf8_polish_ci utf8 197 Yes 8
    utf8_estonian_ci utf8 198 Yes 8
    utf8_spanish_ci utf8 199 Yes 8
    utf8_swedish_ci utf8 200 Yes 8
    utf8_turkish_ci utf8 201 Yes 8
    utf8_czech_ci utf8 202 Yes 8
    utf8_danish_ci utf8 203 Yes 8
    utf8_lithuanian_ci utf8 204 Yes 8
    utf8_slovak_ci utf8 205 Yes 8
    utf8_spanish2_ci utf8 206 Yes 8
    utf8_roman_ci utf8 207 Yes 8
    utf8_persian_ci utf8 208 Yes 8
    utf8_esperanto_ci utf8 209 Yes 8
    utf8_hungarian_ci utf8 210 Yes 8
    utf8_sinhala_ci utf8 211 Yes 8
    utf8_general_mysql500_ci utf8 223 Yes 1
    ucs2_general_ci ucs2 35 Yes Yes 1
    ucs2_bin ucs2 90 Yes 1
    ucs2_unicode_ci ucs2 128 Yes 8
    ucs2_icelandic_ci ucs2 129 Yes 8
    ucs2_latvian_ci ucs2 130 Yes 8
    ucs2_romanian_ci ucs2 131 Yes 8
    ucs2_slovenian_ci ucs2 132 Yes 8
    ucs2_polish_ci ucs2 133 Yes 8
    ucs2_estonian_ci ucs2 134 Yes 8
    ucs2_spanish_ci ucs2 135 Yes 8
    ucs2_swedish_ci ucs2 136 Yes 8
    ucs2_turkish_ci ucs2 137 Yes 8
    ucs2_czech_ci ucs2 138 Yes 8
    ucs2_danish_ci ucs2 139 Yes 8
    ucs2_lithuanian_ci ucs2 140 Yes 8
    ucs2_slovak_ci ucs2 141 Yes 8
    ucs2_spanish2_ci ucs2 142 Yes 8
    ucs2_roman_ci ucs2 143 Yes 8
    ucs2_persian_ci ucs2 144 Yes 8
    ucs2_esperanto_ci ucs2 145 Yes 8
    ucs2_hungarian_ci ucs2 146 Yes 8
    ucs2_sinhala_ci ucs2 147 Yes 8
    ucs2_general_mysql500_ci ucs2 159 Yes 1
    Collation Charset Id Default Compiled Sortlen
    cp866_general_ci cp866 36 Yes Yes 1
    cp866_bin cp866 68 Yes 1
    keybcs2_general_ci keybcs2 37 Yes Yes 1
    keybcs2_bin keybcs2 73 Yes 1
    macce_general_ci macce 38 Yes Yes 1
    macce_bin macce 43 Yes 1
    macroman_general_ci macroman 39 Yes Yes 1
    macroman_bin macroman 53 Yes 1
    cp852_general_ci cp852 40 Yes Yes 1
    cp852_bin cp852 81 Yes 1
    latin7_estonian_cs latin7 20 Yes 1
    latin7_general_ci latin7 41 Yes Yes 1
    latin7_general_cs latin7 42 Yes 1
    latin7_bin latin7 79 Yes 1
    utf8mb4_general_ci utf8mb4 45 Yes Yes 1
    utf8mb4_bin utf8mb4 46 Yes 1
    utf8mb4_unicode_ci utf8mb4 224 Yes 8
    utf8mb4_icelandic_ci utf8mb4 225 Yes 8
    utf8mb4_latvian_ci utf8mb4 226 Yes 8
    utf8mb4_romanian_ci utf8mb4 227 Yes 8
    utf8mb4_slovenian_ci utf8mb4 228 Yes 8
    utf8mb4_polish_ci utf8mb4 229 Yes 8
    utf8mb4_estonian_ci utf8mb4 230 Yes 8
    utf8mb4_spanish_ci utf8mb4 231 Yes 8
    utf8mb4_swedish_ci utf8mb4 232 Yes 8
    utf8mb4_turkish_ci utf8mb4 233 Yes 8
    utf8mb4_czech_ci utf8mb4 234 Yes 8
    utf8mb4_danish_ci utf8mb4 235 Yes 8
    utf8mb4_lithuanian_ci utf8mb4 236 Yes 8
    utf8mb4_slovak_ci utf8mb4 237 Yes 8
    utf8mb4_spanish2_ci utf8mb4 238 Yes 8
    utf8mb4_roman_ci utf8mb4 239 Yes 8
    utf8mb4_persian_ci utf8mb4 240 Yes 8
    utf8mb4_esperanto_ci utf8mb4 241 Yes 8
    utf8mb4_hungarian_ci utf8mb4 242 Yes 8
    utf8mb4_sinhala_ci utf8mb4 243 Yes 8
    cp1251_bulgarian_ci cp1251 14 Yes 1
    cp1251_ukrainian_ci cp1251 23 Yes 1
    cp1251_bin cp1251 50 Yes 1
    cp1251_general_ci cp1251 51 Yes Yes 1
    cp1251_general_cs cp1251 52 Yes 1
    utf16_general_ci utf16 54 Yes Yes 1
    utf16_bin utf16 55 Yes 1
    utf16_unicode_ci utf16 101 Yes 8
    utf16_icelandic_ci utf16 102 Yes 8
    utf16_latvian_ci utf16 103 Yes 8
    utf16_romanian_ci utf16 104 Yes 8
    utf16_slovenian_ci utf16 105 Yes 8
    utf16_polish_ci utf16 106 Yes 8
    utf16_estonian_ci utf16 107 Yes 8
    utf16_spanish_ci utf16 108 Yes 8
    utf16_swedish_ci utf16 109 Yes 8
    utf16_turkish_ci utf16 110 Yes 8
    utf16_czech_ci utf16 111 Yes 8
    utf16_danish_ci utf16 112 Yes 8
    utf16_lithuanian_ci utf16 113 Yes 8
    utf16_slovak_ci utf16 114 Yes 8
    utf16_spanish2_ci utf16 115 Yes 8
    utf16_roman_ci utf16 116 Yes 8
    utf16_persian_ci utf16 117 Yes 8
    utf16_esperanto_ci utf16 118 Yes 8
    utf16_hungarian_ci utf16 119 Yes 8
    utf16_sinhala_ci utf16 120 Yes 8
    cp1256_general_ci cp1256 57 Yes Yes 1
    cp1256_bin cp1256 67 Yes 1
    cp1257_lithuanian_ci cp1257 29 Yes 1
    cp1257_bin cp1257 58 Yes 1
    cp1257_general_ci cp1257 59 Yes Yes 1
    utf32_general_ci utf32 60 Yes Yes 1
    utf32_bin utf32 61 Yes 1
    utf32_unicode_ci utf32 160 Yes 8
    utf32_icelandic_ci utf32 161 Yes 8
    utf32_latvian_ci utf32 162 Yes 8
    utf32_romanian_ci utf32 163 Yes 8
    utf32_slovenian_ci utf32 164 Yes 8
    utf32_polish_ci utf32 165 Yes 8
    utf32_estonian_ci utf32 166 Yes 8
    utf32_spanish_ci utf32 167 Yes 8
    utf32_swedish_ci utf32 168 Yes 8
    utf32_turkish_ci utf32 169 Yes 8
    utf32_czech_ci utf32 170 Yes 8
    utf32_danish_ci utf32 171 Yes 8
    utf32_lithuanian_ci utf32 172 Yes 8
    utf32_slovak_ci utf32 173 Yes 8
    utf32_spanish2_ci utf32 174 Yes 8
    utf32_roman_ci utf32 175 Yes 8
    utf32_persian_ci utf32 176 Yes 8
    utf32_esperanto_ci utf32 177 Yes 8
    utf32_hungarian_ci utf32 178 Yes 8
    utf32_sinhala_ci utf32 179 Yes 8
    binary binary 63 Yes Yes 1
    geostd8_general_ci geostd8 92 Yes Yes 1
    geostd8_bin geostd8 93 Yes 1
    cp932_japanese_ci cp932 95 Yes Yes 1
    cp932_bin cp932 96 Yes 1
    eucjpms_japanese_ci eucjpms 97 Yes Yes 1
    eucjpms_bin eucjpms 98 Yes 1

    Thx,
    Jan

    Posted 11 years ago on Thursday July 5, 2012 | Permalink
  7. Hello Jan,
    I believe the problem is in your wp-config.php file. Gravity Forms tries to create its tables using the character set and collation specified in your wp-config.php file, and it looks like you have "utf8" specified in the collation variable instead of your character set variable.
    Try changing your variables to the following and let me know if the issue persists

    /** Database Charset to use in creating database tables. */
    define('DB_CHARSET', 'utf8');
    
    /** The Database Collate type. */
    define('DB_COLLATE', '');
    Posted 11 years ago on Thursday July 5, 2012 | Permalink
  8. That's it! Thank you!

    Posted 11 years ago on Friday July 6, 2012 | Permalink

This topic has been resolved and has been closed to new replies.