[farcry-dev] Data Truncation Part 3

[Phil Lepanto]

I played around with the installation a little bit and tried Googling some of my errors. I think I have the potential to see the light at the end of the tunnel… but, I could really use some help in getting there.   First, there is this page: http://jroller.com/page/mmatthews/Weblog?catname=%2FJava   It appears that ‘Data Truncation’ behavior in MySQL 4.1 behaves a bit differently than previous version of MySQL. By modifying the jdbc string in the CFMX7 Data Source to include the parameter   jdbcCompliantTruncation=false   We are able to get through the installation successfully… except, that every attempt to login fails. U: farcry and p: farcry yields failure, with the following notes described in the fqaudit table. (So, I didn’t really make any forward progress)   userStatus: 260, account disabled userStatus: 260, account disabled userStatus: 257, account disabled userStatus: 257, account disabled (note, there is also no ‘objectid’ for these failure records. Don’t know if that’s important).   I went wading into all the SQL queries that Coldfusion throws off in the debugging and I’m really stumped by the fact that there is this query:   INSERT INTO dmUserToGroup ( userId, groupId )                                VALUES ( 4294967297, 6 )   Yet, what is in the database is:   +------------+---------+ | userId     | groupId | +------------+---------+ | 2147483647 |       6 | +------------+---------+   Wouldn’t that mean that the previous query would always yield recordcount = 0   I’m also stumped by why the login feature would be disabled when we bull through the truncation error?   --- You are currently subscribed to farcry-dev as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/