Forum LAMS for Tech-Heads - General Forum: Previewing or Viewing Sequence from moodle

i wonder if someone could shed some light on the following problem... we are currently using version 2.1, but recently there has been a problem with a few sequences, not opening, can't save/preview them from the author either. This is the error message given when trying to open sequence from link in Moodle.

org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select resourceus0_.uid as uid, resourceus0_.user_id as user2_835_, resourceus0_.last_name as last3_835_, resourceus0_.first_name as first4_835_, resourceus0_.login_name as login5_835_, resourceus0_.session_uid as session6_835_, resourceus0_.resource_uid as resource7_835_, resourceus0_.session_finished as session8_835_ from tl_larsrc11_user resourceus0_, tl_larsrc11_session resourcese1_ where resourceus0_.session_uid=resourcese1_.uid and resourceus0_.user_id=? and resourcese1_.session_id=?]; nested exception is java.sql.SQLException: Table 'lams2.tl_larsrc11_user' doesn't exist

the last line suggests that a table that it needs to access doesn't exist, would this be due to an upgrade to the system removing this table, or something else...

would a update to the latest version of lams rectify this at all?

thanks in advance

Posted by Samuel Persse