Site loads clean after the update!

[faizan08]

Hi,

As the title says, after updating the site to the latest version, the site loads clean, all images are gone, stats show 343,353 images in the dashboard but doesn't show up in images. I have tried enabling debug mode (no error there), re-uploaded the system files, flushed cache (Cloudflare) and noticed that the SQL size is down to 3.5MB from like 120MB. Please assist.

TY!

 

[Rodolfo]

I'm sorry, but please fill the support template and attach all the logs you can get. Reason for the template is to try to replicate the issue or at least know the exact error behind this.

At this point it is impossible for me (or anyone) to assist you.

Enable debug level 3 as is explained here: https://chevereto.com/docs/debug

 

[faizan08]

As I mentioned earlier "I have tried enabling debug mode (no error there)" debug level 3 is still enabled.

 

[Rodolfo]

I'm sorry, but without any error_log or any other information then I'm not capable to help you. I strongly suggest you to enable error_reporting:



chv_settings table:



Once you get something that could indicate the cause of this issue please share it right here in this topic.

 

[McAtze]

@faizan08 Did you take a look at your browser console for error/issues?

 

[faizan08]

I'm sorry, I initially forgot (had it saved somewhere) to send the debug mode 3 error log. The error had stopped appearing after a few minutes and the site was back to normal, even though the debug mode was still enabled and I didn't make any changes in /app/lib/classes/class.listing.php either.
Later I checked my SQL database size was reduced to 3.5MB (last time I checked it was around 115MB).

I have enabled PHP error reporting, no error there.

Fatal error [400]: SQLSTATE[HY000]: General error: 145 Table './database-name/images' is marked as crashed and should be repaired
Triggered in /app/lib/classes/class.listing.php at line 462

Stack trace:
#0 /app/routes/route.index.php(209): CHV\Listing->exec()
#1 /lib/G/classes/class.handler.php(232): G\Handler->{closure}(G\Handler)
#2 /lib/G/classes/class.handler.php(132): G\Handler->processRequest()
#3 /app/loader.php(812): G\Handler->__construct(Array)
#4 /index.php(20): include_once('/app/loader.php')

 

[Rodolfo]

That's not a direct error of the script but your Mysql server. You will have to run a repair command in your mysql console.

 

[faizan08]

I have installed another site on the same server, no such problem with that and why did it happen after the update, it was fine before.
Anyways, how can I avoid it in the future?

 

[Rodolfo]

You can't, mysql tables crashes and that's why they include a repair command.