MyBB Community Forums

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'pid' in 'where clause'
Query:
SELECT * FROM mybb_reputation WHERE adduid='1' AND uid='25' AND pid = '235'

A while ago someone told me that the 'fast reputation' had a sql vulnerability and i removed it. Great... went back to the stock popup one... and now out of no where i get this error whats up?
This is the table as it is:



When I hower over the add reputation button it says: jMyBB.reputation(25,235);

Really need help fixing this... not sure it seems like its looking for PID?.. and its missing? Is that what I should add to the table? Doesn't make sense as it was working up until yesterday.

Seriously no one knows???????????

ALTER TABLE mybb_reputation ADD COLUMN pid int unsigned default '0';

ALTER TABLE mybb_reputation ADD KEY pid (pid);

Do a file verification check. Also, replace your reputation.php with a untouched one.

(2013-04-15, 06:53 AM).m. Wrote: [ -> ]

ALTER TABLE mybb_reputation ADD COLUMN pid int unsigned default '0';

ALTER TABLE mybb_reputation ADD KEY pid (pid);

Tha tworked brilliantly bro THANK YOU THANK YOU!

I was losing hope with no response lol

I wonder how this happened? After I uninstalled that plugin, everything kept working just fine then out of no where it stopped working... anyways thank God... now it's back to normal Thanks again bro.