ON DUPLICATE KEY UPDATE

  • disagree

    (@disagree)


    10 years ago

    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)

    9 years, 12 months ago

    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.