vb.org Archive - Integration with vBulletin - Complete Wordpress/Vbulletin Bridge

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Integration with vBulletin - Complete Wordpress/Vbulletin Bridge - Share Users And Postings (https://vborg.vbsupport.ru/showthread.php?t=177625)

It seems like there's some issues here..

WordPress database error: [Unknown column 'vb_threadid' in 'field list']
select vb_threadid FROM posts where ID = '9'

thanks very much
* installed *:up:

Hi guys.

I've just bought vbulletin for a new project of mine where i want vbulletin and wordpress to work together.

So i've ofcourse come across this plugin but i have some questions i hope you guys can answer for me.

What i want is ONLY to have users synced. No post or comments. Just users. Is that possible with this plug in?

Will this plug in work with newer versions of both vbulletin and wordpress (with wp 2.7 coming up) (even though it seems it haven't been updated in over half a year).

Will this plugin be able to work with other wordpress comment altering plugins like the one from http://intensedebate.com?

Thanks for your time :)

I get this error

Quote:

Warning: require_once(DIR/includes/functions_newpost.php) [function.require-once]: failed to open stream: No such file or directory in /home/***/public_html/forums/includes/class_dm_threadpost.php on line 18

Fatal error: require_once() [function.require]: Failed opening required 'DIR/includes/functions_newpost.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/***/public_html/forums/includes/class_dm_threadpost.php on line 18

I tried removing DIR but that does nothing.

Any idea if this works with 3.8 and the new WP 2.7 series?

it's working with vb3.7.3 and beta wp2.7 but I haven't gotten the comments working like I want yet :(

Do you have a fix for the problem, that users with umlauts in their nicknames can't use the blog? It have been mentioned in here, but no one answered.
Both, blog and forum are UTF-8, so this can't be the problem.

Quote:

Originally Posted by Loco.M (Post 1678756)

it's working with vb3.7.3 and beta wp2.7 but I haven't gotten the comments working like I want yet :(

Could you elaborate more on the comments issue?

I don't seem to have the same strings in the Readme on my template for the comment system. Anyone wanna take crack at telling me what strings I'm suppose to replace?? I'd really appreciate it....

index.php

HTML Code:

<?php get_header(); ?>

<div class="entry">

    <?php if (have_posts()) : ?>

<?php $firstpostquery = new WP_Query('showposts=1'); ?>

    <?php while($firstpostquery->have_posts()) : $firstpostquery->the_post(); $firstpost = $post->ID; ?>



        <div class="post" id="post-<?php the_ID(); ?>">

            <h2><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>"><?php the_title(); ?></a></h2>

            <small>Written by <?php the_author() ?> on <abbr title="<?php the_time('Y-m-dTH:i:sO'); ?>"><?php unset($previousday); printf(__('%1$s – %2$s'), the_date('', '', '', false), get_the_time()) ?></abbr> - <?php if(function_exists('the_views')) { the_views(); } ?> </small><br /><br />

            <div class="line"></div>





                    <div class="postbg"><?php the_content('Read more &raquo;'); ?></div>



<br />

<?php the_tags('Tags: ', ', ', '<br />'); ?>Posted in <?php the_category(', ') ?> | <?php edit_post_link('Edit', '', ' | '); ?>  <?php comments_popup_link('No Comments »', '1 Comment »', '% Comments »'); ?><br />



<?php adsensem_ad('banner'); ?>



            </div>



<?php endwhile; ?>

<?php endif; ?>



<?php if (have_posts()) : ?>



        <?php $count=0; while (have_posts()) : the_post(); if(!($firstpost == $post->ID)) : ?>

<?php 

### Vbridge Call

$vbridge = Comment_Handler($post->ID); 

###

?>



        <?php if($count % 2 == 0) echo '<div class="left">'; else echo '<div class="right">'; ?>

        

            <div class="excerpt" id="post-<?php the_ID(); ?>">

                <h2><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>"><?php the_title(); ?></a></h2>

                <small><abbr title="<?php the_time('Y-m-dTH:i:sO'); ?>"><?php unset($previousday); printf(__('%1$s – %2$s'), the_date('', '', '', false), get_the_time()) ?></abbr> <!-- by <?php the_author() ?> --></small>

<div class="clear"></div>

            

                    <p><?php the_content_rss('', TRUE, '', 10) ; ?></p><div class="clear"></div>

                    

        <span class="smallies"><?php comments_popup_link('No Comments »', '1 Comment »', '% Comments »'); ?></span>

            </div>

        </div>

        <?php if($count % 2 != 0) echo '<div class="clear"></div>';?>



        <?php $count++; endif; ?>



        <?php  endwhile; ?>

        





        <div class="navigation">

            <div class="alignleft"><?php next_posts_link('&laquo; Older Entries') ?></div>

            <div class="alignright"><?php previous_posts_link('Newer Entries &raquo;') ?></div>

        </div>



    <?php else : ?>

        <div class="post">

        <h2 class="center search">Atlantic Anime could not find anything!</h2>

        <p class="center">Sorry, but you are looking for something that isn't here.</p>

        </div>

    <?php endif; ?>



    </div>

    <div>

<?php include (TEMPLATEPATH . '/topbar.php'); ?>

<div>

<?php include (TEMPLATEPATH . '/sidebar1.php'); ?>

<?php include (TEMPLATEPATH . '/sidebar2.php'); ?>

</div>

</div>

<br clear="all" />

<?php adsensem_ad('bottom'); ?>

<?php get_footer(); ?>

</div>

</body>

</html>

<!-- 60fe2dc8c122376d6564167ddb13db59mochiads.com -->

comment.php

HTML Code:

<?php // Do not delete these lines

    if ('comments.php' == basename($_SERVER['SCRIPT_FILENAME']))

        die ('Please do not load this page directly. Thanks!');



    if (!empty($post->post_password)) { // if there's a password

        if ($_COOKIE['wp-postpass_' . COOKIEHASH] != $post->post_password) {  // and it doesn't match the cookie

            ?>



            <p class="nocomments">This post is password protected. Enter the password to view comments.</p>



            <?php

            return;

        }

    }



    /* This variable is for alternating comment background */

    $oddcomment = 'class="alt" ';

?>



<!-- You can start editing here. -->



<?php if ($comments) : ?>

    <h3 id="comments"><?php comments_number('No Comments', 'One Comment', '% Comments' );?> to “<?php the_title(); ?>”</h3>



    <ol class="commentlist">



    <?php foreach ($comments as $comment) : ?>



        <li <?php echo $oddcomment; ?>id="comment-<?php comment_ID() ?>">

            <?php comment_author_link() ?> Says:

            <?php if ($comment->comment_approved == '0') : ?>

            <em>Your comment is awaiting moderation.</em>

            <?php endif; ?>

            <br />



            <small class="commentmetadata"><a href="#comment-<?php comment_ID() ?>" title=""><?php comment_date('F jS, Y') ?> at <?php comment_time() ?></a> <?php edit_comment_link('edit','&nbsp;&nbsp;',''); ?></small>



            <?php comment_text() ?>



        </li>



    <?php

        /* Changes every other comment to a different class */

        $oddcomment = ( empty( $oddcomment ) ) ? 'class="alt" ' : '';

    ?>



    <?php endforeach; /* end for each comment */ ?>



    </ol>



 <?php else : // this is displayed if there are no comments so far ?>



    <?php if ('open' == $post->comment_status) : ?>

        <!-- If comments are open, but there are no comments. -->



     <?php else : // comments are closed ?>

        <!-- If comments are closed. -->

        <p class="nocomments">Comments are closed.</p>



    <?php endif; ?>

<?php endif; ?>





<?php if ('open' == $post->comment_status) : ?>



<h3 id="respond">Leave a Comment</h3>



<?php if ( get_option('comment_registration') && !$user_ID ) : ?>

<p>You must be <a href="<?php echo get_option('siteurl'); ?>/wp-login.php?redirect_to=<?php echo urlencode(get_permalink()); ?>">logged in</a> to post a comment.</p>

<?php else : ?>



<form action="<?php echo get_option('siteurl'); ?>/wp-comments-post.php" method="post" id="commentform">



<?php if ( $user_ID ) : ?>



<p>Logged in as <a href="<?php echo get_option('siteurl'); ?>/wp-admin/profile.php"><?php echo $user_identity; ?></a>. <a href="<?php echo get_option('siteurl'); ?>/wp-login.php?action=logout" title="Log out of this account">Logout &raquo;</a></p>



<?php else : ?>



<p><input type="text" name="author" id="author" value="<?php echo $comment_author; ?>" size="22" tabindex="1" />

<label for="author"><small>Name <?php if ($req) echo "(required)"; ?></small></label></p>



<p><input type="text" name="email" id="email" value="<?php echo $comment_author_email; ?>" size="22" tabindex="2" />

<label for="email"><small>Mail (will not be published) <?php if ($req) echo "(required)"; ?></small></label></p>



<p><input type="text" name="url" id="url" value="<?php echo $comment_author_url; ?>" size="22" tabindex="3" />

<label for="url"><small>Website</small></label></p>



<?php endif; ?>



<!--<p><small><strong>XHTML:</strong> You can use these tags: <code><?php echo allowed_tags(); ?></code></small></p>-->



<p><textarea name="comment" id="comment" cols="100%" rows="10" tabindex="4"></textarea></p>



<p><input name="submit" type="image" src="<?php bloginfo('template_directory'); ?>/images/submit_button.jpg" id="submit" tabindex="5"/>

<input type="hidden" name="comment_post_ID" value="<?php echo $id; ?>" />

</p>

<?php do_action('comment_form', $post->ID); ?>



</form>



<?php endif; // If registration required and not logged in ?>



<?php endif; // if you delete this the sky will fall on your head ?>

I am going to update to WP 2.7 now, and see how it works (Running vB 3,7,2)

Working great as far as I can see with Wordpress 2.7 - still updating the site here www.ozsource.org if you want to see it working.

Thanks for all your hard work Jafo. Great Stuff.

This plugin seems like exactly what I need.
However, the only part of it that I really need to function, is syncing the users so they only have to login once.

If I start out in the forum, then click a link that takes me to the WP blog I can view the page just fine. But when I click on comments to try to leave a comment a "404 page cannot be found" error shows up.
Any help would be appreciated.

the blog site is: www.fatguysports.com/wp (because it's still in development, when it's finished it will move to the root) , forum - www.fatguysports.com/forum

I also only want it bridge users/groups as I will not be posting to my forum or posting comments outside the standard Wordpress comment system. How would I go about this?

Your installation instructions tell me to do all kinds of things and enter all kinds of data but it's overkill for what I want this to do.

I simply want people to be able to leave comments or post on our community blog (based on their vB group).

Any assistance would be appreciated!

Quote:

Originally Posted by wtb (Post 1683297)

The readme explains everything. Just ignore the comment replacement part of the Readme as it says. It will only map your primary vb usergroup by the way.

Is there any way to display online users (both from vbulletin and wordpress pages) in my homepage (which is the blog) based on cookies from vbulletin:)?

Lesterchans WP-UserOnline 2.40 should do it. http://lesterchan.net/portfolio/programming/php/ Some great wordpress plugins there.

Unexpected charset conversion pbr between Wordpress and vBulletin.
(I use Wordpress 2.7 but had also the pbr with 2.6.)

vBulletin (running for years) is using ISO 8859-1 and i had trouble with charset when publishing Wordpress post to vbulletin. Wordpress was configured for UTF-8 and i had to convert WP tables from UTF-8 to ISO and to set the charest to use into both wp-config.php and WP settings\reading\Charset.

Now everything is *almost* running fine :
- Creating a new post in Wordpress
- Publishing it in Wordpress
- Checking the posted version on vBulletin -> Characters with accents are OK "éàèç..."

But something unexpected happens when editing Wordpress posts :
- Editing a previously published post
- doing some changes to the post (including Title and Post content itself) & publishing it again
- Post's characters are OK into WP, Post's title is OK in vB but characters with accents are not showing anymore into post's content in vB.

E.g. :
- Creating a WP post with title="testing (êçà)" and content="testing (êçà)" -> Ok in vBulletin.
- Opening this post into WP and modifying it : title="testing (êçà) - edit" and content="testing (êçà) - edit" -> title will display correctly into vB but post's content will display "testing (?) - edit"

Copy/paste of this text in a new post and publishing it works. editing a post doesn't.

Any ideas ?

The installation instructions say:

"YOU MUST go to the options page before you do anything else. Click Options, then "Vbridge Options"."

I couldn't find this but did some hunting. You must click "Setting" and there you will see a vBridge Settings link. That is where options are - at least in this current version of WP.

KSB,

I am in the same boat.

vbull 3.7.X
WP 2.7

The first part of the comment addition, adding code to index, single and page .php files was easy enough, but the second part, where comment code needs to be changed to provided, I cannot id the appropriate code to replace.

I am using the wp default theme.

Thanks!
eric

Same here. No luck finding the appropriate code to replace...

Use firebug to locate the code involved:
http://getfirebug.com/

Great Mod.

Two quick questions.

1) Is it possible when a member logs in via the vb forums that if he goes to WP page it will show him as logged in there also?

2) Would it be possible to show PMs count (read and unread) on WP

