by Variance InfoTech Pvt Ltd

Configure specific fields from specific modules and set formats like character limit, numeric, or alphanumeric and more for certain fields using Format Builder.

Cancel at any time!
Free Trial

#3151 - Fatal error

Closed Bug? created by satinalma 2 years ago

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?

  1. varianceinfotech member avatar

    Variance InfoTech Pvt Ltd Provider

    2 years ago

    Hello,

    When you have got this error?

    During addon installation/adding License Key/Using Format Builder addon?

    Regards, Variance Infotech PVT LTD

  2. varianceinfotech member avatar

    Variance InfoTech Pvt Ltd Provider

    2 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 ( id char(36) NOT NULL, name varchar(255) DEFAULT NULL, date_entered datetime DEFAULT NULL, date_modified datetime DEFAULT NULL, modified_user_id char(36) DEFAULT NULL, created_by char(36) DEFAULT NULL, description text, deleted tinyint(1) DEFAULT '0', assigned_user_id char(36) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    Regards, Variance Infotech PVT LTD

    • satinalma member avatar

      satinalma

      2 years ago

      Thank you, I installed latest version. But same fatal error

      ![Screenshot_2.png](https://store.suitecrm.com/assets/img/support/format-builder/f6e75fe844fe6daba5a73a29ebe797ee/Screenshot_3.png "Screenshot_3.png")

    • satinalma member avatar

      satinalma

      2 years ago

      The table was created in DB; Screenshot_3.png

  3. varianceinfotech member avatar

    Variance InfoTech Pvt Ltd Provider

    2 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

  4. varianceinfotech member avatar

    Variance InfoTech Pvt Ltd Provider

    a year ago

    Hello,

    Hope your issue has been resolved.

    Currently We're closing this Case.

    Regards, Variance Infotech PVT LTD

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "Although I had a small problem with install, the support was absolutely top-notch - they responded quickly and got the solution working. The Format Bu..." - catherine

    Read More Reviews