qcri-social / AIDR

Artificial Intelligence for Digital Response
http://aidr.qcri.org/
GNU Affero General Public License v3.0
98 stars 37 forks source link

Non-existent 'aidr_predict.custom_ui_template' table #13

Open ajgbangug opened 10 years ago

ajgbangug commented 10 years ago

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 commented 9 years ago

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.