Just installed the plugin and I am getting a 500 error in the console when attempting to load /actions/omnisearch/fields?elementType=craft\elements\Entry&source=section:da37a9ae-3ebe-440c-a8d0-632ea4d56210
{
"name": "Database Exception",
"message": "SQLSTATE[42703]: Undefined column: 7 ERROR: column users.firstname does not exist\nLINE 1: ...T \"users\".\"id\" AS \"value\", (IF(LENGTH(TRIM(CONCAT(users.firs...\n ^\nHINT: Perhaps you meant to reference the column \"users.firstName\".\nThe SQL being executed was: SELECT \"users\".\"id\" AS \"value\", (IF(LENGTH(TRIM(CONCAT(users.firstName, \" \", users.lastName))), TRIM(CONCAT(users.firstName, \" \", users.lastName)), username)) AS \"label\"\nFROM (SELECT \"elements\".\"id\" AS \"elementsId\", \"elements_sites\".\"id\" AS \"elementsSitesId\", \"content\".\"id\" AS \"contentId\"\nFROM \"elements\" \"elements\"\nINNER JOIN \"users\" \"users\" ON \"users\".\"id\" = \"elements\".\"id\"\nINNER JOIN \"elements_sites\" \"elements_sites\" ON \"elements_sites\".\"elementId\" = \"elements\".\"id\"\nINNER JOIN \"content\" \"content\" ON \"content\".\"elementId\" = \"elements\".\"id\"\nWHERE (\"elements\".\"archived\"=FALSE) AND ((\"users\".\"suspended\"=FALSE) AND (\"users\".\"pending\"=FALSE)) AND (\"elements\".\"dateDeleted\" IS NULL) AND (\"elements\".\"draftId\" IS NULL) AND (\"elements\".\"revisionId\" IS NULL)\nORDER BY \"users\".\"username\") \"subquery\"\nINNER JOIN \"users\" \"users\" ON \"users\".\"id\" = \"subquery\".\"elementsId\"\nINNER JOIN \"elements\" \"elements\" ON \"elements\".\"id\" = \"subquery\".\"elementsId\"\nINNER JOIN \"elements_sites\" \"elements_sites\" ON \"elements_sites\".\"id\" = \"subquery\".\"elementsSitesId\"\nINNER JOIN \"content\" \"content\" ON \"content\".\"id\" = \"subquery\".\"contentId\"\nORDER BY \"users\".\"username\"",
"code": "42703",
"type": "yii\\db\\Exception",
"file": "/app/craftcms/vendor/yiisoft/yii2/db/Schema.php",
"line": 678,
"stack-trace": [
"#0 /app/craftcms/vendor/yiisoft/yii2/db/Command.php(1307): yii\\db\\Schema->convertException(Object(PDOException), 'SELECT \"users\"....')",
"#1 /app/craftcms/vendor/yiisoft/yii2/db/Command.php(1168): yii\\db\\Command->internalExecute('SELECT \"users\"....')",
"#2 /app/craftcms/vendor/yiisoft/yii2/db/Command.php(410): yii\\db\\Command->queryInternal('fetchAll', NULL)",
"#3 /app/craftcms/vendor/yiisoft/yii2/db/Query.php(249): yii\\db\\Command->queryAll()",
"#4 /app/craftcms/vendor/craftcms/cms/src/db/Query.php(152): yii\\db\\Query->all(NULL)",
"#5 /app/craftcms/vendor/craftcms/cms/src/elements/db/ElementQuery.php(1619): craft\\db\\Query->all(NULL)",
"#6 /app/craftcms/vendor/bitmatrix/craft-omnisearch/src/fields/BaseFields.php(293): craft\\elements\\db\\ElementQuery->all()",
"#7 /app/craftcms/vendor/bitmatrix/craft-omnisearch/src/fields/EntryFields.php(33): bitmatrix\\omnisearch\\fields\\BaseFields->getUsersListData('section:da37a9a...')",
"#8 /app/craftcms/vendor/bitmatrix/craft-omnisearch/src/fields/BaseFields.php(105): bitmatrix\\omnisearch\\fields\\EntryFields->builtInFields('section:da37a9a...')",
"#9 /app/craftcms/vendor/bitmatrix/craft-omnisearch/src/OmniSearch.php(126): bitmatrix\\omnisearch\\fields\\BaseFields->getFields('section:da37a9a...')",
"#10 [internal function]: bitmatrix\\omnisearch\\OmniSearch->bitmatrix\\omnisearch\\{closure}(Object(bitmatrix\\omnisearch\\fields\\DefineFieldsEvent))",
"#11 /app/craftcms/vendor/yiisoft/yii2/base/Event.php(312): call_user_func(Object(Closure), Object(bitmatrix\\omnisearch\\fields\\DefineFieldsEvent))",
"#12 /app/craftcms/vendor/yiisoft/yii2/base/Component.php(637): yii\\base\\Event::trigger('bitmatrix\\\\omnis...', 'defineFields', Object(bitmatrix\\omnisearch\\fields\\DefineFieldsEvent))",
"#13 /app/craftcms/vendor/bitmatrix/craft-omnisearch/src/controllers/FieldsController.php(39): yii\\base\\Component->trigger('defineFields', Object(bitmatrix\\omnisearch\\fields\\DefineFieldsEvent))",
"#14 [internal function]: bitmatrix\\omnisearch\\controllers\\FieldsController->actionIndex('craft\\\\elements\\\\...', 'section:da37a9a...')",
"#15 /app/craftcms/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)",
"#16 /app/craftcms/vendor/yiisoft/yii2/base/Controller.php(181): yii\\base\\InlineAction->runWithParams(Array)",
"#17 /app/craftcms/vendor/yiisoft/yii2/base/Module.php(534): yii\\base\\Controller->runAction('', Array)",
"#18 /app/craftcms/vendor/craftcms/cms/src/web/Application.php(287): yii\\base\\Module->runAction('omnisearch/fiel...', Array)",
"#19 /app/craftcms/vendor/craftcms/cms/src/web/Application.php(596): craft\\web\\Application->runAction('omnisearch/fiel...', Array)",
"#20 /app/craftcms/vendor/craftcms/cms/src/web/Application.php(266): craft\\web\\Application->_processActionRequest(Object(craft\\web\\Request))",
"#21 /app/craftcms/vendor/yiisoft/yii2/base/Application.php(392): craft\\web\\Application->handleRequest(Object(craft\\web\\Request))",
"#22 /app/craftcms/web/index.php(24): yii\\base\\Application->run()",
"#23 {main}"
],
"error-info": [
"42703",
7,
"ERROR: column users.firstname does not exist\nLINE 1: ...T \"users\".\"id\" AS \"value\", (IF(LENGTH(TRIM(CONCAT(users.firs...\n ^\nHINT: Perhaps you meant to reference the column \"users.firstName\"."
],
"previous": {
"name": "Exception",
"message": "SQLSTATE[42703]: Undefined column: 7 ERROR: column users.firstname does not exist\nLINE 1: ...T \"users\".\"id\" AS \"value\", (IF(LENGTH(TRIM(CONCAT(users.firs...\n ^\nHINT: Perhaps you meant to reference the column \"users.firstName\".",
"code": "42703",
"type": "PDOException",
"file": "/app/craftcms/vendor/yiisoft/yii2/db/Command.php",
"line": 1302,
"stack-trace": [
"#0 /app/craftcms/vendor/yiisoft/yii2/db/Command.php(1302): PDOStatement->execute()",
"#1 /app/craftcms/vendor/yiisoft/yii2/db/Command.php(1168): yii\\db\\Command->internalExecute('SELECT \"users\"....')",
"#2 /app/craftcms/vendor/yiisoft/yii2/db/Command.php(410): yii\\db\\Command->queryInternal('fetchAll', NULL)",
"#3 /app/craftcms/vendor/yiisoft/yii2/db/Query.php(249): yii\\db\\Command->queryAll()",
"#4 /app/craftcms/vendor/craftcms/cms/src/db/Query.php(152): yii\\db\\Query->all(NULL)",
"#5 /app/craftcms/vendor/craftcms/cms/src/elements/db/ElementQuery.php(1619): craft\\db\\Query->all(NULL)",
"#6 /app/craftcms/vendor/bitmatrix/craft-omnisearch/src/fields/BaseFields.php(293): craft\\elements\\db\\ElementQuery->all()",
"#7 /app/craftcms/vendor/bitmatrix/craft-omnisearch/src/fields/EntryFields.php(33): bitmatrix\\omnisearch\\fields\\BaseFields->getUsersListData('section:da37a9a...')",
"#8 /app/craftcms/vendor/bitmatrix/craft-omnisearch/src/fields/BaseFields.php(105): bitmatrix\\omnisearch\\fields\\EntryFields->builtInFields('section:da37a9a...')",
"#9 /app/craftcms/vendor/bitmatrix/craft-omnisearch/src/OmniSearch.php(126): bitmatrix\\omnisearch\\fields\\BaseFields->getFields('section:da37a9a...')",
"#10 [internal function]: bitmatrix\\omnisearch\\OmniSearch->bitmatrix\\omnisearch\\{closure}(Object(bitmatrix\\omnisearch\\fields\\DefineFieldsEvent))",
"#11 /app/craftcms/vendor/yiisoft/yii2/base/Event.php(312): call_user_func(Object(Closure), Object(bitmatrix\\omnisearch\\fields\\DefineFieldsEvent))",
"#12 /app/craftcms/vendor/yiisoft/yii2/base/Component.php(637): yii\\base\\Event::trigger('bitmatrix\\\\omnis...', 'defineFields', Object(bitmatrix\\omnisearch\\fields\\DefineFieldsEvent))",
"#13 /app/craftcms/vendor/bitmatrix/craft-omnisearch/src/controllers/FieldsController.php(39): yii\\base\\Component->trigger('defineFields', Object(bitmatrix\\omnisearch\\fields\\DefineFieldsEvent))",
"#14 [internal function]: bitmatrix\\omnisearch\\controllers\\FieldsController->actionIndex('craft\\\\elements\\\\...', 'section:da37a9a...')",
"#15 /app/craftcms/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)",
"#16 /app/craftcms/vendor/yiisoft/yii2/base/Controller.php(181): yii\\base\\InlineAction->runWithParams(Array)",
"#17 /app/craftcms/vendor/yiisoft/yii2/base/Module.php(534): yii\\base\\Controller->runAction('', Array)",
"#18 /app/craftcms/vendor/craftcms/cms/src/web/Application.php(287): yii\\base\\Module->runAction('omnisearch/fiel...', Array)",
"#19 /app/craftcms/vendor/craftcms/cms/src/web/Application.php(596): craft\\web\\Application->runAction('omnisearch/fiel...', Array)",
"#20 /app/craftcms/vendor/craftcms/cms/src/web/Application.php(266): craft\\web\\Application->_processActionRequest(Object(craft\\web\\Request))",
"#21 /app/craftcms/vendor/yiisoft/yii2/base/Application.php(392): craft\\web\\Application->handleRequest(Object(craft\\web\\Request))",
"#22 /app/craftcms/web/index.php(24): yii\\base\\Application->run()",
"#23 {main}"
]
}
}
Plugin version: 1.2
Craft version: 3.7.18.1