1
0
-1
2 answers
- 10-1
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.
Add your comment... - 10-1
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
Add your comment...
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.