[Cloudrunner]

Originally Posted by guvner

Man Oh Man!!

I just installed 1.07 - I got all the way to the end and all seemed well then BANG - it brought my whole site down!

The error I received was as follows:

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT donor.userid, donor.total, user.username
																FROM vb3_donation_donators AS donor
																LEFT JOIN vb3_user AS user ON(user.userid = donor.userid)
																WHERE donor.userid != '0'
																ORDER BY total DESC
																LIMIT 0,5

mysql error: Table database_name.vb3_donation_donators' doesn't exist

mysql error number: 1146

Date: Thursday 30th of June 2005 05:08:59 AM
Script: http://www.xpmediacentre.com.au/
Referer: 
Username: Removed
IP Address: xxx.xxx.xxx.xxx

Thankfully - the uninstall removed the offending code and my my site came back, but I was really panicked for a few minutes there.

Why could have happened that the donations module caused such a huge disruption to my database calls?

Of course I had already backed up, so I was well covered - but now - because I had to uninstall my previous version, I have no donations module at all.

I'm currently getting around 25 new members and 80 to 100 new posts a day and now I'm pretty nervous about reinstalling unless you have a concrete idea about what caused it.

I really need to get this back online since I'm currently getting quite a few donations coming in and all I have now is a blank page - HELP!

Mike :ermm:

Delete all the donation files from your server (do not uninstall), and then upload them ALL again out of the 1.07 archive.

What has happened here is that you are running an older version of your donate.php file in the modules directory, don't ask me how, I don't know, but the word donator has not been in use there since 1.03.

I have verified that the files in the 1.07 do not contain this error / query at all...