Quote:

Originally Posted by AzzX (Post 1690082)

Use firebug to locate the code involved:
http://getfirebug.com/

Did you find it?

Does it work with Wordpress 2.7?

Quote:

Originally Posted by Shaliza (Post 1692777)

Does it work with Wordpress 2.7?

i have vb 3.7.4 and wp 2.7 and it works.

I have the same code as below. Any help? It's been 2 weeks since OP posted the request.

Quote:

Originally Posted by Ksb2050 (Post 1681704)

HTML Code:

<?php get_header(); ?>

<div class="entry">

    <?php if (have_posts()) : ?>

<?php $firstpostquery = new WP_Query('showposts=1'); ?>

    <?php while($firstpostquery->have_posts()) : $firstpostquery->the_post(); $firstpost = $post->ID; ?>



        <div class="post" id="post-<?php the_ID(); ?>">

            <h2><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>"><?php the_title(); ?></a></h2>

            <small>Written by <?php the_author() ?> on <abbr title="<?php the_time('Y-m-dTH:i:sO'); ?>"><?php unset($previousday); printf(__('%1$s – %2$s'), the_date('', '', '', false), get_the_time()) ?></abbr> - <?php if(function_exists('the_views')) { the_views(); } ?> </small><br /><br />

            <div class="line"></div>





                    <div class="postbg"><?php the_content('Read more &raquo;'); ?></div>



