NPE's or Table 'kalendar.tblKalendarCategories' doesn't exist

[SarahM]

Hi all,

I've successfully installed Kalendar on my local machine installed and
can use all functions (CF8 Developer Edition). I've now uploaded to
the live server (also CF8). I've created the MySql database and can
view both tables and their structure via phpMyAdmin. I've changed the
paths in both application files, comparable to what worked on my local
machine.

Whenever I try to view the calendar, I first get a Null Pointer
Error. If I refresh, I then get:

Table 'kalendar.tblKalendarCategories' doesn't exist

The error occurred in D:\Inetpub\springfieldhousing\calendar\common\cfc
\kalendar.cfc: line 530


I've read some blog posts, mostly on coldfusionJedi, I think, about
NPE's and the combination of CF8 and MySql, so I'm guessing that might
be the problem?

The host is CrystalTech, in case that's helpful to anybody
experiencing similar issues.

The client has seen this on my local machine, so I really need to get
it working, but 2 days in, I've failed. Can anybody help me out?

Thanks,
Sarah

[SarahM]

Figured it out...how I missed this for the last two days, I have no
clue.

In the MYSQL_KALENDAR.txt file, the two table names are all lower
case. The queries are looking for mixed-case table names (i.e.
tblKalendar instead of tblkalendar). Even after I made that change,
when I used the *import* function to create the tables, they were
created with all lower case names. However, when I copied and pasted
the sql, complete with mixed-case names, into a sql window and ran
*that*, the tables were created with the proper mixed-case names. And
voila! No more 'table doesn't exist' errors. (BTW, the table fields
were always properly formatted with mixed-case names.)

I'm assuming this all has to do with a case-sensitive setting at the
server level (not my niche).

I did also add the blank onRequest code to application.cfc just as a
precautionary measure...
http://www.coldfusionjedi.com/index.cfm/2007/9/28/ColdFusion-8-MySQL-HostMySite-and-NPEs

Hope this helps someone some day; to everyone else, thanks for
reading.

Sarah

[TJ]

Hi Sara

Thanks for notifying me of the fix. I will note this for the next
release and ensure case sensitivity issues are resolved.