Update database for new module

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • w452
    Junior Member
    • Jan 2019
    • 4

    Update database for new module

    hello,

    In a new module under development, the table is not created for the entities.

    Base table or view not found

    I see the entities in Administration> Entity Management.

    How to create the new database with the command line?

    Thank you
  • tanya
    Senior Member
    • Jun 2014
    • 4308

    #2
    Hello,
    the new database? or the new table?
    Did you do Rebuild in administration?

    Comment

    • w452
      Junior Member
      • Jan 2019
      • 4

      #3
      the new table

      I tried rebuild and get this error :

      [2019-01-30 20:30:10] Espo.ERROR: Uncaught Exception Error: "Call to undefined method Doctrine\DBAL\Platforms\MariaDb1027Platform::getCl obTypeLength()" \Espo\Core\Utils\Database\DBAL\Schema\MySqlSchemaM anager.php line 212 {"exception":"[object] (Error(code: 0): Call to undefined method Doctrine\\DBAL\\Platforms\\MariaDb1027Platform::ge tClobTypeLength() at \\EspoCRM\\application\\Espo\\Core\\Utils\\Databas e\\DBAL\\Schema\\MySqlSchemaManager.php:212)"} []

      Comment

      • w452
        Junior Member
        • Jan 2019
        • 4

        #4
        Please help on this issue.
        Thanks

        Comment

        • tarasm
          Super Moderator
          • Mar 2014
          • 573

          #5
          What version of MariaDB do you use?
          What customization did you make (created a new field or new entity)?
          Job Offers and Requests

          Comment

          • tarasm
            Super Moderator
            • Mar 2014
            • 573

            #6
            Just tested on MariaDB 10.3.9. All works like a charm.
            Do you have any customizations?
            What is your version of EspoCRM?
            Job Offers and Requests

            Comment

            • w452
              Junior Member
              • Jan 2019
              • 4

              #7
              Hello,

              I don't have any customizations.
              I just follow this post : https://www.espocrm.com/blog/how-to-...custom-entity/


              PHP Version 7.2.14
              MariaDB 5.5.5-10.3
              EspoCRM 5.5.6

              Thank you

              Comment

              • tarasm
                Super Moderator
                • Mar 2014
                • 573

                #8
                Try to do the following actions:
                1. Move files from the directory <ESPOCRM_DIRECTORY>/custom/Espo/Custom.
                2. Run rebuild (Administration > Rebuild or command line: php rebuild.php).
                3. Refresh browser page with EspoCRM.
                4. Try to create new fields through Entity Manager.
                Job Offers and Requests

                Comment

                • olof
                  Senior Member
                  • Jul 2018
                  • 184

                  #9
                  This looks like its the same issue - sorry didn't come up in search because of some whitepace in the issue posting above.

                  After a composer update to add: &quot;league/oauth2-client&quot;: &quot;^2.0&quot;, &quot;microsoft/microsoft-graph&quot;: &quot;1.0.*&quot; to support https://treolabs.com/store/espocrm-outlook-connector-for-outlook-365-and-exchange-online I'm getting: [2019-06-18 12:39:35] Espo.ERROR: Uncaught Exception Error:

                  Comment

                  Working...