Project

General

Profile

Actions
Copy link

Support #19001

open

FormEditor: problems to show table definition - save broken

Added by Carsten Rose 14 days ago. Updated 11 days ago.

Status:
New
Priority:
High
Assignee:
Carsten Rose
Target version:
CodingWeek2024
Start date:
04.07.2024
Due date:
% Done:

0%

Estimated time:
Discuss:
Prio Planung:
No
Vote:
CR, ZL

Description

Im MultiDB Setup (MY, Exam) gibt es Probleme im 'FormElement' Editor:

Wird ein Formularelement geaendert und gespeichert erscheint:

[ mysqli: 1054 ] Unknown column 'tableName' in 'field list'

SELECT '<h3>Table: ', tableName AS tableName, '</h3>' FROM Form AS f WHERE f.id=2

Files

clipboard-202407041109-jaux0.png View clipboard-202407041109-jaux0.png 33.3 KB Carsten Rose, 04.07.2024 11:09
clipboard-202407041110-14jlw.png View clipboard-202407041110-14jlw.png 58.7 KB Carsten Rose, 04.07.2024 11:10
clipboard-202407041110-u8xzq.png View clipboard-202407041110-u8xzq.png 72.8 KB Carsten Rose, 04.07.2024 11:10
Actions
Copy link
 #1

Updated by Carsten Rose 14 days ago

  • Description updated (diff)
  • Target version changed from 24.8.0 to CodingWeek2023
Actions
Copy link
 #2

Updated by Carsten Rose 14 days ago

  • Target version changed from CodingWeek2023 to CodingWeek2024
Actions
Copy link
 #3

Updated by Carsten Rose 14 days ago

  • Subject changed from FormEditor: problems to show table definition to FormEditor: problems to show table definition - save broken
Actions
Copy link
 #4

Updated by Carsten Rose 13 days ago

  • Description updated (diff)

Hint

  • In Form wird anders auf die Table Definition zugegriffen als in FormElement.
  • Sicherstellen das der Zugriff auf QfqSystem/QfqData nicht via DB-Name sondern dbIndex erfolgt.
    • Grund: 'DB-Name' funktioniert nur wenn die DBs (System & Data) auf der gleichen MariabDB Instanz (=Host) sind!
  • Das Problem tritt nur auf im 'FormElement' Form, nicht im 'Form' Form.
  • Es muesste gefixt werden so das auch bei MultiDB Setup die Table Definition korrekt angezeigt wird fuer Tabellen von QFQ Data (User forms) and QFQ System (Form/FormEditor/AutoCron/...).
Actions
Copy link
 #5

Updated by Carsten Rose 11 days ago

  • Vote CR added
Actions
Copy link
 #6

Updated by Carsten Rose 11 days ago

  • Priority changed from Normal to High
Actions
Copy link
 #7

Updated by Zhoujie Li 11 days ago

  • Vote ZL added
Actions
Copy link

Also available in: Atom PDF