joget forms not creating tables

Confluence User - 12 Jan, 2017

I've imported an older system from v4 to v5 and has not modified it much since the upgrade. Recently the user requested a new form and I realized that the entire v5 system of mine is not creating tables from forms automatically. I had to manually create a blank table directly within the mysql database with just an ID and then it will fill in the columns when i save the form.

 

 

forms

5


12 Jan, 2017
confluenceUser
confluenceUser

Hi Yee Tong Loh

Please download any apps from https://marketplace.joget.org and import and run them to check if the database tables are created.

12 Jan, 2017
confluenceUser
confluenceUser

Failed to work.

got this error message

 

Error! Please check your selected file and try it again.
Failed to create form data table mcrm_contact
13 Jan, 2017
confluenceUser
confluenceUser

Hi, from your description it would seem like your configured database user in Datasource & Profile does not have sufficient privileges to create tables in your database.

 

13 Jan, 2017
confluenceUser
confluenceUser

Hi,

As Anders pointed out, could you try giving permissions to your database user and see if that works?

Also, for starters, do you mind sharing your Joget logs for the errors during the app import? There could be something interesting there.

Thanks!

 

16 Jan, 2017
confluenceUser
confluenceUser

hello,

you can try run app, and try input & save data in form. 

should be table is will be auto created from system.

best regards, thanks

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print