[KevinL]

Originally Posted by Cap'n Steve

KevinL - Try removing this chunk of code from includes/functions_quoteit.php (also, post a list of the other mods you have installed):

PHP Code:

$settings[1] =& $quoteitoptions['ratings'];
$settings[3] =& $quoteitoptions['moderatequotes'];
$settings[0] =& $quoteitoptions['showrandomquote'];
$settings[4] =& $quoteitoptions['numbertomoderate'];
$settings[2] =& $quoteitoptions['averagethreshold'];
$settings[7] =& $quoteitoptions['totalthreshold'];
$settings[5] =& $quoteitoptions['enablecontext']; 


This works wonders!

Got it up and running. Now I had this on my site since the first version. I did a dump of the old database (before we had to close for a bit) and want to add them back in. Now when I tried to do that I started getting these errors:

Database error in vBulletin 3.7.2:

Invalid SQL:

			SELECT quotes.*, categories.title AS category, users.username FROM quotes AS quotes
			LEFT JOIN user AS users ON quotes.userid = users.userid
			LEFT JOIN quotecategories AS categories ON categories.categoryid = quotes.categoryid
			
				 LIMIT 17, 1;

MySQL Error   : Unknown column 'quotes.categoryid' in 'on clause'
Error Number  : 1054
Request Date  : Saturday, August 2nd 2008 @ 07:12:28 AM
Error Date    : Saturday, August 2nd 2008 @ 07:12:28 AM

I understand what it's saying but what I don't understand is why inserting them back into the database is giving me this error (since this is actually the 2nd time doing it like this). Also what is the table 'on clause'?

Thanks for your help!