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)

dontpanic 01-22-2004 12:19 AM

Hmm, oddly enough, it appears to have "fixed itself..." :ermm:

NuclioN 01-22-2004 12:37 AM

Hm..it won't install. After upgrading to vb3 rc3 the index gives a permanent db error. I've uninstalled, and installed again but it gives a db error during installation.

Zachery 01-22-2004 12:43 AM

Quote:

Originally Posted by NuclioN
Hm..it won't install. After upgrading to vb3 rc3 the index gives a permanent db error. I've uninstalled, and installed again but it gives a db error during installation.

can you give us the error?


dontpanic:it was probally a browser cache issue :)_

dontpanic 01-22-2004 12:45 AM

I suppose so...I've got about 2 million windows open. :)

CarolinaKid 01-22-2004 01:03 AM

upgraded from rc2 to rc3 ran the install script had error ininstalled and reinstalled got same error. can anyone help.

Code:

Invalid SQL: SELECT thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, forumid, thread.iconid, votenum, votetotal, post.postid, pagetext, allowsmilie, showsignature
                          , avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline 
                          ,thread.iconid
                          ,attachment.filename, filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
                                FROM thread AS thread
                                LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
                                LEFT JOIN user AS user ON (user.userid = post.userid)
                                LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
                                LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid) 
                                LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
                                WHERE forumid IN(34)
                                GROUP BY post.postid
                                ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous


Zachery 01-22-2004 01:12 AM

Quote:

Originally Posted by CarolinaKid
upgraded from rc2 to rc3 ran the install script had error ininstalled and reinstalled got same error. can anyone help.

Code:

Invalid SQL: SELECT thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, forumid, thread.iconid, votenum, votetotal, post.postid, pagetext, allowsmilie, showsignature
                          , avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline 
                          ,thread.iconid
                          ,attachment.filename, filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
                                FROM thread AS thread
                                LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
                                LEFT JOIN user AS user ON (user.userid = post.userid)
                                LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
                                LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid) 
                                LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
                                WHERE forumid IN(34)
                                GROUP BY post.postid
                                ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous


looks like he forgot a feild thats new in RC3 :/ im sure he will get to it asap :)

CarolinaKid 01-22-2004 01:14 AM

Quote:

Originally Posted by Faranth
looks like he forgot a feild thats new in RC3 :/ im sure he will get to it asap :)

lol well it might be my fault i did not upload the few files that i had hacked all board works fine besides index.

Tigga 01-22-2004 01:17 AM

That was mentioned earlier today and I posted the fix, but I didn't think to mention that change in the post with the upgrade file. Just open your adv_index.php file and look for "filesize," (without the quotes) and change that to "attachment.filesize," (again, wthout the quotes).

CarolinaKid 01-22-2004 01:21 AM

Quote:

Originally Posted by Tigga
That was mentioned earlier today and I posted the fix, but I didn't think to mention that change in the post with the upgrade file. Just open your adv_index.php file and look for "filesize," (without the quotes) and change that to "attachment.filesize," (again, wthout the quotes).

Thanks a ton. Sorry I missed the fix about that earlier. Solved problem

Zachery 01-22-2004 01:27 AM

Quote:

Originally Posted by Tigga
That was mentioned earlier today and I posted the fix, but I didn't think to mention that change in the post with the upgrade file. Just open your adv_index.php file and look for "filesize," (without the quotes) and change that to "attachment.filesize," (again, wthout the quotes).

Tigga check yer pms bud :)

rinkrat 01-22-2004 03:50 AM

Upgrade to RC3 went smooth.

NuclioN 01-22-2004 08:40 AM

Error:

Invalid SQL: INSERT INTO vb3_phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, '-1', 'settinggroup_vbadv_index', 'vBadvanced Homepage Settings', '5000')
mysql error: Duplicate entry 'settinggroup_vbadv_index--1-5000' for key 2

Tigga 01-22-2004 01:46 PM

