Project

General

Profile

Actions

Bug #12314

closed

Check Multi DB setup

Added by Carsten Rose almost 3 years ago. Updated almost 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Carsten Rose
Target version:
Start date:
04.04.2021
Due date:
% Done:

0%

Estimated time:
Discuss:
Prio Planung:
Vote:

Description

  • Bitte testen ob das Multi DB Setup, nach dem Rueckbau von FormAsFile, noch funktioniert.
  • In den 21.3.x scheint es Probleme zu geben: Mit v21.3.2 wurde wiederholt die Tabelle 'Form' & 'FormElement' in QFQ Data (darauf sollte QFQ System gar nicht zugreifen) geloescht und initial mit den QFQ System Forms gefuellt. Dazu gibt es kein explizites Ticket da QFQ vorerst nicht mehr in dem betroffenem Modus betrieben wird.

Test:

  • Test Setup
    • a) Data: 1, System: 2
    • b) Data: 2, System: 1

Test

  • Form:
    • FormEditor aufrufen, etwas aendern, speichern, check das es ok ist.
    • Beliebiges Form aufrufen, bei dem die Daten nicht in QFQ Sytem, sondern QFQ Data sind. Daten aendern, speichern und erneut aufrufen.
  • Report:
    • By default soll der Report auf QFQ Data arbeiten. Testreport erstellen der auf eine Tabelle in QFQ Data zugreift.
    • Umstellen auf QFQ System mit `dbIndex={{indexQfq:Y}}. Testreport erstellen der auf eine Tabelle in QFQ System zugreift (z.B. der FormEditor)

Files

multi-db-setup.png View multi-db-setup.png 113 KB Carsten Rose, 04.04.2021 10:50

Related issues

Related to QFQ - Feature #12145: Add frontend Form Json editor and disable SyncClosedCarsten Rose15.03.2021

Actions
Related to QFQ - Bug #12325: MultiDB form.dbIndex not working for report syntaxPriorizeCarsten Rose06.04.2021

Actions
Actions #1

Updated by Marc Egger almost 3 years ago

  • Status changed from New to In Progress
Actions #2

Updated by Marc Egger almost 3 years ago

  • Related to Feature #12145: Add frontend Form Json editor and disable Sync added
Actions #3

Updated by Marc Egger almost 3 years ago

Data System Report Default Report Data Report System Edit Form Form edits Data Edit Form Json New Form Json Update System Form
1 2 Data ok ok ok ok NO: Form Parameter is ignored on save but not on load: dbIndex={{indexQfq:Y}}  dito<  
2 1 System ok ok ok ok      
Actions #4

Updated by Marc Egger almost 3 years ago

  • Related to Bug #12325: MultiDB form.dbIndex not working for report syntax added
Actions #5

Updated by Marc Egger almost 3 years ago

Fixed DB problem with json form editor (#12145). Test again:

Data System Report Default Report Data Report System Edit Form Form edits Data Edit Form Json New Form Json Update System Form
1 2 Data ok ok ok ok ok  ok ok
2 1 System ok ok ok ok ok ok ok
Actions #6

Updated by Marc Egger almost 3 years ago

  • Assignee changed from Marc Egger to Carsten Rose

Tests alle durchgeführt und bestanden. Ticket schliessen?

Actions #7

Updated by Marc Egger almost 3 years ago

  • Status changed from In Progress to New
Actions #8

Updated by Carsten Rose almost 3 years ago

  • Status changed from New to Feedback
  • Assignee changed from Carsten Rose to Marc Egger

Wir warten noch auf den Merge Request

Actions #9

Updated by Marc Egger almost 3 years ago

  • Status changed from Feedback to New
  • Assignee changed from Marc Egger to Carsten Rose

Ist mit folgendem merge request gefixed: https://git.math.uzh.ch/typo3/qfq/-/merge_requests/332

Actions #10

Updated by Marc Egger almost 3 years ago

  • Status changed from New to Feedback
Actions #11

Updated by Carsten Rose almost 3 years ago

  • Tracker changed from Support to Bug
Actions #12

Updated by Carsten Rose almost 3 years ago

  • Status changed from Feedback to Closed
  • Target version changed from next5 to 21.4.0
Actions

Also available in: Atom PDF