Its probably me not haveing the correct parameters for some mysql version, i do not have time atm to check it since i dont have a later mysql version installed anywhere.
Just import these from phpmyadmin or similar, paste them in a mysql code window and run it, also change FUSION_PREFIX before to the fusion prefix you have defined in config.php
If it works, ill also give you tables for member pages.
Code
CREATE TABLE IF NOT EXISTS `FUSION_PREFIX_vblog` (
`blog_id` mediumint(8) unsigned NOT NULL auto_increment,
`blog_cid` mediumint(8) NOT NULL default '0',
`blog_subject` varchar(100) NOT NULL default '',
`blog_blog` text NOT NULL,
`blog_blog2` text NOT NULL,
`blog_breaks` char(1) NOT NULL default '0',
`blog_name` mediumint(8) unsigned NOT NULL default '1',
`blog_datestamp` int(10) unsigned NOT NULL default '0',
`blog_start` int(10) unsigned NOT NULL default '0',
`blog_end` int(10) unsigned NOT NULL default '0',
`blog_visibility` tinyint(3) unsigned NOT NULL default '0',
`blog_reads` mediumint(8) unsigned NOT NULL default '0',
`blog_allow_comments` tinyint(1) unsigned NOT NULL default '1',
`blog_year` smallint(4) NOT NULL default '0',
`blog_month` smallint(2) NOT NULL default '0',
`blog_day` smallint(2) NOT NULL default '0',
`blog_image` varchar(60) NOT NULL default '',
`blog_thumb` varchar(60) NOT NULL default '',
`blog_thumb2` varchar(60) NOT NULL default '',
`blog_ialign` varchar(10) NOT NULL default '',
`blog_status` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`blog_id`),
KEY `blog_cid` (`blog_cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `FUSION_PREFIX_vblog_cats` (
`cid` mediumint(8) unsigned NOT NULL auto_increment,
`sid` mediumint(8) NOT NULL default '0',
`title` varchar(45) NOT NULL default '',
`access` tinyint(3) NOT NULL default '0',
`image` varchar(45) NOT NULL default '0',
`parentid` mediumint(8) NOT NULL default '0',
`status` char(1) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `sid` (`sid`)
) TYPE=MyISAM AUTO_INCREMENT=1;
CREATE TABLE IF NOT EXISTS `FUSION_PREFIX_vblog_comments` (
`comment_id` smallint(5) unsigned NOT NULL auto_increment,
`comment_item_id` smallint(5) unsigned NOT NULL default '0',
`comment_type` char(1) NOT NULL default '',
`comment_name` varchar(50) NOT NULL default '',
`comment_message` text NOT NULL,
`comment_smileys` tinyint(1) unsigned NOT NULL default '1',
`comment_datestamp` int(10) unsigned NOT NULL default '0',
`comment_ip` varchar(20) NOT NULL default '0.0.0.0',
`comment_approved` char(1) NOT NULL default '',
PRIMARY KEY (`comment_id`),
KEY `comment_item_id` (`comment_item_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;
CREATE TABLE IF NOT EXISTS `FUSION_PREFIX_vblog_settings` (
`msgs` char(1) NOT NULL default '1',
`mpwidth` varchar(10) NOT NULL default '1',
`version` varchar(5) NOT NULL default '',
`max_image_size` varchar(10) NOT NULL default '20480',
`theme` char(1) NOT NULL default '0',
`blog_thumb_w` varchar(10) NOT NULL default '',
`blog_thumb_h` varchar(10) NOT NULL default '',
`blog_thumb2_w` varchar(60) NOT NULL default '',
`blog_thumb2_h` varchar(60) NOT NULL default '',
`blog_max_w` varchar(10) NOT NULL default '',
`blog_max_h` varchar(10) NOT NULL default '',
`blog_nrtolist` varchar(10) NOT NULL default '',
`blog_mode` char(1) NOT NULL default '',
`blog_usr` varchar(10) NOT NULL default '',
`target` varchar(10) NOT NULL default '',
`folderlink` tinyint(1) NOT NULL default '0',
`selection` tinyint(1) NOT NULL default '0',
`cookies` tinyint(1) NOT NULL default '0',
`bclines` tinyint(1) NOT NULL default '0',
`icons` tinyint(1) NOT NULL default '0',
`statustext` tinyint(1) NOT NULL default '0',
`closesamelevel` tinyint(1) NOT NULL default '0',
`inorder` tinyint(1) NOT NULL default '0',
`blog_cats` tinyint(1) NOT NULL default '0',
`blog_imgs` tinyint(1) NOT NULL default '0',
`blog_attachments` tinyint(1) NOT NULL default '0',
`blog_nocats` varchar(10) NOT NULL default '',
`aapprovecmts` char(1) NOT NULL default ''
) TYPE=MyISAM;
Hello,
I too am looking for a blog system that users can write, so multiuser mode would be ideal.
I have installed the infusion and created a blog test , however:-
1) the admin page ->settings when I click is a blank page
2) on my site/infusions/blog/index.php ..I get
3)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 '' at line 4
Hello !
Thank you, it dosent have a builtin support for this option, i guess you could look at replaceing it with something like Disquss or FB comments if you want guest posts.
This Blog seems like a great addon, much better than any other blog system I've tried before.
I seem to have a problem, getting to allow blog comments though.
"Approve comments" is "On", the settings on my testblog is "Allow comments" but still I get "Denied"
Venue uses cookies. Some may already have been set. Read more about our Cookies here.
Please click the button I Consent Cookies to hide this bar and accept our cookies. If you continue to use the site with no action taken, we'll assume that you consent our cookies anyway.
I installed your Member Pages and there the commenting works fine.