Issue: Table BBCode issues after upgrading to 4.2

Also, wouldn't it be easier to just convert the table tags somehow to the built in vbulletin one now?

The VaultWiki table tags actually offer more functionality than the vBulletin tags, so it would be a lossy conversion.
If the table tag is missing, use the following MySQL query:
Then use the Wiki Code Manager to enable the tag.

What version of VaultWiki were you using before upgrading?

3.0.10, which is still what is on my live site but it doesn't work (I have to upgrade it right?)

I just did the MySQL query and it gave me this in return:

If you get that error, the Table BB-Code should be listed in the Wiki Code Manager. Click the Edit button for it, and check because the parsing for it might be turned off. If you upgraded vBulletin past 4.2 after upgrading VaultWiki, you need to run the VaultWiki upgrade script again. Doing this might resolve the issue on its own.

Yes, you need to upgrade. Any version of VaultWiki below 3.0.19 will break the WYSIWYG editor in vBulletin 4.2.0.

The table BB Code is not in the Wiki Code Manager though.

I have only upgraded from 4.1.1 to 4.2 PL3, and that is when this issue started. My test forum I have run the upgrade script more than once, and done a fresh install even.

That error you got trying to insert it to the database says that it's there already, so it really should be in the Manager, as the manager performs a full fetch of the contents of that database table. It's possible the title is not set to "Table" for some reason. It could be blank, or it could have another name. But you should still see the tag "[table]" in the 3rd column either way.

You can always do some snooping in your own database and find out what the row with bbcodetag = 'table' looks like, because there is one there.

Well I have the wysiwyg editor table bbcode. I'll look in the database though, not sure how there can be two [table] bbcodes though then?

Ok, I deleted a bbcode on my test forum that had been using the same icon as the table, and now it appears on the list and in the bbcode.

Secondary question now...It has been so long since I first attempted the upgrade on my live forum that I can't recall if I uploaded the 'updated' files for the VaultWiki 4 install on my forum or not. I think I did because I had to update my PHP.

That being said, I realize that upgrading to 4 might not be the best option now (unless you say otherwise). Could I just re-upload the files but for the latest version of 3 and do the update script?

You should ideally make sure you have a working version of the latest VaultWiki 3 before attempting to upgrade to 4.

Yes, you can re-upload the files for 3 as long as you didn't already start an upgrade attempt for 4. If you did, you will have to continue that attempt - if it was a while ago, I suspect any database backup from before would cause more problems than it would resolve.

Can you please provide the exact steps you performed to fix the table issue, with an example of the database rows you found? By your explanation above I'm still not quite sure why it wasn't appearing in the Wiki Code Manager.

I have zero clue as well. All I did was look into my database manager and see the table code, but I also noticed it was using the same icon as my PRE code (preformatted text). So I just deleted the PRE code from my bbcode manager in the admincp and it suddenly appeared.

Yeah I never attempted the upgrade, I think I started to but it said it required PHP 5.3 so that is when I decided to run it on the test site first. So I only have uploaded the files.