This website can use cookies to improve the user experience

This website can use cookies to improve the user experience and to provide certain services and functions to users. Cookies contain small amounts of information (such as login information and user preferences) and will be stored on your device.

Enable All Cookies Privacy Policy

vBulletin 3 integration


avatar
jfranco 0
From: -
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

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic


1 Re: vBulletin 3 integration
avatar
Administrator
1342
From: Austria
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?

I don’t know. It seems this error appears only under some circumstances. I am currently trying to figure out what it cause.

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?

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.
1 Re: vBulletin 3 integration
avatar
OP 0
From: -
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?
1 Re: vBulletin 3 integration
avatar
Administrator
1342
From: Austria
vBulletin 3 integration

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

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?

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?

The post form will not show up if you choose a forum for the comments. This is mainly to promote the forum.
1 Re: vBulletin 3 integration
avatar
OP 0
From: -
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
1 Re: vBulletin 3 integration
avatar
Administrator
1342
From: Austria
vBulletin 3 integration

Thanks Julio. Look like this field was introduced in vB 3.6. I will fix this problem in next release.

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.