SQL Error on Weight Setting Tabs [#135442]

I selected one category to set weight for and this comes up:

user warning: Table 'kappabeta.faq_weights' doesn't exist query: SELECT n.nid, n.title, if((w.weight IS NULL), 0, w.weight) as weight FROM node n LEFT JOIN node_revisions r ON r.nid = n.nid AND r.vid = n.vid INNER JOIN term_node tn ON n.nid = tn.nid LEFT JOIN faq_weights w ON n.nid = w.nid AND w.tid = 28 WHERE n.type='faq' AND n.status = 1 AND tn.tid = 28 ORDER BY w.weight ASC, n.sticky DESC, n.created DESC in C:\www\drupal\includes\database.mysql.inc on line 172.

Comments

Comment #1

nancydru

she/her/hers

English

Boston

commented 11 April 2007 at 16:11

The install function does not create a "xxx.faq_weights" table and the uninstall function does not delete any such tables.

Comment #2

nancydru

she/her/hers

English

Boston

commented 11 April 2007 at 16:19

More:
1) I cannot display any category now; not even the ones other than the one I tried to change.

2) Using the prefix that you chose is probably going to prevent me from going live because my test site (from which the table name appears to be derived) and live sites are named differently.

I can live without this feature, but don't know how to reset my attempt to try it.