Insert forums through phpMyAdmin - How?
 

I need to create a lot of forums automagically by adding them to the database in bulk. I tested a small list and got it added to the 'forum' table, but they won't show in the list of forums on the board itself. Is there more I need to do in the database to get them to become active?

Attached is a partial shot of the table, the top two forums I added manually to see what values were needed in the table fields, then I copied those into the spreadsheet that I used to create a CSV file.

Thanks,

TW

EDIT: Got it to work by going to the ACP>Maintenance>Update Counters>Rebuild Forum Information

I just need to learn a little more about how to create valid CSV files.

As you discovered, there are a myriad of caches used in vBulletin, and they must be updated. As such, it is generally not advised to directly do CRUD operations to many default vBulletin tables, unless you know what you are doing.

Now I've run into another hurdle. The database forum table when viewed in phpMyAdmin shows a larger number of forums than are showing up in the front page. This after running the maintenance tools. Also, when I try to go to the missing forums by entering the forumID in the browser address bar, I get an error message saying that I'm not authorized to visit that page.

I've looked and looked for an option to increase the number of forums displayed, but no luck. Any ideas?

Thanks,

TW

PS: No, I don't know what I'm doing, but this is a test site that I can break until I do!