Change hasread to read in the SQL statement. Also, change the timestamp
column in the iMS DB into datetimestamp and then change it in all the code
(search & replace).
> Hi,
>
> I'm wondering if I have missed a release of FusionMail... I've just
> installed iMS 1.3c and FusionMail 1.2 onto a brand new server. After
> going through the configuration etc to get everything running I found
> that mail was not being received properly and looking in the SMTP log I
> found the following:
>
> 07/31/2000 11:24:57 [001] WARNING: Application server response:
> 07/31/2000 11:24:57 [001] WARNING:
> Template=C:\Utils\iMS\Domains\DATA.cfm
> 07/31/2000 11:24:57 [001] WARNING: Content-type: text/html
> 07/31/2000 11:24:57 [001] WARNING: Page-Completion-Status: Abnormal
> 07/31/2000 11:24:57 [001] WARNING:
> <TITLE>Error Occurred While Processing
> Request</TITLE></HEAD><BODY><HR><H3>Error Occurred While Processing
> Request</H3><P> <TABLE BORDER><TR><TD><H4>Error Diagnostic
> Information</H4><P>ODBC Error Code = 37000 (Syntax error or access
> violation)<P><P> [Microsoft][ODBC Microsoft Access 97 Driver] Syntax
> error in INSERT INTO statement.<P><P><p>The error occurred while
> processing an element with a general identifier of (CFQUERY), occupying
> document position (104:10) to (104:35).</p><P><P>Date/Time: 07/31/00
> 11:24:57<BR>Browser: <BR>Remote Address:
> 192.168.0.2<P></TD></TR></TABLE><P><HR>
> 07/31/2000 11:24:57 [001] WARNING: </BODY></HTML>
> 07/31/2000 11:24:57 [001] Moving mail file to orphans directory
> (0BF2F2CE9166D411B23600508BD92E27.mail)
>
> I then looked in the Data.cfm and compared it with the database, but it
> looked OK. I then looked at the version of data.cfm on my development
> machine and found that I now had version 1.0.5 on the server as opposed
> to 1.0.4 on the development machine. I decided to clip out some fields
> that were being inserted with what would be default values anyway and
> the message changed (slightly) to:
>
> 31/07/2000 01:06:14 [001] WARNING:
> <TITLE>Error Occurred While Processing
> Request</TITLE></HEAD><BODY><HR><H3>Error Occurred While Processing
> Request</H3><P> <TABLE BORDER><TR><TD><H4>Error Diagnostic
> Information</H4><P>ODBC Error Code = S0022 (Column not found)<P><P>
> [Microsoft][ODBC Microsoft Access 97 Driver] The INSERT INTO statement
> contains the following unknown field name: 'hasread'. Make sure you've
> typed the name correctly, and try the operation again.<P><P><p>The error
> occurred while processing an element with a general identifier of
> (CFQUERY), occupying document position (104:10) to
> (104:35).</p><P><P>Date/Time: 07/31/00 13:06:14<BR>Browser: <BR>Remote
> Address: 192.168.0.2<P></TD></TR></TABLE><P><HR>
>
> Why it now actually named the column I don't know but certainly
> 'hasread' does not exist as a column in the iMS database as ditributed
> with FusionMail 1.2.
>
> So, is this a typo somewhere? A version control problem? Have I missed
> something?
>
> I know FusionMail is free and generally you get what you pay for, but
> I'd just like to know whether there is a new version of FusionMail
> around the corner so that I don't waste my time trying to make the
> templates that have been delivered with iMS 1.3c work with the
> FusionMail 1.2 database.
>
> Sorry about the long post but it took me a while to work out what was
> wrong (well, what *I* think is wrong) and perhaps there might be an
> error in the process I've used that will be obvious to someone with more
> experience with iMS and FusionMail than I have.
>
> Regards and Thanks,
>
> Brett Payne-Rhodes
> B)
>
> ========================================================================
> This list server is Powered by iMS
> 'The Swiss Army Knife of Mail Servers'
> --------------------------------------
> To leave this list please complete the form at
> http://www.CoolFusion.com/iMS.htm
>
> List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
> ========================================================================
>
>
========================================================================
This list server is Powered by iMS
'The Swiss Army Knife of Mail Servers'
--------------------------------------
To leave this list please complete the form at
http://www.CoolFusion.com/iMS.htm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
========================================================================
