Data loss in user_settings table move from 3.3.0.8 to 3.4.0.4

I have noticed that there is “data loss” when moving from 3.3.0.8 to 3.4.0.4 to the admin profile.

(See attached image)
On the left is our production server (3.3.0.8). On the right is our development/sandbox server we are testing the upgrade. In database update process, some data is eliminated. Please advise.

Of note, the original admin role was “CTL” “Centre for Teaching and Learning” and then updated after moving to 3.0.0.8 to “James” “Holobetz”

Error, I meant updated after moving to 3.3.0.8

Hi @jholobetz,

This is a data error in your OJS 3.3.0-x (or prior) database, which is resolved in 3.4.0-x by choosing a “preferred” record from among the options. There is more detail on it it here:

Regards,
Alec Smecher
Public Knowledge Project Team

Thanks for the clarification @asmecher. I was a little confused as to why it was not mirroring production when the data was transferred. It just seemed odd that the most recent update (non-NULL data) to the production (3.3.0.8) database was not preserved in the update to 3.4.0.4. But using the duplicate query Null values in assoc columns in user_settings prevent correct data reading after update · Issue #7167 · pkp/pkp-lib · GitHub @jonasraoni provided helped to verify that no other users are affected in the transfer.

1 Like

This topic was automatically closed after 10 days. New replies are no longer allowed.