MyBB Community Forums

when clicking on the index

MySQL error: 1054
Unknown column 't.lastpostbump' in 'order clause'
Query: SELECT t.*, (t.totalratings/t.numratings) AS averagerating, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='19' AND (t.visible='1' OR t.visible='0') ORDER BY t.sticky DESC, t.lastpostbump DESC LIMIT 0, 20

and when trying to post this

MySQL error: 1054
Unknown column 'lastpostbump' in 'field list'
Query: UPDATE mybb_threads SET lastpostbump='1214259142' WHERE tid=37

do i need to create a table ? and if so how and what kind ? thanks

Do you have a plugin installed on your forum that somehow controls post bumping? These errors are because a plugin either didn't activate correctly or didn't deactivate correctly. If you have a link to the plugin I can take a look at it's code for the required SQL queries.

Try activating / deactivating the plugin again and see if the issue is resolved.

BMR777

Ya this is a post bump plug in , and i found a way to fix it ,, i deleted it ! but heres the link to the plug in , still would be nice find out what happened and how to fix it

http://mybbhacks.zingaburga.com/attachment.php?aid=67

Can't you ask at Zinga's forum?