I installed that hack anf it worked fine. However I also installed the hidden post hack. While trying to hide a post, I got a mysql error in showthread.php
mysql error: Table 'databasename.ratetotal' doesn't exist
while investigating, I found the problem was at
Find in showthread.php (around line 58):
-----------------------------------------------------------------------------------
LEFT JOIN user ON user.userid=post.userid
replace with:
LEFT JOIN user ON user.userid=post.userid,ratetotal,ratenum,allowrat e
---------------------------------------------------------------------------------
I reverted it back by removing that line:
,ratetotal,ratenum,allowrate
and hidepost worked.
Looks like that rate user is still working. My question is: what is the importance of that line?
Notice that the error did not say databasename.user.ratetotal (which exists in table user as per installed but the error is seeinf ratetotal as a table, not a field).
How can I correct this? I am on 2.21
Thanks
|