AJ, nope there was a H2 JAR that basically we couldn't get anything to deploy with... Randomly SQL statements would just time out. It was very odd :)
On Friday, March 8, 2013 3:37:17 PM UTC+11, AJ Mercer wrote: > > 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] > <javascript:>>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] <javascript:> >> To unsubscribe, email: [email protected] <javascript:> >> 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] <javascript:>. >> 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.
