Assuming that there is something wrong with my installation of MySQL, can we review the settings for CFMX7?
CF Data Source name :<SNIP> JDBC URL: jdbc:mysql://localhost:3306/<database name> Driver Class: com.mysql.jdbc.Driver And we followed the instructions for installation at http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253 The jar file being stored at D:\CFusionMX7\wwwroot\WEB-INF\lib -Phil |-----Original Message----- |From: [EMAIL PROTECTED] [mailto:bounce-farcry- |[EMAIL PROTECTED] On Behalf Of Geoff Bowers |Sent: Thursday, July 14, 2005 6:07 PM |To: FarCry Developers |Subject: [farcry-dev] Re: Data Truncation Part 3 | |Phil Lepanto wrote: |> 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 | |I'm not sure. It looks very odd to me. mySQL is the database i have on |my workstation so I do a lot of installs and mucking around during |development. Have never seen the issue you are describing. | |Be sure to completely DROP the schema between installs. The installer |expects to see the tables to be missing. | |-- 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/
