Ich habe jetzt auf der Weboberfläche ein Upgrade durchgeführt:
Prüfen:
Ausgabe
--------------- OpenXE upgrade ---------------
--------------- 2023-03-23 06:17:52 ---------------
git log HEAD --
git ls-files -m /var/www/vhosts/xxxxx.de/xetest.xxxxx.de/openxe
There are modified files:
../conf/main.conf.php
--------------- Upgrade history ---------------
git log --date=short-local --pretty="%cd (%h): %s" HEAD --not HEAD~5 --
2023-03-14 (ecd86d12): Bugfix lager wert calculation of prices added geloescht != 1 and date range
2023-03-13 (5638f187): Merge pull request #67 from exciler/bugfix_gutschrift_php8
2023-03-12 (75aaf5e2): Module creator improvement layout edit forms
2023-03-10 (e9cec0ce): Buchhaltung Export verbindlichkeit rechnungsdatum + bugfix consistency
2023-03-10 (226a2dff): Export Buchhaltung added consistency check
--------------- Dry run, use -do to upgrade ---------------
--------------- Fetching files... ---------------
git fetch https://github.com/openxe-org/openxe.git master
--------------- Pending upgrades: ---------------
git log --date=short-local --pretty="%cd (%h): %s" FETCH_HEAD --not HEAD
No upgrades pending.
--------------- Loading from database 'DB123456@localhost'... ---------------
--------------- Loading from JSON... ---------------
Table count database 594 vs. JSON 590
--------------- Comparing JSON 'openxe@localhost' vs. database 'DB123456@localhost' ---------------
type => [Column existence], table => [adresse_accounts], in DB => [email]
type => [Column existence], table => [adresse_accounts], in DB => [notiz]
type => [Key existence], table => [angebot], in DB => [gruppe]
type => [Key existence], table => [angebot], in DB => [usereditid]
type => [Key existence], table => [artikel], in DB => [usereditid]
type => [Key existence], table => [auftrag], in DB => [gruppe]
type => [Key existence], table => [auftrag], in DB => [usereditid]
type => [Key existence], table => [bestellung], in DB => [usereditid]
type => [Table existence], in DB => [cache_einkaufspreis_id]
type => [Table existence], in DB => [cache_lagerplatz_inhalt]
type => [Table existence], in DB => [eigenschaften_vorlagen]
type => [Table existence], in DB => [eigenschaften_vorlagen_werte]
type => [Key existence], table => [googleapi_user], in DB => [user_id]
type => [Key existence], table => [gutschrift], in DB => [gruppe]
type => [Key existence], table => [gutschrift], in DB => [usereditid]
type => [Key existence], table => [lieferschein], in DB => [vertriebid]
type => [Key existence], table => [lieferschein], in DB => [usereditid]
type => [Key existence], table => [payment_transaction], in DB => [liability_id]
type => [Key existence], table => [rechnung], in DB => [vertriebid]
type => [Key existence], table => [rechnung], in DB => [gruppe]
type => [Key existence], table => [rechnung], in DB => [usereditid]
type => [Key existence], table => [versand], in DB => [adresse]
22 differences.
--------------- Comparing database 'DB123456@localhost' vs. JSON 'openxe@localhost' ---------------
type => [Column definition], table => [projekt], column => [buchhaltung_berater], property => [Collation], in JSON => [], in DB => [utf8_general_ci]
type => [Column definition], table => [projekt], column => [buchhaltung_mandant], property => [Collation], in JSON => [], in DB => [utf8_general_ci]
type => [Column definition], table => [projekt], column => [buchhaltung_wj_beginn], property => [Collation], in JSON => [], in DB => [utf8_general_ci]
3 differences.
--------------- Calculating database upgrade for 'DB123456@localhost'... ---------------
SET SQL_MODE='ALLOW_INVALID_DATES';
SET SESSION innodb_strict_mode=OFF;
ALTER TABLE `projekt` MODIFY COLUMN `buchhaltung_berater` varchar(64) NOT NULL;
ALTER TABLE `projekt` MODIFY COLUMN `buchhaltung_mandant` varchar(64) NOT NULL;
ALTER TABLE `projekt` MODIFY COLUMN `buchhaltung_wj_beginn` varchar(4) NOT NULL DEFAULT '0101';
5 upgrade statements
--------------- Done! ---------------
--------------- 2023-03-23 06:18:42 ---------------
Alles anzeigen
Upgrade:
Aktuelle Version
OpenXE 1.7 (ecd86d12)
Ausgabe
--------------- OpenXE upgrade ---------------
--------------- 2023-03-23 06:23:35 ---------------
git log HEAD --
git ls-files -m /var/www/vhosts/xxxxx.de/xetest.xxxxx.de/openxe
There are modified files:
../conf/main.conf.php
--------------- Upgrade history ---------------
git log --date=short-local --pretty="%cd (%h): %s" HEAD --not HEAD~5 --
2023-03-14 (ecd86d12): Bugfix lager wert calculation of prices added geloescht != 1 and date range
2023-03-13 (5638f187): Merge pull request #67 from exciler/bugfix_gutschrift_php8
2023-03-12 (75aaf5e2): Module creator improvement layout edit forms
2023-03-10 (e9cec0ce): Buchhaltung Export verbindlichkeit rechnungsdatum + bugfix consistency
2023-03-10 (226a2dff): Export Buchhaltung added consistency check
Clear modified files or use -f
--------------- Aborted! ---------------
--------------- 2023-03-23 06:23:51 ---------------
Alles anzeigen
Update erzwingen -f
Aktuelle Version
OpenXE 1.7 (ecd86d12)
Ausgabe
--------------- OpenXE upgrade ---------------
--------------- 2023-03-23 06:27:23 ---------------
git log HEAD --
git ls-files -m /var/www/vhosts/xxxxx.de/xetest.xxxxx.de/openxe
There are modified files:
../conf/main.conf.php
--------------- Upgrade history ---------------
git log --date=short-local --pretty="%cd (%h): %s" HEAD --not HEAD~5 --
2023-03-14 (ecd86d12): Bugfix lager wert calculation of prices added geloescht != 1 and date range
2023-03-13 (5638f187): Merge pull request #67 from exciler/bugfix_gutschrift_php8
2023-03-12 (75aaf5e2): Module creator improvement layout edit forms
2023-03-10 (e9cec0ce): Buchhaltung Export verbindlichkeit rechnungsdatum + bugfix consistency
2023-03-10 (226a2dff): Export Buchhaltung added consistency check
--------------- Pulling files... ---------------
git reset --hard
HEAD is now at ecd86d12 Bugfix lager wert calculation of prices added geloescht != 1 and date range
git pull https://github.com/openxe-org/openxe.git master
Already up to date.
git reset --hard
HEAD is now at ecd86d12 Bugfix lager wert calculation of prices added geloescht != 1 and date range
--------------- Files upgrade completed ---------------
git log -1
commit ecd86d120ad2ecf8587afb0fa3e2f40b6e7db117
Author: OpenXE <>
Date: Tue Mar 14 12:10:54 2023 +0100
Bugfix lager wert calculation of prices added geloescht != 1 and date range
commit ecd86d120ad2ecf8587afb0fa3e2f40b6e7db117
Author: OpenXE <>
Date: Tue Mar 14 12:10:54 2023 +0100
Bugfix lager wert calculation of prices added geloescht != 1 and date range
--------------- Loading from database 'DB123456@localhost'... ---------------
--------------- Loading from JSON... ---------------
Table count database 594 vs. JSON 590
--------------- Comparing JSON 'openxe@localhost' vs. database 'DB123456@localhost' ---------------
type => [Column existence], table => [adresse_accounts], in DB => [email]
type => [Column existence], table => [adresse_accounts], in DB => [notiz]
type => [Key existence], table => [angebot], in DB => [gruppe]
type => [Key existence], table => [angebot], in DB => [usereditid]
type => [Key existence], table => [artikel], in DB => [usereditid]
type => [Key existence], table => [auftrag], in DB => [gruppe]
type => [Key existence], table => [auftrag], in DB => [usereditid]
type => [Key existence], table => [bestellung], in DB => [usereditid]
type => [Table existence], in DB => [cache_einkaufspreis_id]
type => [Table existence], in DB => [cache_lagerplatz_inhalt]
type => [Table existence], in DB => [eigenschaften_vorlagen]
type => [Table existence], in DB => [eigenschaften_vorlagen_werte]
type => [Key existence], table => [googleapi_user], in DB => [user_id]
type => [Key existence], table => [gutschrift], in DB => [gruppe]
type => [Key existence], table => [gutschrift], in DB => [usereditid]
type => [Key existence], table => [lieferschein], in DB => [vertriebid]
type => [Key existence], table => [lieferschein], in DB => [usereditid]
type => [Key existence], table => [payment_transaction], in DB => [liability_id]
type => [Key existence], table => [rechnung], in DB => [vertriebid]
type => [Key existence], table => [rechnung], in DB => [gruppe]
type => [Key existence], table => [rechnung], in DB => [usereditid]
type => [Key existence], table => [versand], in DB => [adresse]
22 differences.
--------------- Comparing database 'DB123456@localhost' vs. JSON 'openxe@localhost' ---------------
type => [Column definition], table => [projekt], column => [buchhaltung_berater], property => [Collation], in JSON => [], in DB => [utf8_general_ci]
type => [Column definition], table => [projekt], column => [buchhaltung_mandant], property => [Collation], in JSON => [], in DB => [utf8_general_ci]
type => [Column definition], table => [projekt], column => [buchhaltung_wj_beginn], property => [Collation], in JSON => [], in DB => [utf8_general_ci]
3 differences.
--------------- Calculating database upgrade for 'DB123456@localhost'... ---------------
SET SQL_MODE='ALLOW_INVALID_DATES';
SET SESSION innodb_strict_mode=OFF;
ALTER TABLE `projekt` MODIFY COLUMN `buchhaltung_berater` varchar(64) NOT NULL;
ALTER TABLE `projekt` MODIFY COLUMN `buchhaltung_mandant` varchar(64) NOT NULL;
ALTER TABLE `projekt` MODIFY COLUMN `buchhaltung_wj_beginn` varchar(4) NOT NULL DEFAULT '0101';
5 upgrade statements
--------------- Executing database upgrade for 'DB123456@localhost' database... ---------------
Upgrade step 1 of 5... ok.
Upgrade step 2 of 5... ok.
Upgrade step 3 of 5... ok.
Upgrade step 4 of 5... ok.
Upgrade step 5 of 5... ok.
0 errors.
--------------- Checking database upgrade for 'DB123456@localhost'... ---------------
--------------- Comparing database 'DB123456@localhost' vs. JSON 'openxe@localhost' ---------------
3 differences.
--------------- Done! ---------------
--------------- 2023-03-23 06:27:49 ---------------
Alles anzeigen