Thread Rating:
  • 2 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 8 Years, 3 Months, 1 Week ago reputation giving me sql error?
#1
Solved: 8 Years, 3 Months, 1 Week ago
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:

[Image: reputation.png]

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.
#2
Solved: 8 Years, 3 Months, 1 Week ago
Seriously no one knows???????????
#3
Solved: 8 Years, 3 Months, 1 Week ago
ALTER TABLE mybb_reputation ADD COLUMN pid int unsigned default '0';

ALTER TABLE mybb_reputation ADD KEY pid (pid);
#4
Solved: 8 Years, 3 Months, 1 Week ago
Do a file verification check. Also, replace your reputation.php with a untouched one.
#5
Solved: 8 Years, 3 Months, 1 Week ago
(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 Sad

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 Smile Thanks again bro.


Forum Jump:


Users browsing this thread: 1 Guest(s)