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.
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
On Apr 1, 3:33 am, TJ <KoldFu...@gmail.com> wrote:
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
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
On Apr 1, 12:35 pm, TJ <KoldFu...@gmail.com> wrote:
> 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
> 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
> On Apr 1, 12:35 pm, TJ <KoldFu...@gmail.com> wrote:
> > 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- Hide quoted text -
> 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
> On Apr 1, 1:13 pm, Mike <gotFus...@gmail.com> wrote:
> > 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
> > On Apr 1, 12:35 pm, TJ <KoldFu...@gmail.com> wrote:
> > > 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- Hide quoted text -
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
On Apr 1, 1:39 pm, Mike <gotFus...@gmail.com> wrote:
