vb.org Archive - vBulletin Blog - vBdiary & vBblog - Convert a forum into a diary or weblog (blog) forum.

i installed this on a clean 3.6.8 pc1 site today.

i immediately got this error when attempting to submit first blog (thread):

Quote:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

, count(comments.commentid) as commentcount
FROM vb3_post AS post
LEFT JOIN vb3_user AS user ON(user.userid = post.userid)
LEFT JOIN vb3_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vb3_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN vb3_icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN vb3_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb3_customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN vb3_deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN vb3_editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN vb3_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 3 AND postparsed.languageid = 1)
LEFT JOIN vb3_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 3 AND sigparsed.languageid = 1)
LEFT JOIN vb3_sigpic AS sigpic ON(sigpic.userid = post.userid)
LEFT OUTER JOIN vb3_diarycomments AS comments ON(comments.postid = post.postid)

WHERE post.postid IN (0,10) GROUP BY post.postid
ORDER BY post.dateline;

MySQL Error : Table 'vbulletin.vb3_diarycomments' doesn't exist
Error Number : 1146

it either 1) didn't run the v1.2 install part of the xml or 2) erred on or before that point in the xml product installation. unfortunately you had db errors turned off.

update: confirmed #2 above:

also, attempted to manually create the table:

Quote:

CREATE TABLE `diarycomments` (

`commentid` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`threadid` int( 10 ) unsigned NOT NULL ,
`postid` int( 10 ) unsigned NOT NULL DEFAULT '0',
`parentid` int( 10 ) unsigned NOT NULL DEFAULT '0',
`username` varchar( 100 ) NOT NULL DEFAULT '',
`userid` int( 10 ) unsigned NOT NULL DEFAULT '0',
`title` varchar( 250 ) NOT NULL DEFAULT '',
`dateline` int( 10 ) unsigned NOT NULL DEFAULT '0',
`pagetext` mediumtext,
`allowsmilie` smallint( 6 ) NOT NULL DEFAULT '0',
`showsignature` smallint( 6 ) NOT NULL DEFAULT '0',
`ipaddress` char( 15 ) NOT NULL DEFAULT '',
`iconid` smallint( 5 ) unsigned NOT NULL DEFAULT '0',
`visible` smallint( 6 ) NOT NULL DEFAULT '0',
`attach` smallint( 5 ) unsigned NOT NULL DEFAULT '0',
`infraction` smallint( 5 ) unsigned NOT NULL DEFAULT '0',
`reportthreadid` int( 10 ) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY ( `commentid` ) ,
KEY `userid` ( `userid` ) ,
KEY `postid` ( `postid` , `userid` ) ,
KEY `threadid` ( `threadid` ) ,
FULLTEXT KEY `title` ( `title` , `pagetext` )
)

MySQL said:

#1214 - The used table type doesn't support FULLTEXT indexes

update: notes i found claim fulltext only works with MyISAM and not innoDB. i am using mysql 5 so i like the innoDB for speed and scalability. guess i will have to get a different product.

secondly, @ HIVEDesigner, the intro description clearly states that the "diary" can only have enties by the thread creater; there is no "comment" capability.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01213 seconds Memory Usage 1,751KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: