vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - vBonjour - Portal System (https://vborg.vbsupport.ru/showthread.php?t=133757)

Lionel 01-21-2007 11:36 PM

I know of some ISP in the US blocking entire countries like India, but I would never thought of England blocking the US. Specially that my provider is one of the top in Miami.

Maybe someone else could provide me a link??

ryansmith 01-22-2007 01:36 AM

Does this work with the default styles I already have set, or does it install its own style like vBPortal? I purchased vBPortal but then realized I had to use their default styles and templates, so my theme (TvB Curves) wouldn't work with it.

I'm looking for a way to add navigation modules and such to my site without having to try and edit too many templates and such.

Ryan

Zowners 01-22-2007 01:41 AM

i installed it but iam getting this
I already played around with the forum id, but still no luck
iam using the 1.0.2

PHP Code:

Database error in vBulletin 3.6.0:

Invalid SQL:
 
        
SELECT t.threadidt.titlet.lastpostt.forumidt.opent.replycountt.postusernamet.postuseridt.lastpostert.datelinet.viewst.visiblet.firstpostidf.title AS forumtitlepost.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 AND visible 1
        ORDER BY dateline DESC 
        LIMIT 3
;

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


Glynn58 01-22-2007 03:57 AM

Quote:

Originally Posted by LePaul (Post 1164639)
Rather than slam a newbie, you could've either said nothing, or said something that might've helped a bit.

Its ok. Someday you'll need help with something. And I hope you get this sort of snotty response.

sorry you took this the wrong way it was never intended as a snotty remark , i am a newbie and that was the point i was trying to make, before jump in the deep end try out a few of the easier mods and learn a bit about the system thats what i'm doing, i'd love this mod and i'm following its progress but until i'm confident i can install it without destroying my board i'll watch and learn

almac 01-22-2007 04:56 AM

Quote:

Originally Posted by Zowners (Post 1164716)
i installed it but iam getting this
I already played around with the forum id, but still no luck
iam using the 1.0.2

PHP Code:

Database error in vBulletin 3.6.0:

Invalid SQL:
 
        
SELECT t.threadidt.titlet.lastpostt.forumidt.opent.replycountt.postusernamet.postuseridt.lastpostert.datelinet.viewst.visiblet.firstpostidf.title AS forumtitlepost.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 AND visible 1
        ORDER BY dateline DESC 
        LIMIT 3
;

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




I get the same problem.

peterska2 01-22-2007 05:02 AM

Quote:

Originally Posted by Zowners (Post 1164716)
i installed it but iam getting this
I already played around with the forum id, but still no luck
iam using the 1.0.2

PHP Code:

Database error in vBulletin 3.6.0:

Invalid SQL:
 
        
SELECT t.threadidt.titlet.lastpostt.forumidt.opent.replycountt.postusernamet.postuseridt.lastpostert.datelinet.viewst.visiblet.firstpostidf.title AS forumtitlepost.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 AND visible 1
        ORDER BY dateline DESC 
        LIMIT 3
;

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


Quote:

Originally Posted by almac (Post 1164797)
I get the same problem.

Quote:

Originally Posted by Kerry-Anne (Post 1163806)
I've put version 1.0.1 back up.

Those who are having problems with 1.0.2 - is your vBonjour in your forum directory or are your forums located in a directory and the vBonjour file in the site root?

Also, everyone who is getting any errors, please confirm if you are using PHP & MySQL 4 or 5 along with full details of all errors being received.

Please see this post and provide the information requested

peterska2 01-22-2007 05:04 AM

Quote:

Originally Posted by ryansmith (Post 1164715)
Does this work with the default styles I already have set, or does it install its own style like vBPortal? I purchased vBPortal but then realized I had to use their default styles and templates, so my theme (TvB Curves) wouldn't work with it.

I'm looking for a way to add navigation modules and such to my site without having to try and edit too many templates and such.

Ryan

This works with your normal styles and does not need anything special, apart from maybe a couple of minor tweaks.

almac 01-22-2007 05:12 AM

Code:


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

peterska2 01-22-2007 05:15 AM

Thank you. When I get home from college later I'll run a test install onto a different setup on one of my test boards and see what is going on.

Zowners 01-22-2007 02:45 PM

I have everything in the forum directory
iam using php 5.1.2 and mysql 5.0.24a-standard-log


All times are GMT. The time now is 01:12 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01391 seconds
  • Memory Usage 1,780KB
  • 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
  • (1)bbcode_code_printable
  • (3)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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