Hi all
I had an application working good in version 4.1.4 an mySql and now when I have upgraded to Servoy 5 gives me the following error:
2009-11-30 15:34 AWT-EventQueue-0 ERROR com.servoy.j2db.util.Debug select tarifas838.tarifa_id from tarifas tarifas838 inner join alojamientos alojamientos842 on tarifas838.alojamiento_id=alojamientos842.alojamiento_id where comisionagencia769.agencia_id = ? and tarifas838.tarifa_id in (?, ?, ?, ?, ?, ?, ?, ?, ?) order by alojamientos842.chk_bajoPeticion asc parameters: [41 ,type: java.lang.Integer, 186 ,type: java.lang.Integer, 185 ,type: java.lang.Integer, 360 ,type: java.lang.Integer, 189 ,type: java.lang.Integer, 187 ,type: java.lang.Integer, 188 ,type: java.lang.Integer, 374 ,type: java.lang.Integer, 398 ,type: java.lang.Integer, 401 ,type: java.lang.Integer]
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘comisionagencia769.agencia_id’ in ‘where clause’
This sql is done by Servoy.
the name of the table is “comision_agencia”. I don’t know if is necesary to changes all the name of the tables with “_”
Thanks in advance