After repairing a few obvious column missing errors, I get this error and
have no idea how to fix the DB for this message:
14:59:43 ERROR (AbstractFaultChainInitiatorObserver:101) - Error occurred
during error handling, give up!
org.apache.cxf.interceptor.Fault:
Internal Exception:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
't1.ORGANIZATION' in 'where clause'
Error Code: 1054
Call: SELECT DISTINCT t1.ROLE FROM MH_USER t0, MH_ROLE t1 WHERE
((t1.ORGANIZATION = t0.ORGANIZATION) AND (t1.USERNAME = t0.USERNAME))
Query: ReportQuery(name="roles" referenceClass=JpaUser sql="SELECT DISTINCT
t1.ROLE FROM MH_USER t0, MH_ROLE t1 WHERE ((t1.ORGANIZATION =
t0.ORGANIZATION) AND (t1.USERNAME = t0.USERNAME))")
at
org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:155)
at
org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:121)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:133)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:82)
On Sat, Dec 17, 2011 at 10:12 AM, Greg Logan <[email protected]> wrote:
> On 12/17/2011 11:28 AM, Christopher Brooks wrote:
> > Hey hank,
> >
> > The autogeneration of ddl does not work reliably. The mysql scripts are
> the most up to date, and there was a resolution on list to reduce our
> coverage just to one script (the mysql one) to help eliminate these issues,
> so the postgres scripts should be removed from future releases. Instead,
> we'll advertise in our release docs any community contributed scripts for
> non mysql dbs.
> >
> > So, I'd try with mysql right now, and autogen off (there were
> significant db naming convention changes in this last rc).
>
> Either something changed and no one told me, or you missed that the
> review is just a patch set :)
>
> Hank, autogen should work fine on an empty DB, but I imagine it might
> complain on a DB with existing tables since some things may have
> changed. The large refactoring Chris is talking about is *not* in rc4.
> For what it's worth, my day-to-day dev environment, as well as the test
> clusters we have available (testadmin.usask.ca and
> testallinone.usask.ca) are all running with ddl-autogen turned on
> against mysql and I haven't seen any issues related to that at all. THe
> ddl scripts are currently known to be broken, so please don't use them
> yet! This is what will be addressed with the DB refactoring (see
> MH-8335 for details).
>
> G
>
_______________________________________________
Matterhorn-users mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn-users
