Default View Age - Set All Forums To "Since Beginning"?

[trevelyn1015]

how can i go in and make every forum show topics since the beginning, instead of having to go in one by one and do the individually...

[Andreas]

Execute the following query
[sql]UPDATE forum SET daysprune=-1[/sql]


Then gto to ACP / Import & Maintenance / Update Counters and select Rebuild Forum Information

[trevelyn1015]

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'forum2.forum' doesn't exist

[Andreas]

Then you are using a table prefix and must change the query accordingly.

[trevelyn1015]

how do i do that? sorry, i don't know about this..

[Andreas]

And I don't know what your table prefix is
Just put it in front of forum, so if your table prefix is vb3_ it would be

[sql]UPDATE vb3_forum SET daysprune = -1[/sql]

[trevelyn1015]

i just ran that, and it didn't do it... great...

what did that query do, then...


b/c it worked, i put my table prefix in there, but the actul changing of the forum views didn't change... did i mess something up running that query?

UPDATE forum2_forum SET daysprune = -1

it said it affected 43 rows, but nothing changed...

[Marco van Herwaarden]

The user you used for testing if anything had changed, dies he have a default set in his profile?

[AN-net]

i thought if you set cut off date to 1,000 days the forum will automatically select "since the beginning"

[trevelyn1015]

Originally Posted by MarcoH64

The user you used for testing if anything had changed, dies he have a default set in his profile?

no... set to default...

some forums are one month.. some are beginning, some are one day...

i dunno why...

ok, for some reason, now it is all set at beginning... maybe it just took time? i dunno

thanks alot, it is all set, now...