Hello,

I get this type of error after FAQ installation

http://myserver/dupalpath/faq

user warning: Table 'dbname.faq_weights' doesn't exist query: SELECT n.title, n.nid, r.body, r.teaser, r.format FROM node n LEFT JOIN node_revisions r ON n.nid = r.nid AND r.vid = n.vid LEFT JOIN faq_weights w ON w.nid = n.nid WHERE n.type='faq' AND n.status = 1 AND w.tid = 0 ORDER BY w.weight, n.sticky DESC, n.created DESC in ....../includes/database.mysql.inc on line 172.

FAQ entries has not listed also.

There is no faq.mysql in archive so I can't create tables myself. I've ran update.php, and nothing has changed.
Please help.

faq-5.x-2.0
drupal-5.1
path to module: ..../drupalpath/sites/all/modules/faq

Comments

stella’s picture

stella commented
Assigned: Unassigned » stella
Status: Active » Closed (duplicate)

Some files that should have been released in 5.x-2.0, including the update for generating that table, got left out of the release tarball. Please use faq 5.x-2.1 and run update.php.

As a side note, there is no faq.mysql file in drupal 5.x modules. Instead the sql is added using functions in faq.install but you don't need to know this. You just need to run http://www.example.com/update.php each time you update the modules on your drupal site.

Marking as a duplicate of #135442.

Stella

forpost’s picture

forpost commented

Thank you very much.
I see SQL CREATE request has added to module code in 5.x-2.0 and everything working fine now.

forpost’s picture

forpost commented

I mean SQL query has been added in 2.1 version. 2.0 is missing that part of code.