IPB 2.0 Import - Weird Bug?

[jjmancini]

Hey there!

I just imported a DB from IPB 2.0 to vB. It seemed to work right, but, it seems that the thread count and the replies are not counted... any ideas? You can see here:

http://www.frunder.com/supportforum/vb/index.php?

Look at any of the forums, it says there are no reply's but really, there are like 10 thyreads and 50 reply's. Any ideas?

Here is the original:
http://www.frunder.com/supportforum/invision/index.php

Thanks!

[jjmancini]

I'm just subscribing to the thread.

[Colin F]

You need to update your counters by going to your

AdminCP > Maintenance > Update Counters

[jjmancini]

Thanks! That was it exactly!

[jjmancini]

I have another quick questions. My admin user got imported as "imported_Frunder" is there a way to change tht back to just Frunder which is also my current admin name? THanks!

[jjmancini]

Acually, just found merge useres. Nevermind. Thanks!

[Jerry]

Merge them :

AdminCP > Users > Merge Users

[Steve Machol]

Use the 'merge users' function instead:

Admin CP -> Users -> Merge Users

[jjmancini]

Alright, one more question, and this one I have looked for. How do I change the default thread to display all time instead of just the last 30 days?

THanks!

[Steve Machol]

In the Forum Manager set the Default View Age to 'Show All Threads'.

Admin CP -> Forums & Moderators -> Forum Manager -> Edit Forum -> Default View Age -> Show All Threads

Or to update them all at once, run this query (assuming no table prefix is being used):

UPDATE forum SET daysprune=-1;

After running that query, update the forum counters:

Admin CP -> Import & Maintenance -> Update Counters -> Rebuild Forum Information

[jjmancini]

Hmmmm.... it says I am not autorized to execute SQL queries... any ideas?

[Steve Machol]

To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = 'x';

...with x being your userid number.

[jjmancini]

Thanks!

[jjmancini]

I just added the prefix here? Is that right?

UPDATE forum SET vb3_daysprune=-1;

[Steve Machol]

Assuming your table prefix is vb3_:

UPDATE vb3_forum SET daysprune=-1;