DataTables Error

I’m a paid self-hosted user and the installation is on a WHM/cPanel server. After upgrading from 3.9.2 to 4.0.1 using the Softaculous upgrader I’m no longer able to see any Payments. Clients, Products, Invoices, Quotes, etc all work fine. When I try to change the option in the Status field I get the error:

DataTables warning: table id=DataTables_Table_0 - Ajax error. For more information about this error, please see

In Chrome’s dev console I see:

jquery.js:9664 GET 500 (Internal Server Error) send @ jquery.js:9664 ajax @ jquery.js:9215 H @ jquery.dataTables.js:2483 j @ jquery.dataTables.js:2515 I @ jquery.dataTables.js:1982 P @ jquery.dataTables.js:2101 Ne @ jquery.dataTables.js:7347 (anonymous) @ jquery.dataTables.js:7421 iterator @ jquery.dataTables.js:6827 (anonymous) @ jquery.dataTables.js:7420 (anonymous) @ jquery.dataTables.js:6990 refreshDatatable_payments @ payments:895 (anonymous) @ payments:1168 u @ jquery.js:3148 fireWith @ jquery.js:3260 n @ jquery.js:9314 e @ jquery.js:9718 XMLHttpRequest.send (async) send @ jquery.js:9664 ajax @ jquery.js:9215 ot.(anonymous function) @ jquery.js:9361 (anonymous) @ payments:1167 dispatch @ jquery.js:4670 m.handle @ jquery.js:4338 trigger @ jquery.js:4579 (anonymous) @ jquery.js:5289 each @ jquery.js:384 each @ jquery.js:136 trigger @ jquery.js:5288 @ select2.js:3060 (anonymous) @ select2.js:3131 i.invoke @ select2.js:637 i.trigger @ select2.js:627 r.trigger @ select2.js:5472 (anonymous) @ select2.js:5298 i.invoke @ select2.js:637 i.trigger @ select2.js:631 (anonymous) @ select2.js:1210 dispatch @ jquery.js:4670 m.handle @ jquery.js:4338 jquery.js:9664 GET 404 (Not Found)

Note that my installation is at but the last jquery error seems to be trying to call with no /inv/. Not sure if that’s the cause here.

And in laravel-error.log I see:

[2018-01-10 18:52:14] production.ERROR: ***Illuminate\Database\QueryException*** [42S22] : /home/mydomain/public_html/inv/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 770] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'payments.exchange_rate' in 'field list' (SQL: select payments.public_id, COALESCE(clients.currency_id, accounts.currency_id) currency_id, COALESCE(clients.country_id, accounts.country_id) country_id, payments.transaction_reference, COALESCE(NULLIF(,''), NULLIF(CONCAT(contacts.first_name, ' ', contacts.last_name),''), NULLIF(,'')) client_name, clients.public_id as client_public_id, clients.user_id as client_user_id, payments.amount, CONCAT(payments.payment_date, payments.created_at) as date, payments.payment_date, payments.payment_status_id, payments.payment_type_id, payments.payment_type_id as source, invoices.public_id as invoice_public_id, invoices.user_id as invoice_user_id, invoices.invoice_number, invoices.invoice_number as invoice_name, contacts.first_name, contacts.last_name,, as method, as payment_type, payments.account_gateway_id, payments.deleted_at, payments.is_deleted, payments.user_id, payments.refunded, payments.expiration, payments.last4,, payments.routing_number, payments.bank_name, payments.private_notes, payments.exchange_rate, payments.exchange_currency_id, invoices.is_deleted as invoice_is_deleted, as gateway_name, as gateway_id, as status from payments inner join accounts on = payments.account_id inner join clients on = payments.client_id inner join invoices on = payments.invoice_id inner join contacts on contacts.client_id = inner join payment_statuses on = payments.payment_status_id left join payment_types on = payments.payment_type_id left join account_gateways on = payments.account_gateway_id left join gateways on = account_gateways.gateway_id where payments.account_id = 1 and contacts.is_primary = 1 and contacts.deleted_at is null and invoices.is_deleted = 0 and ( is null or (payments.deleted_at is not null and payments.is_deleted = 0)) and clients.deleted_at is null order by date desc limit 10) {"context":"PHP","user_id":1,"account_id":1,"user_name":"My Name","method":"GET","url":"","previous":"","user_agent":"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.108 Safari/537.36","ip":"MY IP ADDR","count":28,"is_console":"no","is_api":"no","db_server":"mysql"} []

Any help is appreciated.

Try loading

Thanks for the quick response. I should have mentioned, I ran /inv/public/update once and got a blank screen after. If I try to run it now I get a 500 error.

Can you check storage/logs/laravel-error.log for details

Nothing is written to laravel-error.log when I go to /inv/public/update

Can you check your webserver error log

Good catch.

PHP Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 36864 bytes) in /home/mydomain/public_html/inv/vendor/jaybizzle/crawler-detect/src/Fixtures/Crawlers.php on line 21: /usr/local/cpanel/cgi-sys/ea-php70

Increased memory_limit and the reran /inv/public/update. This time it completed and redirected me to the login page for Invoice Ninja and Payments is working now.

Thanks again for your help and quick replies.

Great to hear!