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

TOPIC:

An unexpected database error occurred. 2 weeks 4 days ago #1

  • frisket
  • frisket's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 19
The webtrees developers would be very interested to learn about this error. If you contact them, they will help you resolve the problem.

Unfortunately the 2.0.15 installer does not say where or how to contact the developers. Does anyone have an address?

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

An unexpected database error occurred. 2 weeks 4 days ago #2

  • hermann
  • hermann's Avatar
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 295
You are just right here! Please copy your error message and a short description, at which action the error occurred, into this thread.
webtrees 2.0.16 (all available custom modules installed, php 7.4.15, MySQL 5.6) @ ahnen.hartenthaler.eu/
and webtrees 1.7.18 (many custom modules) @ ahnen1.hartenthaler.eu/

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

An unexpected database error occurred. 1 week 4 days ago #3

  • frisket
  • frisket's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 19
Sorry for delay (non-COVID medical). The error message said (username redacted)

SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user '<REDACTED>'@'localhost' for table 'wt_module' (SQL: alter table `wt_module_privacy` add constraint `wt_module_privacy_module_name_foreign` foreign key (`module_name`) references `wt_module` (`module_name`) on delete cascade)
#0 /home/peter/Office/website/blogs.silmaril.ie/family/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('alter table `wt...', Array, Object(Closure))
#1 /home/peter/Office/website/blogs.silmaril.ie/family/vendor/illuminate/database/Connection.php(459): Illuminate\Database\Connection->run('alter table `wt...', Array, Object(Closure))
#2 /home/peter/Office/website/blogs.silmaril.ie/family/vendor/illuminate/database/Schema/Blueprint.php(97): Illuminate\Database\Connection->statement('alter table `wt...')
#3 /home/peter/Office/website/blogs.silmaril.ie/family/vendor/illuminate/database/Schema/Builder.php(278): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#4 /home/peter/Office/website/blogs.silmaril.ie/family/vendor/illuminate/database/Schema/Builder.php(167): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#5 /home/peter/Office/website/blogs.silmaril.ie/family/app/Schema/Migration42.php(77): Illuminate\Database\Schema\Builder->create('module_privacy', Object(Closure))
#6 /home/peter/Office/website/blogs.silmaril.ie/family/app/Services/MigrationService.php(71): Fisharebest\Webtrees\Schema\Migration42->upgrade()
#7 /home/peter/Office/website/blogs.silmaril.ie/family/app/Http/RequestHandlers/SetupWizard.php(405): Fisharebest\Webtrees\Services\MigrationService->updateSchema('\\Fisharebest\\We...', 'WT_SCHEMA_VERSI...', 45)
#8 /home/peter/Office/website/blogs.silmaril.ie/family/app/Http/RequestHandlers/SetupWizard.php(366): Fisharebest\Webtrees\Http\RequestHandlers\SetupWizard->createConfigFile(Array)
#9 /home/peter/Office/website/blogs.silmaril.ie/family/app/Http/RequestHandlers/SetupWizard.php(200): Fisharebest\Webtrees\Http\RequestHandlers\SetupWizard->step6Install(Array)
#10 /home/peter/Office/website/blogs.silmaril.ie/family/app/Http/Middleware/ReadConfigIni.php(69): Fisharebest\Webtrees\Http\RequestHandlers\SetupWizard->handle(Object(Nyholm\Psr7\ServerRequest))
#11 /home/peter/Office/website/blogs.silmaril.ie/family/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ReadConfigIni->process(Object(Nyholm\Psr7\ServerRequest), Object(Fisharebest\Webtrees\Http\RequestHandlers\SetupWizard))
#12 /home/peter/Office/website/blogs.silmaril.ie/family/app/Http/Middleware/SecurityHeaders.php(47): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#13 /home/peter/Office/website/blogs.silmaril.ie/family/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\SecurityHeaders->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#14 /home/peter/Office/website/blogs.silmaril.ie/family/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#15 /home/peter/Office/website/blogs.silmaril.ie/family/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\EmitResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#16 /home/peter/Office/website/blogs.silmaril.ie/family/app/Http/Middleware/PhpEnvironment.php(49): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#17 /home/peter/Office/website/blogs.silmaril.ie/family/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\PhpEnvironment->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#18 /home/peter/Office/website/blogs.silmaril.ie/family/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#19 /home/peter/Office/website/blogs.silmaril.ie/family/index.php(57): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest))
#20 {main}
The webtrees developers would be very interested to learn about this
error. If you contact them, they will help you resolve the problem.

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

Last edit: by frisket.

An unexpected database error occurred. 1 week 3 days ago #4

  • fisharebest
  • fisharebest's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 14517
Your database user account does not have permission to create foreign-key constraints.

To grant this permission, you probably need to use your database admin account to run a command similar to the following

grant references on DBNAME.* to REDACTED@localhost;

Then, you'll probably need to wipe the database and start again. One of the database setup steps is likely to have been half-completed and there is no easy way to resume.
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.

An unexpected database error occurred. 1 week 3 days ago #5

  • frisket
  • frisket's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 19
OK, excellent, many thanks.

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

  • Page:
  • 1
Powered by Kunena Forum