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

TOPIC:

Base table or view already exists error message on going to my site 6 days 3 hours ago #1

  • zeidbop
  • zeidbop's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 81
I have had my webtrees site for many years and today when I went to the site I got the error message below. That is all that comes up. There is no UI or anything like that. Just that error message. (see for yourself at zeidmanfamily.com) I searched the forum and saw that somebody else had the same error but just after installation. However as far as I am aware I have not upgraded the site for a while now. This error seems to have come out of the blue. Is there anything that you can suggest to get me back up and running again?


PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'wt_gedcom' already exists in /home/zeidmanf/public_html/vendor/illuminate/database/Connection.php:501 Stack trace: #0 /home/zeidmanf/public_html/vendor/illuminate/database/Connection.php(501): PDOStatement->execute() #1 /home/zeidmanf/public_html/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}('create table `w...', Array) #2 /home/zeidmanf/public_html/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback('create table `w...', Array, Object(Closure)) #3 /home/zeidmanf/public_html/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run('create table `w...', Array, Object(Closure)) #4 /home/zeidmanf/public_html/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement('create table `w...') #5 /home/zeidmanf/public_html/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar)) #6 /home/zeidmanf/public_html/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint)) #7 /home/zeidmanf/public_html/app/Schema/Migration0.php(44): Illuminate\Database\Schema\Builder->create('gedcom', Object(Closure)) #8 /home/zeidmanf/public_html/app/Services/MigrationService.php(69): Fisharebest\Webtrees\Schema\Migration0->upgrade() #9 /home/zeidmanf/public_html/app/Http/Middleware/UpdateDatabaseSchema.php(55): Fisharebest\Webtrees\Services\MigrationService->updateSchema('\\Fisharebest\\We...', 'WT_SCHEMA_VERSI...', 45) #10 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UpdateDatabaseSchema->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #11 /home/zeidmanf/public_html/app/Http/Middleware/UseDatabase.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #12 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseDatabase->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #13 /home/zeidmanf/public_html/app/Http/Middleware/BadBotBlocker.php(233): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #14 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BadBotBlocker->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #15 /home/zeidmanf/public_html/app/Http/Middleware/CompressResponse.php(73): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #16 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\CompressResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #17 /home/zeidmanf/public_html/app/Http/Middleware/ContentLength.php(40): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #18 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ContentLength->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #19 /home/zeidmanf/public_html/vendor/middlewares/client-ip/src/ClientIp.php(65): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #20 /home/zeidmanf/public_html/app/Http/Middleware/ClientIp.php(47): Middlewares\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #21 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #22 /home/zeidmanf/public_html/app/Http/Middleware/HandleExceptions.php(90): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #23 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\HandleExceptions->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #24 /home/zeidmanf/public_html/app/Http/Middleware/BaseUrl.php(79): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #25 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BaseUrl->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #26 /home/zeidmanf/public_html/app/Http/Middleware/ReadConfigIni.php(68): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #27 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ReadConfigIni->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #28 /home/zeidmanf/public_html/app/Http/Middleware/SecurityHeaders.php(48): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #29 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\SecurityHeaders->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #30 /home/zeidmanf/public_html/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #31 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\EmitResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #32 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #33 /home/zeidmanf/public_html/app/Webtrees.php(275): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest)) #34 /home/zeidmanf/public_html/app/Webtrees.php(262): Fisharebest\Webtrees\Webtrees::dispatch(Object(Nyholm\Psr7\ServerRequest), Array) #35 /home/zeidmanf/public_html/index.php(51): Fisharebest\Webtrees\Webtrees->httpRequest() #36 {main} Next Illuminate\Database\QueryException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'wt_gedcom' already exists (SQL: create table `wt_gedcom` (`gedcom_id` int not null auto_increment primary key, `gedcom_name` varchar(255) not null, `sort_order` int not null default '0') default character set utf8 collate 'utf8_unicode_ci' engine = InnoDB) in /home/zeidmanf/public_html/vendor/illuminate/database/Connection.php:712 Stack trace: #0 /home/zeidmanf/public_html/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback('create table `w...', Array, Object(Closure)) #1 /home/zeidmanf/public_html/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run('create table `w...', Array, Object(Closure)) #2 /home/zeidmanf/public_html/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement('create table `w...') #3 /home/zeidmanf/public_html/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar)) #4 /home/zeidmanf/public_html/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint)) #5 /home/zeidmanf/public_html/app/Schema/Migration0.php(44): Illuminate\Database\Schema\Builder->create('gedcom', Object(Closure)) #6 /home/zeidmanf/public_html/app/Services/MigrationService.php(69): Fisharebest\Webtrees\Schema\Migration0->upgrade() #7 /home/zeidmanf/public_html/app/Http/Middleware/UpdateDatabaseSchema.php(55): Fisharebest\Webtrees\Services\MigrationService->updateSchema('\\Fisharebest\\We...', 'WT_SCHEMA_VERSI...', 45) #8 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UpdateDatabaseSchema->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #9 /home/zeidmanf/public_html/app/Http/Middleware/UseDatabase.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #10 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseDatabase->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #11 /home/zeidmanf/public_html/app/Http/Middleware/BadBotBlocker.php(233): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #12 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BadBotBlocker->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #13 /home/zeidmanf/public_html/app/Http/Middleware/CompressResponse.php(73): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #14 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\CompressResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #15 /home/zeidmanf/public_html/app/Http/Middleware/ContentLength.php(40): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #16 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ContentLength->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #17 /home/zeidmanf/public_html/vendor/middlewares/client-ip/src/ClientIp.php(65): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #18 /home/zeidmanf/public_html/app/Http/Middleware/ClientIp.php(47): Middlewares\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #19 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #20 /home/zeidmanf/public_html/app/Http/Middleware/HandleExceptions.php(90): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #21 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\HandleExceptions->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #22 /home/zeidmanf/public_html/app/Http/Middleware/BaseUrl.php(79): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #23 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BaseUrl->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #24 /home/zeidmanf/public_html/app/Http/Middleware/ReadConfigIni.php(68): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #25 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ReadConfigIni->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #26 /home/zeidmanf/public_html/app/Http/Middleware/SecurityHeaders.php(48): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #27 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\SecurityHeaders->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #28 /home/zeidmanf/public_html/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #29 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\EmitResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #30 /home/zeidmanf/public_html/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #31 /home/zeidmanf/public_html/app/Webtrees.php(275): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest)) #32 /home/zeidmanf/public_html/app/Webtrees.php(262): Fisharebest\Webtrees\Webtrees::dispatch(Object(Nyholm\Psr7\ServerRequest), Array) #33 /home/zeidmanf/public_html/index.php(51): Fisharebest\Webtrees\Webtrees->httpRequest() #34 {main}

Thanks

David
(These settings may be out of date!)
-- MySQL Server version: 10.3.18-MariaDB
-- PHP Version: 8.0.16
-- webtrees 2.1.1
-- Edge 99

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

Base table or view already exists error message on going to my site 5 days 21 hours ago #2

  • zeidbop
  • zeidbop's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 81
I think that there may be a database issue. I have approached my hosting provider for further help...
(These settings may be out of date!)
-- MySQL Server version: 10.3.18-MariaDB
-- PHP Version: 8.0.16
-- webtrees 2.1.1
-- Edge 99

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

  • Page:
  • 1
Powered by Kunena Forum