On 11 July 2012 23:42, Raminderjeet Singh <[email protected]> wrote:
> +1 for having some JPA abstraction but that need some work and a resource. > Right now we can make sure we show such errors to the user. I am familiar > with Rave code so i knew where to debug but that may not be true for lot of > users. I am going to change the log message type for this one and see if i > can make the message obvious enough. > > I am able to solve my problem by add lower_case_table_names=1 to mysql > my.cnf file. > Does that also work for the portal preference values? > > Thanks > Raminder > > > On Jul 11, 2012, at 5:14 PM, Jasha Joachimsthal wrote: > > > On 11 July 2012 23:05, Raminderjeet Singh <[email protected]> > wrote: > > > >> I am able to find the problem. Looks like Rave is creating all the > tables > >> with lower case and when we query(SELECT * FROM WIDGET) to see if table > >> already to insert the data its returning false. Log message is of debug > >> level so i was not seeing any error. I changed the log level to debug to > >> notice this. > >> > >> I tried to change this query to lowercase but then problem is coming at > >> separate level now( Caused by: > >> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > >> 'rave.JPAPORTALPREFERENCE_VALUES' doesn't exist). Does anyone have > idea to > >> make mysql db case insensitive? > >> > > > > The question in this case should not be "how to fix it in MySQL", but > "how > > to make it work in any DB". Again we run into the issue of the > > initialization with pure SQL queries. I've installed it before in MySQL, > > PostgreSQL and Oracle; they all had their own issues when dealing with > the > > initial data. > > We should really move the essential part of the initialization (page > > layouts, page types, authorities etc) to some abstraction like JPA and > > preferably also other parts of the demo "content" like users and gadget > > definitions. > > > > Another one that will fail on case sensitivity are the portal preference > > values (already created an issue for this last month). > > > > > >> I am thinking of this log message level to info or warning. > >> > >> Thanks > >> Raminder > >> > >> > >> On Jul 11, 2012, at 1:04 PM, Chris Geer wrote: > >> > >>> On Wed, Jul 11, 2012 at 9:58 AM, Raminderjeet Singh < > >>> [email protected]> wrote: > >>> > >>>> Hi All, > >>>> > >>>> Is anyone running Rave using MySQL? After following the instructions > on > >>>> website, rave is able to create the tables fine but its not uploading > >> the > >>>> initial data. Did anyone else faced this in past? Suggestions to > >> populate > >>>> the data? > >>>> > >>> > >>> We run Rave on MySQL just fine but we have a custom initial_data script > >> we > >>> use, although the standard one should work. What errors are you > getting? > >>> > >>>> > >>>> Thanks > >>>> Raminder > >> > >> > >
