so I should clear this table too?
What's the point in the created database by the addon?
Code:
$this->schemaManager()->createTable('xf_xc_ua_node_session_activity', function (Create $table)
{
$table->engine('MEMORY');
$table->addColumn('user_id', 'int');
$table->addColumn('unique_key', 'varbinary', 16);
$table->addColumn('ip', 'varbinary', 16)->setDefault('');
$table->addColumn('content_type',' enum')->values(['thread', 'node', 'project', 'project_category']);
$table->addColumn('parent_id', 'int')->setDefault(0);
$table->addColumn('content_id', 'int')->setDefault(0);
$table->addColumn('view_state', 'enum')->values(['valid','error']);
$table->addColumn('view_date', 'int');
$table->addPrimaryKey(['user_id', 'unique_key'])->using('btree');
$table->addKey('view_date')->using('btree');
});
This code makes no sense to me because even though this is acrruately tracking when someone does view a thread, you aren't reading the information from this you're using xf_thread_read which isn't accurately updating/tracking when someone has last read a thread? so what is the point in the above code existing and database table existing?
Please can we not read from that instead?
I just cleared that xf_thread_read table, and viewed a thread myself. I am the only person that has vewied the thread now, but it says the time and date that I viewed the thread was the 14th Feburary 2022 at 1:45pm.
What is causing your addon to act so strange and why/how is it saying I read the thread 2 days ago when I've uninstalled/reinstalled the add-on and cleared all the mention above database tables
Times and dates in xf_thread_read are different in the Database, so again it is your add-on being odd.
If you could support on this that'd be great
@XenConcept