Support » Plugin: SQLite Integration » ON DUPLICATE KEY UPDATE fails

  • I have a problem, where SQLite Integration seems not to detect an ‘ON DUPLICATE KEY UPDATE’ correctly and tries to write an INSERT instead of UPDATE statement.

    Anybody out there knows how to fix that?

    Here’s the error thrown:

    Cannot add/save table row; SQL: INSERT INTOwp_pods_testpod(id,name,permalink,modified) VALUES ( 1, ‘1e’, ‘1e’, ‘2016-01-09 17:05:23’ ) ON DUPLICATE KEY UPDATEid= VALUES(id),name= VALUES(name),permalink= VALUES(permalink),modified= VALUES(modified ); Response:

    Queries made or created this session were
    Raw query: INSERT INTO wp_pods_testpod ( id, name, permalink, modified ) VALUES ( 1, ‘1e’, ‘1e’, ‘2016-01-09 17:05:23’ ) ON DUPLICATE KEY UPDATE id = VALUES( id ), name = VALUES( name ), permalink = VALUES( permalink ), modified = VALUES( modified )
    Rewritten: INSERT INTO wp_pods_testpod ( id, name, permalink, modified ) VALUES ( 1, ‘1e’, ‘1e’, ‘2016-01-09 17:05:23’ )
    With Placeholders: INSERT INTO wp_pods_testpod ( id, name, permalink, modified ) VALUES ( 1, :param_0 , :param_1 , :param_2 )
    Prepare: INSERT INTO wp_pods_testpod ( id, name, permalink, modified ) VALUES ( 1, :param_0 , :param_1 , :param_2 )
    Executing: array ( 0 => ‘1e’, 1 => ‘1e’, 2 => ‘2016-01-09 17:05:23’, )
    Error occurred at line 692 in Function execute_query.

    Error occurred at line 692 in Function execute_query.
    Error message was: Error while executing query! Error message was: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: wp_pods_testpod.id

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • +1

    No error thrown, but $wpdb->query returns null.

    query:

    $wpdb->query($wpdb->prepare(
            "INSERT INTO {$wpdb->prefix}h5p_libraries_libraries (library_id, required_library_id, dependency_type)
            SELECT %d, hl.id, %s
            FROM {$wpdb->prefix}h5p_libraries hl
            WHERE name = %s
            AND major_version = %d
            AND minor_version = %d
            ON DUPLICATE KEY UPDATE dependency_type = %s",
            $id, $dependencyType, $dependency['machineName'], $dependency['majorVersion'], $dependency['minorVersion'], $dependencyType)
          );

    Fixed by removing the ON DUPLICATE KEY UPDATE dependency_type = %s", row.

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