0

I was getting a database error when trying to op the Rules UI so I tried to reinstall the module. I uninstalled the Rules Modules and Rules UI module then tried to install the Rules module and now every page of the sites gives this error:

Additional uncaught exception thrown while handling exception.

Original

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sgda_arcade.rules_config' doesn't exist: SELECT base.id AS id, base.name AS name, base.label AS label, base.plugin AS plugin, base.active AS active, base.weight AS weight, base.status AS status, base.dirty AS dirty, base.module AS module, base.access_exposed AS access_exposed, base.data AS data FROM {rules_config} base WHERE (base.plugin = :db_condition_placeholder_0) AND (base.active = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => reaction rule [:db_condition_placeholder_1] => 1 ) in EntityAPIController->query() (line 152 of /srv/arcade/sites/all/modules/custom/entity/includes/entity.controller.inc).

Additional

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sgda_arcade.rules_config' doesn't exist: SELECT base.id AS id, base.name AS name, base.label AS label, base.plugin AS plugin, base.active AS active, base.weight AS weight, base.status AS status, base.dirty AS dirty, base.module AS module, base.access_exposed AS access_exposed, base.data AS data FROM {rules_config} base WHERE (base.plugin = :db_condition_placeholder_0) AND (base.active = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => reaction rule [:db_condition_placeholder_1] => 1 ) in EntityAPIController->query() (line 152 of /srv/arcade/sites/all/modules/custom/entity/includes/entity.controller.inc).

Is there anything I can do to fix this?

10
  • did you actually uninstall the modules after disabling them or just disable and re-enable them?
    – Jimajamma
    Feb 4 '14 at 20:54
  • I actually uninstalled them. Disable then uninstall.
    – Mike2012
    Feb 4 '14 at 20:55
  • 1
    well the uninstall in drupal should go in and actually drop all the database tables as part of its processing, so, something else must be going on to not allow them to be recreated upon re-enabling so I guess you are now in mysql dba mode :(
    – Jimajamma
    Feb 4 '14 at 20:58
  • 1
    well then somehow the tables aren't being dropped when you run the module uninstall routine and or they aren't being created (because they are already there or drupal thinks they are because the uninstall failed or something) so the best thing I can suggest is disable the module, run the uninstall routine, look at the database and then re-enable it and check the database to see if the tables are back.
    – Jimajamma
    Feb 4 '14 at 21:21
  • 1
    you could go into the module install file and look what these tables are supposed to look like and re-create them manually; but, I think a restore from backup might be the eventual end result
    – Jimajamma
    Feb 4 '14 at 21:30
0

As it turns out the drive on which my database was installed had run out of disk space, so as JimaJamma suggested, the table could not be created by the rules module.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.