[micheal332001]

Originally Posted by Distance

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM vbjokes_jokes WHERE aprove=1 ORDER BY rating/numberOfVotes DESC LIMIT 0 , 3;

MySQL Error : Unknown column 'rating' in 'order clause'
Error Number : 1054
Date : Monday, July 24th 2006 @ 07:48:30 AM
Script : http://www.hullchat.co.uk/vbjokes.php
Referrer : http://www.hullchat.co.uk/index.php?
IP Address : **
Username : **
Classname : vb_database

You have not done this step thats why.



6. login to admincp
goto Plugin System
Manage Products
[Add/Import Product]
EITHER upload the XML file from your computer product-vbjokes-upgrade.xml
Allow Overwrite yes
click inport

7. All done enjoy your vbjokes hack.