RRowley

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 263 total)
  • Author
    Posts
  • in reply to: DB upgrade errrors on new installation #1801
    RRowley
    Participant

    Need to check if you have a database table named si_products_values. The error says you don’t. Now check if you have a table named si_products_attributes_values.

    If you don’t have either table, create the si_products_values table and try SI again.

    If you have the si_products_attributes_values table then insert the following to the si_sql_patchmanager table:

    FIELD NAME           VALUE
    sql_patch_ref        324
    sql_patch            Rename si_products_values table to si_products_attributes_values
    sql_release          20210527
    sql_statement        ALTER TABLE si_products_values RENAME TO si_products_attributes_values;
    source               fearless359
    

    Adding this to the patch table will tell SI that this patch has been applied.

    Let me know what you find and how this works out.

    • This reply was modified 3 weeks, 6 days ago by RRowley.
    in reply to: Invoices not appearing in grid #1797
    RRowley
    Participant

    Are you saying that you replicated this problem with the current master_2020 version of SI?

    If so, can you please give me detailed steps so I can replicate and fix?

    in reply to: Invoices not appearing in grid #1794
    RRowley
    Participant

    It would be interesting to see the “quick view” for this invoice. This shows the detail and the amount paid on it. If you can include a picture with Customer and Biller redacted. Also, if you could display the data base records for the invoice. These are in the tables: SI_INVOICES, SI_INVOICE_ITEMS, SI_INVOICE_ITEM_TAX and SI_PAYMENTS.

    In SimpleInvoices, not the invoice number you want to get records for. Use this value to Search the si_invoices table via the index_id field.

    Get the si_invoices record. Note the id value. Use the id of the invoice to select si_invoice_items via the index_id.

    Use the si_invoice_items id value to get si_invoice_item_tax records via the invoice_item_id field.

    Use the si_invoices id value to get si_payment record via the ac_inv_id field.

    If you are using phpMyAdmin, select the table you want to get records from and then us the Search menu to do your selection.

    If you screen show each selection and show it here, we’ll see what the offending record is.

    • This reply was modified 1 month, 1 week ago by RRowley.
    in reply to: Invoices not appearing in grid #1791
    RRowley
    Participant

    Also note that once the precision is set, you can access the invoice in EDIT mode and save it to cause the OWING field to be updated. This should hopefully correct that decimal setting.

    in reply to: Invoices not appearing in grid #1790
    RRowley
    Participant

    What is the localPrecision set to in the config/custom.config.ini file? If this is set to 2, the numeric amount values should be trimmed to 2 decimal places.

    in reply to: Invoices not appearing in grid #1784
    RRowley
    Participant

    I suspect the issue is with attempt to render the two amount fields where data is bad. One thing to try is to print the fields without rendering. This isn’t too difficult. Make a copy of the file “templates/default/invoices/manage.tpl”. Now change the original file from:

                        {
                            "data": "total",
                            "render": function (data, type, row) {
                                let formatter = new Intl.NumberFormat(row['locale'], {
                                    'style': 'currency',
                                    'currency': row['currency_code']
                                });
                                return formatter.format(data);
                            }
                        },
                        {
                            "data": "owing",
                            "render": function (data, type, row) {
                                let formatter = new Intl.NumberFormat(row['locale'], {
                                    'style': 'currency',
                                    'currency': row['currency_code']
                                });
                                return formatter.format(data);
                            }
                        },
    

    to:

                        {"data": "total"},
                        {"data": "owing"},
    

    Now try it an see what the data looks like. Look for any oddities in these two fields. You might have to page past the first screen.

    • This reply was modified 1 month, 3 weeks ago by RRowley.
    in reply to: Something went wrong, please try saving the invoice again #1780
    RRowley
    Participant

    This is actually the 2019.2 update and this stop is not unexpected. The issue is likely an orphaned record in the database that prevents the foreign key update from applying. You need to look at the error information in the tmp/logs/php.log file. It details what record(s) are at issue. If you want to display that information here or zip and attach the log file, I will look at it and let you know what can be done.

    You can also look at the “Unable to set Foreign Keys Error Handling” topic in the “Version Update Process” menu option on the left.

    NOTE: The php.log file might contain secure information. Be sure to scrub it before attaching/publishing it.

    • This reply was modified 1 month, 4 weeks ago by RRowley.
    RRowley
    Participant

    Sorry that you feel you need to move on. Do you recall the SqlPatchManager error you encountered? And have you tried to update recently?

    in reply to: Something went wrong, please try saving the invoice again #1773
    RRowley
    Participant

    It appears you running SI version master_2019.2. Is there any reason you can’t updated to master_2020?

    RRowley
    Participant

    First, check the web server (Apache?) log files to see is anything is reported there. Next check the PHP error log file. The next step would be to set the SI logger lever to DEBUG (custom.config.ini loggerLevel = DEBUG). Recreate the error and look at the tmp/log/si.log file and see where it ends. That is where the process stopped. Hopefully that guides you to the problem.

    I did check out the mysql 8 vs mariadb which I use and they are SQL compatible. So I don’t suspect an issue there.

    in reply to: Change Emailed PDF Title and Email Subject #1767
    RRowley
    Participant

    Unfortunately making an extension requires PHP and Smarty knowledge. Details on setting an extension up can be found in the Extensions topic in the menu list on the left.

    in reply to: stylesheet isn’t working #1707
    RRowley
    Participant

    The problem is the PDF logic on a localhost server cannot handle an absolute URL path to the icon image. It does work with a relative path.

    I just update the files on github to change the logo path to a relative path on all export template. This is version 2020.3.20. If you have your own template, you can remove the holiday_logo function from it as the logo value passed to the template is correctly modified and any holiday logo resolved before it is passed to the template.

    The holiday_logo function in the template still exists but does not change anything. It will generate an entry in the error_log file indicating that the template should be updated. This is done so that your template will process correctly even with this function still in it.

    in reply to: Invoices not appearing in grid #1696
    RRowley
    Participant

    Turn on tracing to see if there are any places that processing stops. Do this by setting these values in the confgi/custom.config.ini file:

    debugLevel = All
    debugErrorReporting = E_ERROR

    This will report information in the tmp/log/si.log file.

    Note that secure information is reported in this file, so make sure any is obscured if you show this info in this forum.

    Normally, when the unresolved loading happens, something is wrong with the data table information. Do make sure that you have the both the gdt and the intl extensions enabled in your php.ini file. You can verify this via the SI phpinfo.php file. To use this, modify the $secure setting to false. Then access this file by specifying /phpinfo.php after the SI https entry.

    in reply to: Still No Logo on invoices! #1694
    RRowley
    Participant

    The attribute error has nothing to do with the logo. I have the same issue on my windows system that you do. However, on my live website, hosted on a Linux domain server, I do not have a problem. So while I haven’t resolved the issue, I think it has to do more with PDF generation on my XAMPP setup; possibly because it doesn’t have an SSL implementation. That is, the logo URL used, uses https and not http. This is something I’ll test later to see if that is the case.

    in reply to: upgrade a 2011.1 to 2020 #1692
    RRowley
    Participant

    The issue is that your data base is not set up. Make sure you can read it via your phpMyAdmin app (or whatever app you use to setup and view your database). For the master_2019.2 version, the database information is in the config/custom.config.php file. For the master_2020 version it is in the config/custom.config.ini file. If it is the master_2020 version you are loading, it is possible that the databasePassword value needs to enclosed in quotes. Once this information is properly set up, the application will proceed to the update screen.

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