vBulletin 3 integration
jfranco 0
From: -
From: -
Notice
This topic is archived. New comments cannot be posted and votes cannot be cast.Responses to this topic
1 Re: vBulletin 3 integration
Philipp
From: Austria
Administrator
1342From: Austria
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.
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
jfranco
OP
0
From: -
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?
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
Philipp
From: Austria
Administrator
1342From: Austria
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.
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
jfranco
OP
0
From: -
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
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
Philipp
From: Austria
Administrator
1342From: Austria
vBulletin 3 integration
Thanks Julio. Look like this field was introduced in vB 3.6. I will fix this problem in next release.
Thanks Julio. Look like this field was introduced in vB 3.6. I will fix this problem in next release.
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