I've been pulling my hair out for the past week or so on this. I cannot login to a Farcry installation using CFMX 7.1 and MySQL 4.1. My MySQL connection is the following:
Type: Other JDBC URL : jdbc:mysql://localhost:3306/philduba_farcry Driver Class : com.mysql.jdbc.Driver ConnectionString : jdbcCompliantTruncation=false&useUnicode=true&characterEncoding=utf-8 I placed a CFDUMP inside of the getUser function in farcry_core/packages/security/authentication.cfc and this is the result on the query: ROW USERID USERLOGIN USERNOTES USERPASSWORD USERSTATUS 1 4294967297 farcry Systems Administrator farcry 260 Now, when I run the exact same query in SQLYog I get the following data back: ROW USERID USERLOGIN USERNOTES USERPASSWORD USERSTATUS 1 1 farcry Systems Administrator farcry 4 Thinking it might be something with my ColdFusion datasource, I created a test page with the same query executed within getUser and dumped the results. I got the following: USERID USERLOGIN USERNOTES USERPASSWORD USERSTATUS 1 1 farcry Systems Administrator farcry 4 If anyone has any suggestions, please let me know as I am getting really frustrated. Thanks, Phil --- 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/