<br />

<?php the_tags('Tags: ', ', ', '<br />'); ?>Posted in <?php the_category(', ') ?> | <?php edit_post_link('Edit', '', ' | '); ?>  <?php comments_popup_link('No Comments ?', '1 Comment ?', '% Comments ?'); ?><br />



<?php adsensem_ad('banner'); ?>



            </div>



<?php endwhile; ?>

<?php endif; ?>



<?php if (have_posts()) : ?>



        <?php $count=0; while (have_posts()) : the_post(); if(!($firstpost == $post->ID)) : ?>

<?php 

### Vbridge Call

$vbridge = Comment_Handler($post->ID); 

###

?>



        <?php if($count % 2 == 0) echo '<div class="left">'; else echo '<div class="right">'; ?>

        

            <div class="excerpt" id="post-<?php the_ID(); ?>">

                <h2><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>"><?php the_title(); ?></a></h2>

                <small><abbr title="<?php the_time('Y-m-dTH:i:sO'); ?>"><?php unset($previousday); printf(__('%1$s – %2$s'), the_date('', '', '', false), get_the_time()) ?></abbr> <!-- by <?php the_author() ?> --></small>

<div class="clear"></div>

            

                    <p><?php the_content_rss('', TRUE, '', 10) ; ?></p><div class="clear"></div>

                    

        <span class="smallies"><?php comments_popup_link('No Comments ?', '1 Comment ?', '% Comments ?'); ?></span>

            </div>

        </div>

        <?php if($count % 2 != 0) echo '<div class="clear"></div>';?>



        <?php $count++; endif; ?>



        <?php  endwhile; ?>

        





        <div class="navigation">

            <div class="alignleft"><?php next_posts_link('&laquo; Older Entries') ?></div>

            <div class="alignright"><?php previous_posts_link('Newer Entries &raquo;') ?></div>

        </div>



    <?php else : ?>

        <div class="post">

        <h2 class="center search">Atlantic Anime could not find anything!</h2>

        <p class="center">Sorry, but you are looking for something that isn't here.</p>

        </div>

    <?php endif; ?>



    </div>

    <div>

