[Plugin: Backup Scheduler] backup sfforum tables
-
Hi, i’m using ssforums plugins and backup scheduler but there is an error when backuping sfforums table :
INSERT INTO sfforums
VALUES ( 1, ‘News’, 1, 1, ‘Infos générales’, 0, ‘news’, ”, ”, , 0, 0, 0, 1, 0, 0, 1, 0, ”, ” ) ;There is twice , , instead of values.
Here is the current structure
CREATE TABLE IF NOT EXISTS
sfforums(
forum_idbigint(20) NOT NULL AUTO_INCREMENT,
forum_namevarchar(200) NOT NULL,
group_idbigint(20) NOT NULL,
forum_seqint(4) DEFAULT NULL,
forum_desctext,
forum_statusint(4) NOT NULL DEFAULT ‘0’,
forum_slugvarchar(200) NOT NULL,
forum_rsstext,
forum_iconvarchar(50) DEFAULT NULL,
post_idbigint(20) DEFAULT NULL,
topic_countmediumint(8) DEFAULT ‘0’,
post_countmediumint(8) DEFAULT ‘0’,
forum_rss_privatesmallint(1) NOT NULL DEFAULT ‘0’,
in_sitemapsmallint(1) NOT NULL DEFAULT ‘1’,
topic_status_setbigint(20) DEFAULT ‘0’,
post_ratingssmallint(1) NOT NULL DEFAULT ‘0’,
use_tagssmallint(1) NOT NULL DEFAULT ‘1’,
parentbigint(20) NOT NULL DEFAULT ‘0’,
childrentext,
forum_messagetext,
PRIMARY KEY (forum_id),
KEYgroupf_idx(group_id),
KEYfslug_idx(forum_slug)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;Thanks for fixing it.
The topic ‘[Plugin: Backup Scheduler] backup sfforum tables’ is closed to new replies.