DRUPAL error PDOException: SQLSTATE[42S22]:

0
votes

can someone help me to fix this Additional uncaught exception thrown while handling exception. Original PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'base.owner' in 'field list': 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.owner AS owner, 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 187 of /home/tjmcom/public_html/mydomain. com/sites/all/modules/entity/includes/entity.controller.inc).

Additional PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'base.owner' in 'field list': 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.owner AS owner, 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 187 of /home/tjmcom/public_html/mydomain. com/sites/all/modules/entity/includes/entity.controller.inc).

1
drupaldrupal-modules
Hi and welcome to SO. Please edit the question to show your code. Like this we will be able to better understand your problem/question and thus we will be able to better help you. It is best to provide a minimal reproducible example. For more information, please see How to Ask and take the Tour. – quant
Can it be that you updated some module but didn't run update.php script. Try running update.php and check if some updates are waiting. – MilanG

1 Answers

1
votes

This sounds like a problem with the Rules Project not having completed its update. Put your site in maintenance mode and go to yoursite.com/update.php.

This issue is documented at https://www.drupal.org/project/rules/issues/2094879 and comment #45 gives a checklist of items to do. If that does not work, please confirm you're indeed using Rules in your setup, and what version you're running.

Furthermore, if you have unsuccessfully tried any specific steps to resolve this issue and it persists, describe briefly what they were. It'll save time to getting you on the right path, avoiding describing suggestions you already tried. (You'll find tips on how to receive quicker and better answers over at https://stackguides.com/questions/how-to-ask.)

Welcome to StackOver flow.