How to get a new mod to automatically create its own table?

[clydejones]

This is the error I get from: admin -> tools -> install sql patches

1064 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 's Test Site', '', 'This is just a test submission to show you how it looks, grea' at line 1
in:
[INSERT INTO zen_testimonials_manager VALUES (1, 'Great', '', 'Clyde's Test Site', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 0, 1, now(), '0000-00-00 00:00:00');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Navicat:

1146 - Table 'loyaltee.configuration_group' doesn't exist

You can try this and see if it works (the correction is highlighted):

INSERT INTO zen_testimonials_manager VALUES (1, 'Great', '', 'Clyde\'s Test Site', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 0, 1, now(), , NULL);

The newest version of the mod has this correction. This version also includes the following features:

* options in admin for image display (Width, Height, and Directory
* options in admin to display "Company", "City" and "State/Country" fields on the Add testimonial page.
* administrators can add an image as well as a link to the author's site
* Submission of testimonials can be restricted to registered customers
* Random display of testimonials in side box
* Display testimonial title, truncated text in sidebox
* Display testimonial submission date