• 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 Update Error - Version 3.5.9

Status
Not open for further replies.

AshleyUK

💖 Chevereto Fan
Hi,
I'm updating from version 3.5.2 to 3.5.9, and I done what I usually do.
Upload all files, log in as Admin, and hit the update button.

In the dashboard, it's showing as 3.5.9 (3.5.2 DB) update
So when I press the update button, I'm getting a cloudflare error:
"Error 524: A timeout occurred"‏ after waiting approx 30 - 1 min for something to happen.

Should the database update take a long time to complete?
I spoke to my host, and they've told me that the database is in the update process, and that I should wait, because my database is quite large. (I'm hosting 1.7 million images)

I've disabled image uploading for now, while the update completes.

Does this sound correct to you? Should it take a long time?
None of the other updates took quite this long?
 
It takes long because in 3.5.8 a full text index was added so yeah it could take a lot for 1.7M images. You can open the install script and do a G\debug($sql_update); then a die(); so you can issue the commands directly in the database.
 
OK then, thanks.
That makes sense. I'll leave it to run, and see how we go.

--- edit ---
Hi,
I've left it to run overnight, I've compared the chv_images table to another one that I exported this morning, and there appears to be differences, but the update still appears to be running.

I probably clicked the 'Update' button maybe 4 or 5 times yesterday, because I thought it wasn't doing anything.
Would that cause a problem? Will I have 4 or 5 instances of the update taking place? Or will it still only result in one update taking place? I'm just wondering if I have inadvertently slowed down the update process by clicking multiple times.

Also, how will I definately know the update is completed? Is one of the last steps, to update the dashboard to show: 3.5.9 (3.5.9 DB), instead of 3.5.9 (3.5.2 DB)?

Thanks
 
Last edited:
The last update command is change 3.5.2 to 3.5.9

TO make sure that nothing is running you need to kill the mysql server (re-start).
 
Status
Not open for further replies.
Back
Top