[Zachery]

Originally Posted by M.C.

strange but straight after changing The ID number of news forum i`ve got MySQL error:

PHP 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(3)
                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: Sunday 25th of January 2004 08:58:22 PM
Script: [url]http://localhost/adv_index.php?styleid=2[/url]
Referer: 
Username: M.C.
IP Address: 127.0.0.1 


I was testing on localhost that hack when i got that...

What i did wrong?

Ok i got it, I disabled "show attachements" and it`s work fine, BUT i want it work fine with "show attachements" enabled

And one more strange thing - in installation a gave right icons path (http://localhost/forum/images/icons/icon1.gif), but it show path like that: http://localhost/images/icons/icon1.gif

And for emprovement of hack i`d love to have option to change blocks position (left, right, center and up and down)

Thanks!

you didnt upgrade vBadvanced when you upgraded to RC3

Originally Posted by digitalSite

Hi all:

Does anyone know:

1) Why all my images except "icons" folder don't show?
I have searched everywhere to make sure I have absolute paths for my images so that it shows, but I can't find where to tell vb where to go for the icons folder.

2) How I can make my vb forum as wide as the screen? I check the "index" template on vb, and it shows 100%, yet the forum is very narrow on a 1024 x whatever resolution.

3) How to prevent non-registered users from seeing the main FORUM page (i.e. forums/index.php) - It shows too much info to non registered user on my site, i.e. Who's Online, etc. I don't want anyone who is not registered to view the forum at all.

If I block non-registered users from "Viewing the Forum" then my vbAdvanced page doesn't work because then you'll just see the "You are not allowed to view this page, login, etc." page.

I'm sorry for all the questions, but I only had 3 hours of sleep last night messing with the new vb 3.0 C 3 and still haven't had this site up running properly.
It messed up another program I was running so I have been trying to get that fixed too (looks like I overwrote an "index.php" by accident and that's where the whole thing messed up.)

Anyway, I would appreciate any help Thank you.

for 2
http://www.vbulletin.com/forum/showthread.php?t=88013
read that

you sorta need to let them view at least the news forum.

closing off your board to all guests isnt a good idea

1 you still need to update your counters and stuff

Originally Posted by jaliam

* Clicks install *

Ok, I have made some modifications in my portal already but I want to do more. How about making an image display on the main page instead of a simple image path? This is what I am talking about...

enable BB code and img code for the front page