Forum Replies Created
-
Posts
-
Got it. That’s part of why I want to add some fields in that table. I’ve asked this in my other post, so I won’t double-post here and I hope you can show me in the other post how to add some fields to the table. Thank you
Sorry to be dumb, but I am a bit confused.
I found the Settings > Customize > Extensions menu and I see the “Core part and the “eway payment gateway” and nothing else. I don’t see a way to add an extension here.
How would I add an extension? And what would the extension be/entail?What I am trying to achieve are two separete things:
1. add some of the CUSTOM FIELDS that I have set in Settings>Custom Fields to the main view that I see when I load the main page in Money>Invoices.
Right now that page shows a table with: Actions / Invoice / Biller / Customer / Preference etc etc
What I want to do is add two custom fields to that table.2. somehow I misspelled my name 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?
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
Recent Comments