XF 2.3 [1146]: Table 'xenforo.xf_rm_resource_view' doesn't exist

[amsaal]

Need assistance with the table issue i have in server logs.

Server error log
XF\Db\Exception: MySQL statement prepare error [1146]: Table 'xenforo.xf_rm_resource_view' doesn't exist src/XF/Db/AbstractStatement.php:230
Generated by: Unknown account Jan 6, 2025 at 9:17 PM
Stack trace
UPDATE xf_rm_resource AS r
INNER JOIN xf_rm_resource_view AS rv ON (r.resource_id = rv.resource_id)
SET r.view_count = r.view_count + rv.total

------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(43): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(61): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/addons/XFRM/Repository/ResourceItem.php(354): XF\Db\AbstractAdapter->query('
UPDATE xf_r...')
#5 src/addons/XFRM/Cron/Views.php(15): XFRM\Repository\ResourceItem->batchUpdateResourceViews()
#6 src/XF/Job/Cron.php(42): XFRM\Cron\Views::runViewUpdate(Object(XF\Entity\CronEntry))
#7 src/XF/Job/Manager.php(275): XF\Job\Cron->run(8)
#8 src/XF/Job/Manager.php(205): XF\Job\Manager->runJobInternal(Array, 8)
#9 src/XF/Job/Manager.php(89): XF\Job\Manager->runJobEntry(Array, 8)
#10 job.php(46): XF\Job\Manager->runQueue(false, 8)
#11 {main}
Request state
array(4) {
["url"] => string(8) "/job.php"
["referrer"] => string(26) "https://domain.com/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[amsaal]

 

[Deleted member 184953]

Have you tried to rebuild XFRM

 

[amsaal]

Have you tried to rebuild XFRM

Can you guide me?

 

[philmckrackon]

Can you guide me?

Admin >> Tools >> Rebuild caches >> XFRM (several options)

 

[amsaal]

This is error i get even after rebuild

 

[Deleted member 184953]

Can you guide me?

Go to the add-ons page then for XFRM:

 

[Deleted member 184953]

View attachment 317096

This is error i get even after rebuild

Something else is wrong with your database

 

[philmckrackon]

I just reread the first post. How was XFRM installed? Was this an upgrade or fresh install? What XF version and what XFRM version is installed. Rebuild caches will not install the needed table.

 

[amsaal]

After doing install resources and removing donate addon now no more error . I had db corruption which i took backup and restore it

 

[amsaal]

After doing install resources and removing donate addon now have table error . I had db corruption which i took backup and restore

 

[amsaal]

How do i fix this table issue ?

The overall forum is not affected by it but is there a way i can fix this table error?