For all drupal installations where a prefix for the table names has been configured, the {faq} notation has to be used instead of faq everywhere the database is accessed.

I've made following changes to the faq.module file to get the module running on my site using table prefixes:

130c130
< db_query('INSERT INTO faq (fid, weight) VALUES(%d, %d)', $node->nid, $node->weight);
---
> db_query('INSERT INTO {faq} (fid, weight) VALUES(%d, %d)', $node->nid, $node->weight);
137c137
< db_query('UPDATE faq SET weight = %d WHERE fid = %d', $node->weight, $node->nid);
---
> db_query('UPDATE {faq} SET weight = %d WHERE fid = %d', $node->weight, $node->nid);

CommentFileSizeAuthor
faq.module.diff386 bytesrc_phil

Comments

stella’s picture

Assigned: Unassigned » stella
Status: Reviewed & tested by the community » Fixed

fixed and added to CVS.

Cheers,
Stella

stella’s picture

Released in 4.7.x-2.1.

Cheers,
Stella

Anonymous’s picture

Status: Fixed » Closed (fixed)