Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Unable to delete at...
 
Notifications
Clear all

Unable to delete attached file record

9 Posts
2 Users
0 Reactions
2,325 Views
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 
[#9396]

Hello,

I'm in V11.1.5.
I create attachment for a project (files test.png), I works and i can show the file content from ProjeQtOr).
I get error from log : cannot create image thumb of size 32 for ....)
I want to delete attachment, nothing append.
In reality, file is deleted from server (in ../files/attach) but record stay in database.
Log show error : 'stSaveRefType' is not an expected status in result
Attachment still on screen, unable to show files (normal, it's deleted).
When trying to download, nothing append an an error (logical) is logged : download.php : XXXX not found.

Trying the same with .pdf, the same thinks appends.

Log file attached.

Regards,

 


 
Posted : 05 Apr 2024 13H15
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Cannot reproduce.
Which version of PHP are you using ?


 
Posted : 06 Apr 2024 12H39
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 

PHP 8.1.4


 
Posted : 08 Apr 2024 12H32
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 

Problem occurs on two differents instances, one in V11.1.4, one in V11.1.5


 
Posted : 08 Apr 2024 12H38
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Possibly you just have access rights in the directory where thumbs are stored projeqtorfilesthumbs
PHP user must have write rights on this folder.


 
Posted : 19 Apr 2024 16H56
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 

Exact, permissions are only rwxr--r-- on files and subdirectories...
It works for thumb creation but i still have problem while deleting attachment.

I'm trying deleting all subdirectories in attach and removing all records from database to see if issue occurs after that


 
Posted : 20 Apr 2024 13H59
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 

Thumb is well created but i get the ame issue on deleting attachment.
creating : directory is created in /files/attach and file is well uploaded.
View and download files from ProjeQtOr is ok.
Deleting file :
directory and files is deleting on server.
Error in log : [V11.1.5] 'stSaveRefType' is not an expected status in result
386 is the id of project i use for test.

Reagrds,


 
Posted : 21 Apr 2024 16H28
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Possibly you face issue relative to ticket #8129.
The fix is deployed in V11.2.2, that is now the last stable release.


 
Posted : 22 Apr 2024 11H53
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 

Corrected with V11.2.2.
But i face an issue while upgrading.

My server can't reach Projeqtor.org for security reason (not only proxy).
So, i need to upload to server directly in installAuto/files.
Works fine, i get the entry to apply not version but, after decompressing, i get error message :
2024-04-22 11:02:50.863 ** ERROR ** [V11.1.5] ERROR **
2024-04-22 11:02:50.863
** ERROR ** [V11.1.5] on file '/var/www/html/plugin/installAuto/installAutoZipList.php' at line (173)
2024-04-22 11:02:50.863
** ERROR ** [V11.1.5] cause = file_get_contents(): php_network_getaddresses: getaddrinfo for projeqtor.org failed: Name or service not known
2024-04-22 11:02:50.863
** ERROR ** [V11.1.5] ERROR **
2024-04-22 11:02:50.864 ** ERROR ** [V11.1.5] on file '/var/www/html/plugin/installAuto/installAutoZipList.php' at line (173)
2024-04-22 11:02:50.864 ** ERROR ** [V11.1.5] cause = file_get_contents( https://projeqtor.org/admin/getInstallableVersions.php?currentVersion=V11.1.5): Failed to open stream: php_network_getaddresses: getaddrinfo for projeqtor.org failed: Name or service not known
2024-04-22 11:03:04.480 ** ERROR ** [V11.1.5] ERROR **
2024-04-22 11:03:04.481
** ERROR ** [V11.1.5] on file '/var/www/html/plugin/installAuto/installAutoZipList.php' at line (173)
2024-04-22 11:03:04.481
** ERROR ** [V11.1.5] cause = file_get_contents(): php_network_getaddresses: getaddrinfo for projeqtor.org failed: Name or service not known
2024-04-22 11:03:04.482
** ERROR ** [V11.1.5] ERROR **
2024-04-22 11:03:04.482 ** ERROR ** [V11.1.5] on file '/var/www/html/plugin/installAuto/installAutoZipList.php' at line (173)
2024-04-22 11:03:04.482 ** ERROR ** [V11.1.5] cause = file_get_contents( http://projeqtor.org/admin/getInstallableVersions.php?currentVersion=V11.1.5): Failed to open stream: php_network_getaddresses: getaddrinfo for projeqtor.org failed: Name or service not known

After that, i need to manualy disconnect, then i get message "update in progress"... and everythinks work.

Regards,


 
Posted : 22 Apr 2024 13H10
Share:

Scroll to Top