Query problem

[Anadrot]

I needed to change my forum homepage to display all threads in each forum. After setting "View Age" to "Show all Threads" and having no success with that I tried to run query "UPDATE forum SET daysprune=-1;" However, I got an error #1146 that said "Table 'golden38_forum.forum' doesn't exist" so the query didn't go through. My database name is 'golden38_forum' but there is nothing in it with a similar to error's name structure.

Any thought or suggestion will be appreciated. I spent last two hours trying to change home page display to Show all Threads and still no success.

[Steve Machol]

You are probably using table prefixes. You need to add the prefix to that table name in that query.

[Anadrot]

Please help me out by clarifying a bit ".. need to add the prefix to that table name in that query." I'm not that familiar with the subject. Thanks.

[Anadrot]

I found the name in my db 'golden38_forum.vb3_forum' Seems like vb3 is a prefix?

[daemon]

Yes, vb3 is your prefix. Try running this query:

UPDATE vb3_forum SET daysprune = -1

[Anadrot]

I ran this query. When finished it said "Affected Rows:0" Nothing in the home page display has changed.

[Steve Machol]

Nothing would change on the home page.

[Anadrot]

I meant the forum still doesn't show all the threads as I hope it would.

[daemon]

Did you go and press:

Admin CP --> Forums & Moderators --> Forum Manager --> [Save Display Order]

... after you ran the query?

[Anadrot]

Yes, I did. But the query doesn't seem did any chage ...""Affected Rows:0"

[Steve Machol]

I meant the forum still doesn't show all the threads as I hope it would.

Did you change the view settings in your User CP? What's the URL to your forums

[Anadrot]

I didn't change viewer options. The URL is

http://www.goldenwyvern.com/forums

I don't know if that can have anything to do with it, but I had two forums and deleted one. The forum I deleted was parent to the one that I left. Of course, I have changed that relationship to none before deleting.

[Steve Machol]

The one forum I can view as guest (Golden Wyvern) is showing posts 'from the beginning'. This means that the default is set correctly. Each user can override this setting in their User CP options.

[Anadrot]

What I'm trying to accomplish is to show all the threads when a visitor comes to the forum's home page. Currently it shows only one thread with the latest post.

[Steve Machol]

All threads do not show on the home page. This has never been a feature of vBulletin. The forum home page shows links to the forums you have. Changing this requires modifying the code. We cannot officially support code modifications or forums running modified code, however can try searching or asking for help with this over at www.vbulletin.org.