WordPress.org

Ready to get started?Download WordPress

Forums

SQLite Integration
ON DUPLICATE KEY UPDATE (2 posts)

  1. Markus Stefanko
    Member
    Posted 10 months 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/

  2. kjmtsh
    Member
    Plugin Author

    Posted 10 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?

Reply

You must log in to post.

About this Plugin

About this Topic