NuclioN - I'm assuming you got that from the RC3 upgrade script, right? Were all your phrases and such removed during the upgrade? It should have removed that phrase as well if it removed the rest, so you may want to double check and see if the others were removed. If they were, try finding this bit of code in that file and removing it:
PHP Code:

        $DB_site->query("INSERT INTO " TABLE_PREFIX "phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, '-1',  'settinggroup_vbadv_index', 'vBadvanced Homepage Settings', '5000')");
        echo 
"<font size=\"1\">Added vBadvanced Setting Group </font><br /><br />"


scottct1 01-22-2004 06:17 PM

Getting the following error....

I upgraded to RC3 fine on my test server, however on my live server I get the following error...

Parsing functions.php Time before: 1074801976.8187 Time after: 1074801976.8452 Time taken: 0.026489973068237
--------------------------------------------------------------------------------
Processing sessions.php Time before: 1074801976.8455
Fatal error: Call to a member function on a non-object in /home/satellit/public_html/includes/sessions.php on line 171

scottct1 01-22-2004 06:24 PM

Got it fixed, I uploaded the main php again to the root and it worked. :)

Phew!

NuclioN 01-22-2004 08:35 PM

Where to check if the frases were removed, phpmyadmin, the phragemanager? I don't even know which frases i've to look for. I must first open the install file and look for each one of them?

PET 01-23-2004 12:04 AM

hi there.

I have a problem.
I have created a new templated called index_regulament where i have normaly put the thext that i want. Now i get this error when i'm trying to access the index_regulament page. This is the error :

Fatal error: Call to undefined function: parse_bbcode() in C:\apache\htdocs\ro-hattrick\vb\index.php on line 555

index.php is acutaly the vBadvanced index. I get this only when i'm trying to acces the new page :

http://localhost/ro-hattrick/vb/inde...age=regulament

Can you help me ?

Tigga 01-23-2004 12:14 AM

Nuclion - Just go to your phrase manager, then select "vBadvanced Homepage" from the select field near the top of that page. There should be about 15 phrases under that IIRC.

PET - See this post for the fix - https://vborg.vbsupport.ru/showpost....4&postcount=53

NuclioN 01-23-2004 12:37 AM

Tnx Tigga..i did it the 'non sleep' method by deleting all the templates in phpmyadmin and then import a fresh vb language. It worked. :)

Ofcourse i have to spend more time to find the solutions for other problems such as the calendar and the login block and the full url's and where to put them. This is a great addon and i hope you can make an update soon where all those problems are history.

Tigga 01-23-2004 01:11 AM

Well I'm actually working on the next version right now. The problem with the phrases being removed after a vB upgrade is a simple fix, but the templates will most likely always be removed. That one's not a big deal though since it only removes any that you haven't customized, plus there's the option in the installer to only install the templates. ;)
What do you mean about the problems with the login block and calendar? There aren't any issues with either of those that I'm aware of...

Zachery 01-23-2004 01:25 AM

Quote:

Originally Posted by Tigga
Well I'm actually working on the next version right now. The problem with the phrases being removed after a vB upgrade is a simple fix, but the templates will most likely always be removed. That one's not a big deal though since it only removes any that you haven't customized, plus there's the option in the installer to only install the templates. ;)
What do you mean about the problems with the login block and calendar? There aren't any issues with either of those that I'm aware of...

Tigga its sorta urgent but try to check your email :) tonight if possible

Tigga 01-23-2004 01:32 AM

Checked & replied. :)

Zachery 01-23-2004 01:36 AM

^^ silly me thanks

PET 01-23-2004 02:26 AM

Quote:

PET - See this post for the fix - https://vborg.vbsupport.ru/show...24&postcount=53
It works now. Thanx

PET 01-23-2004 02:28 AM

Ah...i forghot. I have a question :

I want to create another news page. Like the normal NEWS...but on other category. How can i do that ?

For exemple the first page load's the NEWS forum. If i click on a new link i want it to load the "BLABLA" forum.

AshAbed 01-23-2004 08:38 AM

if i upgrade to vb3 rc3 will the new templates i created be deleted(the ones like index_page)?
thanks

