Howie,

Checked all of those, no problems with the dsource.cfm files.
IMS is processing emails (mostly spams 8^{ ) just fine.  POP is working with no problems.

Can I install the fusionmail templates into a different folder so I can look at a base install without affecting the online system? Do I need to do this on a different server to be safe?

I'm still stuck on why part of fusionmail is looking for session vars and the application.cfm had session vars turned off.

Thanks,

Steve

At 06:55 AM 10/18/2004, Howie Hamlin wrote:
There should be a few dsource.cfm templates (one for the iMS server templates, one for the FusionMail webmail and maybe one other).  This file specifies the datasource to use as well as the database type.  Make sure that the database type is set to MySQL.
 
Regards,
 
Howie
 
----- Original Message -----
From: Stephen Garrett
To: inFusion Support List
Sent: Saturday, October 16, 2004 9:31 PM
Subject: [iMS] [resend] Having a problem with Fusionmail 2.5 and logging in


All, I have installed Fusionmail v2.5 and have run into a couple of issues.

1) FusionMail installed fine. Configured system fine(via Fusionmail/admin). Set up some email accounts.
2) When trying to login into FusionMail, received some strange error messages about session management. Found That the Application.CFM module did not have Client or session management set to YES???? Very strange as part of the application seem to be looking for session vars. So, I changed the "NO"s to "YES"s and got a little further.
3) Now I get this error below, complaining about the SQL syntax. Is there something wrong with my installation, or are there bug fixes for 2.5?

Any help appreciated.

Btw, I had to go into script debugging within IE in order to see this error....

Steve






Error Occurred While Processing Request


Error Diagnostic Information



ODBC Error Code = 37000 (Syntax error or access violation)

[MySQL][ODBC 3.51 Driver][mysqld-4.0.21-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and FolderName not in('Inbox','Sent','Trash') order by F

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (13:2) to (13:60).

Date/Time: 10/15/04 21:13:48
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Remote Address: 204.245.207.6
HTTP Referer: http://204.245.207.14/fusionmail/index.cfm


This list server is Powered by iMS "The Swiss Army Knife of Mail Servers"

This list is provided as a free service. Although we will try to address issues in a timely manner, support via this list is not guaranteed. If you require expedited support then a support contract is required. Support may be purchased from http://www.coolfusion.com/commerce. Details regarding support options may be reviewed at: http://www.coolfusion.com/SupportOptions.cfm.

To leave this list please complete the form at http://www.coolfusion.com/Support/
Need an iMS Developer license? Sign up for a free license here: http://www.coolfusion.com/Developers/
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
Note: You are subscribed as [:smtpto:]

This list server is Powered by iMS "The Swiss Army Knife of Mail Servers"

This list is provided as a free service. Although we will try to address issues in a timely manner, support via this list is not guaranteed. If you require expedited support then a support contract is required. Support may be purchased from http://www.coolfusion.com/commerce. Details regarding support options may be reviewed at: http://www.coolfusion.com/SupportOptions.cfm.
To leave this list please complete the form at http://www.coolfusion.com/Support/
Need an iMS Developer license? Sign up for a free license here: http://www.coolfusion.com/Developers/
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
Note: You are subscribed as [:smtpto:]