Troubleshooting vBulletin Problems Discuss What did I do now? in the vBulletinSetup Information forums; Invalid SQL: SELECT donor.userid, donor.total, user.username, user.showdonor FROM vb_donation_donors AS donor LEFT JOIN vb_user AS user ON(user.userid = donor.userid) WHERE donor.userid != '0' ORDER BY total DESC LIMIT 0,3; MySQL ...

[HotRodGyrl]

Invalid SQL:
SELECT donor.userid, donor.total, user.username, user.showdonor
FROM vb_donation_donors AS donor
LEFT JOIN vb_user AS user ON(user.userid = donor.userid)
WHERE donor.userid != '0'
ORDER BY total DESC
LIMIT 0,3;

MySQL Error : Table 'mikesper_forum.vb_donation_donors' doesn't exist
Error Number : 1146

Need to go delete it out?

[MaestroX]

Where does the error occur? Forum home?

[Brandon Sheley]

Did you add a donation mod ?

[HotRodGyrl]

"X" - The code I get through email.

Brandon - I think I attempted it WHILE Brian was putting the CMPS on and it may have screwed something up.

I'm talking with him now and hopefully one of us can fix it. I was just seeing if it was ME, and it probably was.

Trying to do it myself...lol

No, when I add a link to another page, all I ahve to do is make the page, save it in .php, and add it to the forum root correct?

[Brandon Sheley]

try un installing the donation mod and re installing ( the product )

[HotRodGyrl]

I put it in the wrong thread...

I can delete it if I can find it.....lmao

I'm trying to find it TO delete it, where would it be. I see it in the template section but not in the plugins...GAH

Where is MySQL in the VB cp?

Please

[Brandon Sheley]

products maybe ?

[HotRodGyrl]

I will check, I tried my best not to touch the computer during the weekend.

Now, it's on...lol

[eric]

for sure the script is trying to write to a table that doesn't exist, clearly or the xml import didn't succeed correctly or it went wacko

try to re import (check allow override)