vBulletin 3 integration Hi Philipp, I recently tried to add a news story that would post into a vbulletin forum for effective comment integration and received the following error: Query: INSERT INTO thread (threadid, title, firstpostid, lastpostid, lastpost, forumid, pollid, open, replycount, hiddencount, deletedcount, postusername, postuserid, lastposter, dateline, views, iconid, notes, visible, sticky, votenum, votetotal, attach, similar) VALUES (NULL, 'Yahoo sued by own investors over MS bid rejection', '0', '0', '1203902109', '7', '0', '1', '0', '0', '0', 'Julio Franco', '0', 'Julio Franco', '1203902109', '0', '0', '', '1', '0', '0', '0', '0', '') Error: 1054 Unknown column 'lastpostid' in 'field list' As far as I can recall I have not made any modifications to the vbulletin tables or database. I run vB 3.5.4 Best Julio
vBulletin 3 integration Thanks Julio. Look like this field was introduced in vB 3.6. I will fix this problem in next release.
vBulletin 3 integration Philipp, I upgraded to vbulletin 3.6 in my local copy to see how the integration worked. I was able to post a news topic opening a new thread on vB at the same time. When I commented that story from vB, I got the following error when trying to see the contentteller individual story page: Query: SELECT userid FROM customavatar WHERE userid IN() Error: 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 ')' at line 1 Besides that problem, I also noticed there is no comment post form in contentteller but you are redirected to vbulletin to post a comment, is this the way you meant it to work or you plan to make it all integrated? Thanks Julio
vBulletin 3 integration Another customer report also the same error but it disappeared after a reinstall. Is your test installation using the data of your current forum or is it a fresh install? The post form will not show up if you choose a forum for the comments. This is mainly to promote the forum.
vBulletin 3 integration I'm using a copy of my forum that I later upgraded to the latest version of vBulletin (3.6.x), the idea was to preserve all settings. Was that fixed with a CT or vB clean install? As for the comments within the main site, do you plan at some point making it all integrated so you can post from either location and still add the information to the vbulletin database? At first instance I had assumed you had it setup like that, and would be the most logical and user friendly way to do it... perhaps you could look into it?
vBulletin 3 integration I don’t know. It seems this error appears only under some circumstances. I am currently trying to figure out what it cause. It is overall not that easy after it will require a lot of new routines. Basically, I need to write a post/edit/moderation function and routines to get and parse bbcode, smilies etc. Additionally, it is also not possible to integrate the vBulletin WYSIWYG editor.
