SimpleInvoices Group Forum › Forums › Fearless359 SimpleInvoices Discussion Group › Master2023 PDO Error when saving new invoice › Reply To: Master2023 PDO Error when saving new invoice
Thank you for the reply.
I am using PHP version 8.1.31 . The database is MariaDB version 10
It is installed on a Debian 12 with Apache2 as the server.
I am installing a version from scratch so no upgrade. I tried to update in the past and I never got it to work.
So here is what I did.
1/ I created a new database and updated the custom.config.ini with the correct credentials
2/ I opened the website and it ask me to confirm to install the database.
3/ Then it asked me to install the essential data
4/ I declined to install the sample data and instead created a biller, a customer and a few products.
All seemed good so I created an invoice. When I pressed saved I got the message above.
I also tried to do it again after emptying the database and this time installing the sample data. It gave me the same error while it was doing that.
The php.log attached is from a fresh install.
After installing the sample data I got this error:
Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while there are pending result sets. Consider unsetting the previous PDOStatement or calling PDOStatement::closeCursor() in /var/www/html/simpleinvoices-master_2023/Inc/Claz/PdoDb.php:713 Stack trace: #0 /var/www/html/simpleinvoices-master_2023/Inc/Claz/PdoDb.php(713): PDOStatement->execute() #1 /var/www/html/simpleinvoices-master_2023/Inc/Claz/PdoDb.php(1310): Inc\Claz\PdoDb->lastInsertId() #2 /var/www/html/simpleinvoices-master_2023/modules/install/sample_data.php(20): Inc\Claz\PdoDb->query() #3 /var/www/html/simpleinvoices-master_2023/index.php(441): include('...') #4 {main} thrown in /var/www/html/simpleinvoices-master_2023/Inc/Claz/PdoDb.php on line 713
This was the url listed in the browser at the time:
http://192.168.0.140/simpleinvoices-master_2023/index.php?module=install&view=sample_data
Hopefully this will be useful for you
Recent Comments