Justin, wasn't the H2 issue on Railo because Railo 4 uses an newer verion on H2 and it was not backwards compatible - that is, the H2 db created on Railo 3 stopped working when Railo was updated.
As I understand it, the current Farcry Express runs fine with H2 On 8 March 2013 12:31, Justin Carter <[email protected]> wrote: > We recently had an issue with the H2 JAR that was included in Railo 4.0, > which has now been fixed. I wonder if the H2 JAR in OpenBD was the same > broken version... > > Installing on MySQL in general should be fine though, so it's odd that > you're having problems at that level. Do you have case sensitivity turned > on for that database, and can you turn it off? > > cheers, > Justin > > > On Friday, March 8, 2013 2:35:55 PM UTC+11, Marcus F wrote: >> >> Nope, it hangs at the same place. >> General SQL Error; Database reported: Table 'farcrydb.refobjects' doesn't >> exist >> General SQL Error; Database reported: Table 'farcrydb.rulecarousel' >> doesn't exist >> General SQL Error; Database reported: Table >> 'farcrydb.rulecarousel_**acarouselitems' >> doesn't exist >> General SQL Error; Database reported: Table 'farcrydb.rulecarousel' >> doesn't exist >> *[21:33:26] Application Exception in : C:/CFML >> Sites/FarCryFandango/farcry/core/packages/dbgateways/MySQLGateway.cfc >> Line: 44 >> >> Seems to have something to do with creating the tables.. >> * >> On Thursday, March 7, 2013 9:31:52 PM UTC-6, Marcus F wrote: >>> >>> I didn't put sa as the username. >>> The DB isn't open anywhere else, it runs only when OpenBD Desktop runs >>> this project. >>> >>> I'm trying a MySQL DB right now, let's see if that helps.. >>> >>> On Thursday, March 7, 2013 9:26:27 PM UTC-6, AJ Mercer wrote: >>>> >>>> With your H2 db - did you put 'sa' as the user name? >>>> (assuming it works the same way Railo does) >>>> >>>> Is the database open anywhere else? >>>> >>>> >>>> On 8 March 2013 11:15, Marcus F <[email protected]> wrote: >>>> >>>>> I turned on extra debugging and have some more info: >>>>> I'm using H2, verified the datasource works. >>>>> I chose H2 in the installer. >>>>> Here are the issues I get at the moment. >>>>> --- >>>>> * >>>>> Exceptions >>>>> * >>>>> *[21:11:29] Database Exception in : C:/CFML >>>>> Sites/FarCryFandango/farcry/core/webtop/install/components/install.cfc >>>>> Line: 581* >>>>> >>>>> General SQL Error; Database reported: Table "REFOBJECTS" not found; >>>>> SQL statement: SELECT count(objectId) AS theCount FROM refObjects >>>>> [42102-128] >>>>> *[21:11:31] Database Exception in : C:/CFML >>>>> Sites/FarCryFandango/farcry/core/packages/dbgateways/BaseGateway.cfc >>>>> Line: 921* >>>>> >>>>> General SQL Error; Database reported: Table "RULECAROUSEL" not found; >>>>> SQL statement: SELECT count(*) FROM ruleCarousel [42102-128] >>>>> *[21:11:31] Database Exception in : C:/CFML >>>>> Sites/FarCryFandango/farcry/core/packages/dbgateways/BaseGateway.cfc >>>>> Line: 921* >>>>> >>>>> General SQL Error; Database reported: Table >>>>> "RULECAROUSEL_ACAROUSELITEMS" not found; SQL statement: SELECT count(*) >>>>> FROM ruleCarousel_aCarouselItems [42102-128] >>>>> *[21:11:31] Database Exception in : C:/CFML >>>>> Sites/FarCryFandango/farcry/core/packages/dbgateways/BaseGateway.cfc >>>>> Line: 921* >>>>> >>>>> General SQL Error; Database reported: Table "RULECAROUSEL" not found; >>>>> SQL statement: SELECT count(*) FROM ruleCarousel [42102-128] >>>>> *[21:11:31] Application Exception in : C:/CFML >>>>> Sites/FarCryFandango/farcry/core/packages/dbgateways/MySQLGateway.cfc >>>>> Line: 44* >>>>> --- >>>>> >>>>> >>>>> On Thursday, March 7, 2013 9:10:36 PM UTC-6, AJ Mercer wrote: >>>>> >>>>>> What version of MY SQL are you running? >>>>>> are you able to do a test script with cfquery to verify the db >>>>>> connection is ok? >>>>>> >>>>>> Can you see if anything has been created in the database? >>>>>> >>>>>> >>>>>> I wonder if not being able to create a directory is a permission >>>>>> issue?? >>>>>> >>>>>> >>>>>> >>>>>> On 8 March 2013 10:33, Marcus F <[email protected]> wrote: >>>>>> >>>>>>> I figured I'd have a look at the FarCry CMS, so I started a blank >>>>>>> project and downloaded the FarCry installation files. >>>>>>> I'm running OpenBD Desktop 2.0.2 on my dev box (Windows 7). >>>>>>> >>>>>>> I got one error as it couldn't create the "projects" folder but >>>>>>> passed that point after I manually created it. >>>>>>> >>>>>>> Now it hangs on "Creating rule and container tables", it seems >>>>>>> something going on with MySQLGateway.cfc >>>>>>> >>>>>>> Anyone gotten it to work with OpenBD, or feel like lending me a hand? >>>>>>> >>>>>>> -- >>>>>>> You received this message cos you are subscribed to "farcry-dev" >>>>>>> Google group. >>>>>>> To post, email: [email protected] >>>>>>> To unsubscribe, email: farcry-dev+...@**googlegroups.**com >>>>>>> >>>>>>> For more options: >>>>>>> http://groups.google.com/**group**/farcry-dev<http://groups.google.com/group/farcry-dev> >>>>>>> ------------------------------****-- >>>>>>> Follow us on Twitter: http://twitter.com/farcry >>>>>>> --- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "farcry-dev" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to farcry-dev+...@**googlegroups.**com. >>>>>>> >>>>>>> For more options, visit >>>>>>> https://groups.google.com/**grou**ps/opt_out<https://groups.google.com/groups/opt_out> >>>>>>> . >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> >>>>>> *AJ Mercer* >>>>>> <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org >>>>>> community="Open" /> <http://webonix.org> >>>>>> http://twitter.com/webonix >>>>>> Railo Community >>>>>> Manager<http://www.getrailo.org/index.cfm/community/team/> >>>>>> >>>>> -- >>>>> You received this message cos you are subscribed to "farcry-dev" >>>>> Google group. >>>>> To post, email: [email protected] >>>>> To unsubscribe, email: farcry-dev+...@googlegroups.**com >>>>> For more options: >>>>> http://groups.google.com/**group/farcry-dev<http://groups.google.com/group/farcry-dev> >>>>> ------------------------------**-- >>>>> Follow us on Twitter: http://twitter.com/farcry >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "farcry-dev" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to farcry-dev+...@googlegroups.**com. >>>>> For more options, visit >>>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>>>> . >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> >>>> *AJ Mercer* >>>> <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org >>>> community="Open" /> <http://webonix.org> >>>> http://twitter.com/webonix >>>> Railo Community Manager<http://www.getrailo.org/index.cfm/community/team/> >>>> >>> -- > You received this message cos you are subscribed to "farcry-dev" Google > group. > To post, email: [email protected] > To unsubscribe, email: [email protected] > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry > --- > You received this message because you are subscribed to the Google Groups > "farcry-dev" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- *AJ Mercer* <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org community="Open" /> <http://webonix.org> http://twitter.com/webonix Railo Community Manager <http://www.getrailo.org/index.cfm/community/team/> -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry --- You received this message because you are subscribed to the Google Groups "farcry-dev" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
