-
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
Fail to update
- Thread starter gobzer
- Start date
- Status
Send me FTP and admin access to inbox@chevereto.com, most likely the issue is a PHP timeout.
gobzer
Chevereto Member
Hi,
I've updated sequentally with manual DB queries
3.6.7 -> 3.6.8 -> 3.6.9 -> 3.7.0
The only thing I have for now are zeroes in dashboard
http://demo.chevereto.com/image/w9Q
I've updated sequentally with manual DB queries
3.6.7 -> 3.6.8 -> 3.6.9 -> 3.7.0
The only thing I have for now are zeroes in dashboard
http://demo.chevereto.com/image/w9Q
Last edited:
That's because you need to run the stats query and that's why I requested access to do it. Anyway... Do this:
1. change chevereto_installed_version to 3.6.9 in chv_settings
2. open install/?debug
3. Paste all that statement and ejexecute them in your backend mysql
1. change chevereto_installed_version to 3.6.9 in chv_settings
2. open install/?debug
3. Paste all that statement and ejexecute them in your backend mysql
gobzer
Chevereto Member
Got an error for this query:
I've stopped the execution, but it seems that stats are alive now.
http://demo.chevereto.com/image/wLU
Thanks, man. We may close this case
Code:
INSERT INTO `*****_stats` (stat_type, stat_date_gmt, stat_images, stat_image_views, stat_disk_used)
SELECT "date", DATE(image_date_gmt) AS date_gmt, COUNT(*) AS images, SUM(image_views) AS image_views, SUM(image_size + image_thumb_size + image_medium_size) AS disk_used FROM `*****_images` GROUP BY DATE(image_date_gmt);
Code:
Duplicate entry '2009-07-18' for key 'stat_date_gmt'I've stopped the execution, but it seems that stats are alive now.
http://demo.chevereto.com/image/wLU
Thanks, man. We may close this case
Last edited:
When the system does the update from 3.6.9 to 3.7.0 it truncates the chv_stats table and then it populates that table, is very odd that the stats table shows you a duplicated entry and as you may see, the query insert records using a GROUP BY clause. Most likely you didn't truncated the table so you got those duplicates.
- Status