WordPress.org

Forums

SQLite Integration
ON DUPLICATE KEY UPDATE (2 posts)

  1. Markus Stefanko
    Member
    Posted 1 year 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 1 year 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?

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • SQLite Integration
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic