[nissanpower]

Hello,

I followed the installationinstructions.txt file to the T and when I attempted to create the mysql tables, this is the error message I received.

SQL-query : [Edit]

CREATE TABLE banner (
id int(11) NOT NULL auto_increment,
url_to_banner varchar(255) NOT NULL default \'\',
redirector_url varchar(255) NOT NULL default \'\',
height int(11) NOT NULL default \'0\',
width int(11) NOT NULL default \'0\',
banner_text varchar(255) NOT NULL default \'0\',
guestclicks int(11) NOT NULL default \'0\',
userclicks int(11) NOT NULL default \'0\',
views int(11) NOT NULL default \'0\',
reportuserid int(11) NOT NULL default \'0\',
PRIMARY KEY (id)
) TYPE=MyISAM;

MySQL said:

You have an error in your SQL syntax near '\'\',
redirector_url varchar(255) NOT NULL default \'\',
height int(11) NO' at line 3

I also attempted to create the second table and this is what I got.....

CREATE TABLE userclicks (
userid int(11) NOT NULL default '0',
bannerid int(11) NOT NULL default '0',
clicks int(11) NOT NULL default '0',
PRIMARY KEY (userid,bannerid)
) TYPE=MyISAM;

I'm just copying and pasting them over. I tried several times, so I'm sure I'm not typing anything incorrectly. Can someone give me any ideas what could be wrong here?

Thanks!
-Gabriel