I think the real issue is to figure out why they were empty in the first place. When a user is created user:136 object and the entry in users:joindate should be both created.
In this case you will have to run a custom script to add the missing entries. Place the following code in a javascript file name custom_scripts.js in your nodebb folder and run it with node custom_script.js
/* globals require, console, process */
'use strict';
const nconf = require('nconf');
nconf.file({
file: 'config.json',
});
nconf.defaults({
base_dir: __dirname,
views_dir: './build/public/templates',
upload_path: 'public/uploads',
});
const db = require('./src/database');
db.init(async (err) => {
if (err) {
console.log(`NodeBB could not connect to your database. Error: ${err.message}`);
process.exit();
}
await addMissingJoinDates();
console.log('done');
process.exit();
});
async function addMissingJoinDates() {
const batch = require('./src/batch');
const user = require('./src/user');
const total = await db.sortedSetCard('users:joindate');
let counter = 0;
await batch.processSortedSet('users:joindate', async (uids) => {
const userData = await user.getUsersFields(uids, ['uid', 'joindate']);
counter += uids.length;
await db.sortedSetAddBulk(
userData.map(data => ['users:joindate', data.joindate, userData.uid])
);
console.log(`${counter} / ${total}`);
}, {
batch: 500,
});
}
