free tagging errors

Created on 26 April 2006, about 19 years ago
Updated 27 June 2025, 10 days ago

In 4.7 RC2 and RC3, I created a vocabulary to support free tagging.
I created a node and typed in my new tag and received an error. In the error code provided, I used a non-free tagging term and the new one "Common Japanese Difficulties" which, as you can see, is not working.

I guess the text:
AND td.tid IN (45,Common Japanese Difficulties)
should either be a number or in quotes.

user warning: 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 'Japanese Difficulties) AND th.tid IS NULL' at line 1 query: SELECT DISTINCT td.tid FROM term_data td LEFT JOIN term_hierarchy th on td.tid = th.parent WHERE td.vid IN (1) AND td.tid IN (45,Common Japanese Difficulties) AND th.tid IS NULL in C:\server\drupal\www\includes\database.mysql.inc on line 120.

Here is the referenced code plus some line numbers on the left...

/**
 * Helper function for db_query().
 */
93: function _db_query($query, $debug = 0) {
  global $active_db, $queries;

  if (variable_get('dev_query', 0)) {
    list($usec, $sec) = explode(' ', microtime());
    $timer = (float)$usec + (float)$sec;
  }

101:  $result = mysql_query($query, $active_db);

  if (variable_get('dev_query', 0)) {
    $bt = debug_backtrace();
    $query = $bt[2]['function'] . "\n" . $query;
    list($usec, $sec) = explode(' ', microtime());
    $stop = (float)$usec + (float)$sec;
    $diff = $stop - $timer;
    $queries[] = array($query, $diff);
  }

  if ($debug) {
    print '<p>query: '. $query .'<br />error:'. mysql_error($active_db) .'</p>';
  }

  if (!mysql_errno($active_db)) {
    return $result;
  }
  else {
120:    trigger_error(check_plain(mysql_error($active_db) ."\nquery: ". $query), E_USER_WARNING);
    return FALSE;
  }
}

any advice?

Feature request
Status

Closed: outdated

Version

1.5

Component

Code

Created by

🇨🇦Canada myriad

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024