A single post would be a combination of the closure, node, and text tables.
The node contains the metadata (i.e. title and user information) of everything. That includes channels (forums, articles, blogs, social groups, private messages), topics, replies, comments, and attachments. The text table holds the content. The "closure" table holds the hierarchal chain from Node 1 (Home Channel) to the post in a parent child relationship. There needs to be a single parent <-> child record for every step of the way for every single post. For this post it would be Home -> Forum -> vBulletin 5 Connect -> vBulletin 5 Connect Questions, Problems, Troubleshooting -> vBulletin 5 Support Issues -> Your topic starter -> This Reply. This Reply needs a record in the closure table linking it to each parent. So that is 7 records. The Topic Starter has 6 records. vBulletin 5 Support Issues has 5 records. Etc...
This makes it very easy to find stuff with programming languages. Not so easy to update or change manually. You can't just copy these tables. You would need to manually update each and every record in each table with their new node IDs which are an auto-increment value and cannot be duplicated under any circumstance.
What is the name of the Table Posts in MySQL vbulletin 5
Collapse
X
-
You cannot merge content from one vB5 database to another in this way.👍 1Leave a comment:
-
What is the name of the Table Posts in MySQL vbulletin 5
What is the name of the MySQL Table in vbulletin 5 that Post's contents are stored in?
Hi, I just want to transfer the TABLE that stores the user's posts from the old database to the new one.
I found it , the "postedithistory" table and transmitted it from the database, but still I have not recovered some of the posts I had posted in the past few days.
I want to know what the user's internal posts are stored and which one should I transfer to the new databaseLast edited by habili; Sat 2 Jun '18, 11:40pm.Tags: None
Related Topics
Collapse
-
by ATForumWe were hacked a few weeks back, updated the Forum and now some of our previous modifications to the forum don't seem to be working. We're going to revert our style to a vBulletin syle to see if that...
-
Channel: Support Issues & Questions
-
-
by enduroforumHi there
Accidentally, I have deleted a topic including its posts.
Luckily, I found the topic and posts in one of my db backups.
I loaded the backup into a test environment and...-
Channel: Support Issues & Questions
-
-
by PiotrGT1So one of the users has create a table within the post itself here:
https://www.granturismo.pl/forum/gru...ecny-sklad-t13
and as a result this...-
Channel: Support Issues & Questions
-
-
by AndyFrom what I can gather the new vB5 uses one table to store all the data, is this correct?
-
Channel: Support Issues & Questions
-
Leave a comment: