Configure specific fields from specific modules and set formats like character limit, numeric, or alphanumeric and more for certain fields using Format Builder.
#3151 - Fatal error
When i check suitecrm log, there is an error which is
Thu Oct 15 08:35:45 2020 [10473][1][FATAL] Mysqli_query failed. Thu Oct 15 08:35:45 2020 [10473][1][FATAL] Query Failed: SELECT b.id FROM VIFormatBuilderLicenseAddon b LEFT JOIN aod_indexevent ie ON (ie.record_id = b.id AND ie.record_module = 'VIFormatBuilderLicenseAddon') WHERE b.deleted = 0 AND (ie.id IS NULL OR ie.date_modified < b.date_modified) ORDER BY b.date_modified ASC LIMIT 0,500: MySQL error 1146: Table 'crm.VIFormatBuilderLicenseAddon' doesn't exist
VIFormatBuilderLicenseAddon tabke doesn't exist?
-
"works well, does what it says it does, a few issues upon upgrades that had to be fixed manually." - Michael G.
Read More Reviews
3 years ago
Hello,
When you have got this error?
During addon installation/adding License Key/Using Format Builder addon?
Regards, Variance Infotech PVT LTD
3 years ago
When i repair. from settings.
3 years ago
Every 13 minutes :(
3 years ago
Hello,
I think you didn't installed latest version of our addon. Latest Version is VIFormatBuilder-4.0-Version7.11.zip for SuiteCRM 7.11 Version which is covers your issue.
If you have old version of our Addon then you can run below query in your Database and it'll create viformatbuilderlicenseaddon Table .
CREATE TABLE
viformatbuilderlicenseaddon(idchar(36) NOT NULL,namevarchar(255) DEFAULT NULL,date_entereddatetime DEFAULT NULL,date_modifieddatetime DEFAULT NULL,modified_user_idchar(36) DEFAULT NULL,created_bychar(36) DEFAULT NULL,descriptiontext,deletedtinyint(1) DEFAULT '0',assigned_user_idchar(36) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;Regards, Variance Infotech PVT LTD
3 years ago
Thank you, I installed latest version. But same fatal error
3 years ago
The table was created in DB;
3 years ago
Hello,
is it possible to share your CRM Credentials, FTP Details and Database Access if you don't mind?
If yes then please share us on "techsupport@varianceinfotech.com" and you will get quick solution.
We have checked on our server and we didn't faced this problem.
Regards, Variance Infotech PVT LTD
2 years ago
Hello,
Hope your issue has been resolved.
Currently We're closing this Case.
Regards, Variance Infotech PVT LTD