WordPress database error

[wpdeveloper]

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( meta_id bigint(20) unsigned NOT NULL auto_increment, term_id bigint(20) un' at line 1]
CREATE TABLE ( meta_id bigint(20) unsigned NOT NULL auto_increment, term_id bigint(20) unsigned NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY term_id (term_id), KEY meta_key (meta_key(191)) ) DEFAULT CHARACTER SET utf8

[dd32]

Hi @wpdeveloper and welcome to Trac!

Where did you see this error? During install? Upgrade?

Are you running any Database dropins? (wp-content/db.php)

[boonebgorges]

@dd32 Is there precedent for shimming support for new tables into database dropins? For example, what if someplace like wp_set_wpdb_vars(), we did something like:

if ( ! in_array( 'termmeta', $wpdb->tables ) ) {
    $wpdb->tables[] = 'termmeta';
}

[dd32]

Database dropins are supposed to extend wpdb so that they inherit this stuff, it kind of surprised me to see $wpdb->field_types in wp_set_wpdb_vars().

We've had issues in the past with db dropins and updated versions relying upon new methods/etc, and the answer then was "extend wpdb!", so I'd rather not do anything here until we're sure of why it's been hit.

[jorbin]

@wpdeveloper Thanks for the ticket. Can you please provide the additional information that @dd32 requested above?

[dd32]

Without further details to go on, and no other reports I'm marking this as invalid for now. You may re-open this with steps on how to reproduce at any time.