Hi Geoff, I was able to set up a page that INSERTS and SELECTS a large Text chunk. I was able to recreate the error by creating a column of datatype int size 11. When I put in a value that was 10 characters long, no problem. When I put in a value that was 12 characters long, I got the error.
In looking at the messages that I sent before (Data Truncation Part 2), it seems that this query: Insert into DmUserToGroup (userId,groupId) values (4294967297,6) Results in this error [ConMail DB Server] ERROR 1062: Duplicate entry '2147483647-6' for key 1 Is is possible that there is something between FarCry and MySQL that is transposing the first value? Also, why is the UserID that value? In the dmuser table, the farcry user has an ID of 1 -Phil |-----Original Message----- |From: [EMAIL PROTECTED] [mailto:bounce-farcry- |[EMAIL PROTECTED] On Behalf Of Geoff Bowers |Sent: Tuesday, July 12, 2005 7:06 PM |To: FarCry Developers |Subject: [farcry-dev] Re: Data Truncation Part 3 | |Phil Lepanto wrote: |> Windows Server 2003, Enterprise Edition Xeon 2.4Ghz, 2.39 Ghz, 1 GB RAM |> Web Server: IIS 6 |> Database: mysql-4.1.12a-win32 |> CF: 7,0,0,91690 | |Almost identical to several of our production environments. Definitely |works in this configuration. | |> In the original configuration, the system always craps out when it gets |> to the stage of creating the FarCry user. That is when I see the |> Truncation Error. | |This sounds an awful lot like something is not quite right with the |database connection. Worse comes to worse I can send you a zipped up |mySQL database but its probably better to work out whats going on. | |Can you set up a simple set of CFML pages that interact with this |database? For example, inserting and selecting for a large chunk of |text without truncation? It's important to first isolate whether this |is a CF/database issue or a FarCry issue. | |-- geoff |http://www.daemon.com.au/ | |--- |You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] |To unsubscribe send a blank email to leave-farcry-dev- |[EMAIL PROTECTED] |Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to farcry-dev as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
