We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

SOLVED - Simple Search Form causing a PHP "Exception Caught" error

Development and Programming

BenCorn's avatar
BenCorn
13 posts
3 years ago
BenCorn's avatar BenCorn

Using a simple search form in EE v6.2.6 and upon hitting submit button it comes up with a page full of php errors with the heading “Exception Caught” The first line being: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘no_result_page’ in ‘field list’: Then the stack trace has 11 errors:

#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(172): require_once('...')
#11 index.php(172): require_once('...') 

Anyone have any ideas?

       
Daem0n's avatar
Daem0n
79 posts
3 years ago
Daem0n's avatar Daem0n

I’m having the same issue here.

       
jaygreentree's avatar
jaygreentree
9 posts
3 years ago
jaygreentree's avatar jaygreentree

There is a bug fix coming. You can follow on Github to see bug reports and track updates.

? 1
       
Andy McCormick's avatar
Andy McCormick
322 posts
3 years ago
Andy McCormick's avatar Andy McCormick

Any chance you were able to update to 6.2.7 and see if this issue is resolved?

       
BenCorn's avatar
BenCorn
13 posts
3 years ago
BenCorn's avatar BenCorn

Hi - yes I have upgraded and can confirm that it now works. Thank you 😊

? 1
       
CalvinHarris's avatar
CalvinHarris
1 posts
2 years ago
CalvinHarris's avatar CalvinHarris

Are you using the old version? Try updating to the latest version, your problem will be solved.

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.