Hey everyone,
I’ve upgraded my EE installation to the latest 6.2.6 version and while everything seemed to work fine, today I noticed that I can no longer perform a search without getting the following error…
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'no_result_page' in 'field list':
INSERT INTO `exp_search` (`search_id`, `search_date`, `member_id`, `keywords`, `ip_address`, `total_results`, `per_page`, `query`, `custom_fields`, `result_page`, `no_result_page`, `site_id`) VALUES ('914cd1440706516e5111cbacda7ff016', 1645730934, 1, 'sugar', '109.154.33.83', 36, '12', 'a:3:{s:7:\"entries\";a:36:{i:0;i:1;i:1;i:4;i:2;i:5;i:3;i:8;i:4;i:11;i:5;i:19;i:6;i:20;i:7;i:21;i:8;i:22;i:9;i:23;i:10;i:47;i:11;i:52;i:12;i:58;i:13;i:61;i:14;i:63;i:15;i:68;i:16;i:72;i:17;i:73;i:18;i:83;i:19;i:86;i:20;i:91;i:21;i:97;i:22;i:102;i:23;i:104;i:24;i:105;i:25;i:107;i:26;i:108;i:27;i:112;i:28;i:114;i:29;i:115;i:30;i:123;i:31;i:124;i:32;i:69;i:33;i:79;i:34;i:85;i:35;i:113;}s:11:\"channel_ids\";a:2:{i:0;i:1;i:32;i:4;}s:3:\"end\";s:26:\" ORDER BY entry_date desc\";}', 'a:26:{s:18:\\\"recipe_ingredients\\\";a:2:{i:0;i:1;i:1;b:1;}s:12:\\\"recipe_steps\\\";a:2:{i:0;i:2;i:1;b:1;}s:15:\\\"recipe_calories\\\";a:2:{i:0;i:3;i:1;b:0;}s:15:\\\"recipe_portions\\\";a:2:{i:0;i:5;i:1;b:0;}s:11:\\\"recipe_tips\\\";a:2:{i:0;i:8;i:1;b:1;}s:16:\\\"meta_description\\\";a:2:{i:0;i:9;i:1;b:1;}s:13:\\\"meta_keywords\\\";a:2:{i:0;i:10;i:1;b:1;}s:12:\\\"recipe_video\\\";a:2:{i:0;i:12;i:1;b:0;}s:22:\\\"recipe_photo_pinterest\\\";a:2:{i:0;i:14;i:1;b:0;}s:18:\\\"recipe_description\\\";a:2:{i:0;i:15;i:1;b:1;}s:10:\\\"meta_title\\\";a:2:{i:0;i:24;i:1;b:1;}s:12:\\\"recipe_hours\\\";a:2:{i:0;i:26;i:1;b:0;}s:14:\\\"recipe_minutes\\\";a:2:{i:0;i:27;i:1;b:0;}s:15:\\\"photo_landscape\\\";a:2:{i:0;i:28;i:1;b:0;}s:14:\\\"photo_portrait\\\";a:2:{i:0;i:29;i:1;b:0;}s:12:\\\"photo_square\\\";a:2:{i:0;i:30;i:1;b:0;}s:18:\\\"recipe_social_copy\\\";a:2:{i:0;i:32;i:1;b:1;}s:16:\\\"photo_portrait_2\\\";a:2:{i:0;i:33;i:1;b:0;}s:12:\\\"page_content\\\";a:2:{i:0;i:13;i:1;b:1;}s:7:\\\"aff_url\\\";a:2:{i:0;i:16;i:1;b:0;}s:15:\\\"aff_description\\\";a:2:{i:0;i:17;i:1;b:0;}s:9:\\\"aff_photo\\\";a:2:{i:0;i:18;i:1;b:0;}s:19:\\\"blog_featured_image\\\";a:2:{i:0;i:21;i:1;b:0;}s:12:\\\"blog_excerpt\\\";a:2:{i:0;i:22;i:1;b:1;}s:12:\\\"blog_content\\\";a:2:{i:0;i:23;i:1;b:1;}s:4:\\\"link\\\";a:2:{i:0;i:31;i:1;b:0;}}', 'search/results', 'search/noresults', 1)
ee/legacy/database/drivers/mysqli/mysqli_connection.php:114
Stack Trace: Please include when reporting this error
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query('INSERT INTO `ex...')
#1 ee/legacy/database/DB_driver.php(260): CI_DB_mysqli_driver->_execute('INSERT INTO `ex...')
#2 ee/legacy/database/DB_driver.php(175): CI_DB_driver->simple_query('INSERT INTO `ex...')
#3 ee/ExpressionEngine/Addons/search/mod.search.php(265): CI_DB_driver->query('INSERT INTO `ex...')
#4 ee/legacy/libraries/Actions.php(175): Search->do_search()
#5 ee/legacy/libraries/Core.php(604): EE_Actions->__construct(true, Object(Closure))
#6 ee/legacy/controllers/ee.php(51): EE_Core->generate_action(true)
#7 [internal function]: EE->index()
#8 ee/ExpressionEngine/Core/Core.php(257): call_user_func_array(Array, Array)
#9 ee/ExpressionEngine/Core/Core.php(113): ExpressionEngine\Core\Core->runController(Array)
#10 ee/ExpressionEngine/Boot/boot.php(161): ExpressionEngine\Core\Core->run(Object(ExpressionEngine\Core\Request))
#11 index.php(168): require_once('...')
#11 index.php(168): require_once('...')
Did something break upon upgrading or am I missing something?
Still can’t figure out how to fix this but I’m wondering if the error I’m getting is related to this issue. 🤔
Argh- I’m sorry you hit that bug. We’ve got in in https://github.com/ExpressionEngine/ExpressionEngine/issues/1846 and are expediting a fix.
But in the meantime, run this query (in phpmyadmin or in the EE control panel Tools- Query form’
ALTER TABLE exp_search ADD no_result_page varchar(70) NOT NULL
That should get it working again.
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.