fearless359

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 35 total)
  • Author
    Posts
  • in reply to: change currency option #2020
    fearless359
    Keymaster

    The currency sign is €. The currency code is EUR. You can get this info from the help info for each field in the Inv Prefs option of the Settings tab.

    • This reply was modified 2 weeks, 5 days ago by fearless359.
    • This reply was modified 2 weeks, 5 days ago by fearless359.
    • This reply was modified 2 weeks, 5 days ago by fearless359.
    in reply to: Update SI from an old version #2018
    fearless359
    Keymaster

    In the schema you attached, the following is the id settings in si_invoice_items:

    CREATE TABLE si_invoice_items (
      id int(10) NOT NULL AUTO_INCREMENT,
    

    It should be:

    CREATE TABLE si_invoice_items (
      id int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    

    If the table is set correctly, then the update process should complete as it did once I made the change. Note, you can change the field setting manually in phpMyAdmin by selecting the Change option on the id column under the Structure tab when si_invoice_items is selected.

    • This reply was modified 2 weeks, 5 days ago by fearless359.
    in reply to: Update SI from an old version #2013
    fearless359
    Keymaster

    Via phpMyAdmin, access the si_invoice_items table and execute the following SQL command:

    ALTER TABLE si_invoice_items MODIFY id INT(11) UNSIGNED NOT NULL;
    

    Had to dig, but issue is that the invoice_item_id field in the si_invoice_item_tax table is configured differently than the id field in the si_invoice_items table. This command corrects the issue.

    in reply to: change currency option #2012
    fearless359
    Keymaster

    Refer to the Globalization Support topic in the menu of the left.

    in reply to: Unable to parse ini file: config/custom.config.ini #1977
    fearless359
    Keymaster

    FYI, your password recovery directions to another forum user, were excellent. I hadn’t thought of it before. I tested it and other than some template warnings related to not having a role name stored for the user’s session, it works. So I just delivered an update that fixes the warnings and formalized recovery procedures in the How To menu section.

    in reply to: PHP 8 #1847
    fearless359
    Keymaster

    I’m working on it.

    in reply to: Country field #1843
    fearless359
    Keymaster

    You can change the min and max length fields in the template for the screen. Ex: templates/default/billers/edit.tpl or create.tpl. However, this should be done as an extension so that it isn’t lost when you update. Extension info can be found in the Extension section on the left.

    However, the intent of this size if to support the ISO 3166-1 Alpha 3 code for countries. Which might be added as a validation in the future.

    • This reply was modified 11 months, 4 weeks ago by fearless359.
    in reply to: Fatal Error on fresh installation #1834
    fearless359
    Keymaster

    In the si_sql_patchmanager table, what is the greatest value of the sql_patch_ref field? It should be 335 and the sql_statement should contain,

    INSERT INTO si_system_defaults (name ,value ,domain_id ,extension_id ) VALUES ('invoice_display_days', 0, 1, 1);

    If so, then the invoice_display_days row should be the last item in the si_system_defaults table. Make sure you are looking at all the records in the file. Default is to display 25 record but this one is the 44th row. You can sort the table by the name field to make the entries in alpha order.

    Also, did you download the most current si version? The version # should be 2020.4.5. Click on the About option in the top menu line to see the version or get it from the config/config.ini file.

    in reply to: No payment registered #1827
    fearless359
    Keymaster

    Thanks for the appreciation. Please update to the latest version and see if the problem remains. If so, I can then work it.

    in reply to: Fatal Error on fresh installation #1824
    fearless359
    Keymaster

    Modified si_system_defaults access functions to force an integer value returned by functions that require int type return values. This is now available in v2020.4.5.

    Verify that the invoice_display_days value is numeric in the si_system_defaults table. If it is and you continue to get this failure, download the new version and see if that helps.

    in reply to: upgrade a 2011.1 to 2020 #1689
    fearless359
    Keymaster

    I have update the Version Update Process instructions on the left, menu to explain the update process from old SI version such as 2011.1 to the current version. This needs to be done by first updating to the master_2019.2 version and then to the current master_2020 version. Let me know if you have questions about these instructions.

    in reply to: Slowness after 1000 invoices #1636
    fearless359
    Keymaster

    The logic uses DataTables ajax with deferred rendering to make initial display as fast as possible. On my windows development system I get about a 3 second lapse to display the first page of invoices from a 550 total table. I don’t have a larger table to work with. On my production system that is hosted for me on a shared Linux server, there is about 1 second added to the display time. In either case, if after displaying the first page, I select the option to display the last page, there is no latency in the display on either system.

    This is what I would expect give that the ajax display copies all the invoice data from the server to the browser when the initial page is displayed. The deferred rendering simply allows the first page of the data to be rendered and displayed while the logic continues to render the rest of the data in preparation for display.

    Without more data to test with, I can’t give you comparative results. You might look at increasing your cache size. Also having an SSD rather than HDD can speed things up also.

    The bottom line is that the bulk of the processing time for you page is on the client, not the server. Speed up the client and you should have better results.

    in reply to: Embedding fonts with PDF invoice #1634
    fearless359
    Keymaster

    I haven’t needed to do this, but it seems that you can make your own invoice template folder and in the css file, specify the fonts you want to use. Possible using the the @font-face declaration.

    in reply to: Class ‘NumberFormatter’ #1565
    fearless359
    Keymaster

    I think you need to contact your shared hosting support. If you have access to cpanel for your site, you might look to see if you have a program to specify the version of php. Check it and their might be a list of checkbox items that you can enable and intl should be in there.

    There is not practical was to replace the NumberFormatter class. It is standard PHP and should be something your hosting service supports.

    in reply to: Update 2011 version to 2019_2 version #1451
    fearless359
    Keymaster

    For some reason, this text box didn’t like my long instructions. So I put them in the attached file. Download the attached zip file, and read the FixInstructsions.txt file in it.

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