Database error after installing a download

[seanscully]

I made a slight mistake, although I did make a backup today before hand-
I installed the Ad Manager download and may have done the Install SQL Patches incorrectly - I have all the files uploaded and modified the code where required but after doing a test order I get this after checkout BUT the order does go through, you just can't see the confirmation page.

1146 Table 'stakemil_zc.ad_stats' doesn't exist
in:
[INSERT INTO ad_stats (orders_id, advertizer_id) VALUES ('524', '')]

I ran SQL check from my cpanel and their is no ad_stats database and I ran the check and fix errors which come back clean.

HERE IS THE SQL PATCH
;
; SQL additions - paste into admin Tools->Install SQL Patches and execute
;
CREATE TABLE advertizers (
`advertizer_id` int(11) NOT NULL auto_increment,
`advertizer_name` varchar(40) NOT NULL default '',
`advertizer_enabled` int(4) NOT NULL default '1',
PRIMARY KEY (advertizer_id)
) TYPE=MyISAM;
;
; Change these inserts to reflect your advertizing needs...
; these populate the drop down menu in the checkout page.
; These two are required, you can add more through the Advertizer Manager Tool.
; Note: Never delete a advertizers table entry as the stats page assumes that the id's are sequential!!!
;
INSERT INTO advertizers (advertizer_name) VALUES ('This Web Site');
INSERT INTO advertizers (advertizer_name) VALUES ('Other - describe below in comments area');

CREATE TABLE ad_stats (
`orders_id` int(11) NOT NULL ,
`advertizer_id` int(11) NOT NULL ,
PRIMARY KEY (orders_id)
) TYPE=MyISAM;
;
; End of SQL additions
;

THIS IS THE RESULT I GET AFTER INSTALLING - HOW MANY TIMES CAN YOU RUN AN SQL PATCH?
;
; SQL additions - paste into admin Tools->Install SQL Patches and execute
;

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 '; SQL additions - paste into admin Tools->Install SQL Patches and execute' at line 1
in:
[; SQL additions - paste into admin Tools->Install SQL Patches and execute ;]
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.

[DrByte]

On all the lines that start with a semi-colon (;), replace that semi-colon with a #

Don't touch the lines that "end" with a semi-colon after some other text.... only touch the ones that "start" with a ;

Then rerun via Install SQL Patch