Forum Replies Created
-
Posts
-
Thank you RRolwey for the explanation.
Should you find a way to make the search feature system wide in the future, I think that would be a great feature to add so that one can always search the entire database.
From the little PHP I know it should be easy to disconnect the search feature from the table and just run the search across all the fields of the database.Thank you so much. This is SUPER helpful!
The Display Days settings is what I needed!
I keep all my customers always enabled (cause, as they say, sometimes they come back! 😉 so I wouldn’t need any options to show only enabled customers, but the 1-year worth of invoices did the trick!
I can always click All if I have to find older ones…The one change/feature request I would like to ask for/add is that the search should always work in ALL (entire database of invoices)… I’ve noticed that if I set the days to 365 it won’t search for older invoices… I think the display feature should not affect the search feature as that can create some headaches and confusion (if you forget you have set it to a year of invoices and you need to find an old one with the search function).
Moving the manage.tpl file from the old install to custom/default_template didn’t work…
Basically, what I am trying to do is change what values are shown inside the table that is shown in the main MONEY>INVOICES screen (at the URL: /index.php?module=invoices&view=manage)
What part of the template file generates this table so I can change what is show in that table? Or is there another way to change what is shown?As for the PDF, thanks for telling me where the font settings are.
I have one last PDF question: my name is misspelled in the PDF invoice at the top right corner and I can’t find where the settings are for that… I’ve looked in all the PEOPLE menus and SETTINGS menus but I can’t see where the misspelled name is, where would that be saved?
Thanks
Thank you for your help with this.
I have run the following query:
DELETE FROM si_invoice_item_tax WHERE invoice_item_id IN (2, 3, 4, 5, 7, 8, 162, 322, 471, 617, 660, 1063, 1064, 1058, 1059, 1062, 1060, 1061, 1067, 1068, 1332, 1379, 1455, 1456, 1470, 1598, 1680, 1693, 1694, 1751, 1904, 2008, 2009, 2010, 2164, 2275, 2296, 2401, 2400, 2402, 2403, 2404, 2448, 2449, 2499, 2512, 2517, 2518, 2583, 2586, 2666, 2719, 2752, 2772, 2944, 2989, 2990, 2988, 3038, 3070);And that worked. I was able to continue with the update and access my invoices.
I shall be making another donation to the support GoFund Me to thank you for your time.I do have two other questions but I will post them in separate threads so this thread can stay on topic.
I just emptied the php.log file and re-loaded the root of the SI install, got the same page (stuck at SQL patch 330) and then I clicked on the UPDATE button and after the some time I got a white page with the following error message:
SqlPatchManager::runSqlPatch() error. See error log for more information.…then I opened the php.log file and the contents were these:
[22-Jul-2025 23:18:30 America/New_York] Unable to apply patch 331. Found foreign key table columns with NULL values or values not in the reference table column. The following list shows what values in foreign key columns are missing from reference columns. The records in the FOREIGN KEY TABLE are most likely invalid and should be deleted. FOREIGN KEY TABLE COLUMN REFERENCE TABLE COLUMN INVALID VALUE ------------------------ ------------------ ----------------------- --------- ------------- invoice_item_tax invoice_item_id invoice_items id 2 invoice_item_tax invoice_item_id invoice_items id 3 invoice_item_tax invoice_item_id invoice_items id 4 invoice_item_tax invoice_item_id invoice_items id 5 invoice_item_tax invoice_item_id invoice_items id 7 invoice_item_tax invoice_item_id invoice_items id 8 invoice_item_tax invoice_item_id invoice_items id 162 invoice_item_tax invoice_item_id invoice_items id 322 invoice_item_tax invoice_item_id invoice_items id 471 invoice_item_tax invoice_item_id invoice_items id 617 invoice_item_tax invoice_item_id invoice_items id 660 invoice_item_tax invoice_item_id invoice_items id 1063 invoice_item_tax invoice_item_id invoice_items id 1064 invoice_item_tax invoice_item_id invoice_items id 1058 invoice_item_tax invoice_item_id invoice_items id 1059 invoice_item_tax invoice_item_id invoice_items id 1062 invoice_item_tax invoice_item_id invoice_items id 1060 invoice_item_tax invoice_item_id invoice_items id 1061 invoice_item_tax invoice_item_id invoice_items id 1067 invoice_item_tax invoice_item_id invoice_items id 1068 invoice_item_tax invoice_item_id invoice_items id 1332 invoice_item_tax invoice_item_id invoice_items id 1379 invoice_item_tax invoice_item_id invoice_items id 1455 invoice_item_tax invoice_item_id invoice_items id 1456 invoice_item_tax invoice_item_id invoice_items id 1470 invoice_item_tax invoice_item_id invoice_items id 1598 invoice_item_tax invoice_item_id invoice_items id 1680 invoice_item_tax invoice_item_id invoice_items id 1693 invoice_item_tax invoice_item_id invoice_items id 1694 invoice_item_tax invoice_item_id invoice_items id 1751 invoice_item_tax invoice_item_id invoice_items id 1904 invoice_item_tax invoice_item_id invoice_items id 2008 invoice_item_tax invoice_item_id invoice_items id 2009 invoice_item_tax invoice_item_id invoice_items id 2010 invoice_item_tax invoice_item_id invoice_items id 2164 invoice_item_tax invoice_item_id invoice_items id 2275 invoice_item_tax invoice_item_id invoice_items id 2296 invoice_item_tax invoice_item_id invoice_items id 2401 invoice_item_tax invoice_item_id invoice_items id 2400 invoice_item_tax invoice_item_id invoice_items id 2402 invoice_item_tax invoice_item_id invoice_items id 2403 invoice_item_tax invoice_item_id invoice_items id 2404 invoice_item_tax invoice_item_id invoice_items id 2448 invoice_item_tax invoice_item_id invoice_items id 2449 invoice_item_tax invoice_item_id invoice_items id 2499 invoice_item_tax invoice_item_id invoice_items id 2512 invoice_item_tax invoice_item_id invoice_items id 2517 invoice_item_tax invoice_item_id invoice_items id 2518 invoice_item_tax invoice_item_id invoice_items id 2583 invoice_item_tax invoice_item_id invoice_items id 2586 invoice_item_tax invoice_item_id invoice_items id 2666 invoice_item_tax invoice_item_id invoice_items id 2719 invoice_item_tax invoice_item_id invoice_items id 2752 invoice_item_tax invoice_item_id invoice_items id 2772 invoice_item_tax invoice_item_id invoice_items id 2944 invoice_item_tax invoice_item_id invoice_items id 2989 invoice_item_tax invoice_item_id invoice_items id 2990 invoice_item_tax invoice_item_id invoice_items id 2988 invoice_item_tax invoice_item_id invoice_items id 3038 invoice_item_tax invoice_item_id invoice_items id 3070 [22-Jul-2025 23:18:30 America/New_York] SqlPatchManager::runSqlPatch() - SqlPatchManager::prePatch331() = Unable to set Foreign Keys.I am ready for that zoom unless you can tell me how to proceed.
I am sorry if I was not clear:
my original issue persists, I cannot access the invoices AT ALL! I cannot even access the dashboard of SI! If I access SI I get the Database Update page which is stuck on the SQL patch 330… This is why I am asking what I should be deleting from the database manually in order to unlock this situation… right now I am stuck mid-installation unable to access anything SI-related AT ALL.
I would very much appreciate if we could schedule a zoom call and I would be happy to pay for your time or make a donation to the SI forum because I am not sure how to proceed from here.So I have manually delete all of those items individually from the database with phpmyAdmin?
Do I go into the si_invoice_item_tax and delete all the rows with the invalid value shown on the right?I have just updated to the last 2023 version however during the update I go this error:
SqlPatchManager::runSqlPatch() error. See error log for more information.
and now it is stuck and won’t proceed to the SQL patch 331.
I navigated to:
tmp/log/php.log
and the last line says:[19-Jul-2025 21:38:25 America/New_York] Unable to apply patch 331. Found foreign key table columns with NULL values or values not in the reference table column. The following list shows what values in foreign key columns are missing from reference columns. The records in the FOREIGN KEY TABLE are most likely invalid and should be deleted. FOREIGN KEY TABLE COLUMN REFERENCE TABLE COLUMN INVALID VALUE ------------------------ ------------------ ----------------------- --------- ------------- invoice_item_tax invoice_item_id invoice_items id 2 invoice_item_tax invoice_item_id invoice_items id 3 invoice_item_tax invoice_item_id invoice_items id 4 invoice_item_tax invoice_item_id invoice_items id 5 invoice_item_tax invoice_item_id invoice_items id 7 invoice_item_tax invoice_item_id invoice_items id 8 invoice_item_tax invoice_item_id invoice_items id 162 invoice_item_tax invoice_item_id invoice_items id 322 invoice_item_tax invoice_item_id invoice_items id 471 invoice_item_tax invoice_item_id invoice_items id 617 invoice_item_tax invoice_item_id invoice_items id 660 invoice_item_tax invoice_item_id invoice_items id 1063 invoice_item_tax invoice_item_id invoice_items id 1064 invoice_item_tax invoice_item_id invoice_items id 1058 invoice_item_tax invoice_item_id invoice_items id 1059 invoice_item_tax invoice_item_id invoice_items id 1062 invoice_item_tax invoice_item_id invoice_items id 1060 invoice_item_tax invoice_item_id invoice_items id 1061 invoice_item_tax invoice_item_id invoice_items id 1067 invoice_item_tax invoice_item_id invoice_items id 1068 invoice_item_tax invoice_item_id invoice_items id 1332 invoice_item_tax invoice_item_id invoice_items id 1379 invoice_item_tax invoice_item_id invoice_items id 1455 invoice_item_tax invoice_item_id invoice_items id 1456 invoice_item_tax invoice_item_id invoice_items id 1470 invoice_item_tax invoice_item_id invoice_items id 1598 invoice_item_tax invoice_item_id invoice_items id 1680 invoice_item_tax invoice_item_id invoice_items id 1693 invoice_item_tax invoice_item_id invoice_items id 1694 invoice_item_tax invoice_item_id invoice_items id 1751 invoice_item_tax invoice_item_id invoice_items id 1904 invoice_item_tax invoice_item_id invoice_items id 2008 invoice_item_tax invoice_item_id invoice_items id 2009 invoice_item_tax invoice_item_id invoice_items id 2010 invoice_item_tax invoice_item_id invoice_items id 2164 invoice_item_tax invoice_item_id invoice_items id 2275 invoice_item_tax invoice_item_id invoice_items id 2296 invoice_item_tax invoice_item_id invoice_items id 2401 invoice_item_tax invoice_item_id invoice_items id 2400 invoice_item_tax invoice_item_id invoice_items id 2402 invoice_item_tax invoice_item_id invoice_items id 2403 invoice_item_tax invoice_item_id invoice_items id 2404 invoice_item_tax invoice_item_id invoice_items id 2448 invoice_item_tax invoice_item_id invoice_items id 2449 invoice_item_tax invoice_item_id invoice_items id 2499 invoice_item_tax invoice_item_id invoice_items id 2512 invoice_item_tax invoice_item_id invoice_items id 2517 invoice_item_tax invoice_item_id invoice_items id 2518 invoice_item_tax invoice_item_id invoice_items id 2583 invoice_item_tax invoice_item_id invoice_items id 2586 invoice_item_tax invoice_item_id invoice_items id 2666 invoice_item_tax invoice_item_id invoice_items id 2719 invoice_item_tax invoice_item_id invoice_items id 2752 invoice_item_tax invoice_item_id invoice_items id 2772 invoice_item_tax invoice_item_id invoice_items id 2944 invoice_item_tax invoice_item_id invoice_items id 2989 invoice_item_tax invoice_item_id invoice_items id 2990 invoice_item_tax invoice_item_id invoice_items id 2988 invoice_item_tax invoice_item_id invoice_items id 3038 invoice_item_tax invoice_item_id invoice_items id 3070 [19-Jul-2025 21:38:25 America/New_York] SqlPatchManager::runSqlPatch() - SqlPatchManager::prePatch331() = Unable to set Foreign Keys.Please help
I did write in the first post that I was using Version: 2020.0.10 — 20201217
I will see if I can update to the latestI’ve done more digging and I found that the file /public/data.json is empty… I’ve tried restoring it from backup but it doesn’t change… I’ve also tried deleting it in case it’s corrput but I keep getting the same error (the data.json) file is re-created upon page load but I keep getting the same error and no data in the tables…
This happens ONLY with the INVOICES and CUSTOMERS data, it does not happen with USERS, PAYMENT TYPES and all the others…
I’ve looked in the error logs that are being created and I see a series of errors like these:
[18-Jul-2025 17:46:44 America/New_York] Invoice::getInvoices() – Owing discrepancy on invoice id[1327] – index_id[1329]. Calculated owing[375] not equal to invoices table owning[0.000000]I don’t know how/why these errors are created and how to fix them but any advice would be greatly welcome and I’m willing to hire somebody to fix it.
Thank you so much. I just found your reply today when researching this after updating to master 2020.
Maybe ‘aging’ should be enabled by default, just a thoughtUPDATE: I found that this error was due to the fact that my PHP was set to 7.2 and when I set it to 7.4 it now works.
I have upgraded to 2019.2 but wanted to report the problem still exists and I have tried with different PHP version:
PHP 7.0:
COMPLETELY BLANK Screen with this error:
Fatal error: Uncaught TypeError: Return value of Inc\Claz\Export::setFormat() must be an instance of Inc\Claz\void, none returned in /home/marcurse/public_html/invoices/Inc/Claz/Export.php:504 Stack trace: #0 /home/marcurse/public_html/invoices/modules/export/invoice.php(20): Inc\Claz\Export->setFormat('pdf') #1 /home/marcurse/public_html/invoices/index.php(375): include('/home/marcurse/...') #2 {main} thrown in /home/marcurse/public_html/invoices/Inc/Claz/Export.php on line 504PHP 7.1 and 7.2:
CORRECT SCREEN PREVIEW of the invoice but this error at the bottom:
Fatal error: Uncaught Error: Call to undefined function urlsafe() in /home/marcurse/public_html/invoices/include/smarty_plugins/function.online_payment_link.php:24 Stack trace: #0 /home/marcurse/public_html/invoices/tmp/template_c/1e18b8cd6ed35e267d48e8afc9d384159268ffd2_0.file.template.tpl.php(657): smarty_function_online_payment_link(Array, Object(Smarty_Internal_Template)) #1 /home/marcurse/public_html/invoices/library/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_5ef0f1b8cd8265_46264209(Object(Smarty_Internal_Template)) #2 /home/marcurse/public_html/invoices/library/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode(Object(Smarty_Internal_Template)) #3 /home/marcurse/public_html/invoices/library/smarty/libs/sysplugins/smarty_internal_template.php(216): Smarty_Template_Compiled->render(Object(Smarty_Internal_Template)) #4 /home/marcurse/public_html/invoices/library/smarty/libs/sysplugins/smarty_internal_templatebase.php(232): Smarty_ in /home/marcurse/public_html/invoices/include/smarty_plugins/function.online_payment_link.php on line 24Additionally, when you are in the main invoices managment view (with the list of invoices) I noticed that clicking on the PDF export icon in the first column downloads a file with name “pdf” but no extension… if I add a pdf extension and open it it shows an empty invoice with no dollar amount, today’s date, the Simple Invoices logo (instead of my logo) and the wrong biller (instead of the default biller).
If I can help trouble shoot this please let me know.
Happy to help
Recent Comments