Non-existent 'aidr_predict.custom_ui_template' table #13

Open
ajgbangug opened this Issue Sep 9, 2014 · 1 comment

Comments

Projects
None yet
2 participants
@ajgbangug

I was trying out the new 1.1.1 version of AIDR and I noticed that I was encountering the the following exception when viewing the classifier detaills.

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'aidr_predict.custom_ui_template' doesn't exist

How can I resolve this exception and is this related to why I'm not seeing the pybossa url for the classifier?

screen shot 2014-09-09 at 8 05 47 pm

@jmgtan

This comment has been minimized.

Show comment
Hide comment
@jmgtan

jmgtan May 1, 2015

Just tried deploying this today, encountered the following:

2015-05-01T06:20:34.485+0000] [glassfish 4.1] [ERROR] [] [org.hibernate.tool.hbm2ddl.SchemaUpdate] [tid: _ThreadID=45 _ThreadName=admin-listener(5)] [timeMillis: 1430461234485] [levelValue: 1000] [[
  HHH000388: Unsuccessful: create table aidr_predict.custom_ui_template (customUITemplateID bigint not null auto_increment, crisisID bigint not null, isActive bit not null, nominalAttributeID bigint, status integer, templateType integer not null, templateValue varchar(65535) not null, updated datetime not null, primary key (customUITemplateID))]]

[2015-05-01T06:20:34.485+0000] [glassfish 4.1] [ERROR] [] [org.hibernate.tool.hbm2ddl.SchemaUpdate] [tid: _ThreadID=45 _ThreadName=admin-listener(5)] [timeMillis: 1430461234485] [levelValue: 1000] [[
  Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]]

Might be related to your issue why the table is not being created.

jmgtan commented May 1, 2015

Just tried deploying this today, encountered the following:

2015-05-01T06:20:34.485+0000] [glassfish 4.1] [ERROR] [] [org.hibernate.tool.hbm2ddl.SchemaUpdate] [tid: _ThreadID=45 _ThreadName=admin-listener(5)] [timeMillis: 1430461234485] [levelValue: 1000] [[
  HHH000388: Unsuccessful: create table aidr_predict.custom_ui_template (customUITemplateID bigint not null auto_increment, crisisID bigint not null, isActive bit not null, nominalAttributeID bigint, status integer, templateType integer not null, templateValue varchar(65535) not null, updated datetime not null, primary key (customUITemplateID))]]

[2015-05-01T06:20:34.485+0000] [glassfish 4.1] [ERROR] [] [org.hibernate.tool.hbm2ddl.SchemaUpdate] [tid: _ThreadID=45 _ThreadName=admin-listener(5)] [timeMillis: 1430461234485] [levelValue: 1000] [[
  Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]]

Might be related to your issue why the table is not being created.

kushalkantgoyal pushed a commit that referenced this issue Jul 25, 2016

Kushal Kant Goyal
Merge pull request #13 from Qatar-Computing-Research-Institute/dev
Minor fix merging dev to staging (2.1.2)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment