vb.org Archive - vBindex v3.0.0 RC5

Page 57 of 62

« First

Last »

Show 40 post(s) from this thread on one page

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

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');

RichieBoy67

04-03-2005 01:09 AM

I got the same error..... I don't think it works with 07.....

dkny	04-03-2005 07:37 AM

is there a way to day "Upcoming Events" where it would post events on the in the block or in the middle the events coming up in the next 5 days?

I tried to mod it myself but having no luck

khaleel

04-03-2005 11:13 AM

Quote:

I got the same error..... I don't think it works with 07.....

__________________

No I dont think it does im afraid

GriffinsCreeps

04-04-2005 07:55 AM

Well... My problem is, that it doesn't import the phrases :(

SmartGnome

04-04-2005 10:50 AM

Quote:

Originally Posted by RichieBoy67

I got the same error..... I don't think it works with 07.....

It Works fine with 3.0.7 , what error you have ??

khaleel

04-06-2005 07:22 AM

Quote:

Well... My problem is, that it doesn't import the phrases

Dont know about that sorry

Quote:

It Works fine with 3.0.7 , what error you have ??

Code:

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

can someone help

DJDarknez

04-06-2005 07:40 AM

Me likey!

clicks install

Had some trouble at first, but the 151 pages helped me get though it :p

However, 1 problem still remains. I have the box checked so the shoutbox will scroll. However, after making some test shouts, it doesn't scroll.

http://forums.djdarknez.net

Anyone? tanx!

Club3G

04-08-2005 02:21 AM

I run this on three sites and I love it - by far the best portal software of ANY forum sw out there.

I use a standard post for my front page to show the news, in a hidden forum. I assume a lot of people do it this way. On http://www.club3g.com I have a 'Car of the Month' feature that's pretty static - I just edit the post once a month and I'm golden.

However on http://www.sevenstring.org, I use it for Artist Interviews and Album Reviews. I have a hidden Forum that contains one sticky post that I use for the news. Thing is, I have almost ten reviews/interviews and they're all pretty relevant. I'd LOVE a way to randomize which post gets shown on the front page, so it cycles between, say, all of the posts in a specified forum.

Is this something doable? Thanks!

khaleel

04-08-2005 08:38 AM

Quote:

Well... My problem is, that it doesn't import the phrases

Dont know about that sorry

Quote:

It Works fine with 3.0.7 , what error you have ??

Code:

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

can someone help

bach	04-08-2005 01:02 PM

does anyone knows how to pharse newsbits into extra pages? This could save me hrs of time!

Thanks a head of time!

JMPZ	04-08-2005 09:55 PM

I believe I found a bug in the uninstallation script

When I went to uninstall this hack, I got the following error message:

Code:

Database error in vBulletin 3.0.7:



Invalid SQL: 

                SELECT phrasetypeid

                FROM phrasetype

                WHERE fieldname IN('vbindex', 'vbindex_cp')

        

mysql error: Table 'forum.phrasetype' doesn't exist

As it turns out, that query is missing the ".TABLE_PREFIX."

In vbiupdate.php
This code

