When I try to duplicate a product with it's options, specifications, etc. I get the following:
 
DB ERROR 1064
 
Location: http://localhost/Catalog/admin/admin_product.php
 
Database error: Invalid SQL: SELECT * FROM va_items_properties WHERE item_id=125 ORDER property_order, property_id
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 'property_order, property_id' at line 1
 
I have hundreds of products, I'm at a complete stop. I have v.3.3.1. Help!!

I tried this and got the same error. I then looked at "Announcements" and found a tracking fix as well as a zip of fixes for 3.3.1 and now it works so this might solve your problem.