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/**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.
