- 🇦🇺Australia VladimirAus Brisbane, Australia
Thank you for contribution. 👍
Drupal 6 is no longer supported. 🤷♂️
Closing as outdated. 🔐
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?
Closed: outdated
1.5
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Thank you for contribution. 👍
Drupal 6 is no longer supported. 🤷♂️
Closing as outdated. 🔐