Debugging email

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

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

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

On the production machine

PHP 7.2.19-0ubuntu0.18.04.2 (cli) (built: Aug 12 2019 19:34:28) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.2.19-0ubuntu0.18.04.2, Copyright (c) 1999-2018, by Zend Technologies

and on the test machine

PHP 7.3.9 (cli) (built: Sep 12 2019 10:15:36) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.9, Copyright (c) 1998-2018 Zend Technologies

I have set up the section as per my host. The setting are the same as on the working machine running the old version of SI

email.host = sv4.byethost4.org
email.smtp_auth = true
email.username = myemail@mydomain.com
email.password = mypassword
email.smtpport = 290
email.secure = SSL
email.ack = false
email.use_local_sendmail = false