database error message

  • Resolved Michael

    (@alchymyth)


    9 years, 9 months ago

    after upgrading to version 2.0.1 I get this error message:

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘unsigned auto_increment’ at line 1]
    ALTER TABLE wp_snippets CHANGE COLUMN id id bigint(20) not null unsigned auto_increment

    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_snippets ADD PRIMARY KEY (id)

    https://www.ads-software.com/plugins/code-snippets/

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

  • same here..

    Steven

    (@shazahm1hotmailcom)

    I have the Query Monitor plugin installed on my dev site and when updating to 2.0.1 Query Monitor shows these two error messages:

    Query:

    ALTER TABLE wp_snippets CHANGE COLUMN id id bigint(20) not null unsigned auto_incremen

    Call Stack:

    create_code_snippets_tables()
code_snippets_upgrader()
do_action('plugins_loaded')

    Component:

    Plugin: code-snippets

    Error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unsigned auto_increment' at line 1

    Query:

    ALTER TABLE wp_snippets ADD PRIMARY KEY (id)

    Call Stack:

    create_code_snippets_tables()
code_snippets_upgrader()
do_action('plugins_loaded')

    Component:

    Plugin: code-snippets

    Error:

    Multiple primary key defined

    Plugin Author Shea Bunge

    (@bungeshea)

    This should be fixed in version 2.0.2. Sorry for the oversight.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘database error message’ is closed to new replies.