[ppmt]

Ok I have made some progress. I decided to install the master2010_2 version on the “production” machine.

I created a new database so I can start from scratch. During the database installation I have a 504 Gateway timeout but pressing reload allowed me to continue.

I then tested sending an email with my “production” version of SI and it worked well.

When I used the master2019_2 version then I ended with the same grey screen but this time there was a message printed. I edited the smtp host.

So there is a timeout but I am not sure why since it works for the production version.

Fatal error: Uncaught Swift_IoException: Connection to my_smtp_host:290 Timed Out in /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php:166 Stack trace: #0 /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(467): Swift_Transport_StreamBuffer->readLine(0) #1 /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(358): Swift_Transport_AbstractSmtpTransport->getFullResponse(0) #2 /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(147): Swift_Transport_AbstractSmtpTransport->readGreeting() #3 /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Mailer.php(65): Swift_Transport_AbstractSmtpTransport->start() #4 /var/www/simpleinvoices/simpleinvoi in /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php on line 473

[ppmt]

I am not sure how to run the composer command as I can’t find any command like that in the SI directory.

I attached an si.log extract as for some reason I can’t paste it in he message itself.

PS: ignore the si_extract.log file. It’s the same as the txt one

• This reply was modified 5 years, 2 months ago by ppmt.
• This reply was modified 5 years, 2 months ago by ppmt.

Attachments:

1. si_extract.txt

[ppmt]

Here is what I do:

I click the email icon on the invoice and I get redirected to that url:
http://192.168.1.83:8000/index.php?module=invoices&view=email&stage=1&id=1

I fill in the content box and when I press Email I eventually after a some seconds get redirected to that url:
http://192.168.1.83:8000/index.php?module=invoices&view=email&stage=2&id=1

Here is the access.log from nginx.

192.168.1.100 - - [26/Sep/2019:09:51:32 +0000] "GET /index.php?module=invoices&view=email&stage=1&id=1 HTTP/1.1" 200 14257 "http://192.168.1.83:8000/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:69.0) Gecko/20100101 Firefox/69.0" "-"
192.168.1.100 - - [26/Sep/2019:09:51:32 +0000] "GET /images/common/required-small.png HTTP/1.1" 200 1676 "http://192.168.1.83:8000/index.php?module=invoices&view=email&stage=1&id=1" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:69.0) Gecko/20100101 Firefox/69.0" "-"
192.168.1.100 - - [26/Sep/2019:09:51:32 +0000] "GET /images/common/help-small.png HTTP/1.1" 200 1193 "http://192.168.1.83:8000/index.php?module=invoices&view=email&stage=1&id=1" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:69.0) Gecko/20100101 Firefox/69.0" "-"
192.168.1.100 - - [26/Sep/2019:09:51:32 +0000] "GET /images/common/tick.png HTTP/1.1" 200 537 "http://192.168.1.83:8000/index.php?module=invoices&view=email&stage=1&id=1" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:69.0) Gecko/20100101 Firefox/69.0" "-"

<this is where I press Email>

172.29.0.1 - - [26/Sep/2019:09:53:40 +0000] "GET /templates/invoices/default/style.css HTTP/1.0" 200 1009 "-" "-" "-"
172.29.0.1 - - [26/Sep/2019:09:53:40 +0000] "GET /templates/invoices/logos/_default_blank_logo.png HTTP/1.0" 200 168 "-" "-" "-"
172.29.0.1 - - [26/Sep/2019:09:53:40 +0000] "GET /templates/invoices/logos/_default_blank_logo.png HTTP/1.0" 200 168 "-" "-" "-"

<about 10 to 20 second delay before I get redirected to the url below with a empty grey screen>

192.168.1.100 - - [26/Sep/2019:09:54:11 +0000] "POST /index.php?module=invoices&view=email&stage=2&id=1 HTTP/1.1" 200 6097 "http://192.168.1.83:8000/index.php?module=invoices&view=email&stage=1&id=1" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:69.0) Gecko/20100101 Firefox/69.0" "-"

Nothing in error.log nor the php.log.

[ppmt]

My bad the error above was because I forgot to copy my invoices template.

After that the error above is gone but I am back to the grey screen!

[ppmt]

Ok. I managed to install the lastest version after a bit of timeout issue. Not sure if it is because my test machine is a bit slow but during the database upgrade I had a 504 Gateway timeout.

After reload the page I still wanted to apply the last patch (the one about the foreign key)

Eventually it worked so I could test sending email…and it still fails…I get the following message

Both pdf_string and pdf_file_name must be set or left empty

[ppmt]

I have downloaded the master_2019.2.1 and when I load it tells me to update the database. When I do it after a few second I get this error:

SqlPatchManager::runSqlPatch() error. See error log for more information.

in php.log I see this:

/var/www/html/tmp/log # cat php.log 
[25-Sep-2019 09:42:39 Europe/London] PdoDb - debugger(): ALTER TABLE <code>si_invoice_item_attachments</code> DROP INDEX <code>id</code>;ALTER TABLE <code>si_products_attributes</code> MODIFY <code>type_id</code> INT(11) UNSIGNED NULL;
[25-Sep-2019 09:42:39 Europe/London] PdoDb - query(): Execute error.Array
(
    [0] => 42000
    [1] => 1091
    [2] => Can't DROP INDEX <code>id</code>; check that it exists
)

