Cant rename file og folder, http error 500

[jorola]

hi.
I get an http 500 error when trying to rename a file or folder in the Documents library:
From the log:

Folder:
28. jun 08:05:25 500 GET /Medlemmer/adm_program/modules/documents-files/rename.php?folder_uuid=adf58ad2-1695-421a-abf8-201f873094f3

File:
28. jun 08:00:05 500 GET /Medlemmer/adm_program/modules/documents-files/rename.php?folder_uuid=fa7db79a-fba9-47cf-8da9-bbbe5a60d617&file_uuid=c152e07c-7d95-4156-a44a-d64c043bd013

Admidio v 4.3.10
Was also happening in 4.3.9

BR Johnny

[fasse]

Hi Johnny,

are there any errors in the log files?

I could not reproduce your problem. Do you could reproduce this at our demo area?

Best
Fasse

[jorola]

Hi Fasse.
No, only the message from updating:
[2024-06-28 07:59:39.885342] Admidio.WARNING: UPDATE: Database-Version is lower than the filesystem! {"versionDB":"4.3.9","versionFileSystem":"4.3.10"} {"file":"/var/www/xxxx/public_html/Medlemmer/adm_program/system/classes/Component.php","line":88,"class":"Component","callType":"->","function":"checkDatabaseVersion"}

I've replaced the folders adm_themes, adm_program and adm_plugins.
Is there anything from adm_files I have to update ?

Far as I can see the files from the update are identical.

Download, upload, delete, view works fine.

Works fine on the demo site.

BR Johnny

[jorola]

Follow up:
I didn't have debug mode turned on.
With debug mode, it's not accessible, I get the following:
S Q L - E R R O R

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1' for key 'admidio_user_data.admidio_idx_usd_usr_usf_id'

CODE: 23000

B A C K T R A C E

FILE: adm_program/system/classes/Database.php
LINE: 797
CALL: Database->showError()

FILE: adm_program/system/classes/TableAccess.php
LINE: 570
CALL: Database->queryPrepared()

FILE: adm_program/system/classes/ProfileFields.php
LINE: 656
CALL: TableAccess->save()

FILE: adm_program/system/classes/User.php
LINE: 1817
CALL: ProfileFields->saveUserData()

FILE: adm_program/system/classes/User.php
LINE: 2182
CALL: User->save()

FILE: adm_program/system/common.php
LINE: 189
CALL: User->updateLoginData()

FILE: index.php
LINE: 23
CALL: require_once()

From the logfile:
[2024-07-01 11:01:19.626356] Admidio.INFO: SQL: INSERT INTO admidio_user_data (usd_usr_id,usd_usf_id,usd_value) VALUES (?,?,?) [2,1,"Lyngby"] {"file":"/var/www/hc-xxx/public_html/Medlemmer/adm_program/system/classes/Database.php","line":774,"class":"Database","callType":"->","function":"queryPrepared"}
[2024-07-01 11:01:19.628265] Admidio.DEBUG: SQL: Execution time 1.893044 ms {"file":"/var/www/hc-xxx/public_html/Medlemmer/adm_program/system/classes/Database.php","line":793,"class":"Database","callType":"->","function":"queryPrepared"}
[2024-07-01 11:01:19.628286] Admidio.CRITICAL: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1' for key 'admidio_user_data.admidio_idx_usd_usr_usf_id' {"file":"/var/www/xxxx/public_html/Medlemmer/adm_program/system/classes/Database.php","line":796,"class":"Database","callType":"->","function":"queryPrepared"}
[2024-07-01 11:01:19.629207] Admidio.CRITICAL: 23000: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1' for key 'admidio_user_data.admidio_idx_usd_usr_usf_id' {"file":"/var/www/xxx/public_html/Medlemmer/adm_program/system/classes/Database.php","line":951,"class":"Database","callType":"->","function":"showError"}

[jorola]

Hi Fasse.
Do you need any further information on this problem ?
Or did you find a solution?
BR Johnny