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)
-   -   vBindex v3.0.0 RC5 (https://vborg.vbsupport.ru/showthread.php?t=59524)

EscortCossie 03-23-2005 05:46 PM

I have read a lot of the pages in this thread and I still can't see one single answer to the database error many people suffer from.

Here it is once again.. Please help. :)

Code:

Database error in vBulletin 3.0.6:

Invalid SQL:
                ## GET NEWS ##
                SELECT thread.*,thread.iconid AS threadiconid, threadpost.pagetext AS pagetext,
                threadpost.attach AS attachcount,
                avatarpath, NOT ISNULL(avatardata) AS customavatar, user.avatarrevision, customavatar.dateline AS customdateline,
               
                IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
                FROM thread AS thread
                LEFT JOIN user AS user ON (thread.postuserid = user.userid)
                LEFT JOIN post AS threadpost ON (thread.firstpostid = threadpost.postid)
                LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
               
                LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
                LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
               
                WHERE forumid IN ()
                AND deletionlog.primaryid IS NULL
                AND forumid NOT IN (0)
                AND thread.open <> 10
                AND thread.visible = '1'
               
               
                ORDER BY thread.sticky DESC, thread.dateline DESC
                LIMIT 5
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
                AND deletionlog.primaryid IS NULL
                AND forumid NOT IN (0

mysql error number: 1064

Date: Wednesday 23rd of March 2005 02:38:15 PM
Script: http://www.escortpower.net/vbindex.php?
Referer: http://www.escortpower.net/vbindex.php?styleid=6


Jacuma 03-24-2005 12:24 AM

Installed

jbear6 03-26-2005 02:52 PM

Works like a charm on vB 3.0.7

Thanks :up:

Scerina 03-26-2005 11:53 PM

I just installed vbindex and I have two calendars and no shoutbox. And I have shoutbox enabled as well as the calendar. Can someone help me out here?

pbw 03-28-2005 06:29 PM

This is excellent, i really like it. Install was a synch, i'm curious however if it's possible to list the forums on vbindex.php. I've searched through these forums for an answer a fair bit, but was unsuccessful

Basically what i'd like is the nice welcome box, various sidebars and news on forumhome. Having the regular index.php forum display below.

Any ideas or tips?

Thanks

AKOYLINI 03-30-2005 10:02 AM

Warning: main(): Unable to access ./http://www.greek-music-mania.com/test/forums/admincp/functions_vbiupgrade.php in /admincp/vbiupgrade.php on line 57

Warning: main(./http://www.greek-music-mania.com/test/forums/admincp/functions_vbiupgrade.php): failed to open stream: No such file or directory in /admincp/vbiupgrade.php on line 57

Fatal error: main(): Failed opening required './http://www.greek-music-mania.com/test/forums/admincp/functions_vbiupgrade.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /usr/home/greekmm/public_html/test/forums/admincp/vbiupgrade.php on line 57

can you help me please?i take this error when try isntall vbindex

T3MEDIA 03-30-2005 12:38 PM

Quote:

Originally Posted by pbw
This is excellent, i really like it. Install was a synch, i'm curious however if it's possible to list the forums on vbindex.php. I've searched through these forums for an answer a fair bit, but was unsuccessful

Basically what i'd like is the nice welcome box, various sidebars and news on forumhome. Having the regular index.php forum display below.

Any ideas or tips?

Thanks

no that is alot of html template modding.
take a look at bpcompanion.com/vbindex.php is that what you mean?

SmartGnome 03-30-2005 02:36 PM

Thanks for the portal and Install ist clicked :jump

Sleepyk 04-01-2005 01:07 AM

if i use this hack what bout hacks i have on vb 3.0.7 is it gonna conflict? also isnt this like postnuke type stuff but with vb3 on it?

khaleel 04-01-2005 05:25 PM

*clicks install*

oops

Code:

Warning: chdir(): No such file or directory (errno 2) in /home/deathea/public_html/forum/vbindex.php on line 144
Line 144 reads
Code:

chdir(CHDIR_PATH);
and in vbiconfig the CHDIR code is

Code:

// enter the path to your forums here that you were given during the// install processdefine('CHDIR_PATH', '/home/deathea/public_html/forum');


All times are GMT. The time now is 01:16 AM.

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.03490 seconds
  • Memory Usage 1,745KB
  • 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_code_printable
  • (1)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