Database crashing when non-admin users upload

[Jazazze]

Website URL
<private>

Chevereto version
3.10.16

Description of the issue
Hi,

Been pulling my hair out on this one for a few hours now.

Whenever a registered user attempts to upload pictures the database crashes before the image is stored, confirmed by multiple users and myself. However, when uploading from the admin account, everything works fine, image is uploaded, appears in /dashboard/images and user albums etc.

Have checked the logs for Apache - mysql server has gone away; checked the SQL logs which show the crash and subsequent restart.

Any hints to solving this one? Thanks. 😊

 

[Rodolfo]

Any hints to solving this one?

Unfortunately, no. Most likely there's some sort of bad configuration or function causing that one. You have to check the actual mysql server log, maybe enable the slow query log or even something else. I rarely have issues with MySQL so I can't help you that much.

You have to at least detect the exact query causing the issue.

 

[Jazazze]

Hi Rodolfo,

Thanks for the reply, I've been digging around and even dumping the chv_images table seems to cause a crash, so it would seem that Chevereto isn't directly causing the crashes and perhaps the table has some corruption.

(Especially since it seems to be working at the moment)

 

[Rodolfo]

Sure, most likely is just a local issue. Chevereto installations out there are too many to don't notice a bug like this.