Aw, snap! Internal Server Error - Check your error_log or enable debug_mode = 3 (chevereto.com/docs/debug).

[Mikelin]

After upgrading my website to 3.16.1, there was an error. The error message is:

Aw, snap! Internal Server Error - Check your error_log or enable debug_mode = 3 (chevereto.com/docs/debug).

I don't know PHP technology, I can't understand why this error is. Thank you very much for your help。

My website: https://img.run/

 

[Rodolfo]

Debug | Chevereto V3

Documentation for Chevereto V3

v3-docs.chevereto.com

Enable debug level 3 to print errors. Alternatively, you can provide the related error log entry.

 

[Mikelin]

Fatal error [400]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'chv_images.image_is_approved' in 'where clause'
Triggered in /app/lib/classes/class.listing.php at line 473

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

 

[Rodolfo]

Go to /install and perform the required DB queries. This happened because you skipped the installing of the 3.16 database.

 

[Mikelin]

Thank you very much. But,
Is this a direct visit https://img.run/install Is that ok? I visited https://img.run/install Found a pile of English and code I can't understand..
I directly click Update 3.16.1 from the dashboard. It should be the direct update completed. How can there be a problem?

 

[Rodolfo]

Try reading the message, the software tells you exactly what to do. If you ignore the system messages there's very little I can do for you helping you.

For example, paste the message you don't understand to instruct you.

 

[Mikelin]

but
I don't know any PHP technology or MySQL technology.
System upgrade, shouldn't it be automatically upgraded together with the database? Why do we have to leave some for users to do manually? Users don't necessarily know the technology. (if everyone knows the technology, who is willing to spend money to buy a ready-made program to build a site, right

 

[Rodolfo]

I don't know any PHP technology or MySQL technology.

I'm sorry, but the system requirements are very clear regarding these technologies. The fact that you don't know about these doesn't mean that your Chevereto experience won't ever involve touching these components.

System upgrade, shouldn't it be automatically upgraded together with the database?

No, and the documentation is very clear in this regard.

There is a very high chance to break any large installation if the system automatically does the SQL update. This is because the update could take minutes, even hours depending on how big is your database, so is way better to issue the query directly in the SQL console. The system shows the queries to prevent your installation from being totally unusable, it is a built-in feature.

 

[Mikelin]

I'm sorry, but the system requirements are very clear regarding these technologies. The fact that you don't know about these doesn't mean that your Chevereto experience won't ever involve touching these components.


No, and the documentation is very clear in this regard.

There is a very high chance to break any large installation if the system automatically does the SQL update. This is because the update could take minutes, even hours depending on how big is your database, so is way better to issue the query directly in the SQL console. The system shows the queries to prevent your installation from being totally unusable, it is a built-in feature.

Thank you for your advice.
At first I didn't know what the code meant. After your words, I understand that this is the SQL statement. I directly execute these SQL statements in the database console, and the database will be upgraded directly. Thank you very much.