Column not found Error when saving plugin settings

[raygers]

Hi

Get the below error while trying to save the settings from within the plugin settings in CP. I had to revert to using the config file to configure the plugin.

Using Craft Pro 3.1.8

Exception:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'craft_elements.id' in 'field list' in /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/db/Command.php:1258 Stack trace:

0 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/db/Command.php(1258): PDOStatement->execute()

1 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/db/Command.php(1148): yii\db\Command->internalExecute('SELECT `craft_e...')

2 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/db/Command.php(399): yii\db\Command->queryInternal('fetchAll', NULL)

3 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/db/Query.php(237): yii\db\Command->queryAll()

4 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/db/Query.php(161): yii\db\Query->all(NULL)

5 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/elements/db/ElementQuery.php(1200): craft\db\Query->all(NULL)

6 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/la-haute-societe/craft-elasticsearch/src/services/Elasticsearch.php(489): craft\elements\db\ElementQuery->all()

7 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/la-haute-societe/craft-elasticsearch/src/Elasticsearch.php(336): lhs\elasticsearch\services\Elasticsearch->getEnabledEntries()

8 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/la-haute-societe/craft-elasticsearch/src/Elasticsearch.php(111): lhs\elasticsearch\Elasticsearch->onPluginSettingsSaved()

9 [internal function]: lhs\elasticsearch\Elasticsearch->lhs\elasticsearch{closure}(Object(craft\events\PluginEvent))

10 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/base/Event.php(310): call_user_func(Object(Closure), Object(craft\events\PluginEvent))

11 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/base/Component.php(636): yii\base\Event::trigger('craft\services\...', 'afterSavePlugin...', Object(craft\events\PluginEvent))

12 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/services/Plugins.php(702): yii\base\Component->trigger('afterSavePlugin...', Object(craft\events\PluginEvent))

13 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/controllers/PluginsController.php(171): craft\services\Plugins->savePluginSettings(Object(lhs\elasticsearch\Elasticsearch), Array)

14 [internal function]: craft\controllers\PluginsController->actionSavePluginSettings()

15 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)

16 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)

17 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/web/Controller.php(109): yii\base\Controller->runAction('save-plugin-set...', Array)

18 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/base/Module.php(528): craft\web\Controller->runAction('save-plugin-set...', Array)

19 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/web/Application.php(297): yii\base\Module->runAction('plugins/save-pl...', Array)

20 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/web/Application.php(561): craft\web\Application->runAction('plugins/save-pl...', Array)

21 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/web/Application.php(281): craft\web\Application->_processActionRequest(Object(craft\web\Request))

22 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/base/Application.php(386): craft\web\Application->handleRequest(Object(craft\web\Request))

23 /Users/raygerstner/GitRespositories/mweb_web_craftcms/web/index.php(21): yii\base\Application->run()

24 {main}

Next yii\db\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'craft_elements.id' in 'field list' The SQL being executed was: SELECT craft_elements.id AS entryId, craft_elements_sites.siteId FROM (SELECT elements.id AS elementsId, elements_sites.id AS elementsSitesId, content.id AS contentId FROM craft_elements elements INNER JOIN craft_entries entries ON entries.id = elements.id INNER JOIN craft_elements_sites elements_sites ON elements_sites.elementId = elements.id INNER JOIN craft_content content ON content.elementId = elements.id LEFT JOIN craft_structureelements structureelements ON structureelements.elementId = elements.id WHERE (elements_sites.siteId=1) AND (content.siteId=1) AND (elements.archived=FALSE) AND (((elements.enabled=TRUE) AND (elements_sites.enabled=TRUE)) AND (entries.postDate <= '2019-02-19 10:44:40') AND ((entries.expiryDate IS NULL) OR (entries.expiryDate > '2019-02-19 10:44:40'))) AND (elements.dateDeleted IS NULL) AND (elements_sites.enabled=TRUE) ORDER BY structureelements.lft, entries.postDate DESC) subquery INNER JOIN craft_entries entries ON entries.id = subquery.elementsId INNER JOIN craft_elements elements ON elements.id = subquery.elementsId INNER JOIN craft_elements_sites elements_sites ON elements_sites.id = subquery.elementsSitesId INNER JOIN craft_content content ON content.id = subquery.contentId LEFT JOIN craft_structureelements structureelements ON structureelements.elementId = subquery.elementsId ORDER BY structureelements.lft, entries.postDate DESC in /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/db/Schema.php:664 Stack trace:

0 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/db/Command.php(1263): yii\db\Schema->convertException(Object(PDOException), 'SELECT `craft_e...')

1 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/db/Command.php(1148): yii\db\Command->internalExecute('SELECT `craft_e...')

2 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/db/Command.php(399): yii\db\Command->queryInternal('fetchAll', NULL)

3 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/db/Query.php(237): yii\db\Command->queryAll()

4 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/db/Query.php(161): yii\db\Query->all(NULL)

5 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/elements/db/ElementQuery.php(1200): craft\db\Query->all(NULL)

6 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/la-haute-societe/craft-elasticsearch/src/services/Elasticsearch.php(489): craft\elements\db\ElementQuery->all()

7 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/la-haute-societe/craft-elasticsearch/src/Elasticsearch.php(336): lhs\elasticsearch\services\Elasticsearch->getEnabledEntries()

8 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/la-haute-societe/craft-elasticsearch/src/Elasticsearch.php(111): lhs\elasticsearch\Elasticsearch->onPluginSettingsSaved()

9 [internal function]: lhs\elasticsearch\Elasticsearch->lhs\elasticsearch{closure}(Object(craft\events\PluginEvent))

