Error when cloning a record

[oli]

Hi,
when I try to clone a record following error occures:

Code: Select all

[0] : 
===USER==========
globeadmin
===PDO MESSAGE=== 
SQLSTATE[42000]: Syntax error or access violation: 1110 Column 'tagesplan_nulog' specified twice
===SQL=========== 
INSERT INTO tagesplan  (tagesplan_id, `tplan_typ`, `tplan_status`, `tplan_titel`, `tplan_einsatztag`, `tagesplan_nulog`, `tagesplan_nulog`)  VALUES ('609a364a2f258ba', 'Tagesplan', 'Aktiv', 'Schule (Freitag) - CLONE', '2021-06-18', '{\"added\":{\"user\":\"oli\",\"time\":1620662183},\"viewed\":{\"user\":\"oli\",\"time\":1620719171}}', '{\"added\":{\"user\":\"oli\",\"time\":1620719178}}');
===BACK TRACE====
C:\wamp64\www\bts-sandbox1\core\nudata.php - line 419 (nuRunQuery)
C:\wamp64\www\bts-sandbox1\core\nuapi.php - line 71 (nuUpdateDatabase)

Creating and saving a record works fine.

I added the field <TABLENAME>_nulog to see who changed and viewed the record.

BR, Oli

[kev1n]

Does the error occur if you use a Display Object for the nulog Column?

[oli]

I used an INPUT field (Type: Text) to show it.

[kev1n]

Yes, that's what I was assuming. Please try a Display Object.

[oli]

Hi Kevin,
I created a DISPLAY object - now it works !!!
Thank you.

[kev1n]

BTW, this has been fixed. Now you may also use an Input object for the nulog column.