UBB.Developers Forums UBB.threads 7 Development Addons and Modifications [7.0-7.3] RSS Topic Creator [Release Candidate]

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

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

// Setup the smarty class
require_once('../libs/smarty/Smarty.class.php');
$smarty = new Smarty();
$smarty->template_dir = 'templates/default';
$smarty->compile_dir = 'templates/compile';
// include all of the required libraries
require_once( "../libs/phpmailer/class.phpmailer.php" );
require_once( "../includes/config.inc.php" );
require_once( "../libs/mysql.inc.php" );
require_once( "../libs/ubbthreads.inc.php" );

/**
 * Should each new item increase the user's post count?
 */
$config['TOPIC_FEED_INC_POSTCOUNT'] = true;

$html =& new html;

// Setup the smarty class
require('../libs/smarty/Smarty.class.php');
$smarty = new Smarty();

$smarty->template_dir = 'templates/default';
$smarty->compile_dir = 'templates/compile';

// include all of the required libraries
require_once("../libs/phpmailer/class.phpmailer.php");
require_once("../includes/config.inc.php");
require_once("../libs/mysql.inc.php");
require_once("../libs/bbcode.inc.php");
require_once("../styles/wrappers.php");
require_once("../libs/html.inc.php");
require_once("../libs/mailer.inc.php");
require_once("../libs/user.inc.php");
require_once("../libs/ubbthreads.inc.php");

/**
 * Should each new item increase the user's post count?
 */
$config['TOPIC_FEED_INC_POSTCOUNT'] = true;

$html =& new html;

&

<br />

<input type="hidden" name="returntab" value="$returntab" /> 

<input type="hidden" name="valid_post" value="1" /> 

(file_exists("{$config['FULL_PATH']}/cache/forum_list.php")) ? include("{$config['FULL_PATH']}/cache/forum_list.php") : $tree = array() ; 

(file_exists("{$config['FULL_PATH']}/cache/forum_cache.php")) ? include("{$config['FULL_PATH']}/cache/forum_cache.php") : $tree = array() ;