UBB.Developers Forums UBB.threads 7 Development How Do I? Manually inserting w3t_Posts rows

I'm attempting to import some rows from one database into another (exact same threads version btw), and it does insert them...but they won't show up on the boards for some mysterious reason.

The only way I can see them is if I do a search.

Here's an example of what I'm entering...

INSERT INTO `w3t_Posts` VALUES ('posttesting', 399, 0, 399, 1090531466, 1090531466, '206.xxx.xxx.xxx', 'Test', 'Testing ', NULL, '', 'O', 'yes', 'book.gif', 'y', 2, 0, 0, '', 0, 'both', NULL, NULL, 910, '0', 0, NULL, 0, '', 910, NULL, NULL);

I did make sure to use a unique post number for them too.

Any ideas? I have a small bunch that I need to move over from a schema dump.

Have you checked that the right columns are assigned and the correct values are being assigned to the correct columns in the resulting record since you are not specifying the order?

Yep, they are being assigned in the exact same way that the other existing rows are. The number of fields and their order are identical.

Instead of doing querries to insert them, I may try to dump the current table, copy/paste the new rows to it, drop the table, and then import it with the new rows to see if that works.

I'll report back my results after I attempt it.