WordPress.org

Support

Support » Plugins and Hacks » ON DUPLICATE KEY UPDATE

ON DUPLICATE KEY UPDATE

  • Could you add handling for ‘ON DUPLICATE KEY UPDATE’ statements in the PDO class? Currently they simply throw :

    PHP Warning: PDO::prepare(): SQLSTATE[HY000]: General error: 1 near "ON": syntax error in /var/www/wp-content/plugins/sqlite-integration/pdoengine.class.php on line 58x

    The ON statements are used by WordPress e.g. on INSERT INTO wp_options (option_name, option_value, autoload) VALUES ... update_option() calls etc.

    https://wordpress.org/plugins/sqlite-integration/

Viewing 1 replies (of 1 total)
  • Plugin Author kjmtsh

    @kjmtsh

    Hi, Markus

    SQLite Integration can manipulate ‘ON DUPLICATE KEY UPDATE’ statement used by WordPress ( in wp-includes/options.php and wp-inludes/comments.php ). And I couldn’t reproduce the same error.

    Will you let me know the details? Whick version of WordPress and SQLite Integration are you using? Does the error occur when you deactivate all the plugins and use the default theme?

Viewing 1 replies (of 1 total)
  • The topic ‘ON DUPLICATE KEY UPDATE’ is closed to new replies.