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

TOPIC:

Migration to Xigmanas 12.3.0.4 - Une erreur de base de données s’est produite 2 weeks 2 days ago #1

  • follegot
  • follegot's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 5
I want to repatriate a Webtree2 instance from a running installation hosted on 7.3.31-1~deb10u1
to a Xigmanas 12.3.0.4 - Artisia (revision 8948) , lighttpd , PHP Version 7.4.26

To solve this I did increase the 'session_id' of `wt2_session` table from VARCHAR 32 to 64 (even if 48 seems enough).

Thanks
JP FOL

Assistant d’installation pour webtrees

Une erreur de base de données s’est produite de manière inattendue.

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'session_id' at row 1 (SQL: insert into `wt2_session` (`session_id`, `session_time`, `user_id`, `ip_address`, `session_data`) values (k0e9v6jjiq9eiqkhl7jqkgbcnmefvreh51c49e6kepeoch9q, 2022-01-10 14:07:49, 0, 192.168.0.167, initiated|b:1;))

#0 /mnt/Data2/www/webtrees-2/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('insert into `wt...', Array, Object(Closure))
#1 /mnt/Data2/www/webtrees-2/vendor/illuminate/database/Connection.php(459): Illuminate\Database\Connection->run('insert into `wt...', Array, Object(Closure))
#2 /mnt/Data2/www/webtrees-2/vendor/illuminate/database/Connection.php(411): Illuminate\Database\Connection->statement('insert into `wt...', Array)
#3 /mnt/Data2/www/webtrees-2/vendor/illuminate/database/Query/Builder.php(2646): Illuminate\Database\Connection->insert('insert into `wt...', Array)
#4 /mnt/Data2/www/webtrees-2/app/SessionDatabaseHandler.php(95): Illuminate\Database\Query\Builder->insert(Array)
#5 [internal function]: Fisharebest\Webtrees\SessionDatabaseHandler->write('k0e9v6jjiq9eiqk...', 'initiated|b:1;')
#6 /mnt/Data2/www/webtrees-2/app/Session.php(151): session_regenerate_id(false)
#7 /mnt/Data2/www/webtrees-2/app/Auth.php(194): Fisharebest\Webtrees\Session::regenerate(false)
#8 /mnt/Data2/www/webtrees-2/app/Http/RequestHandlers/SetupWizard.php(438): Fisharebest\Webtrees\Auth::login(Object(Fisharebest\Webtrees\User))
#9 /mnt/Data2/www/webtrees-2/app/Http/RequestHandlers/SetupWizard.php(366): Fisharebest\Webtrees\Http\RequestHandlers\SetupWizard->createConfigFile(Array)
#10 /mnt/Data2/www/webtrees-2/app/Http/RequestHandlers/SetupWizard.php(200): Fisharebest\Webtrees\Http\RequestHandlers\SetupWizard->step6Install(Array)
#11 /mnt/Data2/www/webtrees-2/app/Http/Middleware/ReadConfigIni.php(69): Fisharebest\Webtrees\Http\RequestHandlers\SetupWizard->handle(Object(Nyholm\Psr7\ServerRequest))
#12 /mnt/Data2/www/webtrees-2/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ReadConfigIni->process(Object(Nyholm\Psr7\ServerRequest), Object(Fisharebest\Webtrees\Http\RequestHandlers\SetupWizard))
#13 /mnt/Data2/www/webtrees-2/app/Http/Middleware/SecurityHeaders.php(48): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#14 /mnt/Data2/www/webtrees-2/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\SecurityHeaders->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#15 /mnt/Data2/www/webtrees-2/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#16 /mnt/Data2/www/webtrees-2/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\EmitResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#17 /mnt/Data2/www/webtrees-2/app/Http/Middleware/PhpEnvironment.php(49): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#18 /mnt/Data2/www/webtrees-2/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\PhpEnvironment->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#19 /mnt/Data2/www/webtrees-2/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#20 /mnt/Data2/www/webtrees-2/index.php(57): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest))
#21 {main}

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

Migration to Xigmanas 12.3.0.4 - Une erreur de base de données s’est produite 2 weeks 2 days ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 15173
By default, PHP creates session IDs with 26 characters.
Look at the PHP.INI setting session.sid_length

webtrees creates a session_id column in the database with 128 characters.
(Old versions may have used 32 characters).

I guess you have changed session.sid_length to a larger value than the default.
If so, you should also change the column to be larger than this value.
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.

  • Page:
  • 1
Powered by Kunena Forum