Entwickler getestet = ungetestet! Wir brauchen Eure Hilfe!

Question

Wir haben vergangene Woche bei unserem gemeinsamen Entwicklersprint viel programmiert.

• Wir haben den CKEditor (wird benutzt in Textfeldern mit Formatierung)
  von Version 4 auf Version 5 hochgezogen.
• Wir haben den Unterbau vom Einkaufs- und Verkaufsworkflow erneuert,
  vereinheitlicht und verbessert. Hier wurden aber erst die Grundsteine
  gelegt.
• Einige Bugfixes und diverses am neuem Design wurde auch verbessert
  bzw. berichtigt.

Zwischenzeitlich kamen auch neue Belegtypen und Funktionen hinzu

• Verkaufsauftrag wurde aufgeteilt in Auftragseingang und
  Auftragsbestätigung.

• Der Lieferantenauftrag wurde in Angebotseingang und
  Lieferantenauftrag geteilt.

• Neue SMTP und IMAP Emailfunktionen.

Es lohnt sich auf jedenfall das changelog durchzulesen Es ist zuviel das alles hier zu schreiben.
Jetzt brauchen wir Eure Hilfe zum Testen.
Sofern die Möglichkeit besteht ein Testsystem aufzubauen bitten wir Euch kivitendo an der Oberfläche mit Euren Daten zu testen und uns hier Rückmeldung zu geben. Es ist alles im aktuellem masterbranch eingecheckt.
Wir wollen dann in zwei Wochen die betaversion 3.9 stempeln.
Um die SMTP und IMAP Funktionen zu testen lohnt sich ein Blick in die kivitendo.conf.default.
Die PDF bzw. HTML Dokumentation ist auch erweitert.
Fehler können direkt hier als Antwort erfasst werden.

Beste Grüße
Werner kivitendodienstleister

Answer 1

Hallo,
Ich wollte das mal testen und habe heute sowohl beim ERP, als auch beim CRM einen "git pull " gemacht.
Leider bekomme ich auf meinem Testsystem nur folgende Fehlermeldung:

Fehler!

Invalid method 'get_layout_style' at /srv/www/vhosts/kivitendo/kivitendo-erp/SL/Helper/UserPreferences/DisplayPreferences.pm  line 22.

Auf meinem Testsystem laufen mehrere port-based VHosts, u.a. auch Kivitendo.
In der Errordatei des "Indianers" bekomme ich folgende Meldung:

[Mon Oct 16 11:44:44.392714 2023] [fcgid:warn] [pid 117989] [client 192.168.2.18:47314] mod_fcgid: stderr: Invalid method 'get_layout_style' at /srv/www/vhosts/kivitendo/kivitendo-erp/SL/Helper/UserPreferences/DisplayPreferences.pm line 22., referer: http://snrnas.snr:1762/controller.pl?action=LoginScreen/user_login

Testsystem:
OS: Debian 10.13 (x86_64 mit Backports)
Kernel: Linux snrnas 5.10.0-0.deb10.16-amd64 #1 SMP Debian 5.10.127-2~bpo10+1 (2022-07-28) x86_64 GNU/Linux

Apache:

