User badges SQL Syntax Error on Activation

This was tested on 5.x-1.2 release AND also the devel version.

When installing and activating the module in the Administer>Modules section, the following error appears:

user warning: 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 '. )' at line 6 query: CREATE TABLE xxxxxx_user_badges_badges ( bid int(10) NOT NULL default '0', name varchar(50) NOT NULL default '', image varchar(80) NOT NULL default '', weight int(2) NOT NULL default '0', href VARCHAR(80) default ''. ) in /home/freetech/public_html/includes/database.mysql.inc on line 174.

(Note: The actual table prefix name has been edited and replaced with xxxx in the message above, the actual error message will show the prefix.)

So here is what I did so far:

1. I tried to copy the query and run it in phpMyAdmin, where I got the about the same message
saying that the syntax was wrong starting at line 1.

2. I then wrote down the table name and all the field names and attempted to create that table and
fields manually using the information from the query. This time I got a different error message:

#1103 - Incorrect table name 'xxxxxx_user_badges_badges '

My current version of mySQL straight from the horses mouth:

mysql Ver 14.12 Distrib 5.0.67, for redhat-linux-gnu (i686) using readline 5.1

Hopefully, I gave enough information so someone can figure this out, if you really need the actual table prefix name, contact me as I will NOT post it publicly.