vb.org Archive
Page 15 of 26 « First 51314 15 161725 Last »
Show 40 post(s) from this thread on one page

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)

Glynn58 01-25-2007 09:13 AM
Quote:
Originally Posted by almac (Post 1164814)
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
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 01-25-2007 09:44 AM
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 01-25-2007 02:19 PM
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:

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

any suggestions?

osso12 01-25-2007 02:56 PM
Quote:
Originally Posted by hIBEES (Post 1162965)
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 :D :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 01-25-2007 06:59 PM
Quote:
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 01-25-2007 09:30 PM
Quote:
Originally Posted by captainslater (Post 1167207)
Quote:
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
Change the bit in red to t.visible = 1 in portal.php

Worked for us

goodguy 01-27-2007 11:21 AM
Fist time trying to install anything like this so I might just be missing something out, I'm gretting this error.

Quote:
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 01-27-2007 12:41 PM
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 01-27-2007 01:31 PM
Quote:
Originally Posted by Kerry-Anne (Post 1168304)
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. :eek:

peterska2 01-27-2007 03:52 PM
Update

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


All times are GMT. The time now is 02:20 PM.
Page 15 of 26 « First 51314 15 161725 Last »
Show 40 post(s) from this thread on one page

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.01471 seconds
  • Memory Usage 1,755KB
  • 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
  • (2)bbcode_code_printable
  • (2)bbcode_php_printable
  • (7)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