I've encountered a truly bizarre problem today. Some required data such as user_first_name, user_last_name, and user_email which DOES appear on dotProject screens DOES NOT exist for some records in the MySQL user table. Though I suppose the data may have gotten deleted somehow, I really (really!) don't understand how dotProject is working with data that doesn't seem to exist (ie users which at present show no email address are and have been receiving project emails).

Though I'm glad the system is still working, I'd kinda prefer the problem be the other way around... I'm getting dizzy!

OK, I've at least found where the data is coming from! The missing data is in the contacts table as contact_first_name, contact_last_name, and contact_email. Why new records now have this user information stored here is a different story!

At least my world has stopped spinning! :)

In ver 1.0.2 these data was on the users table, but now is on contacts table and is linked (users.user_contact = contacts.contact_id)

Pedro A.

Thanks pedroa!

Perhaps for the next version, the users and contacts tables look like good candidates for some normalization! :)