[25-Sep-2019 09:42:39 Europe/London] PdoDb - backtrace: Array
(
    [0] => Array
        (
            [file] => /var/www/html/Inc/Claz/SqlPatchManager.php
            [line] => 241
            [function] => query
            [class] => Inc\Claz\PdoDb
            [object] => Inc\Claz\PdoDb Object
                (
                    [caseStmts:Inc\Claz\PdoDb:private] => 
                    [debug:Inc\Claz\PdoDb:private] => 
                    [debug_label:Inc\Claz\PdoDb:private] => 
                    [debug_microtime:Inc\Claz\PdoDb:private] => 0
                    [distinct:Inc\Claz\PdoDb:private] => 
                    [excludedFields:Inc\Claz\PdoDb:private] => Array
                        (
                        )

                    [fauxPost:Inc\Claz\PdoDb:private] => 
                    [fieldPrefix:Inc\Claz\PdoDb:private] => 
                    [functions:Inc\Claz\PdoDb:private] => 
                    [groupBy:Inc\Claz\PdoDb:private] => 
                    [havings:Inc\Claz\PdoDb:private] => 
                    [joinStmts:Inc\Claz\PdoDb:private] => 
                    [keyPairs:Inc\Claz\PdoDb:private] => 
                    [lastCommand:Inc\Claz\PdoDb:private] => 
                    [limit:Inc\Claz\PdoDb:private] => 0
                    [noErrorLog:Inc\Claz\PdoDb:private] => 
                    [onDuplicateKey:Inc\Claz\PdoDb:private] => 
                    [orderBy:Inc\Claz\PdoDb:private] => 
                    [pdoDb:Inc\Claz\PdoDb:private] => PDO Object
                        (
                        )

                    [pdoDb2:Inc\Claz\PdoDb:private] => PDO Object
                        (
                        )

                    [saveLastCommand:Inc\Claz\PdoDb:private] => 
                    [selectAll:Inc\Claz\PdoDb:private] => 
                    [selectList:Inc\Claz\PdoDb:private] => 
                    [selectStmts:Inc\Claz\PdoDb:private] => 
                    [table_columns:Inc\Claz\PdoDb:private] => 
                    [table_constraints:Inc\Claz\PdoDb:private] => 
                    [table_engine:Inc\Claz\PdoDb:private] => InnoDB
                    [table_schema:Inc\Claz\PdoDb:private] => fear_invoices
                    [transaction:Inc\Claz\PdoDb:private] => 1
                    [usePost:Inc\Claz\PdoDb:private] => 1
                    [whereClause:Inc\Claz\PdoDb:private] => 
                )

            [type] => ->
            [args] => Array
                (
                    [0] => ALTER TABLE <code>si_invoice_item_attachments</code> DROP INDEX <code>id</code>;ALTER TABLE <code>si_products_attributes</code> MODIFY <code>type_id</code> INT(11) UNSIGNED NULL;
                )

        )

    [1] => Array
        (
            [file] => /var/www/html/Inc/Claz/SqlPatchManager.php
            [line] => 314
            [function] => runSqlPatch
            [class] => Inc\Claz\SqlPatchManager
            [type] => ::
            [args] => Array
                (
                    [0] => 308
                    [1] => Array
                        (
                            [name] => Remove dup id key from invoice_item_attachments and fix products_attributes type_id data type
                            [patch] => ALTER TABLE <code>si_invoice_item_attachments</code> DROP INDEX <code>id</code>;ALTER TABLE <code>si_products_attributes</code> MODIFY <code>type_id</code> INT(11) UNSIGNED NULL;
                            [date] => 20190329
                            [source] => fearless359
                        )

                )

        )

    [2] => Array
        (
            [file] => /var/www/html/index.php
            [line] => 183
            [function] => runPatches
            [class] => Inc\Claz\SqlPatchManager
            [type] => ::
            [args] => Array
                (
                )

        )

)

[25-Sep-2019 09:42:39 Europe/London] SqlPatchManager::runSqlPatch() - PdoDb - query(): Execute error. See error_log.

Whis other logs should I be looking at? si.log is empty

[ppmt]

I have it set to en_GB and it did not fix the issue

[ppmt]

I updated the database to NULL and it is still working. The default value for that field is NULL.

and forget about the pdf. It does work. I was confused by the documentation that ask to check to for library/pdf
Then I saw you replaced that library by something else.

[ppmt]

Just to chime in. I have the same issue

I use the latest master_2019 and updated the custom.config.php to use en_GB. The Invoice preferences was already set to the £ sign.

If I display the invoice I see the £ sign but in the main screen with all the invoices displayed I see a $ sign.

[ppmt]

I will check as instructed…

I am also going to may be create another post related to pdf if I can’t find my answer in the documentation. It seems the master_2019 repo doesn’t include the library/pdf directory

[ppmt]

I found out the problem in the end. I backed up the database and when I tried to import it again restored it I originally “ignored” a error (don’t ask!)

ERROR 1366 (22007) at line 3982: Incorrect integer value: '' for column 'fear_invoices\’.’si_products’.’default_tax_id_2′ at row 1`

when I checked the database I could see that a few of the products (about 8) had been loaded but the rest (about 20) were not. All the culprit had their ‘default_tax_id_2’ field set to ” while the loaded had ‘0’

I fixed the file to and reimport it again and after that all was good.

So I guess you are right the database did import fully and then SI assumed it wasn’t not installed!

What I don’t get is why some of the product where not set correctly. And how do you set that Tax_2 field?

Anyway the problem is solved on my side. Now I need to check that all still work as expected before switching over.

• This reply was modified 5 years, 2 months ago by ppmt.
• This reply was modified 5 years, 2 months ago by ppmt.
• This reply was modified 5 years, 2 months ago by ppmt.
• This reply was modified 5 years, 2 months ago by ppmt.

[Author]

Posts