how rebuilding bitfields?

It's under vBulletin Options, you might have to turn debug mode on.

that did it!

actually it worked but its not allowing me to approve the quotes..saying

Sorry, you don't have permission to access the administrative controls on this page.

If you need to access this page, ask your lead administrator to enable your permissions for this page using the Administrator Permissions section of the control panel.

Try rebuilding the bitfields or saving the usergroup permissions like I mentioned in the post above. If that doesn't work, what vBulletin version are you using?

This may be a stupid question, but where can I edit the URL for the pagenav links? There are unencoded ampersands in it and I'm getting a bunch of errors in the W3C Validator. :p

I believe the pagnav is in the pagenav template. I never noticed that before, so I'm not sure exactly why they aren't getting escaped. It looks like they might need to be escaped in includes/functions_quoteit.php (just search for $querystring), but that might break something else. I'll have to take a deeper look sometime.

For anyone who can help, I get this mysql error when trying to upload the product:

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM' at line 15
Error Number : 1064

Does anyone have any idea what causes it, and/or how to fix it?

Try redownloading and reinstalling it. What MySQL version do you have?

Problem Solved...