Affiliate hack prob ... Running a SQL query

[boo.3]

ok it says

Run this query:
DROP TABLE IF EXISTS affiliates;
CREATE TABLE affiliates (
	 affiliate_id int(10) NOT NULL auto_increment,
	 sitename varchar(50) NOT NULL,
	 siteurl varchar(250) NOT NULL,
	 sitedesc mediumtext NOT NULL,
	 buttonurl varchar(150) NOT NULL,
	 type tinyint(4) NOT NULL,
	 email varchar(250) NOT NULL,
	 clicksout int(20) NOT NULL,
	 clicksin int(20) NOT NULL,
	 active tinyint(4) NOT NULL,
	 totalrating bigint(20) NOT NULL,
	 totalvotes bigint(20) NOT NULL,
	 approved tinyint(4) NOT NULL,
	 PRIMARY KEY (affiliate_id),
	 KEY sitename (sitename),
	 KEY siteurl (siteurl),
	 KEY email (email)
);

i do and i get this error

An error occurred while attempting to execute your query. The following information was returned. 
error number: 1064 
error desc: 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 ';
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL a

i have no idea what i did wrong? i did everything right but the SQL queries


thanks in advanced

[Marco van Herwaarden]

How are you trying to run them?

If you're running them from ACP, try to execute one query at a time (1st the first line, second query line 2 and down)

[boo.3]

ahh ok i'll try it