iGalerie

Peter Martin

Membre

Inscription : 26-03-2024

Messages : 9

Site Web

Operation failed because an error occurred

Above error whenever I try to activate / deactivate / delete users. Also does not seem to be remembering password changes, displaying "Incorrect information" when trying to login with a newly changed password. 

https://www.woodcentral.com/gallery/

Server
Server type: LiteSpeed
Operating System: Linux 4.18.0-477.10.1.lve.el8.x86_64 x86_64
Server time: 2025-07-16 19:59:14 +02:00 (Europe/Luxembourg)
Database
Type: SQLite
Version: 3.45.2
Database size : 1.46 MB
PHP
Version: 8.3.20
Interface: litespeed
GD
GD Version : 2.3.3
FreeType Support : activated
AVIF Support : activated
GIF Read Support : activated
GIF Create Support : activated
JPEG Support : activated
PNG Support : activated
WebP Support : activated
PHP directives
allow_url_fopen : On
disable_classes : /
disable_functions : /
display_errors : Off
file_uploads : On
max_execution_time : 60
max_input_vars : 4000
memory_limit : 512M
open_basedir : /
post_max_size : 64M
upload_max_filesize : 64M
zlib.output_compression : Off
PHP extensions
curl : loaded
exif : loaded
fileinfo : loaded
gd : loaded
iconv : loaded
mbstring : loaded
pcre : loaded
PDO : loaded
pdo_mysql : loaded
pdo_pgsql : not loaded
pdo_sqlite : loaded
SimpleXML : loaded
zip : loaded
zlib : loaded
PHP functions
chmod : activated
get_loaded_extensions : activated
fsockopen : activated
ini_get : activated
ini_set : activated
ignore_user_abort : activated
imagealphablending : activated
imagecolorallocatealpha : activated
imagecolortransparent : activated
imagecreatefromavif : activated
imagecreatefromgif : activated
imagecreatefromjpeg : activated
imagecreatefrompng : activated
imagecreatefromwebp : activated
imagesavealpha : activated
imagetypes : activated
mail : activated
mime_content_type : activated
php_uname : activated
rmdir : activated
set_time_limit : activated

gilisa

Membre

Lieu : Région parisienne (sud)

Inscription : 23-04-2012

Messages : 304

Site Web

Re : Operation failed because an error occurred

Also does not seem to be remembering password changes, displaying "Incorrect information" when trying to login with a newly changed password.

About this request it is not a trouble of iGalerie, it is a problem of your Egde or Chrome or whatever you are
using as Internet client take a look at your Explorer configuration.
With Edge or Chrome you can set or not password for site in your profil, if you change the profil you are loosing  password and you go back in the first one you'll get it.
Take care of cookies if you are working in SSL.

Regards.
GGA.

Peter Martin

Membre

Inscription : 26-03-2024

Messages : 9

Site Web

Re : Operation failed because an error occurred

Thanks, but it seems to be more than that. For example, if I use admin to reset the password of a user, and then log out and try to log in using that name, manually entering the name and password (not replying on autofil), it will say the username/password it not correct. Is it trying to compare my login with a cookie instead of server-based validation?

Also, from within the admin backend, I cannot delete users, replying with "Operation failed because an error occurred". Corrupted SQLitte db file?  IDK.  My plan is to migrate this to MariaDB or PostGreSQL (if supported) but I would like to understand what is happening here first.

I use Chromium on a computer running NixOS Plasma desktop, but I don't think that should cause this.

Many thanks for creating and supporting this project. FOSS dev in galleries is not what it used to be. Most are very out of date, no longer actively supported, or will not do what I need: allow users to create accounts and their own albums where they can upload, edit, and delete images. Support for videos is also a nice bonus.

Peter Martin

Membre

Inscription : 26-03-2024

Messages : 9

Site Web

Re : Operation failed because an error occurred

Forgot to mention, the " Operation failed because an error occurred"  referenced when trying to delete a user does not produce an Incident in the admin interface.

gilisa

Membre

Lieu : Région parisienne (sud)

Inscription : 23-04-2012

Messages : 304

Site Web

Re : Operation failed because an error occurred

Hi,
On my site I create a user and I delete him using admin backoffice I cannot reproduce any trouble what you describe it works fine for me.
Can you tell us in wich condition you get this trouble ?

Regards.
GGA.

Peter Martin

Membre

Inscription : 26-03-2024

Messages : 9

Site Web

Re : Operation failed because an error occurred

I cannot do what you do: create and then delete a user from the admin backoffice. Trying to delete the user results in the error, with nothing logged as an incident.

I was suspecting it may be because the server is running PHP 8.3. I dropped it back to PHP 7.4 but no change.

Dernière modification par Peter Martin (21-07-2025 10:52:15)

djdakta

Membre

Lieu : Torhout

Inscription : 25-07-2018

Messages : 18

Site Web

Re : Operation failed because an error occurred

I cannot do what you do: create and then delete a user from the admin backoffice. Trying to delete the user results in the error, with nothing logged as an incident.

I was suspecting it may be because the server is running PHP 8.3. I dropped it back to PHP 7.4 but no change.

Hi Peter,

I don't think it has anything to do with the PHP version since I have PHP 8.3.23 running on my server and I don't have, nor can reproduce your problem. :-(
Which iGalerie version do you have?

Oh, I just read that you are using SQLlite, do you have the possibility to use MySQL instead?
Btw, iGalerie is compatible with "PostgreSQL" in case.

Dernière modification par djdakta (29-07-2025 13:39:37)

Peter Martin

Membre

Inscription : 26-03-2024

Messages : 9

Site Web

Re : Operation failed because an error occurred

>Which iGalerie version do you have?

Latest version.

>do you have the possibility to use MySQL instead?

Yes. I've never done a SQLite-to-MySQL conversion before, but I'll give it a try when I get time.

Thanks

gilisa

Membre

Lieu : Région parisienne (sud)

Inscription : 23-04-2012

Messages : 304

Site Web

Re : Operation failed because an error occurred

Hi,
https://www.geeksforgeeks.org/mariadb/h … o-mariadb/
Go link to do it even sqlite is lage it takes only few minutes.
Regards.
GGA.