PHP Code:


		
			
    echo "<p>Deleting Phrases...</p>";

    $types = $DB_site->query("

        SELECT phrasetypeid

        FROM phrasetype

        WHERE fieldname IN('vbindex', 'vbindex_cp')

    ");

Should look like this

PHP Code:


		
			
    echo "<p>Deleting Phrases...</p>";

    $types = $DB_site->query("

        SELECT phrasetypeid

        FROM ".TABLE_PREFIX."phrasetype

        WHERE fieldname IN('vbindex', 'vbindex_cp')

    ");

Hope this helps.

khaleel

04-09-2005 05:45 PM

Quote:

Well... My problem is, that it doesn't import the phrases

Dont know about that sorry

Quote:

It Works fine with 3.0.7 , what error you have ??

Code:

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

Is ANYONE going to give me some support?!

ZacUSNYR

04-10-2005 10:49 AM

Quote:

Originally Posted by khaleel

Dont know about that sorry

Code:

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

Is ANYONE going to give me some support?!

You did set your forum path correctly in vbiconfig.php right?

khaleel

04-10-2005 05:38 PM

Yes :tired:

Delphy

04-11-2005 11:37 AM

If all else fails, you can try commenting out the chdir() line.

Also, check your unix permissions - you need the executable bit set on all paths down to root from the public_html folder for the group. For example on mine I have:

Code:

drwxr-xr-x 9 forums forums 4096 Apr 11 06:48 forums/

and

Code:

drwxr-x--- 27 forums nobody 4096 Apr 11 07:39 public_html/

and obviously on /home too.

Hope this helps,
Delphy

Delphy

04-11-2005 11:43 AM

Quote:

Originally Posted by Club3G

Quite easy:

Code:

select * from thread where forumid=X order by rand() limit 1;

You'd obviously have to incoporate the users table and the post table and so on - but if you look at the "Get News" section in vBindex you could clone it, modify the SQL to ORDER BY RAND() LIMIT 1 and you're all set to go :)

You could even add a new template specifically for this section and just change the fetch_template('vbindex_newsbit') to whatever the new one is.

Hope this helps,
Delphy

Club3G

04-11-2005 05:22 PM

:D The only part of that I understood was "quite easy".

Delphy

04-11-2005 11:16 PM

I could probably hack vbIndex to do that and add a template. I'm really busy with stuff on my site, so it'll be a little while. :)

Q-v-n-s-Q

04-12-2005 03:25 PM

whats the points of use this hack?? its useless you know?

Marco van Herwaarden

04-12-2005 06:27 PM

Quote:

Originally Posted by Q-v-n-s-Q

whats the points of use this hack?? its useless you know?

Thank you for the well argumented positive feedback.

Delphy

04-13-2005 10:58 AM

Club3G,

I'm actually going to be doing something like this for my own site, so when it's done I'll share the code :)

Club3G

04-14-2005 04:05 PM

You'll be my absolute hero man. Thanks very much. :D

Branden

04-17-2005 11:12 PM

Is there a way to have the results pulled for the latest threads" block to be limited to specific forums?

ZacUSNYR

04-18-2005 07:55 PM

Quote:

Originally Posted by Branden

Is there a way to have the results pulled for the latest threads" block to be limited to specific forums?

Yes

In the AdminCP you can put the forums you don't want it to show in the exclusions list.

cessna140

04-19-2005 06:41 PM

Quote:

Originally Posted by khaleel

Dont know about that sorry

Code:

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

Is ANYONE going to give me some support?!

Did you ever get this figured out? I am getting the same error and can't figure it out.

Thanks

Got it figured out. I did not have my paths set correctly. :dead:

deta	04-23-2005 07:07 AM

It is worked, actually, on a new version?

If so when gives you?

cu Deta

Wrestling-Freek

04-24-2005 10:40 AM

I have just installed this on my site but when you log in on the vBindex page, it just logs you into the forum, and then when you return to the vBindex page, it doesn't recognise the fact that I'm logged in if you know what I mean. How can I log into the actual vBindex page itself without it just taking me to the forum?

Please help!!

Thanks,

- Nick. :squareeyed:

Wrestling-Freek

04-24-2005 04:02 PM

Can anyone PLEASE help? I really need to get this sorted out.

FightRice.com

04-27-2005 06:59 AM

Try clearing your cookies maybe, dunno

mb425

04-28-2005 10:44 PM

Hi, I just installed and I am having a problem. Every time I try to go to the vbindex.php page, I get this error.

Unable to add cookies, header already sent.
File: /forums/vbiconfig.php
Line: 34

Can anyone help me? Thanks in advance!

All times are GMT. The time now is 07:46 PM.

Page 57 of 62

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03667 seconds Memory Usage 1,844KB 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 (13)bbcode_code_printable (2)bbcode_php_printable (14)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 (40)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
Messages: