PDOException: SQLSTATE[42000]: Syntax error or access violation:

It looks like this is a bug in core DB, there is this bit in the query that that is wrong. However, it would be good to see what triggered this to fix the trigger here and then pass it along into the core queue to fix that too!

What was the machine name of the new content type? This should be the only thing that differs between the core content types and the new content types.

I tried with "did_you_know_" and I couldn't replicate the error.

What version of Drupal are you using? Any other access or search related modules installed?

And trying a machine name of didyouknow would be an interesting test if you have time.

Cheers

Cool, I've got these, so you can remove the above files if you can / want. I'll look at setting up a test site tonight.

Installed, tested and I can not replicate this issue!

Can you write down step by step how to get the error?

I ran tests as user = 0, user = 1 and another user (uid = ?), searches.

Also, what version of MySQL / PHP are you using?

This was a strange core bug, from memory there is a preg_replace() or something similar in the core DB code, so there is a error there!

Right, I'll push through a new release soon, but changing the code from:

    $excluded_content_types = array();
    foreach (search_config_content_types() as $type => $label) {
      if (!user_access("search $type content")) {
        $excluded_content_types[] = $type;
      }
    }

    // This is the valid DB code that breaks the query
    if (!empty($excluded_content_types)) {
      $query->condition($node . '.type', array($excluded_content_types), 'NOT IN');
    }

to this resolved it!

    $excluded_content_types = array();
    foreach (search_config_content_types() as $type => $label) {
      if (!user_access("search $type content")) {
        $excluded_content_types[] = $type;
      }
    }

    // A core bug results in a DB error if we use the following: Ref: #1210072
    // $query->condition($node . '.type', array($excluded_content_types), 'NOT IN');
    if (!empty($excluded_content_types)) {
      $db_and = db_and();
      foreach ($excluded_content_types as $type) {
        $db_and->condition($node . '.type', $type, '!=');
      }
      $query->condition($db_and);
    }

Stranger still, the rewrite happens a number of times successfully before failing! Thanks for the time you spent helping track this bug!

cheers
Alan

The new release has been published. Reopen if you have any more issues

Hi All,

I have this query. don't know why this query gives an error.

$form_state['values']['uid'] = 2;
$pfid->pfid = 3;
$key = SVTgikKQVSoimianTHBXGZ5vDXXa8_JAI1MiR5kHtsg;

$and = db_and()->condition('uid', $form_state['values']['uid'])->condition('pfid', $pfid->pfid)->condition('key', $key);
db_delete('uc_file_users')->condition($and)->execute();

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key = '\'SVTgikKQVSoimianTHBXGZ5vDXXa8_JAI1MiR5kHtsg\'') )' at line 1: DELETE FROM {uc_file_users} WHERE ( (uid = :db_condition_placeholder_0) AND (pfid = :db_condition_placeholder_1) AND (key = :db_condition_placeholder_2) ); Array ( [:db_condition_placeholder_0] => 2 [:db_condition_placeholder_1] => 3 [:db_condition_placeholder_2] => 'SVTgikKQVSoimianTHBXGZ5vDXXa8_JAI1MiR5kHtsg' ) in project_licenses_remove_submit() (line 821 of ......

Please Help me.

Try the forums for misc coding questions.