[ExpertGeeks]

Thanks Richard. Can I recommend you amended this in the default template? Cheers.

[ExpertGeeks]

The default template (which the “Invoices Templates & Styles” you referenced to edit) renders the date in MM-DD-YYYY format.

I can’t put this any more plainly, how can I get the default template to display the date in the format YYYY-MM-DD ?

[ExpertGeeks]

Apologies, I think the version issue might have been to a permission on the config folder. I’ve tried the update again and now it shows 2020.0.11, however the print preview and the pdfs still have the date formate of MM-DD-YYYY. I’d be very happy with your new format of YYYY-MM-DD, I think this format makes the most sense. If only I could get the PDF’s to comply !

[ExpertGeeks]

I’ve manually made the changes listed here;

https://github.com/fearless359/simpleinvoices/commit/62c86040ae3cc154aa3e76bc51d1f8fd25f16155

to my working copy of 2020.0.10 which should bring me up to v2020.0.11. Despite all dates now showing as YYYY-MM-DD in the menus, they’re still MM-DD-YYYY in the print preview and the PDF’s for both the default template and my own eg-invoice template.

• This reply was modified 3 years, 10 months ago by ExpertGeeks.

[ExpertGeeks]

I also tried a git clone and copying across the usual config files etc etc and I get;

PdoDb – construct error: SQLSTATE[HY000] [1698] Access denied for user ‘root’@’localhost’ (Error code: 0)

[ExpertGeeks]

I’ve downloaded the zip from github, but it seems to be a revision off;

Version: 2020.0.10 — 20201217

This is still showing the date in MM-DD-YYYY format. How/where would I need to edit this to make changes to the date format ? My template references this field using;

{$invoice.date|utilDate}

• This reply was modified 3 years, 10 months ago by ExpertGeeks.

[ExpertGeeks]

OK Good stuff. Upgraded and working. Thanks Richard.

[ExpertGeeks]

..however;

<option value='0'></option>

does work, and if you enter another customer into the parent customer field, it uses their value instead of 0.

[ExpertGeeks]

No, I’m afraid not.. Same error;

[18-Dec-2020 00:03:15 Europe/London] PdoDb – debugger(): INSERT INTO si_customers (domain_id, attention, name, department, street_address, street_address2, city, state, zip_code, country, phone, mobile_phone, fax, email, credit_card_holder_name, credit_card_expiry_month, credit_card_expiry_year, notes, custom_field1, parent_customer_id, enabled) VALUES (1, ”, ‘NAME’, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ’email@address.com’, ”, ”, ”, ”, ”, ”, 1)
[18-Dec-2020 00:03:15 Europe/London] PdoDb – query(): Execute error.Array
(
[0] => 22007
[1] => 1366
[2] => Incorrect integer value: ” for column sinv2020.si_customers.parent_customer_id at row 1
)

[ExpertGeeks]

It’s;
Version: 2020.0.07 — 20201201

• This reply was modified 3 years, 11 months ago by ExpertGeeks.

[ExpertGeeks]

I can add customers if I set a ‘parent customer’.. but if this field is blank, it gives the error above

[ExpertGeeks]

The default database has a default delete value of ‘N’. I’ve changed it to 1 and now I can edit the system defaults. This version can print to PDF so the environment is capable of printing PDF’s. I’ve switched to my database and can print PDF’s from this too (hooray). Thanks Richard.

• This reply was modified 3 years, 11 months ago by ExpertGeeks.

[ExpertGeeks]

New install didn’t complete, the database was broken. While I could create products and customers, I couldn’t select either when generating an invoice.

I did as the ‘installation’ doc suggests when you have ‘Problems with the Simple Invoices installer?’ and imported the supplied database. This imported database IS able to generate PDF’s. However, when I went to try to check whether I could change the currency etc in ‘SI Defaults’ I get the following error;

Fatal error: Uncaught TypeError: Return value of Inc\Claz\SystemDefaults::getDelete() must be of the type int, string returned in /var/www/html/sinv2020.1/simpleinvoices-master_2020/Inc/Claz/SystemDefaults.php:216 Stack trace: #0 /var/www/html/sinv2020.1/simpleinvoices-master_2020/modules/system_defaults/manage.php(28): Inc\Claz\SystemDefaults::getDelete() #1 /var/www/html/sinv2020.1/simpleinvoices-master_2020/index.php(440): include(‘/var/www/html/s…’) #2 {main} thrown in /var/www/html/sinv2020.1/simpleinvoices-master_2020/Inc/Claz/SystemDefaults.php on line 216

Error in tmp/log/php.log
[03-Dec-2020 04:56:31 America/Los_Angeles] PHP Fatal error: Uncaught TypeError: Return value of Inc\Claz\SystemDefaults::getDelete() must be of the type int, string returned in /var/www/html/sinv2020.1/simpleinvoices-master_2020/Inc/Claz/SystemDefaults.php:216
Stack trace:
#0 /var/www/html/sinv2020.1/simpleinvoices-master_2020/modules/system_defaults/manage.php(28): Inc\Claz\SystemDefaults::getDelete()
#1 /var/www/html/sinv2020.1/simpleinvoices-master_2020/index.php(440): include(‘/var/www/html/s…’)
#2 {main}
thrown in /var/www/html/sinv2020.1/simpleinvoices-master_2020/Inc/Claz/SystemDefaults.php on line 216

FYI Linux installation,
PHP Version 7.4.9
Server version: Apache/2.4.46 (Ubuntu)
Server built: 2020-08-10T12:32:00

[ExpertGeeks]

I’ve gone back to the installation instructions and am running through the ‘Export to PDF’ setup. There isn’t a pdf directory in .library/ are these instructions for an older version or should this directory still be present ? Creating and making that and pdf/fpdf writable by the apache user didn’t help.

GD support is enabled.

• This reply was modified 3 years, 11 months ago by ExpertGeeks.

[ExpertGeeks]

I tried setting up a fresh instance with a new database and got the following error during the database creation;

Fatal error: Uncaught TypeError: Return value of Inc\Claz\Db::query() must be of the type bool or null, object returned in /var/www/html/sinv2020.1/simpleinvoices-master_2020/Inc/Claz/Db.php:134 Stack trace: #0 /var/www/html/sinv2020.1/simpleinvoices-master_2020/modules/install/structure.php(16): Inc\Claz\Db->query() #1 /var/www/html/sinv2020.1/simpleinvoices-master_2020/index.php(440): include(‘/var/www/html/s…’) #2 {main} thrown in /var/www/html/sinv2020.1/simpleinvoices-master_2020/Inc/Claz/Db.php on line 134

[Author]

Posts