Data records and access

Hi Guys…

Two things I wanted to bring up…

  1. Mobile and Desktop app works well on PHP8.0 on other devices. The devices I use to use gives the handshake error. But through a browser on the devices that used to use the app, it won’t work with PHP8.0, I have to switch to PHP8.1. What’s weird is that PHP8.1 won’t work on the other devices that use the app again. For that to work, it must be on PHP8.0

  2. I am sure other’s might have this question… How can I download invoices in the system from a year back without having to manually go in each and every invoice to download manually. Is there not a bulk option that I can just click on to get all the pdfs for those invoices? Currently there is an export tool but this only works with producing records in excel. I need the actual invoices in pdf…

Thanks.

Hi,

  1. Are there any errors in storage/logs?

  2. Invoices can be bulk downloaded from the invoice table or the reports

Thanks for the reply.

Here’s the logs:

[2022-10-05 10:02:24] production.ERROR: During inheritance of PDO: Uncaught ErrorException: Return type of Doctrine\DBAL\Driver\PDOConnection::exec($sql) should either be compatible with PDO::exec(string $statement): int|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /usr/www/users/(commented out)/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:50

Stack trace:

#0 /usr/www/users/(commented out)/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(22): Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(8192, ‘Return type of …’, ‘/usr/www/users/…’, 50)

#1 /usr/www/users/(commented out)/vendor/composer/ClassLoader.php(480): include(‘/usr/www/users/…’)

#2 /usr/www/users/(commented out)/vendor/composer/ClassLoader.php(346): Composer\Autoload\includeFile(‘/usr/www/users/…’)

#3 [internal function]: Composer\Autoload\ClassLoader->loadClass(‘Doctrine\DBAL\D…’)

#4 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(66): class_exists(‘Doctrine\DBAL\D…’)

#5 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection(‘mysql:host=dedi…’, ‘(commented out)’, ‘(commented out)…’, Array)

#6 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection(‘mysql:host=dedi…’, Array, Array)

#7 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect(Array)

#8 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors{closure}()

#9 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(997): call_user_func(Object(Closure))

#10 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1033): Illuminate\Database\Connection->getPdo()

#11 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(426): Illuminate\Database\Connection->getReadPdo()

#12 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(352): Illuminate\Database\Connection->getPdoForSelect(true)

#13 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(685): Illuminate\Database\Connection->Illuminate\Database{closure}(‘select * from i…’, Array)

#14 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback(‘select * from i…’, Array, Object(Closure))

#15 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(360): Illuminate\Database\Connection->run(‘select * from i…’, Array, Object(Closure))

#16 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(44): Illuminate\Database\Connection->select(‘select * from i…’, Array)

#17 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\Schema\MySqlBuilder->hasTable(‘accounts’)

#18 /usr/www/users/(commented out)/app/Exceptions/Handler.php(78): Illuminate\Support\Facades\Facade::__callStatic(‘hasTable’, Array)

#19 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(414): App\Exceptions\Handler->report(Object(ErrorException))

#20 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(112): Illuminate\Foundation\Http\Kernel->reportException(Object(ErrorException))

#21 /usr/www/users/(commented out)/public/index.php(57): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

#22 {main} {“exception”:"[object] (Symfony\Component\ErrorHandler\Error\FatalError(code: 0): During inheritance of PDO: Uncaught ErrorException: Return type of Doctrine\DBAL\Driver\PDOConnection::exec($sql) should either be compatible with PDO::exec(string $statement): int|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /usr/www/users/(commented out)/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:50

Stack trace:

#0 /usr/www/users/(commented out)/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(22): Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(8192, ‘Return type of …’, ‘/usr/www/users/…’, 50)

#1 /usr/www/users/(commented out)/vendor/composer/ClassLoader.php(480): include(‘/usr/www/users/…’)

#2 /usr/www/users/(commented out)/vendor/composer/ClassLoader.php(346): Composer\Autoload\includeFile(‘/usr/www/users/…’)

#3 [internal function]: Composer\Autoload\ClassLoader->loadClass(‘Doctrine\DBAL\D…’)

#4 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(66): class_exists(‘Doctrine\DBAL\D…’)

#5 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection(‘mysql:host=dedi…’, ‘(commented out)’, ‘(commented out)…’, Array)

#6 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection(‘mysql:host=dedi…’, Array, Array)

#7 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect(Array)

#8 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors{closure}()

#9 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(997): call_user_func(Object(Closure))

#10 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1033): Illuminate\Database\Connection->getPdo()

#11 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(426): Illuminate\Database\Connection->getReadPdo()

#12 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(352): Illuminate\Database\Connection->getPdoForSelect(true)

#13 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(685): Illuminate\Database\Connection->Illuminate\Database{closure}(‘select * from i…’, Array)

#14 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback(‘select * from i…’, Array, Object(Closure))

#15 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(360): Illuminate\Database\Connection->run(‘select * from i…’, Array, Object(Closure))

#16 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(44): Illuminate\Database\Connection->select(‘select * from i…’, Array)

#17 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\Schema\MySqlBuilder->hasTable(‘accounts’)

#18 /usr/www/users/(commented out)/app/Exceptions/Handler.php(78): Illuminate\Support\Facades\Facade::__callStatic(‘hasTable’, Array)

#19 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(414): App\Exceptions\Handler->report(Object(ErrorException))

#20 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(112): Illuminate\Foundation\Http\Kernel->reportException(Object(ErrorException))

