search

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

aidr-tagger-api looking for non-existent userID column in document_nominal_label #15

Open ajgbangug opened 9 years ago

ajgbangug commented 9 years ago

I run into this exception whenever I check the Human tagged items. Please see exception below.

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'dnl.userID' in 'on clause'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
        at com.sun.gjc.spi.jdbc40.PreparedStatementWrapper40.executeQuery(PreparedStatementWrapper40.java:642)
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:80)
        ... 129 more
koushiksinha commented 9 years ago

Hi AJ,

Can you pull the latest tagger-api code? For some reason, the JSON internal parser stopped automatic ignoring of unknown fields. We have fixed this in the latest code in github.

Regards, Koushik

On Thu, Sep 25, 2014 at 2:58 PM, AJ Bangug notifications@github.com wrote:

I run into this exception whenever I check the Human tagged items. Please see exception below.

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'dnl.userID' in 'on clause' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281) at com.sun.gjc.spi.jdbc40.PreparedStatementWrapper40.executeQuery(PreparedStatementWrapper40.java:642) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:80) ... 129 more

— Reply to this email directly or view it on GitHub https://github.com/qcri-social/AIDR/issues/15.

ajgbangug commented 9 years ago

Ok got it! Is it ok if I just get it straight from master? Or should I use the v1.2.0 tag?

koushiksinha commented 9 years ago

Master should be fine :).

Regards, Koushik

On Thu, Sep 25, 2014 at 3:13 PM, AJ Bangug notifications@github.com wrote:

Ok got it! Is it ok if I just get it straight from master? Or should I use the v1.2.0 tag?

— Reply to this email directly or view it on GitHub https://github.com/qcri-social/AIDR/issues/15#issuecomment-56809719.

ajgbangug commented 9 years ago

Hi just tried out the latest build from master and we're still experiencing the error :(