<?php include (TEMPLATEPATH . '/topbar.php'); ?>

<div>

<?php include (TEMPLATEPATH . '/sidebar1.php'); ?>

<?php include (TEMPLATEPATH . '/sidebar2.php'); ?>

</div>

</div>

<br clear="all" />

<?php adsensem_ad('bottom'); ?>

<?php get_footer(); ?>

</div>

</body>

</html>

<!-- 60fe2dc8c122376d6564167ddb13db59mochiads.com -->

comment.php

HTML Code:

<?php // Do not delete these lines

    if ('comments.php' == basename($_SERVER['SCRIPT_FILENAME']))

        die ('Please do not load this page directly. Thanks!');



    if (!empty($post->post_password)) { // if there's a password

        if ($_COOKIE['wp-postpass_' . COOKIEHASH] != $post->post_password) {  // and it doesn't match the cookie

            ?>



            <p class="nocomments">This post is password protected. Enter the password to view comments.</p>



            <?php

            return;

        }

    }



    /* This variable is for alternating comment background */

    $oddcomment = 'class="alt" ';

?>



<!-- You can start editing here. -->



<?php if ($comments) : ?>

    <h3 id="comments"><?php comments_number('No Comments', 'One Comment', '% Comments' );?> to “<?php the_title(); ?>”</h3>



    <ol class="commentlist">



    <?php foreach ($comments as $comment) : ?>



        <li <?php echo $oddcomment; ?>id="comment-<?php comment_ID() ?>">

            <?php comment_author_link() ?> Says:

            <?php if ($comment->comment_approved == '0') : ?>

            <em>Your comment is awaiting moderation.</em>

            <?php endif; ?>

            <br />



            <small class="commentmetadata"><a href="#comment-<?php comment_ID() ?>" title=""><?php comment_date('F jS, Y') ?> at <?php comment_time() ?></a> <?php edit_comment_link('edit','&nbsp;&nbsp;',''); ?></small>



            <?php comment_text() ?>



        </li>



    <?php

        /* Changes every other comment to a different class */

        $oddcomment = ( empty( $oddcomment ) ) ? 'class="alt" ' : '';

    ?>



    <?php endforeach; /* end for each comment */ ?>



    </ol>



 <?php else : // this is displayed if there are no comments so far ?>



    <?php if ('open' == $post->comment_status) : ?>

        <!-- If comments are open, but there are no comments. -->



     <?php else : // comments are closed ?>

        <!-- If comments are closed. -->

        <p class="nocomments">Comments are closed.</p>



    <?php endif; ?>

