So once I did a search for the correct error in the forums I found the info needed. Commenting out the STRICT_TRANS_TABLES in MySQL's ini file moved us on. We had four tables that already existed in the db. Once we dropped those and continued the Moodle process our wiki install was successful
Thanks to all that post problems and solutions.