Before asking for help please read "Requesting Help and Suggestions" by clicking on that tab above here.
  • Page:
  • 1

TOPIC:

SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared 1 week 2 days ago #1

  • carolalind
  • carolalind's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 6
Well I seem to have the same question again. I moved back obviously to a hosting I forgot isn't good for webtrees. I get this error over and over again in the log. i search the error and found my way here: last time I asked . Thought I should try the suggestion given there but the file doesn't look the same. I'm now on webtrees 2.1.7 and php 8.1.

What should I do? Go on and change hosting again? Suggestions for a good hosting which is not that expensive. I'm keeping the site live as a memory for my mother who died three years ago. Her database contains over 40 000 people and feels bad to just let it go. But I don't want to pay a fortune on hosting.

The hosting I'm on now is simply.com. Anyone else tried this with webtrees?

The error:

SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (SQL: select `wt_gedcom`.`gedcom_id` as `tree_id`, `wt_gedcom`.`gedcom_name` as `tree_name`, `wt_gedcom_setting`.`setting_value` as `tree_title` from `wt_gedcom` left join `wt_gedcom_setting` on `wt_gedcom_setting`.`gedcom_id` = `wt_gedcom`.`gedcom_id` and `wt_gedcom_setting`.`setting_name` = title inner join `wt_gedcom_setting` as `wt_gs2` on `wt_gs2`.`gedcom_id` = `wt_gedcom`.`gedcom_id` and `wt_gs2`.`setting_name` = imported inner join `wt_gedcom_setting` as `wt_gs3` on `wt_gs3`.`gedcom_id` = `wt_gedcom`.`gedcom_id` and `wt_gs3`.`setting_name` = REQUIRE_AUTHENTICATION left join `wt_user_gedcom_setting` on `wt_user_gedcom_setting`.`gedcom_id` = `wt_gedcom`.`gedcom_id` and `wt_user_gedcom_setting`.`user_id` is null and `wt_user_gedcom_setting`.`setting_name` = canedit where `wt_gedcom`.`gedcom_id` > 0 and (`wt_user_gedcom_setting`.`setting_value` = admin or (`wt_gs2`.`setting_value` = 1 and `wt_gs3`.`setting_value` = 1 and `wt_user_gedcom_setting`.`setting_value` <> none) or (`wt_gs2`.`setting_value` = 1 and `wt_gs3`.`setting_value` <> 1)) order by `wt_gedcom`.`sort_order` asc, `wt_gedcom_setting`.`setting_value` asc) …/vendor/illuminate/database/Connection.php:712 #0 …/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback('select `wt_gedc...', Array, Object(Closure)) #1 …/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run('select `wt_gedc...', Array, Object(Closure)) #2 …/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select('select `wt_gedc...', Array, true) #3 …/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect() #4 …/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 …/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #6 …/app/Services/TreeService.php(135): Illuminate\Database\Query\Builder->get() #7 …/app/Cache.php(60): Fisharebest\Webtrees\Services\TreeService::Fisharebest\Webtrees\Services\{closure}() #8 …/vendor/symfony/cache/Adapter/ArrayAdapter.php(84): Fisharebest\Webtrees\Cache::Fisharebest\Webtrees\{closure}(Object(Symfony\Component\Cache\CacheItem), true) #9 …/app/Cache.php(61): Symfony\Component\Cache\Adapter\ArrayAdapter->get('2306624cadfb63d...', Object(Closure)) #10 …/app/Services/TreeService.php(139): Fisharebest\Webtrees\Cache->remember('all-trees', Object(Closure)) #11 …/app/Http/Middleware/Router.php(138): Fisharebest\Webtrees\Services\TreeService->all() #12 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\Router->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #13 …/app/Http/Middleware/BootModules.php(60): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #14 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BootModules->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #15 …/app/Http/Middleware/RegisterGedcomTags.php(54): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #16 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\RegisterGedcomTags->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #17 …/app/Http/Middleware/LoadRoutes.php(75): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #18 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\LoadRoutes->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #19 …/app/Http/Middleware/CheckForNewVersion.php(65): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #20 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\CheckForNewVersion->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #21 …/app/Http/Middleware/UseTransaction.php(45): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #22 …/vendor/illuminate/database/Concerns/ManagesTransactions.php(29): Fisharebest\Webtrees\Http\Middleware\UseTransaction::Fisharebest\Webtrees\Http\Middleware\{closure}(Object(Illuminate\Database\MySqlConnection)) #23 …/app/Http/Middleware/UseTransaction.php(46): Illuminate\Database\Connection->transaction(Object(Closure), 3) #24 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseTransaction->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #25 …/app/Http/Middleware/DoHousekeeping.php(73): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #26 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\DoHousekeeping->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #27 …/app/Http/Middleware/UseTheme.php(69): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #28 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseTheme->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #29 …/app/Http/Middleware/CheckForMaintenanceMode.php(51): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #30 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\CheckForMaintenanceMode->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #31 …/app/Http/Middleware/UseLanguage.php(71): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #32 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseLanguage->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #33 …/app/Http/Middleware/UseSession.php(78): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #34 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseSession->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #35 …/app/Http/Middleware/UpdateDatabaseSchema.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #36 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UpdateDatabaseSchema->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #37 …/app/Http/Middleware/UseDatabase.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #38 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseDatabase->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #39 …/app/Http/Middleware/BadBotBlocker.php(233): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #40 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BadBotBlocker->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #41 …/app/Http/Middleware/CompressResponse.php(73): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #42 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\CompressResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #43 …/app/Http/Middleware/ContentLength.php(40): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #44 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ContentLength->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #45 …/vendor/middlewares/client-ip/src/ClientIp.php(65): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #46 …/app/Http/Middleware/ClientIp.php(47): Middlewares\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #47 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #48 …/app/Http/Middleware/HandleExceptions.php(90): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #49 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\HandleExceptions->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #50 …/app/Http/Middleware/BaseUrl.php(79): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #51 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BaseUrl->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #52 …/app/Http/Middleware/ReadConfigIni.php(68): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #53 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ReadConfigIni->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #54 …/app/Http/Middleware/SecurityHeaders.php(48): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #55 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\SecurityHeaders->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #56 …/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #57 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\EmitResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #58 …/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #59 …/app/Webtrees.php(275): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest)) #60 …/app/Webtrees.php(262): Fisharebest\Webtrees\Webtrees::dispatch(Object(Nyholm\Psr7\ServerRequest), Array) #61 …/index.php(51): Fisharebest\Webtrees\Webtrees->httpRequest() #62 {main}

Please Log in or Create an account to join the conversation.

SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared 1 week 1 day ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 16208
> I get this error over and over again in the log

AFAICT, the database server is either misconfigured, or under-resourced.

There is one thing you could try:

Edit this file, and after the indicated line, add the following.

github.com/fisharebest/webtrees/blob/2.1.../UseDatabase.php#L68
PDO::ATTR_EMULATE_PREPARES => true,

This will make your site run a little slower, but it *might* avoid the limitation of your server...
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared 1 week 13 hours ago #3

  • carolalind
  • carolalind's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 6
Thank you for replying. I've added the line in file now. Will wait a few days and check the log again.

If it doesn't work I'll move the site again :)

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Powered by Kunena Forum