Web based family history software

Question Error SQLSTATE [42000] in fresh install.

  • JorVlcEs
  • Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 11 months ago #1 by JorVlcEs
Due to problems installing update for WT 2.0.17 to 2.0.19, I decided try fresh install for 2.1.0-alpha1, and got this error:
SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user 'epiz_28561355'@'192.168.2.197' for table 'wt_gedcom' (SQL: alter table `wt_gedcom_setting` add constraint `wt_gedcom_setting_gedcom_id_foreign` foreign key (`gedcom_id`) references `wt_gedcom` (`gedcom_id`))
#0 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/vendor/illuminate/database/Connection.php(663): Illuminate\Database\Connection->runQueryCallback('alter table `wt...', Array, Object(Closure))
#1 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/vendor/illuminate/database/Connection.php(493): Illuminate\Database\Connection->run('alter table `wt...', Array, Object(Closure))
#2 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement('alter table `wt...')
#3 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#4 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/vendor/illuminate/database/Schema/Builder.php(228): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#5 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/app/Schema/Migration0.php(61): Illuminate\Database\Schema\Builder->create('gedcom_setting', Object(Closure))
#6 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/app/Services/MigrationService.php(69): Fisharebest\webtrees\Schema\Migration0->upgrade()
#7 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/app/Http/RequestHandlers/SetupWizard.php(398): Fisharebest\webtrees\Services\MigrationService->updateSchema('\\Fisharebest\\We...', 'WT_SCHEMA_VERSI...', 45)
#8 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/app/Http/RequestHandlers/SetupWizard.php(359): Fisharebest\webtrees\Http\RequestHandlers\SetupWizard->createConfigFile(Array)
#9 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/app/Http/RequestHandlers/SetupWizard.php(193): Fisharebest\webtrees\Http\RequestHandlers\SetupWizard->step6Install(Array)
#10 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/app/Http/Middleware/ReadConfigIni.php(68): Fisharebest\webtrees\Http\RequestHandlers\SetupWizard->handle(Object(Nyholm\Psr7\ServerRequest))
#11 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/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/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/app/Http/Middleware/SecurityHeaders.php(48): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#13 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\SecurityHeaders->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#14 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#15 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\EmitResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher))
#16 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/venMy dor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#17 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/app/webtrees.php(245): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest))
#18 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/app/webtrees.php(232): Fisharebest\webtrees\webtrees::dispatch(Object(Nyholm\Psr7\ServerRequest), Array)
#19 /home/vol5_3/epizy.com/epiz_28561355/htdocs/webtrees/index.php(44): Fisharebest\webtrees\webtrees->httpRequest()
#20 {main}
My WT would be miarbol.infinityfreeapp.com/webtrees/
Thanks in advance
Jorge.

New at webtrees, using v 2.0.0 My native language is Spanish. Sorry for my bad English.

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

More
2 years 11 months ago #2 by Sir Peter
Replied by Sir Peter on topic Error SQLSTATE [42000] in fresh install.

1142 REFERENCES command denied to user ...

Your database user seems to be missing the REFERENCES privilege.

support.mattermost.com/hc/en-us/articles...ENCES-command-denied
stackoverflow.com/questions/41258971/mys...t-was-working-on-5-0

Peter

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

Powered by Kunena Forum