[altaphista]

Cheers thanks that worked! I just gave my httpd service the needed read&write access.

[altaphista]

I’ve got a new error now…

[12-Dec-2025 14:16:03 Europe/Amsterdam] modules/invoices/manage.php Unable to store json data.

[altaphista]

I’ve been diving into your SqlPatchManager code trying to retrieve the error. After some time debugging I saw that this query threw an error: ALTER TABLE 'si_invoice_item_tax' ADD CONSTRAINT 'si_invoice_item_tax_ibfk_2' FOREIGN KEY ('invoice_item_id') REFERENCES 'si_invoice_items'('id') ON DELETE NO ACTION ON UPDATE CASCADE; .

Digging further into the database buildup I stumbled upon the error: invoice_items.id did not have the attritbute ‘UNSIGNED’.

The fix: ALTER TABLE 'si_invoice_items' CHANGE 'id' 'id' INT(11) UNSIGNED NOT NULL AUTO_INCREMENT;

Thanks again for your time and efforts Fearless!

• This reply was modified 1 month ago by altaphista. Reason: typo
• This reply was modified 1 month ago by altaphista.

[altaphista]

Thanks for your reply @fearless359. I’ve already done all the steps in the Version Update Process topic. I accidently copied to many rows from the php.log in my first quote, it should only be this what’s below. I manually deleted the 16 references to invoice_item_tax do not get that error any more.
Just to be sure I ran the update script again and this is the only error I get:

[12-Dec-2025 12:12:12 Europe/Amsterdam] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1005 Can't create table 'my_fact'.'si_invoice_item_tax' (errno: 150 "Foreign key constraint is incorrectly formed") in /volume1/websites_folder/invoices/Inc/Claz/PdoDb.php:1287
Stack trace:
#0 /volume1/websites_folder/invoices/Inc/Claz/PdoDb.php(1287): PDOStatement->execute()
#1 /volume1/websites_folder/invoices/Inc/Claz/SqlPatchManager.php(145): Inc\Claz\PdoDb->query('ALTER TABLE 'si...')
#2 /volume1/websites_folder/invoices/Inc/Claz/SqlPatchManager.php(215): Inc\Claz\SqlPatchManager::runSqlPatch(331, Array)
#3 /volume1/websites_folder/invoices/index.php(247): Inc\Claz\SqlPatchManager::runPatches()
#4 {main}
  thrown in /volume1/websites_folder/invoices/Inc/Claz/PdoDb.php on line 1287

[altaphista]

The quotes did not work unfortunately (i do not have special chars in my pw, also I use app generated passwords).

This is the info from the php.log file:

Stack trace:
#0 /home/.../vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(358): Swift_Transport_AbstractSmtpTransport->assertResponseCode('', Array)
#1 /home/.../vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(147): Swift_Transport_AbstractSmtpTransport->readGreeting()
#2 /home/.../vendor/swiftmailer/swiftmailer/lib/classes/Swift/Mailer.php(65): Swift_Transport_AbstractSmtpTransport->start()
#3 /home/.../Inc/Claz/Email.php(113): Swift_Mailer->send(Object(Swift_Message))
#4 /home/.../vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php on line 445

[altaphista]

@ the taxes, I just discovered after some debugging that the var $invoice.gross isn’t set/doesn’t exist in template.tpl on row 207:
Export::getData() - templatePath[templates/invoices/mycompany/template.tpl]

my sollution:
{($invoice.total - $invoice.total_tax)|siLocal_number}

• This reply was modified 6 years, 4 months ago by altaphista.

[Author]

Posts