AJ
Reported
Dear Sir/ Madam
I hope this message finds you well. This evening, I took the exciting step of purchasing your scripts from the Envato Market, and I am pleased to share that I successfully completed the installation process, which has resulted in the software looking absolutely fantastic on my system. However, I have encountered a minor issue that I believe needs your expertise. When I attempt to create an invoice, I encounter a frustrating obstacle: I receive a 500 server error message when trying to save the invoice. This issue has prevented me from moving forward with my work, and I would greatly appreciate your help in troubleshooting and resolving this matter.
Thank you in advance for your help.
I hope this message finds you well. This evening, I took the exciting step of purchasing your scripts from the Envato Market, and I am pleased to share that I successfully completed the installation process, which has resulted in the software looking absolutely fantastic on my system. However, I have encountered a minor issue that I believe needs your expertise. When I attempt to create an invoice, I encounter a frustrating obstacle: I receive a 500 server error message when trying to save the invoice. This issue has prevented me from moving forward with my work, and I would greatly appreciate your help in troubleshooting and resolving this matter.
Thank you in advance for your help.
- MSAnsweredHello,
Please ask question and then add private reply with error details from `storage/logs/` folder so that I can suggest solution.
Thank you - AJAnswered**[@Mian Saleem](/u/saleem)** Hello, I wanted to bring to your attention an issue that I have been experiencing with the invoice system, as it does not seem to be functioning properly at times. Specifically, I have encountered several frustrating technical difficulties, including 500 errors and 403 errors. I would greatly appreciate your assistance in troubleshooting and fixing these errors.
To aid in your investigation, I have attached the logs folder below, which contains detailed information regarding the errors I've been encountering.
Thank you in advance for your attention to this matter.Attachments - MSAnsweredHello,
I have seen pdo error. If you are using `MariaDB`, please try
```sql
SET GLOBAL table_definition_cache = 1024;
```
You can try to update the database config `config/database.php` to set `strict` to `false` and update `options` to set `ATTR_EMULATE_PREPARES`
```
'options' => extension_loaded('pdo_mysql') ? array_filter([
PDO::ATTR_EMULATE_PREPARES => true,
PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
]) : [],
```
Thank you - AJAnsweredam using SQL Database not MariaDB am still getting the 500 errors
- MSAnsweredHello,
Did you update the options in database config? - Login to Reply