Solved 404 error page after upgrading from 1.7.20 to 2.0.26
- fisharebest
-
- Offline
- Administrator
-
Less
More
1 year 5 months ago #21
by fisharebest
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Replied by fisharebest on topic 404 error page after upgrading from 1.7.20 to 2.0.26
You set:
If you set this, webtrees will generate "pretty URLs". If you do this, you must also configure your webserver to pass requests to the file index.php. See webtrees.net/faq/urls/
For the next error,
This says that you have set the database table-prefix to "wt-" (not the default "wt_").
The setup script does not allow you to select a hyphen (only an underscore).
I guess the 1.7 setup allowed this...
The error is in the database library. It might (or might not) be possible to fix this in webtrees.
Create an issue on github and I'll take a look.
Code:
rewrite_urls="1"
If you set this, webtrees will generate "pretty URLs". If you do this, you must also configure your webserver to pass requests to the file index.php. See webtrees.net/faq/urls/
For the next error,
Code:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wt' in 'field list' (SQL: select `wt-g_individuals`.*,
This says that you have set the database table-prefix to "wt-" (not the default "wt_").
The setup script does not allow you to select a hyphen (only an underscore).
I guess the 1.7 setup allowed this...
The error is in the database library. It might (or might not) be possible to fix this in webtrees.
Create an issue on github and I'll take a look.
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Please Log in or Create an account to join the conversation.
- littlegolf
-
Topic Author
- Offline
- New Member
-
1 year 5 months ago #22
by littlegolf
I understood the same, but in config.php.ini there was/is this:
the same prefix I set up and I used at the begin (years ago)
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Replied by littlegolf on topic 404 error page after upgrading from 1.7.20 to 2.0.26
There is a prefix for the tables defined in config.ini.php (like wt_). It should be the same as it is used in the names of the database tables.
I understood the same, but in config.php.ini there was/is this:
Code:
tblpfx="wt-g_"
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Please Log in or Create an account to join the conversation.
- littlegolf
-
Topic Author
- Offline
- New Member
-
1 year 5 months ago #23
by littlegolf
Can I fix it if I rename every table with another allowed prefix (e.g. "wtg_" instead of "wt-g_")?
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Replied by littlegolf on topic 404 error page after upgrading from 1.7.20 to 2.0.26
not now.You set:
Code:rewrite_urls="1"
Yes, I set up years ago...For the next error,
Code:SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wt' in 'field list' (SQL: select `wt-g_individuals`.*,
This says that you have set the database table-prefix to "wt-" (not the default "wt_").
The setup script does not allow you to select a hyphen (only an underscore).
I guess the 1.7 setup allowed this...
Ok.The error is in the database library. It might (or might not) be possible to fix this in webtrees.
Create an issue on github and I'll take a look.
Can I fix it if I rename every table with another allowed prefix (e.g. "wtg_" instead of "wt-g_")?
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Please Log in or Create an account to join the conversation.
- bertkoor
-
- Offline
- Platinum Member
-
- Greetings from Utrecht, Holland
1 year 5 months ago - 1 year 5 months ago #24
by bertkoor
You can at least try. There might be an issue with foreign key constraints (a column in one table pointing to data from another table)
To prevent such things you can use PhpMyAdmin control panel to make a dump of the whole database content into a text file, search&replace "wt-g_" for "wtg_" and load that back.
stamboom.BertKoor.nl runs on webtrees v2.1.20
Replied by bertkoor on topic 404 error page after upgrading from 1.7.20 to 2.0.26
Can I fix it if I rename every table with another allowed prefix (e.g. "wtg_" instead of "wt-g_")?
You can at least try. There might be an issue with foreign key constraints (a column in one table pointing to data from another table)
To prevent such things you can use PhpMyAdmin control panel to make a dump of the whole database content into a text file, search&replace "wt-g_" for "wtg_" and load that back.
stamboom.BertKoor.nl runs on webtrees v2.1.20
Last edit: 1 year 5 months ago by bertkoor.
Please Log in or Create an account to join the conversation.
- littlegolf
-
Topic Author
- Offline
- New Member
-
1 year 5 months ago - 1 year 5 months ago #25
by littlegolf
I did it (exported in ods, manually modified tables names and changes in the 4 tables); I correctly uploaded the tables in db and modified congif.ini.php.
No succeed...
This is what I get...
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Replied by littlegolf on topic 404 error page after upgrading from 1.7.20 to 2.0.26
Can I fix it if I rename every table with another allowed prefix (e.g. "wtg_" instead of "wt-g_")?
You can at least try. There might be an issue with foreign key constraints (a column in one table pointing to data from another table)
To prevent such things you can use PhpMyAdmin control panel to make a dump of the whole database content into a text file, search&replace "wt-g_" for "wtg_" and load that back.
I did it (exported in ods, manually modified tables names and changes in the 4 tables); I correctly uploaded the tables in db and modified congif.ini.php.
No succeed...
This is what I get...
Code:
PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'wtg_gedcom' already exists in /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 Stack trace: #0 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL) #1 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Connection.php(458): Doctrine\DBAL\Driver\PDOStatement->execute() #2 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('create table `w...', Array) #3 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('create table `w...', Array, Object(Closure)) #4 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Connection.php(459): Illuminate\Database\Connection->run('create table `w...', Array, Object(Closure)) #5 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Schema/Blueprint.php(97): Illuminate\Database\Connection->statement('create table `w...') #6 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Schema/Builder.php(278): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar)) #7 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Schema/Builder.php(167): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint)) #8 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Schema/Migration0.php(44): Illuminate\Database\Schema\Builder->create('gedcom', Object(Closure)) #9 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Services/MigrationService.php(71): Fisharebest\webtrees\Schema\Migration0->upgrade() #10 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/UpdateDatabaseSchema.php(56): Fisharebest\webtrees\Services\MigrationService->updateSchema('\\Fisharebest\\We...', 'WT_SCHEMA_VERSI...', 45) #11 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UpdateDatabaseSchema->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #12 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/UseDatabase.php(117): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #13 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseDatabase->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #14 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/BadBotBlocker.php(223): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #15 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BadBotBlocker->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #16 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/CompressResponse.php(75): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #17 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\CompressResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #18 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/ContentLength.php(40): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #19 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ContentLength->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #20 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/middlewares/client-ip/src/ClientIp.php(81): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #21 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/ClientIp.php(47): Middlewares\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #22 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #23 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/HandleExceptions.php(90): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #24 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\HandleExceptions->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #25 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/BaseUrl.php(77): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #26 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BaseUrl->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #27 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/ReadConfigIni.php(69): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #28 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ReadConfigIni->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #29 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/SecurityHeaders.php(48): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #30 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\SecurityHeaders->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #31 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #32 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\EmitResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #33 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #34 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/webtrees.php(239): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest)) #35 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/webtrees.php(226): Fisharebest\webtrees\webtrees::dispatch(Object(Nyholm\Psr7\ServerRequest), Array) #36 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/index.php(44): Fisharebest\webtrees\webtrees->httpRequest() #37 {main} Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'wtg_gedcom' already exists in /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: #0 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException)) #1 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Connection.php(458): Doctrine\DBAL\Driver\PDOStatement->execute() #2 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('create table `w...', Array) #3 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('create table `w...', Array, Object(Closure)) #4 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Connection.php(459): Illuminate\Database\Connection->run('create table `w...', Array, Object(Closure)) #5 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Schema/Blueprint.php(97): Illuminate\Database\Connection->statement('create table `w...') #6 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Schema/Builder.php(278): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar)) #7 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Schema/Builder.php(167): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint)) #8 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Schema/Migration0.php(44): Illuminate\Database\Schema\Builder->create('gedcom', Object(Closure)) #9 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Services/MigrationService.php(71): Fisharebest\webtrees\Schema\Migration0->upgrade() #10 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/UpdateDatabaseSchema.php(56): Fisharebest\webtrees\Services\MigrationService->updateSchema('\\Fisharebest\\We...', 'WT_SCHEMA_VERSI...', 45) #11 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UpdateDatabaseSchema->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #12 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/UseDatabase.php(117): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #13 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseDatabase->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #14 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/BadBotBlocker.php(223): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #15 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BadBotBlocker->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #16 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/CompressResponse.php(75): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #17 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\CompressResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #18 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/ContentLength.php(40): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #19 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ContentLength->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #20 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/middlewares/client-ip/src/ClientIp.php(81): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #21 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/ClientIp.php(47): Middlewares\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #22 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #23 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/HandleExceptions.php(90): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #24 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\HandleExceptions->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #25 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/BaseUrl.php(77): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #26 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BaseUrl->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #27 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/ReadConfigIni.php(69): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #28 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ReadConfigIni->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #29 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/SecurityHeaders.php(48): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #30 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\SecurityHeaders->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #31 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #32 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\EmitResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #33 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #34 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/webtrees.php(239): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest)) #35 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/webtrees.php(226): Fisharebest\webtrees\webtrees::dispatch(Object(Nyholm\Psr7\ServerRequest), Array) #36 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/index.php(44): Fisharebest\webtrees\webtrees->httpRequest() #37 {main} Next Illuminate\Database\QueryException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'wtg_gedcom' already exists (SQL: create table `wtg_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 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Connection.php:664 Stack trace: #0 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('create table `w...', Array, Object(Closure)) #1 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Connection.php(459): Illuminate\Database\Connection->run('create table `w...', Array, Object(Closure)) #2 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Schema/Blueprint.php(97): Illuminate\Database\Connection->statement('create table `w...') #3 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Schema/Builder.php(278): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar)) #4 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/illuminate/database/Schema/Builder.php(167): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint)) #5 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Schema/Migration0.php(44): Illuminate\Database\Schema\Builder->create('gedcom', Object(Closure)) #6 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Services/MigrationService.php(71): Fisharebest\webtrees\Schema\Migration0->upgrade() #7 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/UpdateDatabaseSchema.php(56): Fisharebest\webtrees\Services\MigrationService->updateSchema('\\Fisharebest\\We...', 'WT_SCHEMA_VERSI...', 45) #8 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UpdateDatabaseSchema->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #9 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/UseDatabase.php(117): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #10 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\UseDatabase->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #11 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/BadBotBlocker.php(223): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #12 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BadBotBlocker->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #13 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/CompressResponse.php(75): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #14 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\CompressResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #15 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/ContentLength.php(40): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #16 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ContentLength->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #17 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/middlewares/client-ip/src/ClientIp.php(81): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #18 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/ClientIp.php(47): Middlewares\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #19 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #20 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/HandleExceptions.php(90): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #21 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\HandleExceptions->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #22 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/BaseUrl.php(77): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #23 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\BaseUrl->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #24 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/ReadConfigIni.php(69): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #25 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\ReadConfigIni->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #26 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/SecurityHeaders.php(48): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #27 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\SecurityHeaders->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #28 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #29 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\webtrees\Http\Middleware\EmitResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Middleland\Dispatcher)) #30 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest)) #31 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/webtrees.php(239): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest)) #32 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/webtrees.php(226): Fisharebest\webtrees\webtrees::dispatch(Object(Nyholm\Psr7\ServerRequest), Array) #33 /web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/index.php(44): Fisharebest\webtrees\webtrees->httpRequest() #34 {main}
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Last edit: 1 year 5 months ago by littlegolf.
Please Log in or Create an account to join the conversation.
- littlegolf
-
Topic Author
- Offline
- New Member
-
1 year 5 months ago #26
by littlegolf
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Replied by littlegolf on topic 404 error page after upgrading from 1.7.20 to 2.0.26
I backed up the 1.7.20 version site.
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Please Log in or Create an account to join the conversation.
- bertkoor
-
- Offline
- Platinum Member
-
- Greetings from Utrecht, Holland
1 year 5 months ago #27
by bertkoor
stamboom.BertKoor.nl runs on webtrees v2.1.20
Replied by bertkoor on topic 404 error page after upgrading from 1.7.20 to 2.0.26
Only 4 tables? There should be at least 20 if I recall correctly
stamboom.BertKoor.nl runs on webtrees v2.1.20
Please Log in or Create an account to join the conversation.
- fisharebest
-
- Offline
- Administrator
-
1 year 5 months ago #28
by fisharebest
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Replied by fisharebest on topic 404 error page after upgrading from 1.7.20 to 2.0.26
> This is what I get...
Did you update the table prefix in config.ini.php?
That error indicates that it cannot read the current version from table wtg_site_setting, so assumes it needs to create all the tables (it creates wtg_gedcom first).
Sounds like you have some tables, but not others. This could be caused by foreign key checks.
TIP, if you are creating a mysql-dump and editing it (as suggested by bertkoor), then
a) search/replace `wt-g_ with `wtg_ (note the backtick at the start). This stops you accidently changing things that should not be changed. That sequence could appear in IDs, secret keys, etc.
b) make sure the mysqldump file contains a line "SET foreign_key_checks := 0;" near the beginning. Otherwise you'll find that some tables won't load due to foreign key checks.
c) if your mysqldump file does not contain "DROP TABLE ..." statements, then delete all the tables before you import the SQL file.
Did you update the table prefix in config.ini.php?
That error indicates that it cannot read the current version from table wtg_site_setting, so assumes it needs to create all the tables (it creates wtg_gedcom first).
Sounds like you have some tables, but not others. This could be caused by foreign key checks.
TIP, if you are creating a mysql-dump and editing it (as suggested by bertkoor), then
a) search/replace `wt-g_ with `wtg_ (note the backtick at the start). This stops you accidently changing things that should not be changed. That sequence could appear in IDs, secret keys, etc.
b) make sure the mysqldump file contains a line "SET foreign_key_checks := 0;" near the beginning. Otherwise you'll find that some tables won't load due to foreign key checks.
c) if your mysqldump file does not contain "DROP TABLE ..." statements, then delete all the tables before you import the SQL file.
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Please Log in or Create an account to join the conversation.
- littlegolf
-
Topic Author
- Offline
- New Member
-
1 year 4 months ago #29
by littlegolf
I think I have to repeat all better...
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Replied by littlegolf on topic 404 error page after upgrading from 1.7.20 to 2.0.26
Only 4 tables? There should be at least 20 if I recall correctly
I think I have to repeat all better...
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Please Log in or Create an account to join the conversation.
- littlegolf
-
Topic Author
- Offline
- New Member
-
1 year 4 months ago - 1 year 4 months ago #30
by littlegolf
Thank you Greg!
Next week I will have no time to apply your tips.
Now I have a new problem with original site (1.7.20) I uploaded from a backup.
This is the error messagge:
I deleted all the tables then I uploaded the dump.
Table is on the db. Why this problem?
Anyway, I reupload all files and the database dump.
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Replied by littlegolf on topic 404 error page after upgrading from 1.7.20 to 2.0.26
Yes.> This is what I get...
Did you update the table prefix in config.ini.php?
That error indicates that it cannot read the current version from table wtg_site_setting, so assumes it needs to create all the tables (it creates wtg_gedcom first).
Sounds like you have some tables, but not others. This could be caused by foreign key checks.
TIP, if you are creating a mysql-dump and editing it (as suggested by bertkoor), then
a) search/replace `wt-g_ with `wtg_ (note the backtick at the start). This stops you accidently changing things that should not be changed. That sequence could appear in IDs, secret keys, etc.
b) make sure the mysqldump file contains a line "SET foreign_key_checks := 0;" near the beginning. Otherwise you'll find that some tables won't load due to foreign key checks.
c) if your mysqldump file does not contain "DROP TABLE ..." statements, then delete all the tables before you import the SQL file.
Thank you Greg!
Next week I will have no time to apply your tips.
Now I have a new problem with original site (1.7.20) I uploaded from a backup.
This is the error messagge:
Code:
/web/htdocs/www.mariogolfetto.it/home/webtrees/golfetty/app/Statement.php:85 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Sql1075355_1.wt-g_site_access_rule' doesn't exist #0 /app/Statement.php:85 PDOException("SQLSTATE[42S02]: Base table or view not found: 1146 Table 'Sql1075355_1.wt-g_site_access_rule' doesn't exist") #1 /includes/session.php:315 execute([array]) #2 /index.php:31 require('/web/htdocs/www.mariogolfetto.…')
I deleted all the tables then I uploaded the dump.
Table is on the db. Why this problem?
Anyway, I reupload all files and the database dump.
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Last edit: 1 year 4 months ago by littlegolf.
Please Log in or Create an account to join the conversation.
- fisharebest
-
- Offline
- Administrator
-
1 year 4 months ago #31
by fisharebest
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Replied by fisharebest on topic 404 error page after upgrading from 1.7.20 to 2.0.26
> Table is on the db. Why this problem?
Are you sure it is there?
1) The error says it does not exist.
2) The upgrade from 1.7 to 2.x will delete this table.
I guess you upgrade the database (by upgrading the code), and then try to use the updated database with the old code.
Are you sure it is there?
1) The error says it does not exist.
2) The upgrade from 1.7 to 2.x will delete this table.
I guess you upgrade the database (by upgrading the code), and then try to use the updated database with the old code.
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
Please Log in or Create an account to join the conversation.
- littlegolf
-
Topic Author
- Offline
- New Member
-
1 year 4 months ago #32
by littlegolf
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Replied by littlegolf on topic 404 error page after upgrading from 1.7.20 to 2.0.26
Thank you Greg for your time.
Some days ago I uploaded the 1.7 backup (files and db) of golfetty webtrees site, so the site is running old version, but is back and ok.
I use a home pc as local webserver (with debian 10, Apache, PHP 7.3. MySQL) to host and test the first site, so I'm free to create some db as I like!
I will try to do what you wrote on post #28 (thank you for it).
Then...
I also updated the second site (durigon) to 2.0.26 and is ok.
Now I'm upgrading to 2.1.17, and I hope there is no problems.
Unfortunately, due to change php setting from 7.3 to 7.4 (just for now, I want to set it to 8.2), the first site (golfetty) can't run.
Well, just only one problem to solve!
Some days ago I uploaded the 1.7 backup (files and db) of golfetty webtrees site, so the site is running old version, but is back and ok.
I use a home pc as local webserver (with debian 10, Apache, PHP 7.3. MySQL) to host and test the first site, so I'm free to create some db as I like!
I will try to do what you wrote on post #28 (thank you for it).
Then...
I also updated the second site (durigon) to 2.0.26 and is ok.
Now I'm upgrading to 2.1.17, and I hope there is no problems.
Unfortunately, due to change php setting from 7.3 to 7.4 (just for now, I want to set it to 8.2), the first site (golfetty) can't run.
Well, just only one problem to solve!
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Please Log in or Create an account to join the conversation.
- littlegolf
-
Topic Author
- Offline
- New Member
-
1 year 4 months ago #33
by littlegolf
Now second site "Durigon" is updated, running on PHP Version 8.2.8
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Replied by littlegolf on topic 404 error page after upgrading from 1.7.20 to 2.0.26
Now I'm upgrading to 2.1.17, and I hope there is no problems.
Now second site "Durigon" is updated, running on PHP Version 8.2.8
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Please Log in or Create an account to join the conversation.
- littlegolf
-
Topic Author
- Offline
- New Member
-
1 year 4 months ago #34
by littlegolf
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Replied by littlegolf on topic 404 error page after upgrading from 1.7.20 to 2.0.26
Now also the first site (golfetty) is online and it was upgraded to 2.1.17.
I changed, as Greg wrote, using a command line on a personal homemade mysql server.
Then I reuploaded modified db so manual upgrading was fine.
Thanks to all.
Mario
I changed, as Greg wrote, using a command line on a personal homemade mysql server.
Then I reuploaded modified db so manual upgrading was fine.
Thanks to all.
Mario
Mario Golfetto | OpenSource & debian enthusiastic fan
[I'm sorry for my english...]
Please Log in or Create an account to join the conversation.