ExpertGeeks

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 48 total)
  • Author
    Posts
  • in reply to: Date format #1328
    ExpertGeeks
    Participant

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

    in reply to: Date format #1295
    ExpertGeeks
    Participant

    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 ?

    in reply to: Date format #1293
    ExpertGeeks
    Participant

    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 !

    in reply to: Date format #1291
    ExpertGeeks
    Participant

    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 1 year, 7 months ago by ExpertGeeks.
    in reply to: Date format #1290
    ExpertGeeks
    Participant

    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)

    in reply to: Date format #1288
    ExpertGeeks
    Participant

    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 1 year, 7 months ago by ExpertGeeks.
    in reply to: Cannot add new customers #1273
    ExpertGeeks
    Participant

    OK Good stuff. Upgraded and working. Thanks Richard.

    in reply to: Cannot add new customers #1271
    ExpertGeeks
    Participant

    ..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.

    in reply to: Cannot add new customers #1270
    ExpertGeeks
    Participant

    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
    )

    in reply to: Cannot add new customers #1267
    ExpertGeeks
    Participant

    It’s;
    Version: 2020.0.07 — 20201201

    • This reply was modified 1 year, 7 months ago by ExpertGeeks.
    in reply to: Cannot add new customers #1265
    ExpertGeeks
    Participant

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

    in reply to: PDF generation urlsafe/htmlsafe #1259
    ExpertGeeks
    Participant

    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 1 year, 8 months ago by ExpertGeeks.
    in reply to: PDF generation urlsafe/htmlsafe #1257
    ExpertGeeks
    Participant

    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

    in reply to: PDF generation urlsafe/htmlsafe #1255
    ExpertGeeks
    Participant

    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 1 year, 8 months ago by ExpertGeeks.
    in reply to: PDF generation urlsafe/htmlsafe #1254
    ExpertGeeks
    Participant

    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

Viewing 15 posts - 1 through 15 (of 48 total)