Database Query Error when adding an event

[Mike]

I tried to add this to an existing thread but for some reason it would
not allow me to respond. so I will start a new topic on this same
subject

Original topic:

http://groups.google.com/group/cfkalendar/browse_thread/thread/7336ab3fc9062e9e#

++++++++++++++++++

This is the same error I receive.

http://www.meadowbrookhills.net/kalendar/saveError.gif

CFIDE is mapped.

CF MX-7

Kalendar is live online if you wish to see the full error that is
thrown

http://www.meadowbrookhills.net/kalendar/admin/kalendar/

Categories add, edit, delete, fine. Events do not.

only paths in admin ap.cfc file have been edited.

application.kalendarURLPath = "/kalendar/";
application.CFCPath = "kalendar.common.cfc.";
application.javascriptPath = "/kalendar/common/scripts/";
request.kalendarAdminPath = "/kalendar/admin";

The the "onerror" cffunction has been commented out as suggested in
another topic.

Everything runs/displays fine, no events can be saved.

Mike


On Jan 25, 4:17 am, KoldFuzun <koldfu...@gmail.com> wrote:
> Hi Jean-Michel,
>
> Much like you, without an error I wouldn't even know where to start to
> debug. Sorry!
>

[TJ]

Hi Mike, what version of MySQL are you using?

[Mike]

I have 5.0.37 installed and this is the active DB when this error
shows.

Sorry, I put this in the other thread but not in here.

I also have a 4.1.22 installed. Do you want me to give it a shot with
this version?

Mike

[Mike]

I've deleted the MySQL 5 (5.0.37) database and created a MySQL 4
(4.1.22) database. Ran the create tables script.
http://www.meadowbrookhills.net/kalendar/mysql_kalendar.txt

I can add categories, edit categories, delete categories

I cannot add any events.

Admin page is located at this URL if you wish to see the error.

http://www.meadowbrookhills.net/kalendar/admin/kalendar/index.cfm

All unzipped files were uploaded to this domain/folder exactly as they
were unzipped with no modifications to any file or folder names.

Mike

> > Hi Mike, what version of MySQL are you using?- Hide quoted text -
>
> - Show quoted text -

[TJ]

Mike you may want to check the app.cfc files (there are two of them)
to be sure it is running in mysql mode and not mssql

after you make changes to the application variables you need to
restart cf or rename the application (this.name)

[Mike]

Default setting is MySQL which is still set.

The save, edit delete works in both the MySQL databases (4 and 5) but
on with the categories. If there were an issue in the application
files the other DB table would not function. The coding is working
with both databases, it is just the events module that is failing

I have saved the application.cfc as a text file if you wish to see the
changes I have made.

main app.cfc:
http://www.meadowbrookhills.net/kalendar/main_application.txt

admin app.cfc:
http://www.meadowbrookhills.net/kalendar/admin/admin_application.txt

Changing this.name=??? on save after each edit as per other info in
topics.

I have SQL Server 2005 running. I could try using that DB. I think
that because the 2 MySQL databases (4 and 5) were functioning
perfectly in the categories table that it would still throw the same
query failure in the calendar table regardless of which database is
used but I am willing to set up a sql server 2005 database and test if
you would like. I will wait till I hear back before changing anything
since the errors are consistent across 2 different database versions
of MySQL

Maybe you can see something in the application files that would shed
light on this.

Mike

[TJ]

Hi Mike

I just went through the process of configuring a brand new instance of
Kalendar using the zip file downloaded from RIAForge. I created a
brand new database on MySQL '5.0.45-community-nt' (from SELECT
version();)

After I FTP'ed the Kalendar directory to my server I changed the
values in the application.cfc files to match my environment then ran
the SQL script against the database, setup the DSN and ran the
Kalendar application. Everything loaded up fine and I am able to
insert, update and delete both events and categories.

So, given this, I'd say it's likely not an issue with Kalendar itself
but something in your environment or some code changes you may have
made. Maybe even a corrupt download. The error you are receiving is
saying that it doesn't know what the type you are passing to it, which
is very strange since all the previous types it is passing into the
query are the same exact types.

My two questions:
Have you made any modifications to the description textarea in the
admin?
What version of CF are you using? I am on CF 8

[Mike]

I am using CF MX-7

No changes to anything except as noted with the exception of the
security change for the "returnmessage" cfif in both application
files. Only the path was changed to reflect the relative location of
folders.

I have only opened the 2 application files and edits were made to the
files on the web server using homesite. Files on my local computer
are the default download.

I've tried to keep everything as default as possible to avoid any self
induced issues.

I will delete what I have on my local computer and the server and try
a fresh download from RIAForge.

Mike

[TJ]

Sounds good Mike. Id also ensure that the database type matches the
tables the scripts are creating (ISAM)

[Mike]

Do you think it might be an incompatibility with CF 7?

Fresh download and install still throws the same error.

Can still work categories table but calendar table throws query error.

I did not bother with the security edit this time, only paths in both
application files

Mike

> > What version of CF are you using? I am on CF 8- Hide quoted text -

[Mike]

I used Heidi to run the create script. This is what was created in
the calendar table. Maybe there is something missing?

http://www.meadowbrookhills.net/kalendar/HeidiCalendarTable.gif

Heidi is the newest version of MySQL Front which I have used for years

Mike

> > - Show quoted text -- Hide quoted text -

[steveo]

I'm also having this problem. The error is "Unknown Types value" using
MySQL 5.0.45. All settings are set correctly, I can create/udpate/
delete Categories. I cannot add new Events. I am running in a hosted
environment, so I can't change to a different version of MySQL -this
is what I get. The hosting is running CFMX 7. Is this possibly in the
sqltype string where the error is being thrown? Thanks

[TJ]

SteveO, possibly. I will have to setup that specific version and test
this week. Curious, I wonder if MySQL made some changes to datatypes
in that release. Ill let you know by Friday

[Mike]

This adobe kb article was what resolved the issue.

http://kb.adobe.com/selfservice/viewContent.do?externalId=6ef0253&sliceId=1

I had to bring in someone with a lot more knowledge and they found the
problem

Mike

[TJ]

Hi Mike, that URL comes up blank. Could you repost it for me? I'd like
to take a look and determine if there's something we can include in
Kalendar to help resolve the problem, even if it's just a
documentation blurb.

Thanks!
TJ

[Mike]

I found this other link to the KB article

http://www.adobe.com/go/6ef0253

Hopefully this will get you there

Mike

[TJ]

Thanks Mike! That would explain why I couldn't duplicate the error, I
always use the MySQL driver from the MySQL site.