Here is another quick question, hopefully someone State-side can send a quick answer:
Where does the USERID value come from in the dmusertogroup table? I've been looking through the tables and it is easy enough to see how dmgroup.groupid corresponds to dmusertogroup.groupid, but I don't see where dmusertogroup.userId = dmuser.userid |-----Original Message----- |From: [EMAIL PROTECTED] [mailto:bounce-farcry- |[EMAIL PROTECTED] On Behalf Of Phil Lepanto |Sent: Friday, July 15, 2005 9:41 AM |To: FarCry Developers |Subject: [farcry-dev] Re: Data Truncation Part 3 | |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 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/
