Dashlet error on Invoice setting

šŸ“¦ Install & Upgrade Help
1

I just upgraded from V881 to V890 and everything is working ok. I do get an error on the home page when I go to settings for Invoices in the Dashlet -

Warning: Undefined array key 3 in /var/www/html/crm/public/legacy/modules/Configurator/LogView.php on line 158

Wed Sep 24 2025 at 06:30:39 [72349][1][FATAL] Query Failed: SELECT
id,
title
FROM accounts
WHERE deleted = 0
ORDER BY title ASC: MySQL error 1054: Unknown column ā€˜titleā€™ in ā€˜SELECTā€™

Not sure where this is coming from. Could this be from V 7?

2

Hello Willie,

Iā€™ve just tested it online:
https://suite8demo.suiteondemand.com/
and it seems to be working fine there.
Do you get any results in the dashlet, or will it stay empty?

SELECT
id,
title
FROM accounts

That sounds like the issue is coming from somewhere else as well.
accounts != invoices.
The name of the account is the ā€œmain fieldā€ - title isnā€™t a field inside the standard set of account fields.

Do you have any code customizations in place?

3

Hi,
This issue typically arises after the upgrade because the Accounts table no longer has a title column in V890. The system is still trying to call it, which is why youā€™re seeing the MySQL error. The ā€œUndefined array keyā€ warning is just tied to that missing field.
Try running Quick Repair & Rebuild , then Sync Database with vardefs from Admin ā†’ Repair. That often clears it up. If you have any custom dashlets or old packages that reference the title, youā€™ll need to update those as well.

1 Like