Generally, my upgrade from 1.1 to 1.2 RC2 went according to the directions. But I am getting a SQL Store error anytime I try to update my user profile (I am a superadmin, BTW)
Particulars:
J! 1.0.15 Stable
CB 1.2 RC2
MySQL 4.0.27-max-log
PHP Version: 4.4.8
Tools shows the CB Databases as totally green
Tools shows Plugin db as totally green as well
I have synced users with the db without an error
None of the actions above made a change.
Key part of Error message:
{Note, spaces in between colons after "moscomprofiler" and before "store" are there to defeat a smiley from being rendered. There are no spaces in the actual code!}
moscomprofiler : : store failed: Unknown column 'lastpasswordchange' in 'field list' SQL=UPDATE jos_comprofiler (followed by my user table entry details)
When updating profile, error shows as alert dialog. When update is canceled, error shows above profile. Also happens if I try to update from the back end.
I have one test user and was able to login and mod the profile without an error. Checked the test user and the value for lastpasswordchange in jos_users for that user is 'NULL'. My account (as well as most others) has a date value in that field.
After I nulled the field value, I was able to update without an error.
Hope this is enough to get you started, let me know if you need anything else!
Post edited by: rpitera, at: 2008/07/19 20:21
EDIT: changed thread title per user request
Post edited by: beat, at: 2008/07/23 15:20