Before asking for help please read "How to request help" by clicking on that tab above here.

TOPIC: [SOLVED] 2.0.3 and the Vesta-modules from Richard

2.0.3 and the Vesta-modules from Richard 2 weeks 5 days ago #1

  • wsb56
  • wsb56's Avatar
  • Offline
  • New
  • Posts: 37
What is the exact status of Richards "Vesta..."modules in 2.0.3.

There seemed to be problems. Are they solved? Otherwise I will have to stick to 2.0.2!

Bernd
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 2 weeks 4 days ago #2

  • ric2015
  • ric2015's Avatar
  • Offline
  • Junior
  • Posts: 130
The latest Vesta release (from today) works with 2.0.3 in general. The Shared Places module temporarily requires replacing a single webtrees core file, instructions are included. All other modules can be used as before, without further adjustments. I hope we'll be able to resolve this properly in the next webtrees release, see these issues for details: here, here, and here.

The 'develop'-branch is expected to address the issue, but its development has stalled unfortunately.
Richard

webtrees 1.7.15 at cissee.de/webtrees
Custom modules for 1.7.x and 2.x (Extended Relationships, Gov4Webtrees, Shared Places, Compact Themes Adjuster) available at cissee.de
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 2 weeks 4 days ago #3

  • wsb56
  • wsb56's Avatar
  • Offline
  • New
  • Posts: 37
Hi Richard,

thanks a lot. With these informations I can move to 2.0.3.

Best regards from Braunschweig
Bernd
The administrator has disabled public write access.

[SOLVED] 2.0.3 and the Vesta-modules from Richard 2 weeks 4 days ago #4

  • wsb56
  • wsb56's Avatar
  • Offline
  • New
  • Posts: 37
Problem solved.
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 1 week 5 days ago #5

  • rola
  • rola's Avatar
  • Offline
  • New
  • Posts: 77
ric2015 wrote:
The Shared Places module temporarily requires replacing a single webtrees core file, instructions are included.

I will to test and play a little bit with the vesta modules.

I have just downloded the file vesta."2.0.3.1.zip". After instalation I received a message You'll either have to disable it temporarily, or patch the webtrees core code by replacing a single file, as described in 'Hotfix.txt' in this module's folder. - but there is no file 'Hotfix.txt' in the folder, only a subfolder "hotfix". Should I copy the file "ModuleService.php" into the folder "app/Services"?

Thanks

Ladislav
webtrees 1.7.16
testing webtrees 2.0.2
on PHP Version 7.3.12
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 1 week 5 days ago #6

  • ric2015
  • ric2015's Avatar
  • Offline
  • Junior
  • Posts: 130
rola wrote:
Should I copy the file "ModuleService.php" into the folder "app/Services"?

Thanks for the note - I forgot to include the instructions file, I have just added it. You can now also find it here. Anyway you already figured out what to do: Copying the "ModuleService.php" file indeed 'fixes' the issue and the warning message will disappear. Again, I hope we'll resolve this properly in the next webtrees release!
Richard

webtrees 1.7.15 at cissee.de/webtrees
Custom modules for 1.7.x and 2.x (Extended Relationships, Gov4Webtrees, Shared Places, Compact Themes Adjuster) available at cissee.de
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 1 week 5 days ago #7

  • wsb56
  • wsb56's Avatar
  • Offline
  • New
  • Posts: 37
And it works well. I'm very satisfied...

Bernd
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 1 week 5 days ago #8

  • rola
  • rola's Avatar
  • Offline
  • New
  • Posts: 77
It looks very, I am sure I will have a lot of questions to understan better the whole concept of GEDCOM-L and GOV-id.

Now i have two small problems:

1. the Vesta tab places gives the following errors:

With german as the language:
SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8_german2_ci' (SQL: select * from `wt_other` where `o_type` = _LOC and `o_file` in (1) and o_gedcom /*! COLLATE utf8_german2_ci */ LIKE %1%NAME%Necpaly%) …/vendor/illuminate/database/Connection.php:664
#0 …/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#1 …/vendor/illuminate/database/Connection.php(367): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#2 …/modules_v4/vesta_shared_places/patchedWebtrees/Services/SearchServiceExt.php(80): Illuminate\Database\Connection->cursor('select * from `...', Array, true)
#3 …/modules_v4/vesta_shared_places/patchedWebtrees/Services/SearchServiceExt.php(55): Cissee\WebtreesExt\Services\SearchServiceExt->paginateQuery(Object(Illuminate\Database\Query\Builder), Object(Closure), Object(Closure), 0, 9223372036854775807)
...
#69 …/index.php(55): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest))
#70 {main}

