I'm getting a 500 error when completing the Company set up setup.php after first install. The Apache2 logs show the following:
[Sat Jun 21 17:10:51.865555 2025] [php:error] [pid 31304] [client 100.123.224.35:53224] PHP Fatal error: Uncaught mysqli_sql_exception: Field 'company_currency' doesn't have a default value in /var/www/<my domain>/setup.php:351\nStack trace:\n#0 /var/www/<my domain>/setup.php(351): mysqli_query()\n#1 {main}\n thrown in /var/www/<my domain>/setup.php on line 351, referer: https://<my domain>/setup.php?company
The offending line reads as follows:
mysqli_query($mysqli,"INSERT INTO companies SET company_name = '$name', company_address = '$address', company_city = '$city', company_state = '$state', company_zip = '$zip', company_country = '$country', company_phone = '$phone', company_email = '$email', company_website = '$website', company_tax_id = '$tax_id'");
With a little bit of troubleshooting, I tried the following
(add "company_currency = 'USD'" to the end):
mysqli_query($mysqli,"INSERT INTO companies SET company_name = '$name', company_address = '$address', company_city = '$city', company_state = '$state', company_zip = '$zip', company_country = '$country', company_phone = '$phone', company_email = '$email', company_website = '$website', company_tax_id = '$tax_id', company_currency = 'USD'");
I reloaded the webpage and it works.
I used the install script on a fresh VM of Ubuntu 24. The first time I just wiped it and tried again, and the second time I tried the above fix and it worked.