I had some problems executing the mydownloads.sql script in plesk. Probably because our database versions differ? It was throwing up syntax errors. So I edited the script to get rid of all the dumps, and what not.. it worked.. if anyone else is having this problem.. here you go:
Code:
CREATE TABLE files (
fileid int(11) NOT NULL auto_increment,
filename varchar(255) NOT NULL default '',
info longtext NOT NULL,
PRIMARY KEY (fileid,fileid)
) TYPE=MyISAM;
CREATE TABLE log (
logid int(6) unsigned NOT NULL auto_increment,
filename varchar(255) default NULL,
dldate date default NULL,
dltime time default NULL,
dluser varchar(255) default NULL,
dlipaddr varchar(15) NOT NULL default '',
PRIMARY KEY (logid)
) TYPE=MyISAM;