10 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/base/Event.php(310): call_user_func(Object(Closure), Object(craft\events\PluginEvent))

11 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/base/Component.php(636): yii\base\Event::trigger('craft\services\...', 'afterSavePlugin...', Object(craft\events\PluginEvent))

12 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/services/Plugins.php(702): yii\base\Component->trigger('afterSavePlugin...', Object(craft\events\PluginEvent))

13 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/controllers/PluginsController.php(171): craft\services\Plugins->savePluginSettings(Object(lhs\elasticsearch\Elasticsearch), Array)

14 [internal function]: craft\controllers\PluginsController->actionSavePluginSettings()

15 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)

16 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)

17 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/web/Controller.php(109): yii\base\Controller->runAction('save-plugin-set...', Array)

18 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/base/Module.php(528): craft\web\Controller->runAction('save-plugin-set...', Array)

19 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/web/Application.php(297): yii\base\Module->runAction('plugins/save-pl...', Array)

20 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/web/Application.php(561): craft\web\Application->runAction('plugins/save-pl...', Array)

21 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/craftcms/cms/src/web/Application.php(281): craft\web\Application->_processActionRequest(Object(craft\web\Request))

22 /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/base/Application.php(386): craft\web\Application->handleRequest(Object(craft\web\Request))

23 /Users/raygerstner/GitRespositories/mweb_web_craftcms/web/index.php(21): yii\base\Application->run()

24 {main}

Additional Information: Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'craft_elements.id' in 'field list' )

Copied!Copy Stacktrace Search Stackoverflow Search Google Exception Database Exception – yii\db\Exception SQLSTATE[42S22]: Column not found: 1054 Unknown column 'craft_elements.id' in 'field list' The SQL being executed was: SELECT craft_elements.id AS entryId, craft_elements_sites.siteId FROM (SELECT elements.id AS elementsId, elements_sites.id AS elementsSitesId, content.id AS contentId FROM craft_elements elements INNER JOIN craft_entries entries ON entries.id = elements.id INNER JOIN craft_elements_sites elements_sites ON elements_sites.elementId = elements.id INNER JOIN craft_content content ON content.elementId = elements.id LEFT JOIN craft_structureelements structureelements ON structureelements.elementId = elements.id WHERE (elements_sites.siteId=1) AND (content.siteId=1) AND (elements.archived=FALSE) AND (((elements.enabled=TRUE) AND (elements_sites.enabled=TRUE)) AND (entries.postDate <= '2019-02-19 10:44:40') AND ((entries.expiryDate IS NULL) OR (entries.expiryDate > '2019-02-19 10:44:40'))) AND (elements.dateDeleted IS NULL) AND (elements_sites.enabled=TRUE) ORDER BY structureelements.lft, entries.postDate DESC) subquery INNER JOIN craft_entries entries ON entries.id = subquery.elementsId INNER JOIN craft_elements elements ON elements.id = subquery.elementsId INNER JOIN craft_elements_sites elements_sites ON elements_sites.id = subquery.elementsSitesId INNER JOIN craft_content content ON content.id = subquery.contentId LEFT JOIN craft_structureelements structureelements ON structureelements.elementId = subquery.elementsId ORDER BY structureelements.lft, entries.postDate DESC Error Info: Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'craft_elements.id' in 'field list' ) ↵ Caused by: PDOException SQLSTATE[42S22]: Column not found: 1054 Unknown column 'craft_elements.id' in 'field list' in /Users/raygerstner/GitRespositories/mweb_web_craftcms/vendor/yiisoft/yii2/db/Command.php at line 1258

[juban]

Hi @raygers,

That's weird. Sounds like you have a defined table prefix 'craft' in your configuration but, for some reason, the native elements table (`craft elements` in your case) can not be found. Could you check, using some MySQL client that the table exists? I can't see a reason why it wouldn't be the case though and what could be the relation with the saving of the plugin settings. Do you have any other plugin or module that could influence that strange behavior?

Thanks.

[raygers]

Hi @juban

Thanks for the response. Yes I do have a table called craft_elements. It definitely does exist.

The only plugins which I have installed are the following: Amazon S3 Amazon SES CKEditor Elasticsearch Element API Feed Me GatherContent Redactor

I am not sure why it does not work.

I am also experiencing some issues with the plugin where the article fails to index after save. Is there anywhere where I can check logs for these failures?

[juban]

Hi @raygers

Very strange indeed. You could check the application log file in storage/logs/web.log to have some informations about what could go wrong. The missing table issue is a mystery for me right now. I will try to do more tests using table prefixes to figure out what's going on. In the meantime, if have any relevant information from the log file, please, let me know.

Thanks.

[juban]

Hi @raygers

Did you figure out what was going wrong? Feel free to send me your log files so I can investigate.

Thanks.

[juban]

Hi @raygers,

I'm closing the ticket as I did not get new feedback from you and can't reproduce the issue. Please, give a try to the latest version 1.1.0-beta.2 and feel free to reopen the ticket if you have any new information to provide.

Thanks again.

[juban]

I finally managed to reproduce the issue. Looking for the cause of that.

[raygers]

@juban , apologies for not getting back to you. I haven't had much time to sit and figure it out. In the interim I created an api endpoint using the ElementsApi and I feed that into ES.

If you figure it out then let me know and I will test again.

Thanks Ray

[juban]

Hi @raygers ,

No apologies needed :) We released 1.1.0-beta.3 version which should fix the issue. You can try it out right now and let us know. In order to test that beta, you will have to add the following parameters to your composer file, then do a composer update:

...
"minimum-stability": "dev",
"prefer-stable": true,
...

Let us know.

Thanks.

[juban]

1.1.0 includes the fix.