[chris]

I can see it both ways, if you do need to go back to an old invoice it’s a nightmare changing pages one at a time or guessing which page it would be on.

[chris]

I’ve just reverted back to my old server so i can get some invoices out in the mean time and it’s quite happy, 4 seconds from pressing login until the invoice page loads showing 30 invoices. It does look like the new version loads every invoice into the page at once and gives you the option of how many to display.. Once i got the invoices up i could go from 30 to All and it would show the other 4000 odd almost instantly. The old SI version only shows 30 per page and if you click the next arrow it loads up the next 30 with the option to jump to page numbers where it loads them on request.

[chris]

Hmmm, i’m on 4440. Been using it since 2012. Might be an idea to wipe out the old invoices below 4300 or so. I’ve got digital copies of them all in PDF….although if i can;t get this working again i might have to just look for something else. Quite nostalgic about SI though so going to keep at it as long as possible.

[chris]

That sounds about right for my luck 😀 😀 😀
As a side note: do you have a lot of invoices in your install and is it slow to load the invoices page as a result of that? Mine takes a good 30 seconds to login or go back to the invoices pages from elsewhere. I remember there being a fix for the original involving changing the database type (not sure how accurate that is but was definitely something involving phpmyadmin) but would’t think that a good idea without checking as it could wreck everything the sql patches have done during upgrades.

[chris]

Could do with changing the title now, I’m at a point now where i’m running PHP 7.2 with the latest master2 SI fearless and after cleaning up some database fields so it could upgrade i have a working install. Know though the logo still isnt showing but instead of the empty box previously mentioned i have the box with a red cross in the middle. Formatting of the invoice is fone just the logo is missing. I found a similar problem someone else had with nginx and they resolved it by usign a jpg instead of a png for the logo, tried that but did not solve the problem.

Again any advice would be greatly appreciated, felt like i couldn’t send out invoices with the logo missing and now haven’t been able to invoice any customers for a week 🙁

[chris]

Hmmmm, i’m not sure my setup would be comparable,
-cent os 7 hosted on godaddy vps
-PHP 7.0-7.2 with PHP-FPM (tried them all with different current SI versions)
-Apache2
Is there anyone else that uses this forum? Appreciate your help but don’t think we’ll get much further due to the setup differences. I can’t even find anymore error messages to fix now 🙁

[chris]

Have you not had any luck getting the pdf export to work?

[chris]

Can i ask what versions of everything you are using so i can try and match it here and see if it works?

[chris]

cleared everything in the cron-log as well as a couple of empty fields in expenses, database was upgraded. Still no logo on pdf export though, latest version of fearless, php 7.2, formatting is there now just a red cross where the logo should be. No errors in php error log.

[chris]

Can i just delete the cron tables, upgrade the database then re-import the cron tables?

[chris]

Finally got something to work on……..no idea what to do with it though 😀 was a late night though and an early morning. Will maybe digest it better later in the day:

[21-Oct-2019 23:51:52 America/Los_Angeles]
Unable to apply patch 318. Found foreign key table columns with values not in
the reference table column. The following list shows what values in foreign
key columns are missing from reference columns.

There two ways to fix this situation. Either change the row columns to reference
an existing record in the REFERENCE TABLE, or delete the rows that contain
the invalid columns.

To do this, the following example of the SQL statements to execute for the test
case where the ‘cron_log’ table contains invalid values ‘2’ and ‘3’ in the
‘cron_id’ column. The SQL statements to consider using are:

UPDATE si_cron_log SET cron_id = 6 WHERE cron_id IN (2,3);
—- or —-
DELETE FROM si_cron_log WHERE cron_id IN (2,3);

FOREIGN KEY TABLE COLUMN REFERENCE TABLE COLUMN INVALID VALUE
———————— —————— ———————– ——— ————-
cron_log cron_id cron id 2
cron_log cron_id cron id 3
cron_log cron_id cron id 4
cron_log cron_id cron id 5
cron_log cron_id cron id 6
cron_log cron_id cron id 7
cron_log cron_id cron id 8
cron_log cron_id cron id 9
cron_log cron_id cron id 10
cron_log cron_id cron id 11
cron_log cron_id cron id 12
cron_log cron_id cron id 13
cron_log cron_id cron id 14
cron_log cron_id cron id 18
cron_log cron_id cron id 30
cron_log cron_id cron id 31
cron_log cron_id cron id 35
cron_log cron_id cron id 37
cron_log cron_id cron id 41
expense customer_id customers id 0
expense invoice_id invoices id 0

[21-Oct-2019 23:51:52 America/Los_Angeles] SqlPatchManager::runSqlPatch() – SqlPatchManager::prePatch318() = Unable to set Foreign Keys.
[21-Oct-2019 23:51:52 America/Los_Angeles] PdoDb destruct – incomplete transaction – rollback performed.

[chris]

Will try upgrade again tonight, version I’m on just now uses the config. file instead of the custom.php file. Everything works fine but the export to pdf, finally found where the log files were being saved (root of the cpanel user directory) and found problems listed in the above new post. Will try upgrade again and see if it complains about something else instead. I have a suspicion I’ll get it upgraded properly and still not have working pdf export due to something else 🙁

[chris]

Have just run php -m | grep -i openssl on my VPS which returned “openssl” confirming that it is installed. Does fetcherUrl support SSL? Could do with any input as i’ve hit a wall with this now 🙁

[chris]

Although i have that set the same on the old server as well :/

[chris]

Finally tracked down so logs to show, is it because i have redirect to https enabled?:
[21-Oct-2019 14:10:11 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:10:11 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/default/style.css
[21-Oct-2019 14:10:11 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:10:11 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/logos/logo_cropped.png
[21-Oct-2019 14:15:55 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:15:55 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/default/style.css
[21-Oct-2019 14:15:55 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:15:55 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/logos/logo_cropped.png
[21-Oct-2019 14:19:13 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:19:13 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/default/style.css
[21-Oct-2019 14:19:13 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:19:13 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/logos/logo_cropped.png
[21-Oct-2019 14:20:29 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:20:29 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/default/style.css
[21-Oct-2019 14:20:30 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:20:30 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/logos/logo_cropped.png
[21-Oct-2019 14:26:16 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:26:16 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/default/style.css
[21-Oct-2019 14:26:16 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:26:16 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/logos/logo_cropped.png
[21-Oct-2019 14:30:17 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:30:17 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/default/style.css
[21-Oct-2019 14:30:17 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:30:17 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/logos/logo_cropped.png
[21-Oct-2019 14:51:12 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:51:12 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/default/style.css
[21-Oct-2019 14:51:12 America/Los_Angeles] Cannot connect to invoicing.revolutionaryit.co.uk:443 – (0) <br/>Missing SSL support?
[21-Oct-2019 14:51:12 America/Los_Angeles] FetcherUrl – Cannot open https://invoicing.revolutionaryit.co.uk/templates/invoices/logos/logo_cropped.png

[Author]

Posts