Hi all,
I'm hoping someone on this forum can help me. I use hibernate with java
to access mysql. We are trying to upgrade from 4.1.15 non-inndb, to
5.0.18 with innodb. Hibernate makes a 'create tables' script. The
script installs, but the queries that hibernate creates now fails.
These same queries worked fine with 4.1 .
Since this is a hard problem to solve on a forum, if any kind fellow
would like to, you could install the db from this zip:
http://www.braziloutsource.com/random/hwtf.zip
The query failing is this:
select count(activity0_.activity_id) as col_0_0_ from activity
activity0_, appointment_scheduler appointmen1_ inner join
activity_velox_info activityve2_ on
activity0_.act_velox_info_id=activityve2_.act_velo x_info_id inner join
activity_schedule activitysc3_ on
activity0_.act_sch_id=activitysc3_.act_sch_id inner join micro_area
microarea4_ on activityve2_.micro_area_id=microarea4_.micro_area_ id
inner join micro_area_scheduler microareas5_ on
appointmen1_.appsch_id=microareas5_.appsch_id inner join micro_area
microarea6_ on microareas5_.micro_area_id=microarea6_.micro_area_ id,
periods_of_day periodsofd7_ where (appointmen1_.appsch_id=1
)AND(activity0_.state<>'TRIAGE' )AND((activity0_.type='INSTALL'
)OR(activity0_.TYPE='SERVICE'
))AND(activity0_.promise_date>='2006-2-10'
)AND(activity0_.promise_date<'2006-2-11'
)AND(periodsofd7_.code='FIRST_HOUR' and
activityve2_.period_of_day_id=periodsofd7_.period_ of_day_id)AND(microarea4_.micro_area_id
IN(microarea6_.micro_area_id))AND(activitysc3_.sch eduler_id=appointmen1_.appsch_id
)
Unknown column 'activity0_.ACT_VELOX_INFO_ID' in 'on clause'
So its complaining on ACT_VELOX_INFO_ID, yet I can do a simple query:
select act_velox_info_id from activity;
+-------------------+
| act_velox_info_id |
+-------------------+
| 1 |
| 2 |
I'm very stuck. Any help highly appreciated.
iksrazal