MyBB Community Forums

Help! I had no luck upgrading to 1.2, so I've put 1.1.8 back on, but when I try to go into User CP, I get the following error:

mySQL error: 1054
Unknown column 'r.pid' in 'on clause'
Query: SELECT r.*, p.subject, p.tid FROM mybb_reputation r LEFT JOIN mybb_posts p ON (p.pid=r.pid) WHERE r.uid='1' ORDER BY r.dateline DESC LIMIT 0, 10

I can post and go into Admin CP, so what does this error mean, and how can I fix it?? Thanks!

MyBB 1.2's reputation table doesn't have a pid column, since the system is no longer based on posts.

Are you trying to use the MyBB 1.1.8 files with a database that's already been upgraded by MyBB 1.2? That sounds like a bad idea...

Edit: I didn't see this thread before posting: http://community.mybboard.net/showthread.php?tid=12197

Well, hopefully I can get this sorted out soon!  

EDIT: A big thank you to Tiki, for upgrading my board! woo hoo