<?php endif; ?>





<?php if ('open' == $post->comment_status) : ?>



<h3 id="respond">Leave a Comment</h3>



<?php if ( get_option('comment_registration') && !$user_ID ) : ?>

<p>You must be <a href="<?php echo get_option('siteurl'); ?>/wp-login.php?redirect_to=<?php echo urlencode(get_permalink()); ?>">logged in</a> to post a comment.</p>

<?php else : ?>



<form action="<?php echo get_option('siteurl'); ?>/wp-comments-post.php" method="post" id="commentform">



<?php if ( $user_ID ) : ?>



<p>Logged in as <a href="<?php echo get_option('siteurl'); ?>/wp-admin/profile.php"><?php echo $user_identity; ?></a>. <a href="<?php echo get_option('siteurl'); ?>/wp-login.php?action=logout" title="Log out of this account">Logout &raquo;</a></p>



<?php else : ?>



<p><input type="text" name="author" id="author" value="<?php echo $comment_author; ?>" size="22" tabindex="1" />

<label for="author"><small>Name <?php if ($req) echo "(required)"; ?></small></label></p>



<p><input type="text" name="email" id="email" value="<?php echo $comment_author_email; ?>" size="22" tabindex="2" />

<label for="email"><small>Mail (will not be published) <?php if ($req) echo "(required)"; ?></small></label></p>



