org.openmrs.api.db.DAOException: Error while running sql: CREATE TABLE IF NOT EXISTS `xforms_xform` ( `form_id` int(11) NOT NULL, `xform_xml` longtext, `layout_xml` longtext, `creator` int(11) NOT NULL default '0', `date_created` datetime NOT NULL default '0000-00-00 00:00:00', `changed_by` int(11) default NULL, `date_changed` datetime default NULL, PRIMARY KEY (`form_id`), KEY `user_who_created_xform` (`creator`), KEY `form_with_which_xform_is_related` (`form_id`), CONSTRAINT `user_who_created_xform` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), CONSTRAINT `user_who_last_changed_xform` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 . Message: Unknown data type: "USER_WHO_CREATED_XFORM"; SQL statement: CREATE TABLE IF NOT EXISTS `xforms_xform` ( `form_id` int(11) NOT NULL, `xform_xml` longtext, `layout_xml` longtext, `creator` int(11) NOT NULL default '0', `date_created` datetime NOT NULL default '0000-00-00 00:00:00', `changed_by` int(11) default NULL, `date_changed` datetime default NULL, PRIMARY KEY (`form_id`), KEY `user_who_created_xform` (`creator`), KEY `form_with_which_xform_is_related` (`form_id`), CONSTRAINT `user_who_created_xform` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), CONSTRAINT `user_who_last_changed_xform` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [50004-135]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via JIRA by Jon Skeet, 1 year ago
Error while running sql: CREATE TABLE IF NOT EXISTS `xforms_xform` ( `form_id` int(11) NOT NULL, `xform_xml` longtext, `layout_xml` longtext, `creator` int(11) NOT NULL default '0', `date_created` datetime NOT NULL default
via JIRA by Jon Skeet, 1 year ago
Error while running sql: CREATE TABLE IF NOT EXISTS `xforms_xform` ( `form_id` int(11) NOT NULL, `xform_xml` longtext, `layout_xml` longtext, `creator` int(11) NOT NULL default '0', `date_created` datetime NOT NULL default
org.h2.jdbc.JdbcSQLException: Unknown data type: "USER_WHO_CREATED_XFORM"; SQL statement: CREATE TABLE IF NOT EXISTS `xforms_xform` ( `form_id` int(11) NOT NULL, `xform_xml` longtext, `layout_xml` longtext, `creator` int(11) NOT NULL default '0', `date_created` datetime NOT NULL default '0000-00-00 00:00:00', `changed_by` int(11) default NULL, `date_changed` datetime default NULL, PRIMARY KEY (`form_id`), KEY `user_who_created_xform` (`creator`), KEY `form_with_which_xform_is_related` (`form_id`), CONSTRAINT `user_who_created_xform` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`), CONSTRAINT `user_who_last_changed_xform` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [50004-135]

Users with the same issue

27 times, 2 days ago
6 times, 3 days ago
22 times, 1 month ago
2 times, 1 month ago
Once, 2 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.