 |
 |
 |
 |
#314339 - 06/05/07 09:14 PM
Re: RSS Topic Creator [Release Candidate]
[Re: Gizmo]
|
Master Hacker
Registered: 01/25/03
Posts: 3765
Loc: Saint Johns, PA
|
|
|
Top
|
|
|
|
 |
 |
 |
 |
|
|
|
|
|
#314359 - 06/07/07 03:43 AM
Re: RSS Topic Creator [Release Candidate]
[Re: GEN]
|
Power User
Registered: 01/01/07
Posts: 52
Loc: UK
|
 Totally unfamiliar with PhpAdmin I copy n pasted this: CREATE TABLE %%TABLE_PREFIX%%TOPIC_FEEDS (
FEED_ID int(4) unsigned not null auto_increment primary key,
USER_ID int(9) unsigned not null,
FORUM_ID int(9) unsigned not null,
FEED_URL varchar(255),
LAST_BUILD int(11) unsigned not null default '0',
LAST_TOPIC_TIME int(11) unsigned not null default '0',
CACHE_TIME int(9) unsigned not null default '30',
TITLE_PREFIX varchar(32),
BODY_FORMAT text,
FEED_IS_ENABLED tinyint(1) default '1',
FEED_WAS_ESCAPED tinyint(1) default '0',
PARSE_BBCODE tinyint(1) default '0',
TOPIC_ICON varchar(30),
REGEXP_SPECIAL text
) TYPE=MyISAM Into my Query window...resulting in this: Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 14
STR: %%
SQL: CREATE TABLE %%TABLE_PREFIX%%TOPIC_FEEDS (
FEED_ID int(4) unsigned not null auto_increment primary key,
USER_ID int(9) unsigned not null,
FORUM_ID int(9) unsigned not null,
FEED_URL varchar(255),
LAST_BUILD int(11) unsigned not null default '0',
LAST_TOPIC_TIME int(11) unsigned not null default '0',
CACHE_TIME int(9) unsigned not null default '30',
TITLE_PREFIX varchar(32),
BODY_FORMAT text,
FEED_IS_ENABLED tinyint(1) default '1',
FEED_WAS_ESCAPED tinyint(1) default '0',
X PARSE_BBCODE tinyint(1) default '0',
TOPIC_ICON varchar(30),
REGEXP_SPECIAL text
) TYPE=MyISAM
SQL query:
CREATE TABLE %%TABLE_PREFIX%%TOPIC_FEEDS ( FEED_ID int(4) unsigned not null auto_increment primary key, USER_ID int(9) unsigned not null, FORUM_ID int(9) unsigned not null, FEED_URL varchar(255), LAST_BUILD int(11) unsigned not null default '0', LAST_TOPIC_TIME int(11) unsigned not null default '0', CACHE_TIME int(9) unsigned not null default '30', TITLE_PREFIX varchar(32), BODY_FORMAT text, FEED_IS_ENABLED tinyint(1) default '1', FEED_WAS_ESCAPED tinyint(1) default '0', PARSE_BBCODE tinyint(1) default '0', TOPIC_ICON varchar(30), REGEXP_SPECIAL text ) TYPE=MyISAM
MySQL said: Documentation
#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 '%%TABLE_PREFIX%%TOPIC_FEEDS (
FEED_ID int(4) unsigned not null
|
|
Top
|
|
|
|
|
|
|
|
|
|
at the moment - but expanding all the time....) 
Previous Topic
Index