#21 /usr/www/users/(commented out)/public/index.php(57): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

#22 {main} at /usr/www/users/(commented out)/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:22)

[stacktrace]

#0 {main}

"}

[2022-10-05 10:07:24] production.ERROR: During inheritance of PDO: Uncaught ErrorException: Return type of Doctrine\DBAL\Driver\PDOConnection::exec($sql) should either be compatible with PDO::exec(string $statement): int|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /usr/www/users/(commented out)/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:50

Stack trace:

#0 /usr/www/users/(commented out)/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(22): Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(8192, ‘Return type of …’, ‘/usr/www/users/…’, 50)

#1 /usr/www/users/(commented out)/vendor/composer/ClassLoader.php(480): include(‘/usr/www/users/…’)

#2 /usr/www/users/(commented out)/vendor/composer/ClassLoader.php(346): Composer\Autoload\includeFile(‘/usr/www/users/…’)

#3 [internal function]: Composer\Autoload\ClassLoader->loadClass(‘Doctrine\DBAL\D…’)

#4 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(66): class_exists(‘Doctrine\DBAL\D…’)

#5 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection(‘mysql:host=dedi…’, ‘(commented out)’, ‘(commented out)…’, Array)

#6 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection(‘mysql:host=dedi…’, Array, Array)

#7 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect(Array)

#8 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors{closure}()

#9 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(997): call_user_func(Object(Closure))

#10 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1033): Illuminate\Database\Connection->getPdo()

#11 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(426): Illuminate\Database\Connection->getReadPdo()

#12 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(352): Illuminate\Database\Connection->getPdoForSelect(true)

#13 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(685): Illuminate\Database\Connection->Illuminate\Database{closure}(‘select * from i…’, Array)

#14 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback(‘select * from i…’, Array, Object(Closure))

#15 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(360): Illuminate\Database\Connection->run(‘select * from i…’, Array, Object(Closure))

#16 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(44): Illuminate\Database\Connection->select(‘select * from i…’, Array)

#17 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\Schema\MySqlBuilder->hasTable(‘accounts’)

#18 /usr/www/users/(commented out)/app/Exceptions/Handler.php(78): Illuminate\Support\Facades\Facade::__callStatic(‘hasTable’, Array)

#19 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(414): App\Exceptions\Handler->report(Object(ErrorException))

#20 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(112): Illuminate\Foundation\Http\Kernel->reportException(Object(ErrorException))

#21 /usr/www/users/(commented out)/public/index.php(57): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

#22 {main} {“exception”:"[object] (Symfony\Component\ErrorHandler\Error\FatalError(code: 0): During inheritance of PDO: Uncaught ErrorException: Return type of Doctrine\DBAL\Driver\PDOConnection::exec($sql) should either be compatible with PDO::exec(string $statement): int|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /usr/www/users/(commented out)/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:50

Stack trace:

#0 /usr/www/users/(commented out)/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(22): Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(8192, ‘Return type of …’, ‘/usr/www/users/…’, 50)

#1 /usr/www/users/(commented out)/vendor/composer/ClassLoader.php(480): include(‘/usr/www/users/…’)

#2 /usr/www/users/(commented out)/vendor/composer/ClassLoader.php(346): Composer\Autoload\includeFile(‘/usr/www/users/…’)

#3 [internal function]: Composer\Autoload\ClassLoader->loadClass(‘Doctrine\DBAL\D…’)

#4 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(66): class_exists(‘Doctrine\DBAL\D…’)

#5 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection(‘mysql:host=dedi…’, ‘(commented out)’, ‘(commented out)…’, Array)

#6 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection(‘mysql:host=dedi…’, Array, Array)

#7 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect(Array)

#8 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors{closure}()

#9 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(997): call_user_func(Object(Closure))

#10 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1033): Illuminate\Database\Connection->getPdo()

#11 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(426): Illuminate\Database\Connection->getReadPdo()

#12 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(352): Illuminate\Database\Connection->getPdoForSelect(true)

#13 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(685): Illuminate\Database\Connection->Illuminate\Database{closure}(‘select * from i…’, Array)

#14 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback(‘select * from i…’, Array, Object(Closure))

#15 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Connection.php(360): Illuminate\Database\Connection->run(‘select * from i…’, Array, Object(Closure))

#16 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(44): Illuminate\Database\Connection->select(‘select * from i…’, Array)

#17 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\Schema\MySqlBuilder->hasTable(‘accounts’)

#18 /usr/www/users/(commented out)/app/Exceptions/Handler.php(78): Illuminate\Support\Facades\Facade::__callStatic(‘hasTable’, Array)

#19 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(414): App\Exceptions\Handler->report(Object(ErrorException))

#20 /usr/www/users/(commented out)/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(112): Illuminate\Foundation\Http\Kernel->reportException(Object(ErrorException))

#21 /usr/www/users/(commented out)/public/index.php(57): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))

#22 {main} at /usr/www/users/(commented out)/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:22)

[stacktrace]

#0 {main}

"}

PS: How can I get the pdf invoices via bulk processing? At present the reports and database give the report in CSV/Excel. I would really like to have the invoices in pdfs like without having to download each and every one manually :slight_smile:

@david any thoughts on the error?

You can use the bulk download action.

If you log into the client portal, you can batch download the PDFs from there in groups of 100 per client.

But currently there is no PDF export functionality.

1 Like