sql server database setup

Confluence User - 21 Aug, 2015

Hi,

Question1

The source code was downloaded from : https://github.com/jogetworkflow/jw-community.git (Tried 3.1 & 4.0)

The DB was created using sql downloaded from: http://dev.joget.org/community/download/attachments/5341200/jwdb-mssql.sql?version=4&modificationDate=1359988440000&api=v2

Below errors where thrown when sql script from above mention link are executed, Could you please advise  these errors.

Msg 2716, Level 16, State 1, Line 1
Column, parameter, or variable #4: Cannot specify a column width on data type text.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FK7A835713462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK7A835713462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FKE411D54E462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FKE411D54E462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FK5E9247A6462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK5E9247A6462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FK740A62EC462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK740A62EC462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FK45957822462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK45957822462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FKEE346FE9462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FKEE346FE9462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FK852EA428462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK852EA428462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.

 

sql;server

2


21 Aug, 2015
confluenceUser
confluenceUser

hello, you can import empty database with name jwdb to sql server, you can copy or paste this code in sql server query and try run code.... database can create auto into sql server, and dont forget you set connection database joget workflow in system settings joget workflow....

best regards

21 Aug, 2015
confluenceUser
confluenceUser

Hi,

From the error message "Cannot specify a column width on data type text", it seems like there might be an incompatibility in one of the TEXT columns with your version of SQL Server. There's an updated SQL file in Running on Microsoft SQL Server 2005 which you can try.

Thanks.

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print