I am having the same problem. I see that there was not answer to this request and assume that the answer must be so simple as not to require a reply.... 8-(
Would appreciate one anyway.... 8-)
Jim
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
the reason there was no reply is because I didn't get the usual notification of the post...
I actually have come across this, and have added a patch to the version I am using. I don't remember what it was exactly, but I will try and get an update release out this weekend.
The constraint violation was the "NULL" value being added by the query, and the fix was in the user_add method... I think there may have been mods to the user_edit method as well (both in the class file).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Following the directions in the INSTALL Doc,
everything works fine until i try and create a new account
MDB Error: constraint violation
INSERT INTO psa_users (updated, lname, fname, mname, email, phone, id, pass, hash, groups, active, expiration) VALUES ('2005-08-15 11:23:20', 'mitch', 'admin', 'b', 'mitch@innovators.net', '746.0823', 'mitch', 'e93f9d470543e556ea64d868e208efff', '88e5400ac34bc32c6319e15357d95cc2', '3', 'Y', NULL)
I can add profiles and change settings so other parts of the script are working correctly.
Linux devel 2.6.12-1.1398_FC4
httpd-2.0.54-10
PHP Version 5.0.4 --with-gettext
MDB 1.3.0
mysql-server-4.1.11-2
whats up?
Mitch
I am having the same problem. I see that there was not answer to this request and assume that the answer must be so simple as not to require a reply.... 8-(
Would appreciate one anyway.... 8-)
Jim
the reason there was no reply is because I didn't get the usual notification of the post...
I actually have come across this, and have added a patch to the version I am using. I don't remember what it was exactly, but I will try and get an update release out this weekend.
The constraint violation was the "NULL" value being added by the query, and the fix was in the user_add method... I think there may have been mods to the user_edit method as well (both in the class file).
The new release (4.0.1) should address and fix this problem.