Phil Lepanto wrote:
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
We've done a bit of research here and what looks to be funky is the
assignment of the userid value. The reason why the login is broken is
likely that the userid in dmuser and dmusertogroup tables are different.
Consider the following...
For mySQL FarCry sets:
dmuser.userid to be an unsigned integer with autoincrement
dmusertogroup.userid to be a signed integer
In mySQL these datatypes equate to...
INT[(M)]
A normal-size integer. The signed range is -2147483648 to 2147483647.
The unsigned range is 0 to 4294967295.
It looks like something is going wrong in determining the userid. The
code uses a generic statement of:
select max(userID) as thisUserID FROM dmUser
It appears that some mySQL installations get the right userid and others
get the maximum possible for the datatype range eg. 4294967295 So when
you try and insert this into the dmusertogroup table the database chokes
and if you truncate the value it no longer matches dmuser (ie. you have
no role assigned in the system).
Why this occurs is a mystery -- it doesn't occur for our installations.
I suspect that it is a specific JDBC driver issue rather than a
database issue. In any event, we're looking at modifying the underlying
security code to change the code but get the same result.
I've detailed this information on the bug database. You can track
progress here:
http://bugs.farcrycms.org:8080/browse/FC-202
Best regards,
-- geoff
http://www.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/
