Major Additions - vBonjour - Portal System

vBonjour

Easy Customizable Portal System

Brought to you by www.peterska2.co.uk

Welcome to the launch of vBonjour. This is the base package which is required for all installations of this system.

What is vBonjour?
vBonjour is an alternative to vBAdvanced. It is an easy to install, modular portal system designed as a gateway to your site.

Why vBonjour?
This is pretty simple really. As the front page is the first thing that your visitors see, it is a welcome page. The first few names that were thought of were either very boring, or far too long winded and not at all catchy.

This is a base package. What is included?
The base package includes a news feature from up to two forums. The news from the first forum will be displayed first, followed by the news from the second forum. It also includes the left and right columns which can be activated or deactivated via some simple settings in the ACP. These columns can be customised without using any of the Add On Modules, or Add On Modules can be installed to expand on the functionality.

Why is it so modular?
vBonjour is extremely modular to allow for maximum customization of the page. The idea is to make it as easy as possible to install the items that you want to have included, and not have anything which you would be simply turning off. By using a modular method it means that every site can easily achieve their own custom portal without having to know any coding.

I want to add something that isn't already included. How do I go about this?
vBonjour makes use of the plugin system and includes it's own hooks. This allows easy devlopment of additional Add Ons and maximum flexability.

What about the ACP? Is it really complicated?
Unlike other systems, almost all the settings for vBonjour are collected in one setting group in the vBOptions. Because you only install what you want to use, you don't need to have lots of settings. Anything which does not use settings in the Portal settings group is highlighted in the documentation for that Add On.

Ok, so where are the screen shots?
Why have screen shots when you can have a live demo?
The demo is available at www.peterska2.co.uk

What versions of vBulletin does vBonjour work with?
vBonjour will work with vBulletin 3.6.0 and above. Support for sites running versions earlier than 3.6.0 will not be given.



Contributers to the base system: [name]christianb[/name]


I hope that you like this system. Please remember to mark it as installed to recieve notification of updates and support. Support will only be provided to those who have clicked install.

[Glynn58]

Originally Posted by almac

Database error in vBulletin 3.6.2:

Invalid SQL:
 
		SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle, post.pagetext AS preview 
		FROM forum f 
		INNER JOIN thread t ON t.forumid = f.forumid
		LEFT OUTER JOIN post AS post ON post.postid = t.firstpostid WHERE t.forumid = 82 AND visible = 1
		ORDER BY dateline DESC 
		LIMIT 10;

MySQL Error  : Column 'visible' in where clause is ambiguous
Error Number : 1052
Date         : Monday, January 22nd 2007 @ 01:10:59 AM
Referrer     : 
IP Address   : 72.234.55.40
Username     : Jesse
Classname    : vb_database

Running on:
PHP version 4.4.3
MySQL 4.1.21-standard


And its in my root.
MySQL version 4.1.21-standard

I installed today and got the same error.

Looking at portal.php I could see a difference from Getnews 1 & Getnews 2

Get News 2 looks like this

PHP Code:

if (forumid2) {
    $getnews2 = $db->query_read(" 
        SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle, post.pagetext AS preview 
        FROM " . TABLE_PREFIX . "forum f 
        INNER JOIN " . TABLE_PREFIX . "thread t ON t.forumid = f.forumid
        LEFT OUTER JOIN " . TABLE_PREFIX . "post AS post ON post.postid = t.firstpostid WHERE t.forumid = " . $forumid2 . " AND visible = 1 


the very last bit is the problem
change it to

PHP Code:

t.visible = 1 


That cured this error for me.

However I now have the left sidebox displaying full page width. Then the news items and then the right side box all full width.
Any ideas?

[Glynn58]

In the news posts the formatting tags are showing in the posts on the portal page.

http://www.touring-camping.co.uk/forum/portal.php

index.php is still the forum home page at the moment as we don't want it going live until we fix these issues.

[Forza]

I have my forum in a subdomain and I want to use this portal for my main root. But i keep getting the 'Invalid forum path specified' error.

This is the line i used in the index.php:

$forumpath = '/var/www/vhosts/musicinjection.net/subdomains/forum/httpdocs';

any suggestions?

[osso12]

Originally Posted by hIBEES

Sort off worked lol

As soon as I change the forum ID and have a forum ID in the " Forum ID
Specify the second (optional) forum id where you want your news to come from. " section I get the error again...

Working just now thou so thanks :up:

I am having this same exact problem.
Every time I add a forum to the second forum ID I get the SQL error.
If I remove the second forum ID, the problem goes away...
I did the fix on line 62 and 116 that was recommended, but that still did not solve the issue.
Anyone?
Thanks!
Great Mod BTW!

[captainslater]

Invalid SQL:

SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle, post.pagetext AS preview
FROM forum f
INNER JOIN thread t ON t.forumid = f.forumid
LEFT OUTER JOIN post AS post ON post.postid = t.firstpostid WHERE t.forumid = 5 AND visible = 1
ORDER BY dateline DESC
LIMIT 3;

MySQL-Fehler : Column 'visible' in where clause is ambiguous
Fehler-Nr. : 1052

OS: Linux
PHP: 5.0.4
MySQL 4.1.4

Installed in forum root

[Glynn58]

Originally Posted by captainslater

OS: Linux
PHP: 5.0.4
MySQL 4.1.4

Installed in forum root

Change the bit in red to t.visible = 1 in portal.php

Worked for us

[goodguy]

Fist time trying to install anything like this so I might just be missing something out, I'm gretting this error.

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle, post.pagetext AS preview
FROM forum f
INNER JOIN thread t ON t.forumid = f.forumid
LEFT OUTER JOIN post AS post ON post.postid = t.firstpostid WHERE t.forumid = 0 AND visible = 1
ORDER BY dateline DESC
LIMIT 3;

MySQL Error : Column 'visible' in where clause is ambiguous
Error Number : 1052

Can anyone help me? T.I.A.

[peterska2]

I'm releasing an update later today which will address the database error (and maybe a couple of other minor things if I get time to code them in).

[goodguy]

Originally Posted by Kerry-Anne

I'm releasing an update later today which will address the database error (and maybe a couple of other minor things if I get time to code them in).

Thanks, I thought I had broke it.

[peterska2]

Update

vBonjour version 1.0.3 has been released which fixes the bugs in 1.0.2 which were causing database errors.