PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1364 Field

It’s been 4 days that I’ve been struggling with the same problem, only this can you prove that I’m for

I have installed php7.3 and switched the amanet.digital domain to use it.

I cannot fix your application. I have no idea how it works.

You said you deleted your .htaccess (which is not something I told you to do), and I assume that provided the necessary proxy paths or redirects for things like /services paths to work, since you have no services directory in public_html. So, if your app needs an .htaccess to function correctly, you should not delete it!

I already have it on a folder on my PC I will test it please if you can give me the lines with which you installed php 7.3 so that I can install it on the main server thank you very much

I’ve already given you the lines multiple times and linked you to the documentation that tells you the lines!

Browse to this: Multiple PHP Versions – Virtualmin

Scroll down to your operating system, Ubuntu.

Follow the instructions, changing the version in the apt-get install command to the version you want (as I showed you above). This is also documented on that page.

It is literally two (2!) commands. I don’t know how we can make it easier.

I’m not sure how useful this will be now, but with these kind of errors:

General error: 1364 Field ‘payment_note’ doesn’t have a default value

I have often found they are due to transfering to a newer MySql or MariaDB server. It would be interesting to see what DB server the OPs website was working on previously, and what they are on now. Either way it’s very unfair to blame the control panel!

You can overcome some of these DB errors by setting sql_mode to reduce them to warnings or upgrading/rewriting the PHP code so that, for example, it doesn’t try to insert rows with empty values when the column has no default set, which is what is causing the above error.