root@snrnas:~# dpkg -l | grep apache
ii  apache2                                       2.4.52-1~bpo10+1                               amd64        Apache HTTP Server
ii  apache2-bin                                   2.4.52-1~bpo10+1                               amd64        Apache HTTP Server (modules and other binary files)
ii  apache2-data                                  2.4.52-1~bpo10+1                               all          Apache HTTP Server (common files)
ii  apache2-doc                                   2.4.52-1~bpo10+1                               all          Apache HTTP Server (on-site documentation)
ii  apache2-utils                                 2.4.52-1~bpo10+1                               amd64        Apache HTTP Server (utility programs for web servers)
ii  libapache-dbi-perl                            1.12-2                                         all          interface connecting Apache server to database via perl's DBI
ii  libapache-dbilogger-perl                      0.93-13                                        all          Perl module for tracking what's being transferred in a DBI database
ii  libapache-logformat-compiler-perl             0.35-1                                         all          Perl module to pre-compile a LogFormat string
ii  libapache2-mod-fcgid                          1:2.3.9-4                                      amd64        FastCGI interface module for Apache 2
ii  libapache2-mod-perl2                          2.0.10-3                                       amd64        Integration of perl with the Apache2 web server
ii  libapache2-mod-php                            2:7.3+69                                       all          server-side, HTML-embedded scripting language (Apache 2 module) (default)
ii  libapache2-mod-php7.3                         7.3.31-1~deb10u5                               amd64        server-side, HTML-embedded scripting language (Apache 2 module)
ii  libapache2-reload-perl                        0.13-2                                         all          module for reloading Perl modules when changed on disk
`

==========zu viele Buchstaben => Rest im nächsten Post ======================

Comments

Teil 2:
Kivitendo ERP Install-Check:

root@snrnas:/srv/www/vhosts/kivitendo/kivitendo-erp# scripts/installation_check.pl -a
Checking Required Modules:
Looking for parent ....................................................... 0.236
Looking for Algorithm::CheckDigits ........................................ 0.50
Looking for Archive::Zip 1.40 ............................................. 1.64
Looking for CAM::PDF ...................................................... 1.60
Looking for CGI 3.43 ...................................................... 4.40
Looking for Clone ......................................................... 0.41
Looking for Config::Std .................................................. 0.903
Looking for Daemon::Generic 0.71 .......................................... 0.85
Looking for DateTime ...................................................... 1.50
Looking for DateTime::Event::Cron 0.08 .................................... 0.09
Looking for DateTime::Format::Strptime .................................... 1.76
Looking for DateTime::Set 0.12 .......................................... 0.3900
Looking for DBI 1.50 ..................................................... 1.642
Looking for DBD::Pg 1.49 ................................................. 3.7.4
Looking for Digest::SHA ................................................... 6.01
Looking for Exception::Class 1.44 ......................................... 1.44
Looking for Email::Address 1.888 ......................................... 1.912
Looking for Email::MIME .................................................. 1.946
Looking for Encode::IMAPUTF7 .............................................. 1.05
Looking for FCGI 0.72 ..................................................... 0.79
Looking for File::Copy::Recursive ......................................... 0.44
Looking for File::Flock 2008.01 ........................................ 2014.01
Looking for File::MimeInfo ................................................ 0.29
Looking for File::Slurp ................................................ 9999.26
Looking for GD ............................................................ 2.71
Looking for HTML::Parser .................................................. 3.72
Looking for HTML::Restrict .............................................. v2.5.0
Looking for Image::Info ................................................... 1.41
Looking for Imager ....................................................... 1.010
Looking for Imager::QRCode ............................................... 0.033
Looking for IPC::Run ................................................ 20180523.0
Looking for JSON .......................................................... 4.02
Looking for List::MoreUtils 0.30 ......................................... 0.416
Looking for List::UtilsBy 0.09 ............................................ 0.11
Looking for LWP::Authen::Digest (from libwww-perl) ........................ 6.36
Looking for LWP::UserAgent (from libwww-perl) ............................. 6.36
Looking for Math::Round ................................................... 0.07
Looking for Mail::IMAPClient .............................................. 3.42
Looking for Params::Validate .............................................. 1.29
Looking for PBKDF2::Tiny 0.005 ........................................... 0.005
Looking for PDF::API2 2.000 .............................................. 2.033
Looking for Regexp::IPv6 0.03 ............................................. 0.03
Looking for REST::Client ................................................... 273
Looking for Rose::Object ................................................. 0.860
Looking for Rose::DB ..................................................... 0.778
Looking for Rose::DB::Object 0.788 ....................................... 0.815
Looking for Set::Infinite 0.63 ............................................ 0.65
Looking for String::ShellQuote 1.01 ....................................... 1.04
Looking for Sort::Naturally ............................................... 1.03
Looking for Template 2.18 ................................................. 2.27
Looking for Text::CSV_XS 0.23 ............................................. 1.38
Looking for Text::Iconv 1.2 ................................................ 1.7
Looking for Text::Unidecode ............................................... 1.30
Looking for Try::Tiny ..................................................... 0.30
Looking for URI 1.35 ...................................................... 1.76
Looking for XML::LibXML ................................................. 2.0134
Looking for XML::Writer 0.602 ............................................ 0.625
Looking for YAML 0.62 ..................................................... 1.27
Looking for pdfinfo executable .......................................... 0.71.0

Checking Optional Modules:
Looking for HTTP::DAV 0.46 ................................................ 0.49
Looking for IO::Socket::SSL .............................................. 2.060
Looking for Net::LDAP ..................................................... 0.65
Looking for Net::SMTP::SSL ................................................ 1.04
Looking for Net::SSLGlue ................................................. 1.058
Looking for YAML::XS ...................................................... 0.79

Checking Developer Modules:
Looking for DBIx::Log4perl ................................................ 0.26
Looking for Devel::REPL ............................................... 1.003028
Looking for Term::ReadLine::Gnu ........................................... 1.36
Looking for Log::Log4perl ................................................. 1.49
Looking for LWP::Simple (from libwww-perl) ................................ 6.36
Looking for Moose::Role ................................................. 2.2011
Looking for Sys::CPU ...................................................... 0.61
Looking for Test::Deep ................................................... 1.128
Looking for Test::Exception ............................................... 0.43
Looking for Test::Output ................................................. 1.031
Looking for Thread::Pool::Simple .......................................... 0.25
Looking for URI::Find ................................................. 20160806
Looking for GD 2.00 ....................................................... 2.71
Looking for Rose::DB::Object 0.809 ....................................... 0.815
Looking for LaTeX kpsewhich ................................................. ok
Looking for LaTeX package pdfx .............................................. ok
This is pdfTeX, Version 3.14159265-2.6-1.40.19 (TeX Live 2019/dev/Debian) (preloaded format=pdflatex)
 restricted \write18 enabled.
entering extended mode
Looking for pdfx version 2018 or higher ..................................... ok

==========zu viele Buchstaben => Rest im nächsten Post ======================

---

Teil 3:
Checking LaTeX Dependencies for Master Templates 'RB':

Looking for LaTeX document class scrartcl ................................... ok
Looking for LaTeX package colortbl .......................................... ok
Looking for LaTeX package embedfile ......................................... ok
Looking for LaTeX package eurosym ........................................... ok
Looking for LaTeX package geometry .......................................... ok
Looking for LaTeX package german ............................................ ok
Looking for LaTeX package graphicx .......................................... ok
Looking for LaTeX package hyperref .......................................... ok
Looking for LaTeX package ifthen ............................................ ok
Looking for LaTeX package inputenc .......................................... ok
Looking for LaTeX package kivitendo ......................................... ok
Looking for LaTeX package lastpage .......................................... ok
Looking for LaTeX package latexsym .......................................... ok
Looking for LaTeX package longtable ......................................... ok
Looking for LaTeX package scrlayer-scrpage .................................. ok
Looking for LaTeX package substr ............................................ ok
Looking for LaTeX package tabularx .......................................... ok
Looking for LaTeX package textcomp .......................................... ok
Looking for LaTeX package ulem .............................................. ok
Looking for LaTeX package wallpaper ......................................... ok
Looking for LaTeX package xcolor ............................................ ok
Looking for LaTeX package xstring ........................................... ok
Looking for LaTeX package xy ................................................ ok

Checking LaTeX Dependencies for Master Templates 'Standard':
Looking for LaTeX document class scrartcl ................................... ok
Looking for LaTeX package colortbl .......................................... ok
Looking for LaTeX package embedfile ......................................... ok
Looking for LaTeX package eurosym ........................................... ok
Looking for LaTeX package fontenc ........................................... ok
Looking for LaTeX package fontspec .......................................... ok
Looking for LaTeX package geometry .......................................... ok
Looking for LaTeX package german ............................................ ok
Looking for LaTeX package graphicx .......................................... ok
Looking for LaTeX package hyperref .......................................... ok
Looking for LaTeX package iftex ............................................. ok
Looking for LaTeX package ifthen ............................................ ok
Looking for LaTeX package inputenc .......................................... ok
Looking for LaTeX package kiviletter ........................................ ok
Looking for LaTeX package kivitendo ......................................... ok
Looking for LaTeX package latexsym .......................................... ok
Looking for LaTeX package longtable ......................................... ok
Looking for LaTeX package textcomp .......................................... ok
Looking for LaTeX package transparent ....................................... ok
Looking for LaTeX package ulem .............................................. ok
Looking for LaTeX package xstring ........................................... ok

Checking LaTeX Dependencies for Master Templates 'marei':
Looking for LaTeX document class scrartcl ................................... ok
Looking for LaTeX package colortbl .......................................... ok
Looking for LaTeX package embedfile ......................................... ok
Looking for LaTeX package eurosym ........................................... ok
Looking for LaTeX package fontenc ........................................... ok
Looking for LaTeX package fontspec .......................................... ok
Looking for LaTeX package geometry .......................................... ok
Looking for LaTeX package german ............................................ ok
Looking for LaTeX package graphicx .......................................... ok
Looking for LaTeX package hyperref .......................................... ok
Looking for LaTeX package iftex ............................................. ok
Looking for LaTeX package ifthen ............................................ ok
Looking for LaTeX package inputenc .......................................... ok
Looking for LaTeX package kiviletter ........................................ ok
Looking for LaTeX package kivitendo ......................................... ok
Looking for LaTeX package latexsym .......................................... ok
Looking for LaTeX package longtable ......................................... ok
Looking for LaTeX package textcomp .......................................... ok
Looking for LaTeX package transparent ....................................... ok
Looking for LaTeX package ulem .............................................. ok
Looking for LaTeX package xstring ........................................... ok

Checking LaTeX Dependencies for Master Templates 'rev-odt':
Looking for LaTeX package embedfile ......................................... ok
Looking for LaTeX package textcomp .......................................... ok
Looking for LaTeX package ulem .............................................. ok

Result:
All ......................................................................... OK

MfG
SNR

---

Hallo SNR,
der Fehler ist am Freitag reingekommen und gerade vor 22 min gefixt der letzte commit sollte sein:

e38f0b8725 Erzwungener Layout-Stil: Abfangen, wenn Spalte in defaults noch nicht…

versuchen Sie doch bitte nochmalein aktuelles pull und falls dieser Fehler immer noch besteht eine kurze Meldung.
Ansonsten schonmal vielen dank fürs testen.

Beste Grüße
Werner kivitendodienstleister

---

Hallo,
Ja danke, hat geholfen (hab das an dem Tag noch probiert, aber keine Zeit zum Antworten) und ich habe heute noch mal weiter getestet. Leider wird ein DB-Upgrade nicht angewendet.
ich bekomme folgende Meldungen:

...kivitendo/kivitendo-erp# scripts/dbupgrade2_tool.pl  --user=snr --client=LMV --unapplied
oe_purchase_order_confirmation_order_types
oe_delivery_orders_add_vendor_confirmation_number
oe_purchase_order_confirmation
...kivitendo/kivitendo-erp# scripts/dbupgrade2_tool.pl  --user=snr --client=LMV --apply oe_purchase_order_confirmation_order_types
Applying upgrade oe_purchase_order_confirmation_order_types.sql
DBD::Pg::st execute failed: FEHLER:  ALTER TYPE ... ADD kann nicht in einem Transaktionsblock laufen at ... kivitendo/kivitendo-erp/scripts/../SL/DBUpgrade2.pm line 202, <GEN0> line 6.
... kivitendo/kivitendo-erp# 
... kivitendo/kivitendo-erp# scripts/dbupgrade2_tool.pl  --user=snr --client=LMV --apply oe_delivery_orders_add_vendor_confirmation_number
    Applying upgrade oe_delivery_orders_add_vendor_confirmation_number.sql
... kivitendo/kivitendo-erp# scripts/dbupgrade2_tool.pl  --user=snr --client=LMV --apply oe_purchase_order_confirmation
Applying upgrade oe_purchase_order_confirmation.sql
... kivitendo/kivitendo-erp# scripts/dbupgrade2_tool.pl  --user=snr --client=LMV --apply   oe_purchase_order_confirmation_order_types
Applying upgrade oe_purchase_order_confirmation_order_types.sql
DBD::Pg::st execute failed: FEHLER:  ALTER TYPE ... ADD kann nicht in einem 
Transaktionsblock laufen at ... kivitendo/kivitendo-erp/scripts/../SL/DBUpgrade2.pm line 
202, <GEN0> line 6.

OS: Debain 10 Buster
Kivitendo: kivitendo 3.9.0-unstable (Git-Revision: 001ca02, 29.11.2023 15:46:01 +0100)
alle Installchecks weiterhin i.O..

    # dpkg -l | grep postgres
   ii  postgresql                                    11+200+deb10u5                                 all          object-relational SQL database (supported version)
   ii  postgresql-11                                 11.22-0+deb10u1                                amd64        object-relational SQL database, version 11 server
   ii  postgresql-client-11                          11.22-0+deb10u1                                amd64        front-end programs for PostgreSQL 11
   ii  postgresql-client-common                      200+deb10u5                                    all          manager for multiple PostgreSQL client versions
   ii  postgresql-common                             200+deb10u5                                    all          PostgreSQL database-cluster manager

MfG
SNR

---

Hallo,
das liegt in der Tat an Postgres 11. Es gibt einen händischen Workaround bisher.
https://www.kivitendo.de/redmine/issues/640
Demnächst auch einen richtigen Fix.

Beste Grüße
Werner kivitendodienstleister