<p><input type="text" name="url" id="url" value="<?php echo $comment_author_url; ?>" size="22" tabindex="3" />

<label for="url"><small>Website</small></label></p>



<?php endif; ?>



<!--<p><small><strong>XHTML:</strong> You can use these tags: <code><?php echo allowed_tags(); ?></code></small></p>-->



<p><textarea name="comment" id="comment" cols="100%" rows="10" tabindex="4"></textarea></p>



<p><input name="submit" type="image" src="<?php bloginfo('template_directory'); ?>/images/submit_button.jpg" id="submit" tabindex="5"/>

<input type="hidden" name="comment_post_ID" value="<?php echo $id; ?>" />

</p>

<?php do_action('comment_form', $post->ID); ?>



</form>



<?php endif; // If registration required and not logged in ?>



<?php endif; // if you delete this the sky will fall on your head ?>

The readme instructions seem outdated.

But requirements are:
Stable Wordpress Version greater than or equal to 2.5.

None of my wp 2.7 codes changes seem to match.

Can someone guide us through?

Make sure you are editing your template files not the wordpress php files.

None of my 2.7 codes seem to match either

I think we are all OK up until part two of "IF YOU WANT TO USE VB For comments:" from the readme.

From there!

Code to swap out is NOT the same in all themes.

Using the default theme, line 34 of the index.php file. Swap that out with code provided in the readme.

The code to swap out looks like this:

<?php the_tags('Tags: ', ', ', '<br />'); ?> Posted in <?php the_category(', ') ?> | <?php edit_post_link('Edit', '', ' | '); ?> <?php comments_popup_link('No Comments »', '1 Comment »', '% Comments »'); ?>

With the classic theme it is line 23 of the index.php file, and there it reads identical to the content of the readme file.

In a custom theme I have the code is also in the index.php file, reads identical to the code in the default theme, the code above.

woohoo!
eric

love the mod, and I want to use VB for comments as well.
Do I disable the comments on WP after inserting the codes?

Also, Im inserting these in the vbulletin or wordpress templates? I have the new blog posts showing up in the forum, but am having a time getting the comments to work. What am I doing wrong?

Here is an interesting question. I'd like to use this modification on Wordpress MU but my site will only have one user table. I have multiple "blogs" but only for the admin user and nobody else. I just want to have the user directory in sync and don't plan on offering blogs to any of my users. Has anyone been able to successfully install this with MU installed with only the main user table?

Actually, I have gotten it to work. The only problem I'm having is that when the plugin is enabled, you can't login to WP and keep getting redirected to the forums URL.

Excellent Plug-in, Jafo, thank you for creating and sharing it.

XMan, I am receiving the same issue as you are.

When posting a blog article for the first time into VB, the encoding is fine.

But then, when editing a WP article, all of the characters do not translate to the edited version of the blog post in VB.

