Database error in vBulletin 3.8.6

[mecho]

Database error in vBulletin 3.8.6:

Invalid SQL:

SELECT AVG(mas_r.rating) AS avgrating, mas_a.*, user.username, user.email, user.languageid
FROM mas_application mas_a
LEFT JOIN mas_rating mas_r ON (mas_r.appid = mas_a.appid)
LEFT JOIN user AS user ON (user.userid = mas_a.userid)
GROUP BY mas_a.appid;

MySQL Error : Table 'TableName.mas_application' doesn't exist
Error Number : 1146
Request Date : Friday, December 7th 2012 @ 12:30:02 PM
Error Date : Friday, December 7th 2012 @ 12:30:02 PM
Script : h**p://w*w.domain.com/forum/cron.php?rand=716011
Referrer : h**p://w*w.domain.com/forum/100-documentaries/index41.html
IP Address :
Username : Unregistered
Classname : vB_Database
MySQL Version :

Any Help would be great.

thanks

[borbole]

It looks like you have a missing table in the db.

 MySQL Error   : Table 'TableName.mas_application' doesn't exist

I am not very familiar with the vb 3.8x db structure and I do not know if it is a default table or it is added by a third party mod. But by the looks of it I think the latter.

Do you have any kind of application mod installed btw?

[mecho]

i have few plugins installed but problem is that i can not check which one is the reason ? cause this errors shows up in random urls and it is not happening again when u refresh the page so i have no idea how to make sure what is the reason and is that table is default or for a installed mod.

[Zachery]

This is not an error from the standard vBulletin software. Its from a third party modification. Good luck getting it fixed.

[mecho]

Good to know Zachery , but any idea how can i find out which 3rd party is the reason?

thanks

[Loco.M]

Good to know Zachery , but any idea how can i find out which 3rd party is the reason?

thanks

It looks to be from this mod

http://www.vbulletin.org/forum/showthread.php?t=159704

Does the error go away if you disable the mod.

[mecho]

It looks to be from this mod

http://www.vbulletin.org/forum/showthread.php?t=159704

Does the error go away if you disable the mod.

I had this addon installed but uninstalled long time ago!

Edit/Solved : it was so simple to check and i learned now. as it was a Cron error in Database error report, i checked the "Scheduled Task Manager" and i have found out the error by checking the "titles" so as Loco.M said it is from the "Moderator App" mod. I have uninstalled it before but the Cron was still in the list and it was active! so i just removed it and it should not be happen again .

Thanks to everyone

[Mark.B]

Thanks for coming back and posting how you fixed it, this can really help others who may run into the same problem.