Yes it does. On Jul 11, 2012, at 6:02 PM, Jasha Joachimsthal wrote:
> 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 >>>> >>>> >> >>
