Hi all

I have a Wordpress plugin that creates a table, some people have reported that this does not get created. When I have asked then to run the definition in manually they get errors, when I do it, it creates the table correctly without any problems.

The reported error is:

#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
'fields text,
file_lines int(15) default '0',
post_content text,
post_ti' at line 5

I did not think that the table was doing anything out of the ordinary so if anyone can help I would appreciate it.

The table is as follows:

CREATE TABLE wp_multifeed (
id int(11) NOT NULL auto_increment,
title varchar(255) default '',
file varchar(255) default '',
fields text,
file_lines int(15) default '0',
post_content text,
post_title text,
tags text,
categories text,
remove int(2) default '0',
isunique varchar(50) default '',
one varchar(10) default '',
custom_names text,
custom_values text,
chkshed smallint(2) default '0',
noofposts int(10) default '0',
post_int int(10) default '0',
comment_status smallint(2) default '0',
ping_status smallint(2) default '0',
condition1 varchar(10) default '',
condition1value varchar(255) default '',
condition1type varchar(64) default '',
condition2 varchar(10) default '',
condition2value varchar(255) default '',
condition2type varchar(64) default '',
usecondition varchar(10) default '',
localfile text,
url text,
file_date timestamp NOT NULL default CURRENT_TIMESTAMP,
advanced varchar(10) default '',
start varchar(10) default '',
finish varchar(10) default '',
slt_intrtype varchar(10) default '',
PRIMARY KEY (id)
) AUTO_INCREMENT=3;


Thanks

Matt Houldsworth
Digitalquill