I installed the module but I have this error whenever the block load:

* user warning: Table 'site_table.quotes' doesn't exist query: SELECT q.author AS quotes_author, q.citation AS quotes_citation, q.promote AS quotes_promote FROM quotes q WHERE q.vid = 169 in /home/site.com/includes/database.mysql.inc on line 172.
* user warning: Table 'site_table.quotes' doesn't exist query: UPDATE quotes SET author = '', citation = '', promote = 1 WHERE nid = 169 AND vid = 169 in /home/site.com/includes/database.mysql.inc on line 172.
* user warning: Table 'site_table.quotes' doesn't exist query: SELECT COUNT(*) FROM quotes q INNER JOIN node n USING(vid) WHERE n.status=1 AND n.type='quotes' AND q.promote = 1 AND 1=1 in /home/site.com/includes/database.mysql.inc on line 172.

What is the problem?

Comments

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Active » Postponed (maintainer needs more info)

You had to have had errors when you installed. This indicates that the tables did not get built correctly (or at all). Do you see a "quotes" table in your database? How about "quotes_blocks"?

My first suggestion is to disable and uninstall the module, then re-install it and pay attention to the messages that come out at the top of the page.

Which version of Drupal, PHP, and MySql (or PostGres) are you using?

vkams’s picture

vkams commented

I've got the same error in Drupal 5.7 on localhost (MySQL 4.1.16-max).
quotes_blocks are present in MySQL, but quotes are not.
After turning the module on I've seen the message:

* 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 'UNSIGNED, vid INTEGER NOT NULL UNSIGNED PRIMARY KEY, author ' at line 2 query: CREATE TABLE quotes ( nid INTEGER NOT NULL UNSIGNED, vid INTEGER NOT NULL UNSIGNED PRIMARY KEY, author VARCHAR(255) NOT NULL, citation VARCHAR(255), promote INTEGER UNSIGNED NOT NULL DEFAULT 0 ) /*!40100 DEFAULT CHARACTER SET utf8 */ in z:\home\dp\www\includes\database.mysql.inc on line 172.
* user warning: Table 'dp5.quotes' doesn't exist query: CREATE INDEX quotes_nid ON quotes (nid) in z:\home\dp\www\includes\database.mysql.inc on line 172.
* user warning: Table 'dp5.quotes' doesn't exist query: CREATE INDEX quotes_promote ON quotes (promote) in z:\home\dp\www\includes\database.mysql.inc on line 172.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Postponed (maintainer needs more info) » Closed (duplicate)

http://drupal.org/node/244082