Prefixes are needed on shared hosting, because the number of databases is restricted.
Drupal parses sql requests and adds the current prefix when needed, but Drupal needs to know when this needs to be done: every time a table name is written within brackets. A table name should therefore never be used "as is", like "node", but always between brackets, like "{node}".
Line 80 reads
$result = db_query("SELECT COUNT(*) FROM {node} LEFT JOIN {content_type_story} ON node.vid = content_type_story.vid WHERE node.type = 'story' AND content_type_story.field_extended_status_value = '%s'", $value);
it should read instead
$result = db_query("SELECT COUNT(*) FROM {node} LEFT JOIN {content_type_story} ON {node}.vid = {content_type_story}.vid WHERE {node}.type = 'story' AND {content_type_story}.field_extended_status_value = '%s'", $value);
Line 90 reads
$result = db_query("SELECT COUNT(*) FROM {node} WHERE node.type = 'story'");
it should read instead
$result = db_query("SELECT COUNT(*) FROM {node} WHERE {node}.type = 'story'");
I have done the changes on my installation, and it does work fine. If the correction could be delivered in a future patch, this would be great. I guess there are more places to look at.
SQL error in pp.admin.inc when prefixes are used.
Prefixes are needed on shared hosting, because the number of databases is restricted.
Drupal parses sql requests and adds the current prefix when needed, but Drupal needs to know when this needs to be done: every time a table name is written within brackets. A table name should therefore never be used "as is", like "node", but always between brackets, like "{node}".
Line 80 reads type_story} ON node.vid = content_ type_story. vid WHERE node.type = 'story' AND content_ type_story. field_extended_ status_ value = '%s'", $value);
$result = db_query("SELECT COUNT(*) FROM {node} LEFT JOIN {content_
it should read instead type_story} ON {node}.vid = {content_ type_story} .vid WHERE {node}.type = 'story' AND {content_ type_story} .field_ extended_ status_ value = '%s'", $value);
$result = db_query("SELECT COUNT(*) FROM {node} LEFT JOIN {content_
Line 90 reads
$result = db_query("SELECT COUNT(*) FROM {node} WHERE node.type = 'story'");
it should read instead
$result = db_query("SELECT COUNT(*) FROM {node} WHERE {node}.type = 'story'");
I have done the changes on my installation, and it does work fine. If the correction could be delivered in a future patch, this would be great. I guess there are more places to look at.