Hi,

I am in real trouble while Enabling 'Fusion Apply' module on my website www.firmaroning.dk/brk

As soon as I have activated I got following error message. At the moment I am unable to perform any action:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'firmaroning_dk.fusion_apply_skins' doesn't exist: SELECT s.sid AS sid FROM {fusion_apply_skins} s WHERE (theme = :db_condition_placeholder_0) AND (module = :db_condition_placeholder_1) AND (element IN (:db_condition_placeholder_2)) AND (status = :db_condition_placeholder_3) ; Array ( [:db_condition_placeholder_0] => metropolis [:db_condition_placeholder_1] => block [:db_condition_placeholder_2] => system__help [:db_condition_placeholder_3] => 1 ) in fusion_apply_skin_get_sids() (line 631 of /customers/f/9/4/firmaroning.dk/httpd.www/brk/sites/all/modules/fusion_accelerator/fusion_apply/fusion_apply.module).
The website encountered an unexpected error. Please try again later.

Comments

aquariumtap’s picture

aquariumtap commented
Status: Active » Postponed (maintainer needs more info)

Does the table fusion_apply_skins exist in your database?

monsoon’s picture

monsoon commented
Status: Postponed (maintainer needs more info) » Active

Thanks for quick response.

fusion_apply_skins does not exist, I have just checked.

Any suggestion :)

I encountered similar problem with previous installation then had to discard it altogether. Now same problem again :(

aquariumtap’s picture

aquariumtap commented

Hi monsoonpk, that table should have been created when you enabled the Fusion Apply module. The schema is saved in fusion_apply.install. Are you working with multiple databases?

monsoon’s picture

monsoon commented

Hi @aquarimtap
I have only one database firmaroning_dk and developing a prototype website for a roklub, and will move to another server once completed. I have drupal installation in www.firmaroning.dk/brk

It is connected to database firmaroning_dk on the same company server.

I made a mistake while Enabling Fusion Apply module. I did not enable and set default a fusion theme "Mix and Match" which I want to use for my web project in the long run.

Please let me know if i can run database schema now?

Thanks.

aquariumtap’s picture

aquariumtap commented
Status: Active » Closed (works as designed)

I don't think Skinr Apply has an uninstall module hook implemented, which means you can't uninstall and reinstall to create the table. You'll have to enable that module on a fresh drupal installation, then export the schema into your current site. I can't say why your table is missing -- selecting a default theme would have no effect on the module creating that table during installation. It must have been deleted at some point.

monsoon’s picture

monsoon commented
Status: Closed (works as designed) » Active

Hi Aquariumtap, I am stuck on error page and cannot perform any administration task at all. Can you please let me know if there is a safe way to avoid such errors in future?
Also is there any Restore option in drupal to go back to previous working settings.

Thanks.

aquariumtap’s picture

aquariumtap commented
Status: Active » Closed (works as designed)

Hi monsoonpk, when the module is installed, it creates the necessary table, which has somehow been removed from your database. If you create a new Drupal site and install the module on a fresh database, you can export the schema from there. If you do not know how to do that, I'm afraid you'll need to talk to a developer. I cannot assist you from here.

There is no evidence that this module is the source of your problem, which is why I've changed the status to works as designed.

Best of luck!

monsoon’s picture

monsoon commented

Hi Aquariumtap,

I deleted the Fusion Accelator module from sites/all/modules manually using Filezilla.

Websites fatal error disappeared and all administrator menus worked as normal. I enabled and set default the "Mix and Match" theme.

I installed Fusion again and tried to enable Fusion Apply module. And got somhow different error.

Hope you can now look at it and suggest some solution:

Many thanks for your support. :)

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes: CREATE TABLE {fusion_apply_skins} ( `sid` INT unsigned NOT NULL auto_increment COMMENT 'The primary identifier for a skin configuration.', `theme` VARCHAR(128) NOT NULL DEFAULT '' COMMENT 'The theme this configuration applies to.', `module` VARCHAR(128) NOT NULL DEFAULT '' COMMENT 'The module this configuration applies to.', `element` VARCHAR(128) NOT NULL DEFAULT '' COMMENT 'The element this configuration applies to.', `skin` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'The skin that has been applied.', `options` LONGTEXT NOT NULL COMMENT 'A serialized array containing the skin options that have been applied.', `status` TINYINT NOT NULL DEFAULT 0 COMMENT 'Boolean indicating whether or not this item is enabled.', PRIMARY KEY (`sid`), UNIQUE KEY `theme_module_element_skin` (`theme`(40), `module`(40), `element`(40), `skin`(40)), INDEX `theme` (`theme`), INDEX `module` (`theme`, `module`), INDEX `element` (`theme`, `module`, `element`), INDEX `skin` (`skin`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'Stores Fusion Apply data.'; Array ( ) in db_create_table() (line 2688 of /customers/f/9/4/firmaroning.dk/httpd.www/brk/includes/database/database.inc).

sheena_d’s picture

sheena_d commented

That is a known issue with Fusion Accelerator. There is a fix available in the 7.x-2.x-dev version of the module and a patch available that applies to the current stable release of the module; http://drupal.org/node/1325542

In addition, the Mix & Match theme and the Fusion 7.x-1.x branch are not compatible with Fusion Accelerator. If you want to use the Mix & Match theme, you will need to install the Skinr module.

Cheers,
Sheena

maryhkcs’s picture

maryhkcs commented
Title: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'firmaroning_dk.fusion_apply_skins' doesn't exist: » Armchair

Picking armchairs can actually be quite an exhaustive and mentally demanding job to undertake. You want to be sure you know which ones are going to be suitable, which will overpower your room, and which will look too small or out of place.

Armchair

sheena_d’s picture

sheena_d commented
Title: Armchair » PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'firmaroning_dk.fusion_apply_skins' doesn't exist

oh, fun spambot.

solquimpo’s picture

solquimpo commented

Hi Sheena,

About the fix you mentioned that's available in 7.x-2.x-dev, should it fix the PDOException as well? The other issue you linked to ( http://drupal.org/node/1325542 ) is mysql related.

I also encounter the original issue posted by monsoon, but apart from Fusion, I don't have any other themes installed. I tried upgrading both Fusion theme and Fusion Accelerator modules to 7.x-2.x-dev, but no luck. I also tried aquariumtap's suggestion to install the module on a fresh drupal install but still no luck. Table fusion_apply_skins can't be created at all. I have Drupal core 7.14 with postgres 9.1.

Sol

solquimpo’s picture

solquimpo commented
Issue summary: View changes

Webiste address needed .dk