Sql error

  • NAROLLES

    (@narolles)


    5 months, 3 weeks ago

    Hello,

    When activating WP-Polls, I noticed an SQL error in the logs:

    WordPress database error Invalid default value for 'pollq_id' for query ALTER TABLE wp_pollsq ALTER COLUMN pollq_id SET DEFAULT ''

    The issue is that the plugin tries to set DEFAULT '' on an AUTO_INCREMENT column.
    However, in MySQL/MariaDB, an AUTO_INCREMENT column cannot have a default value.

    The correct definition should be:

    pollq_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY

    without a DEFAULT.

    This does not break functionality if the tables are already created correctly, but it clutters the error logs and may block installation on some environments.

    Please consider fixing this in a future release.

    Best regards,

    The page I need help with: [log in to see the link]

You must be logged in to reply to this topic.