I get this install error when I enable this module on Drupal 4.7.2:

 * 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 '.quotes_nid ON drupal.quotes (nid)' at line 1 query: CREATE INDEX drupal.quotes_nid ON drupal.quotes (nid) in /home/drupal/includes/database.mysql.inc on line 120.
    * 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 '.quotes_promote ON drupal.quotes (promote)' at line 1 query: CREATE INDEX drupal.quotes_promote ON drupal.quotes (promote) in /home/drupal/includes/database.mysql.inc on line 120.

Comments

jhriggs’s picture

Status: Active » Closed (fixed)

It looks like you have your $db_prefix set to 'drupal.'. The prefix is designed for prefixing a table name, not specifying a database.