vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vBadvanced Homepage (https://vborg.vbsupport.ru/showthread.php?t=59803)

infiniterb 01-28-2004 01:39 AM

I'm not getting the dates to display on the front page with version 1.1. Any ideas?

The site www.clantt.com

dpakman91 01-28-2004 01:39 AM

quick question: when i installed vba, my list of members, posts and threads as well as "who's online" went to the main index page...this is fine, however, what can i do to ALSO have it at the bottom of my forum listing page like it was before?

one other thing is that with IE (does not happen with netscape), i have red x's for certain icons and i can't figure out where to fix it. it is hard to explain, but you can see it here:

http://www.thevividedge.com/forum/forumdisplay.php?f=15

really frusrated with it so any help would be great.

CarolinaKid 01-28-2004 02:05 AM

Can Anyone help me with this. Did not have till i upgraded to 1.1 amd yes i added the function.php edit
Code:

Database error in vBulletin 3.0.0 Release Candidate 3:
 
Invalid SQL: SELECT thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
  , thread.iconid AS threadiconid
    ,thread.forumid, forum.title AS forumtitle
    , post.pagetext AS preview
    , NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
    FROM thread as thread
    LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
    LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
    LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 175)
    WHERE open <> '10' AND forumid NOT IN(76) AND deletionlog.primaryid IS NULL
    ORDER BY lastpost DESC
    LIMIT 10
mysql error: Column: 'forumid' in where clause is ambiguous
 
mysql error number: 1052


Tigga 01-28-2004 02:05 AM

FastAttack - Could you explain your problems in a little more depth? What exactly do you mean by "can't sustain the users"? How exactly does it act differently when outside of the forums directory?
I did notice that the page seems to fluctuate in loading times though... Sometimes it loaded in less than 1/2 second, others it took up to 3. If you could add this line of code to your include/config.php file:

if ($_SERVER['REMOTE_ADDR'] == '24.99.20.118') { $debug = 1; }

That will turn on debug mode only for my IP address. If you could add that I will be glad to take a look at the queries and such to see if I can find out why it's behaving like that.
As far as new blocks, I may make it a little easier to add / manage new ones, but I don't think I'll go too far with that on this script. It should be fairly easy to copy one of the custom templates and past it in your index template where you would like it to appear as long as you know basic HTML. I will eventually have a CMS / Portal available for purchase which will be much more powerful and have features like this as well.
What exactly do you mean by "pull out the header/ and blocks using a regular php page"? If you're trying to display your header & side blocks with other content in the center, take a look in the readme file - it's explained there how to do that. If that's not what you mean please explain it in a little more detail.

infiniterb - Try saving your options in the Admin CP. There's a new option to set the time/date format for the news there. That, and the other new options won't take affect until after they've been saved.

FastAttack 01-28-2004 02:08 AM

Do you have an IM so I can explain myself a little bit more in detail.. I know sometimes I don't make any sense ( bad habit its called brain storming of what i think is going on)

FastAttack 01-28-2004 02:23 AM

you been pm'd btw Tigga..

infiniterb 01-28-2004 02:38 AM

Carolinakid, I just got the same thing on my board.

Zachery 01-28-2004 02:38 AM

Quote:

Originally Posted by CarolinaKid
Can Anyone help me with this. Did not have till i upgraded to 1.1 amd yes i added the function.php edit
Code:

Database error in vBulletin 3.0.0 Release Candidate 3:
 
Invalid SQL: SELECT thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
  , thread.iconid AS threadiconid
    ,thread.forumid, forum.title AS forumtitle
    , post.pagetext AS preview
    , NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
    FROM thread as thread
    LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
    LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
    LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 175)
    WHERE open <> '10' AND forumid NOT IN(76) AND deletionlog.primaryid IS NULL
    ORDER BY lastpost DESC
    LIMIT 10
mysql error: Column: 'forumid' in where clause is ambiguous
 
mysql error number: 1052


did you just upgrade from vB2 ?

infiniterb 01-28-2004 02:40 AM

Faranth, I can tell you that I didn't upgrade from vb2 recently. I've had vb3 for awhile now. All I did was save the changes from the control panel for vbadvance and it started to send these errors to me.

CarolinaKid 01-28-2004 02:46 AM

Quote:

Originally Posted by infiniterb
Faranth, I can tell you that I didn't upgrade from vb2 recently. I've had vb3 for awhile now. All I did was save the changes from the control panel for vbadvance and it started to send these errors to me.

like infiniterb all i did was upgraded my vbadvance to 1.1 and saved changes in control pannel
* I am running Vb3 RC3 and have been sence it came out.*


All times are GMT. The time now is 11:40 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.01635 seconds
  • Memory Usage 1,748KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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