RobAC 01-23-2004 11:03 AM

Probably a stupid question....but how do you add custom blocks to the index page? There are provisions for handling index_custom1 and index_custom2, but I don't see any instructions on how to add more custom blocks?

Milhouse 01-23-2004 02:40 PM

OK i have VB RC3 installed, I downloaded the vbadvanced from the 1 st post followed all instructions everything went smooth. However I have one Minor problem. When a guest gets to the main page, it asks them to login or register. Well however all the links are linking to the wrong place.

ie.( regisger.php should be /forums/register.php
ie.(login.php should be /forums/login.php

Basically all links avaialable including those in the footer, for archive, contact aer all linking wrong.. not sure what I did wrong. In vb options the home URL and the forums URL is set correctly, just the index page is not linking right.

I looked through these 26 pages and found a few related problems but not exactly specifying the same. Any help would be great. Thanx

Zachery 01-23-2004 03:32 PM

Quote:

Originally Posted by Milhouse
OK i have VB RC3 installed, I downloaded the vbadvanced from the 1 st post followed all instructions everything went smooth. However I have one Minor problem. When a guest gets to the main page, it asks them to login or register. Well however all the links are linking to the wrong place.

ie.( regisger.php should be /forums/register.php
ie.(login.php should be /forums/login.php

Basically all links avaialable including those in the footer, for archive, contact aer all linking wrong.. not sure what I did wrong. In vb options the home URL and the forums URL is set correctly, just the index page is not linking right.

I looked through these 26 pages and found a few related problems but not exactly specifying the same. Any help would be great. Thanx

sorta thought we phased this problem out

are you usin the most recent copys of the templates?

Quote:

Originally Posted by AshAbed
if i upgrade to vb3 rc3 will the new templates i created be deleted(the ones like index_page)?
thanks

customtemplates are not overwritten
Quote:

Originally Posted by RobAC
Probably a stupid question....but how do you add custom blocks to the index page? There are provisions for handling index_custom1 and index_custom2, but I don't see any instructions on how to add more custom blocks?

look at the bottom of the page were the there evaled

its about the same process

or check my sig for basics of vB3 and look specificly at how things are "evaled"

Milhouse 01-23-2004 03:46 PM

Quote:

Originally Posted by Faranth
sorta thought we phased this problem out

are you usin the most recent copys of the templates?

As i stated, vb3 rc3 is a fresh install. No modyfications have been done to it. I simply downloaded the zip file from the first post in this thread. Followed all instructions. All went smooth, all linked fine as far as news, polls, etc.

If I am at the portal page and logged in, everything is linking fine to the forums. news, poll, pm's latest threads. However the bottom footer that has ADMIN/ MOD/ Archive all those link wrong.

If a gues comes they will have to register/login/forget pass, all those links are wrong as well as the footer.

I have not made any changes, and used the templates that come in the zip file.

Even the forumjump links don't work. They also link to the wrong place.

Zachery 01-23-2004 03:52 PM

Quote:

Originally Posted by Milhouse
As i stated, vb3 rc3 is a fresh install. No modyfications have been done to it. I simply downloaded the zip file from the first post in this thread. Followed all instructions. All went smooth, all linked fine as far as news, polls, etc.

If I am at the portal page and logged in, everything is linking fine to the forums. news, poll, pm's latest threads. However the bottom footer that has ADMIN/ MOD/ Archive all those link wrong.

If a gues comes they will have to register/login/forget pass, all those links are wrong as well as the footer.

I have not made any changes, and used the templates that come in the zip file.

if your using the default header / footer templates you shouldnt have too much if any problems

Milhouse 01-23-2004 04:19 PM

OK ignore het above problem. It seems i woudl have to edit the standard_errors template to reflect the correct url. So instead i changed the guests access to be ablve to view the board but need to register and that is fine. Here is one little problem,

The index_newsbits as a varable $newsicon , That $newsicon is linking to the wrong place so it displays a nice big RED X . It is pointing to /images/icons/... instead of /forums/images/icons/...

How would i go abotus of changing that variable to reflect the correct path.

Zachery 01-23-2004 04:20 PM

icon manager in the ACP :) not sure where it is off the top of my head :)

Milhouse 01-23-2004 04:38 PM

Quote:

Originally Posted by Faranth
icon manager in the ACP :) not sure where it is off the top of my head :)


