>
>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 don't remember having that error on the original code of fusionmail but
you can check if you have the correct time on your regional settings on the
control panel . Other solution would be setting the date as a default with
Now()
>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>
there should be a col name hasread on the mail table. cf debugger is
telling you the col is missing and there should be according to the cf code.
>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.
Fusionmail 1.2 works "ok" on its original version you will start getting
some log errors after making exportations to sql or so (this is normal). I
would suggest unpacking the db and set it again to start from the beginning.
>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/
>========================================================================
********************************************
* Ing. Guillermo Dewey Guerra
* Metro Cybercomercio Mexico
* [EMAIL PROTECTED]
* ICQ: 25876549 (GDewey)
*
* http://www.metro.com.mx
* http://www.ablecommerce.com.mx
*
* Tel. (011) (52) (8) 3-90-7000
* Fax (011) (52) (8) 3-90-7001
* Cel. (011) (52) (044) (8) 3-09-24-16
* Monterrey N.L. Mexico
********************************************
========================================================================
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/
========================================================================
