I have installed styles 7.x-2.x-dev on a site called "noblerod.de". When i try to manage a nodetyp i get the following message:

"PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'noblerod.styles' doesn't exist: SELECT styles.* FROM {styles} styles ORDER BY name ASC; Array ( ) in styles_default_styles() (Zeile 228 von G:\mowes\www\www.noblerod.de\sites\all\modules\styles\styles.module)."

Comments

sgeets’s picture

sgeets commented

subscribing : due to an error when installing the styles module creating node types fails as the styles table was not created. Apparently the install of the module sets an index on a non existing column 'label'.
In the update_7206 the 'label' column was changed to 'description' column. But due to the missing column the update is never been executed during install.

Apply patch http://drupal.org/node/961646 removing the index and you'll be fine

Install error : PDOException: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'label' doesn't exist in table: CREATE TABLE {styles} ( `sid` INT unsigned NOT NULL auto_increment COMMENT 'The primary identifier for a style.', `field_type` VARCHAR(128) NOT NULL COMMENT 'The field type.', `name` VARCHAR(255) NOT NULL COMMENT 'The style name.', `description` LONGTEXT NOT NULL COMMENT 'The style description.', PRIMARY KEY (`sid`), INDEX `field_type` (`field_type`), INDEX `name` (`name`), INDEX `label` (`label`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'Stores configuration options for styles.'; Array ( ) in db_create_table() (line 2588 of C:\wamp\www\includes\database\database.inc).

aaron’s picture

aaron commented
Status: Active » Fixed

ah, forgot about that issue. should be good now.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.