That won't do anything. it's the variable $newsicon in the index_newsbits template that is wrong. If i go to post icon manager and look at the icon it is linked fine there and it displays fine in the forum. But in the portal page it shows a nice big X

RobAC 01-23-2004 04:57 PM

Is it possible to add a random block function? For example, I want to add a random quote box to my vBadvanced home page that would add a random quote from a list of quotes in a text file in the block each time the user refreshes their browser. How can this be programmed?

eger 01-23-2004 07:22 PM

im gettin this error after install. followed all directions.

Code:

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL: SELECT thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, forumid, thread.iconid, votenum, votetotal, post.postid, pagetext, allowsmilie, showsignature
                          , avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline 
                          ,thread.iconid
                          ,attachment.filename, filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
                                FROM thread AS thread
                                LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
                                LEFT JOIN user AS user ON (user.userid = post.userid)
                                LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
                                LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid) 
                                LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
                                WHERE forumid IN(2)
                                GROUP BY post.postid
                                ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous

mysql error number: 1052

Date: Friday 23rd of January 2004 01:23:03 PM
Script: http://test.test.test
Referer:
Username: test
IP Address: 63.63.63.63

EDIT: i've determined this to be the New attachment option. when i turn it off, the page displays. BUT it only displays the very first thread from the news forumid and it only displays the Subject, not the text from the post. this is odd =\

Zachery 01-23-2004 07:54 PM

Quote:

Originally Posted by eger
im gettin this error after install. followed all directions.

Code:

Database error in vBulletin 3.0.0 Release Candidate 3:
 
Invalid SQL: SELECT thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, forumid, thread.iconid, votenum, votetotal, post.postid, pagetext, allowsmilie, showsignature
                        , avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline
                        ,thread.iconid
                          ,attachment.filename, filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
                                FROM thread AS thread
                                LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
                                LEFT JOIN user AS user ON (user.userid = post.userid)
                                LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
                                LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
                                LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
                                WHERE forumid IN(2)
                                GROUP BY post.postid
                                ORDER BY dateline DESC, attachmentid LIMIT 5
mysql error: Column: 'filesize' in field list is ambiguous
 
mysql error number: 1052
 
Date: Friday 23rd of January 2004 01:23:03 PM
Script: http://test.test.test
Referer:
Username: test
IP Address: 63.63.63.63

EDIT: i've determined this to be the New attachment option. when i turn it off, the page displays. BUT it only displays the very first thread from the news forumid and it only displays the Subject, not the text from the post. this is odd =\

did you upgrade? with the correct upgrade script?

tgmorris 01-23-2004 07:56 PM

Change:
Code:

,attachment.filename, filesize, attachment.visible
To:
Code:

,attachment.filename, attachment.filesize, attachment.visible

Milhouse 01-23-2004 07:57 PM

Quote:

Originally Posted by Faranth
did you upgrade? with the correct upgrade script?

Why not include the correct install file with the zip in he first post? Would avoid this.

Darnell 0216 01-23-2004 08:19 PM

Quote:

Originally Posted by Milhouse
That won't do anything. it's the variable $newsicon in the index_newsbits template that is wrong. If i go to post icon manager and look at the icon it is linked fine there and it displays fine in the forum. But in the portal page it shows a nice big X

As someone mentioned either here or on vb.com, even though settings are automatically inputted, they don't always stick. In this case it is necessary to "Save" the instruction anyway even when it appears correctly. I've had to go to my smilies and click save on them anyway to make them work with the index page.


All times are GMT. The time now is 10:30 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.04179 seconds
  • Memory Usage 1,867KB
  • 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
  • (6)bbcode_code_printable
  • (1)bbcode_php_printable
  • (16)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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