• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space

Database crashing when non-admin users upload

Status
Not open for further replies.
Jazazze

Jazazze

Chevereto Member
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. 😊
 
Jazazze said:
Any hints to solving this one?
Click to expand...
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.
 
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)
 
Sure, most likely is just a local issue. Chevereto installations out there are too many to don't notice a bug like this.
 
Status
Not open for further replies.
Back
Top