Table 'jwdb.app_fd_<MY_TABLE>' doesn't exist error

 
1
0
-1

Hi,

I have just set up a new Joget environment on my a machine.

I created a very simple form with 2 text fields and then used the "app generator" to make the rest of the pages that I needed to work with the form.

 

When I go into the list page I get the error 

Table 'jwdb.app_fd_<MY_TABLE>' doesn't exist error

 

Note <MY_TABLE> is the name of the table I set when setting up the form. I have tried this a few times.  

Is it possible I have done something wrong with the setup ? 

    CommentAdd your comment...

    7 answers

    1.  
      1
      0
      -1

      I was got a same issue. but I finally found the problem and soved it.

      If  you want to install joget on mysql or mariadb environment all by yourself,

      you must change database's default character set utf8mb4 to utf8.

      problem is joget's id column property. It has varchar(255) and primary key.

      mysql innodb cannot make index because of column size. If joget developer see this, please change default size to 100 or smaller. In the log, the error message has only "Table 'jwdb.app_fd_<MY_TABLE>' doesn't exist error".

      Sorry about my poor English. Thanks.

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Does anybody else have this issue with v6? I'm running a fresh install with the docker image and a MySQL (5.5, hopefully not for much longer) database.

          CommentAdd your comment...
        1.  
          1
          0
          -1

          Hey,

          I have checked the DB there is no issue with creating tables with that account. It's almost as if the tool isn't creating the tables when I finish with the form.  

          The tables absolutely don't exist. 

            CommentAdd your comment...
          1.  
            1
            0
            -1

            Hi George Gaynor

            There could be a 'problem' with your database. Try using SQLyog or similar SQL utility to query the db tables.

            The following might have some answers that related to your issue:

             

              CommentAdd your comment...
            1.  
              1
              0
              -1

              Below is my log from yesterday and a screenshot of the error. 

              joget.log.20171025 

               

              1. Anders

                That's very strange, the log does not indicate much. What environment are you running on, and how did you install Joget? The installation should be very straightforward if you follow https://dev.joget.org/community/display/KBv5/Installation

              CommentAdd your comment...
            2.  
              1
              0
              -1

              Hi George Gaynor

              Can you provide the table name you keyed into the form or a screenshot of the form properties and the error message screen.

              Thank you.

               

                CommentAdd your comment...
              1.  
                1
                0
                -1

                Hi, the form database tables should have been automatically created as required. It's probable that there is some db configuration or permission problem. What do the logs or console messages say? They should contain the actual error messages that will pinpoint the problem.

                  CommentAdd your comment...