Project

General

Profile

Bug #7639

Drag and drop in subrecords: expect 1 row got nothing

Added by Carsten Rose over 1 year ago. Updated 6 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
13.01.2019
Due date:
% Done:

0%

Estimated time:
Discuss:

Description

  • Im FormEditor bei den FE funktioniert das Drag and Drop in Subrecords.
  • Auf dem MI-Tool, bei den Settings (form=setting)
    • im Setting 'Misc', koennen die Subelements ebenfalls sortiert werden.
    • im Setting 'Finanzierungsform', gibt es folgenden Fehler:
UniqId:: 5c3ba456e2e68
------------------------------------------------
toUser:: Expected one row, got 0 rows
Timestamp:: 2019.01.13 21:49:26 +0100
Code:: 2008
Message:: Expected one row, got 0 rows
Type:: Db Exception
SQL final:: SELECT * FROM Form WHERE id = ?
SQL Params:: array (
  0 => '257',
)
current sip:: array (
  '__dbIndexData' => '0',
  'dnd-subrecord-form-id' => '257',
  'dnd-subrecord-id' => '833',
  'dndTable' => 'Ggroup',
  'orderColumn' => 'ord',
  'orderInterval' => '10',
  'r' => '0',
  's' => '5c3b9f821f3bc',
  'urlparam' => '__dbIndexData=0&dnd-subrecord-form-id=257&dnd-subrecord-id=833&dndTable=Ggroup&orderColumn=ord&orderInterval=10&r=0',
)
Page Id:: -
FE User:: crose
File:: /var/www/html/mi/typo3conf/ext/qfq/Source/core/database/Database.php
Line:: 238
IP Address:: 192.168.133.210
HTTP User Agent:: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36 OPR/57.0.3098.102
QFQ Cookie:: nssntptvrji46sgclf1c77aboc
Stacktrace:: 
#0 /var/www/html/mi/typo3conf/ext/qfq/Source/core/store/Store.php(909): qfq\Database->sql('SELECT * FROM F...', 'expect_1', Array)
#1 /var/www/html/mi/typo3conf/ext/qfq/Source/core/QuickFormQuery.php(1587): qfq\Store::fillStoreWithRecord('Form', '257', Object(qfq\Database))
#2 /var/www/html/mi/typo3conf/ext/qfq/Source/api/dragAndDrop.php(61): qfq\QuickFormQuery->dragAndDrop()

Weitere Beobachtung:

  • Auf webwork16/crose/qfq ist das Drag and Drop ok.
  • Auf w16/my liefert es den oben genannten Fehler.
  • Wird webwork16/crose/qfq auf MultiDB umgestellt, kommt zwar nicht der Fehler, das Drag and Drop funktioniert nicht - nach einem Refresh haben die FE noch die alte Ordnung.

Associated revisions

Revision b6f342a8 (diff)
Added by Carsten Rose 6 months ago

Implements #7639. Check for id/_id and ord/_ord. Use the given columname. Throw meaningful exception if missing.

Revision fca1b949 (diff)
Added by Carsten Rose 6 months ago

Fixed #7639. Update Manual.rst. Fake STORE_SIP so it can be used during processing sql1. Fixed bug that the currently form loaded record is available via STORE_RECORD.

Revision eeb27b78 (diff)
Added by Carsten Rose 6 months ago

Fixed #7639. Fixes bug that orderInterval has not been respected.

History

#1 Updated by Carsten Rose over 1 year ago

  • Description updated (diff)

#2 Updated by Carsten Rose 11 months ago

Testform: Report > Action > DragnDrop: ganz oben der Button zum Form: 'subrecordDragAndDrop'.

Aktuell funktioniert der BreakPoint in dragAndDrop.php nicht, falls er via subrecord & non-ord column aufgerufen wird, via Form Editor (subcord & ord column) oder in Report wird der Breakpoint angesprungen - keine Idee wie dieser Effekt zustande kommt.

#3 Updated by Carsten Rose 11 months ago

  • Status changed from New to In Progress

#5 Updated by Carsten Rose 6 months ago

  • Status changed from In Progress to Closed

#6 Updated by Carsten Rose 6 months ago

  • Target version changed from 146 to 19.11.3

Also available in: Atom PDF