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 [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
