Had a user unable to register, tried adding him manually and got the same error message that he reported.
** Unable to write to database.
INSERT INTO WKX_users (usersUsername, usersPassword, usersEmail, usersFullname) VALUES('Userid', '4GHHwoDKhYsc', 'userid@verizon.net', 'User S Id')
--> (Field 'usersTimestamp' doesn't have a default value) **
I also note a number of dead records in table WKX_user_register with no means of clearing them out in admin?
Last edit: Frank A 2013-02-24
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes, fixed in 4.1.9. I've spent the last few weeks chasing after changes in PHP and MySQL between versions and this timestamp issue is one of them. Hopefully I've now found all such issues.
Could you send me a dump of just your user_register table please? I should be able to write something in the repairkit plugin to manage the clearout.
Regards,
Mark
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Had a user unable to register, tried adding him manually and got the same error message that he reported.
** Unable to write to database.
INSERT INTO
WKX_users(usersUsername,usersPassword,usersEmail,usersFullname) VALUES('Userid', '4GHHwoDKhYsc', 'userid@verizon.net', 'User S Id')--> (Field 'usersTimestamp' doesn't have a default value) **
I also note a number of dead records in table WKX_user_register with no means of clearing them out in admin?
Last edit: Frank A 2013-02-24
Ahh, fixed in 4.1.9 :) phewww that was quick :D
Sorry Frank, I was the first. you, the latest :D
F.
Hi Frank,
Yes, fixed in 4.1.9. I've spent the last few weeks chasing after changes in PHP and MySQL between versions and this timestamp issue is one of them. Hopefully I've now found all such issues.
Could you send me a dump of just your user_register table please? I should be able to write something in the repairkit plugin to manage the clearout.
Regards,
Mark