You have encountered what I can only rationalise as a bug in the mySQL
driver you are using. As mySQL are a bit bigger than us, and I'm no
JDBC driver developer we're looking at a workaround.
Current status for this issue is available here:
http://bugs.farcrycms.org:8080/browse/FC-202
If you can comment with the drvier version you are using for the CF
datasource.
Hope that helps,
-- geoff
http://www.daemon.com.au/
[EMAIL PROTECTED] wrote:
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/
