The delimiters for the table name are wrong in the install script.

Lines 9-14:

      $result = db_query("
        CREATE TABLE IF NOT EXISTS {feedback_pages} (
        name VARCHAR(32) NOT NULL PRIMARY KEY,
        data LONGTEXT
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

Should read:

      $result = db_query("
        CREATE TABLE IF NOT EXISTS `feedback_pages` (
        name VARCHAR(32) NOT NULL PRIMARY KEY,
        data LONGTEXT
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

Note there is similar delimiters in the pgsql lines 16-20, but I'm not sure if it has different syntax.

Comments

kbahey’s picture

Status: Active » Closed (works as designed)

Joe,

This is needed for prefixes to work correctly, for example when you have multisite with one database.

Did you try it and it fail on you?