Database Errors

[Big-k]

I just installed this on my test site.

Attempt to edit an article gives the following errors:

Invalid SQL:

                       REPLACE INTO vb4_vault_protect
                               (namespaceid, title, title_lower, options, targetid)
                       VALUES
                       (
                               6,
                               'Globe Trekker',
                               'globe+trekker',
                               5,
                               39162
                       );

MySQL Error   : Unknown column 'title_lower' in 'field list'
Error Number  : 1054
Request Date  : Friday, December 18th 2009 @ 08:09:28 AM
Error Date    : Friday, December 18th 2009 @ 08:09:29 AM
Script        : xxx/forum/showwiki.php?title=Globe+Trekker&do=protect
Referrer      : xxx/forum/showwiki.php?title=Globe+Trekker&do=edit
IP Address    : 70.131.97.98

                       SELECT protectid
                       FROM vb4_vault_protect
                       WHERE namespaceid IN (-1,6)
                               AND title_lower = 'globe+trekker'
                               AND options = 4;

MySQL Error   : Unknown column 'title_lower' in 'where clause'
Error Number  : 1054

[pegasus]

We don't have any record of your account purchasing or downloading the software, so I'm not really sure which version of the software you're currently using.

If it was a fresh install of the latest build 2.5.7, the field in question is included by default, and I can only see it being left out if there was an error during the installation process. I would recommend reinstalling your test and reporting any errors that may occur.

Please also include your vBulletin, PHP, and MySQL versions which I see you removed from above.