When WP was UTF-8, and VB was ISO 8859-1, question marks ("), the and symbol (&), and apostrophes (') converted to "?" in VB when I edited a WP post in WP.

So, I decided to change both WP and VB encoding to UTF-8 (since I have read that this is more universally used), and now edited WP posts post all characters OK, except for the "&" symbol, which displays in the edited VB post as "&"

Again, I really appreciate the Plug-in, and this is going to be very useful for both my WP and VB installations.

I haven't activated the User Bridge or WP comment bridge yet, but I will try to activate and test this within a few days.

For now, I love the fact that my WP blogs post in VB, and that when I edit a WP blog post, the edits appear in the same VB post as well, without impacting VB replies to that bridged WP article.

Khashyar

Quote:

Originally Posted by XManuX (Post 1686587)

Unexpected charset conversion pbr between Wordpress and vBulletin.
(I use Wordpress 2.7 but had also the pbr with 2.6.)

vBulletin (running for years) is using ISO 8859-1 and i had trouble with charset when publishing Wordpress post to vbulletin. Wordpress was configured for UTF-8 and i had to convert WP tables from UTF-8 to ISO and to set the charest to use into both wp-config.php and WP settings\reading\Charset.

Now everything is *almost* running fine :
- Creating a new post in Wordpress
- Publishing it in Wordpress
- Checking the posted version on vBulletin -> Characters with accents are OK "????..."

But something unexpected happens when editing Wordpress posts :
- Editing a previously published post
- doing some changes to the post (including Title and Post content itself) & publishing it again
- Post's characters are OK into WP, Post's title is OK in vB but characters with accents are not showing anymore into post's content in vB.

E.g. :
- Creating a WP post with title="testing (???)" and content="testing (???)" -> Ok in vBulletin.
- Opening this post into WP and modifying it : title="testing (???) - edit" and content="testing (???) - edit" -> title will display correctly into vB but post's content will display "testing (?) - edit"

Copy/paste of this text in a new post and publishing it works. editing a post doesn't.

Any ideas ?

I have installed Wordpress and vBulletin in two different MySQL databases. WordPress is ver 5.0, and vBulletin is sql ver 4.1.

To make this work, do I have to combine the two databases? Any tips on how to go about doing that? Which database should be the combined one?

Thank you!

Hi Cadre,

I have wordpress and VB in two seperate MYSQL databases (I believe that is standard)...

As long as the databases are in the same domain, then you should be fine.

It's a pretty easy install.

Khashyar

Quote:

Originally Posted by Candrews9 (Post 1697273)

Quote:

Table 'dalailamaforum.wp_terms' doesn't exist

The "My Category Order" Plugin should be accessing the DB table "wordpress.wp_terms," and so it looks like the WP/VB Bridge changed the database name reference in Wordpress to the VB database name without changing the database name to "wordpress."

I "Deactivated" the WP/VB bridge plugin to see if it was the casue of the error, and the error went away when I did.

My temporary work-around is when I want to change the order of categories, I deactive the WP/VB Bridge plugin, change the category order through "My Category Order" plug-in, and then reactivate the WP/VB Bridge again.

So, the two errors that I have found so far are:

1) WP/VB Bridge changes the reference to the database name in Wordpress (to the VB database name) without changing it back to the Wordpress database name after the WP/VB Bridge plugin is finished with its process.

2) When a post is edited in Wordpress, some characters do not import correctly into the corresponding VB post.

I do appreciate this plugin, and thank anyone who can help find fixes to these two bugs.

Khashyar

Quote:

Originally Posted by Khashyar (Post 1697563)

Hi Everyone,

Again, I appreciate the effort that went into this plugin, and that Jafo is sharing it with all of us.

Everything seemed to be working fine with VB Bridge installed, and WP posts are posting correctly into the VB forum I chose.

However, today, I just noticed what I think is a bug: I also have "My Category order" plugin installed in WordPress (so that I can change the order of my categories in WP), but when I tried to change the order of categories again (after VB Bridge was installed), I received this error in Wordpress:

The "My Category Order" Plugin should be accessing the DB table "wordpress.wp_terms," and so it looks like the WP/VB Bridge changed the database name reference in Wordpress to the VB database name without changing the database name to "wordpress."

Using the exact same wordpress plugin here www.ozsource.org but not experiencing that issue. A strange one.

That is odd, Azz.

I haven't modified any code in either software.

I wonder if this particular error is a result of the WP theme that I chose (I believe that each theme has its own corresponding .php files.

Are you experiencing the same edit issue that Xman and I are where some characters don't migrate correctly to VB?

Khashyar

QUOTE=AzzX;1698889]Using the exact same wordpress plugin here www.ozsource.org but not experiencing that issue. A strange one.[/QUOTE]

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02660 seconds Memory Usage 1,963KB 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 (4)bbcode_html_printable (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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: