Query Error: Table farcry.dmfile doesn't exist

[sli...@gmail.com]

Hi guys,

Im new to farcry, and I'm just checking it out on my own. I got this
error when I tried to upload an image to a news piece. Upon inspecting
my database, i noticed that the table's name is actually dmFile
instead of dmfile. In the database it is camel cased, but not in the
sql that executes this query. I changed the name of the table
accordingly, but got the same error with table dmFlash. Anyone have
any thoughts on this?

BTW, Im running farcry version 5-0-0.

[AJ Mercer]

what database server are you using?

--

AJ Mercer
Web Log: http://webonix.net

[sli...@gmail.com]

running apache2 / jrun 4 / coldfusion 8 / mysql on ubuntu

On Jul 12, 6:35 pm, "AJ Mercer" <ajmer...@gmail.com> wrote:
> what database server are you using?
>

> On Sun, Jul 13, 2008 at 4:29 AM, slim...@gmail.com <slim...@gmail.com>

[AJ Mercer]

I have farcry409 with mySQL in windows
and all my table names have been created all lower case.

Are there many tables with mixed case?

I would change the database naming, and not the code

You can log bugs here
http://bugs.farcrycms.org

[sli...@gmail.com]

Yeah, all of the tables are camelCased. I started a new bug in the
tracker.
http://bugs.farcrycms.org/browse/FCI-38

I'm pretty sure there were many more parts of the app that I went
through that didn't throw any errors. Just that part. So maybe the app
was refactored in 5.0 to camelCase all the db names but not all the
sql was updated?

On Jul 13, 12:49 am, "AJ Mercer" <ajmer...@gmail.com> wrote:
> I have farcry409 with mySQL in windows
> and all my table names have been created all lower case.
>
> Are there many tables with mixed case?
>
> I would change the database naming, and not the code
>

> You can log bugs herehttp://bugs.farcrycms.org
>
> On Sun, Jul 13, 2008 at 1:32 PM, slim...@gmail.com <slim...@gmail.com>

[Matthew Williams]

I've found the condition that leads to this back in FarCry 3.0.

1) You run MySQL on top of a linux OS, and using a case sensitive
2) You import the schema/tables vs creating them through the installer.

What I saw when this happened is that tables are named after the objects
that create them. Eg, dmFile.cfc, dmCron.cfc, etc translates to dmFile,
dmCron when the tables are created. This becomes a problem when the
code calls dmfile instead of dmFile. I can't recall if the DB gateway
is lower casing all the calls? It may be, I've not had any reason to
poke about in that part of the code.

Matthew Williams
Geodesic GraFX

[Joel Cass]

Check the ftJoin attribute in the default dmEvent and dmNews objects in
the cms plugin... Potentially the cause could be right there.

[modius]

On Jul 14, 2:16 pm, Matthew Williams <webmas...@geodesicgrafx.com>
wrote:

Any reason you can't simply set mySQL to be case insensitive for table
names?
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

We'll try and track the bug but its not something that is likely to
get fixed quickly without specific references to code lines. We don't
maintain a unix based mysql testbed in house.

-- geoff
http://www.daemon.com.au/