With englissh, or slovak language:
Undefined variable: provider …/resources/views/modules/places/tab.phtml:35
#0 …/resources/views/modules/places/tab.phtml(35): Fisharebest\Webtrees\Webtrees::Fisharebest\Webtrees\{closure}(8, 'Undefined varia...', '/home/html/just...', 35, Array)
#1 …/app/View.php(186): include('/home/html/just...')
#2 …/app/View.php(282): Fisharebest\Webtrees\View->render()
#3 …/app/Helpers/functions.php(203): Fisharebest\Webtrees\View::make('modules/places/...', Array)
#4 …/modules_v4/vesta_places_and_pedigree_map/PlacesController.php(51): view('modules/places/...', Array)
#5 …/modules_v4/vesta_places_and_pedigree_map/PlacesAndPedigreeMapModuleExtended.php(86): Cissee\Webtrees\Module\PPM\PlacesController->getTabContent(Object(Fisharebest\Webtrees\Individual))
#6 …/app/Module/ModuleTabTrait.php(140): Cissee\Webtrees\Module\PPM\PlacesAndPedigreeMapModuleExtended->getTabContent(Object(Fisharebest\Webtrees\Individual))
...
#62 …/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle(Object(Nyholm\Psr7\ServerRequest))
#63 …/index.php(55): Middleland\Dispatcher->dispatch(Object(Nyholm\Psr7\ServerRequest))
#64 {main}

2. Weesta chart "Pedigree map" displays insted of the map only a grey rectangle


Ladislav
webtrees 1.7.16
testing webtrees 2.0.2
on PHP Version 7.3.12
Last Edit: 1 week 4 days ago by rola.
The administrator has disabled public write access.
Do you need a web hosting solution for your webtrees site?
If you prefer a host that specialises in webtrees, the following page lists some suppliers able to provide one for you: 

2.0.3 and the Vesta-modules from Richard 1 week 4 days ago #9

  • ric2015
  • ric2015's Avatar
  • Offline
  • Junior
  • Posts: 130
What a mess! I think I have fixed these issues now in the latest release - apart from this "Unknown collation: 'utf8_german2_ci'", which I don't understand (and cannot reproduce). I guess this collation is selected somehow based on your php config (PDO?), it isn't set anywhere explicitly. I would expect this to cause issues in other places as well (not only within the custom modules), if you select German as language.
Richard

webtrees 1.7.15 at cissee.de/webtrees
Custom modules for 1.7.x and 2.x (Extended Relationships, Gov4Webtrees, Shared Places, Compact Themes Adjuster) available at cissee.de
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 1 week 4 days ago #10

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 12560
> Unknown collation: 'utf8_german2_ci'

What version of MySQL do you use?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 1 week 4 days ago #11

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 12560
The utf8_german2_ci collation is only available in MySQL 5.6 or higher.

If you are using MySQL 5.5, then it went out of support in 2018.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 1 week 4 days ago #12

  • rola
  • rola's Avatar
  • Offline
  • New
  • Posts: 77
fisharebest wrote:
> Unknown collation: 'utf8_german2_ci'

What version of MySQL do you use?

No idea, here is my phpinfo

Ladislav
webtrees 1.7.16
testing webtrees 2.0.2
on PHP Version 7.3.12
Last Edit: 1 week 4 days ago by rola.
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 1 week 4 days ago #13

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 12560
The MySQL version is not included in phpinfo.

You will need to connect to your MySQL server and run this query:

show variables like 'version';
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 1 week 4 days ago #14

  • rola
  • rola's Avatar
  • Offline
  • New
  • Posts: 77
It seems to be version:5.5.62-0+deb8u1.

Ladislav
webtrees 1.7.16
testing webtrees 2.0.2
on PHP Version 7.3.12
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 1 week 4 days ago #15

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 12560
@ric2015

See github.com/vesta-webtrees-2-custom-modul...hServiceExt.php#L115
$field = DB::raw($field . ' /*! COLLATE ' . 'utf8_' . $this->locale->collation() . ' */');

Instead, try this.
$field = DB::raw($field . ' /*! COLLATE ' . I18N::collation() . ' */');

This function was written before MySQL 5.6 was widely available.
We probably need to detect the MySQL version, and only enable german/vietnamese/croatian if it is available.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 1 week 4 days ago #16

  • rola
  • rola's Avatar
  • Offline
  • New
  • Posts: 77
ric2015 wrote:
What a mess! I think I have fixed these issues now in the latest release - apart from this "Unknown collation: 'utf8_german2_ci'", which I don't understand (and cannot reproduce). I guess this collation is selected somehow based on your php config (PDO?), it isn't set anywhere explicitly. I would expect this to cause issues in other places as well (not only within the custom modules), if you select German as language.

Thanks for the new version. It works as expected.

The problem with german language I solved with changing the line in SearchServiceExt.php with the following code:
$field = DB::raw($field . ' /*! COLLATE ' . 'utf8_general_ci' . ' */');

Using the code provided by Greg I received something like "no function I18N"

Ladislav
webtrees 1.7.16
testing webtrees 2.0.2
on PHP Version 7.3.12
The administrator has disabled public write access.

2.0.3 and the Vesta-modules from Richard 1 week 4 days ago #17

  • ric2015
  • ric2015's Avatar
  • Offline
  • Junior
  • Posts: 130
Thanks Greg - I guess I'll just drop that line altogether, it's not in the original SearchService either (although the method is commented as "Apply collation rules to MySQL."). I don't think it's required in this context anyway, not sure where it came from ...
Richard

webtrees 1.7.15 at cissee.de/webtrees
Custom modules for 1.7.x and 2.x (Extended Relationships, Gov4Webtrees, Shared Places, Compact Themes Adjuster) available at cissee.de
The administrator has disabled public write access.
Powered by Kunena Forum