Issue: Revision DB Error editing a page

Issue Tools
- View Changes

June 20, 2010 8:45 PM

mickknutson mickknutson is offline

Regular Member

Revision DB Error editing a page

I just tried to edit an existing page, I get this error:

Code:

tabase error in vBulletin 4.0.4:

Invalid SQL:
INSERT INTO vault_revision
	(forumid, threadid, dateline, iconid, pagetext, userid, ipaddress, title, reason, minor, section, attach, pending, htmlstate, prefixid, unzip, lastrevisionid)
VALUES
	(78, 36413, 1277080997, 4, 'jVRha+Q2EP0eyH8Y3C9tCXZbyn0oLGU33aTb7i0l3hI4IYJsj9fqypKxxrvno1/7vzuSnVz2CKUQiFfSPL1572nE7Xq3Xz9IsZKPaErXIpADalBkK3l9JfLNh/XiXdjerR9htczX8KiPOuyKLGyGQ9kMcn11fbWpuVp74L/RDT3UuvcEJ+013YAn1RMUI/SoKm0P4SKonTHuzL/+gQAgil4K3aoDSn8cjEn/6g5/f//Dd91HkU3LIuMjfHC7yffh/7dyovmjXJYldhRRmbH4RfvSKN0iIzLh9DPjzyUPeNJ4nko2oU/x58N2kTRE3U9Z5jujaDAqZWWyojZZIqMGd4qU0TTCVnN3X6/utt+IjAvlJMxGgrIViMfN7xv5cjYnRXxcl15kcedNQjtHoMAfx0qfsIcR6We4d3BB63w+p1Xvuk/OYqTmVY00ZltUvX0i95RP5Zm2FX5MfUOtSWSrjgg+WDyj+4nz5NGbZPYN2mhW1FPcI1GwTVsOSRBChh4uojCbcuEjnpwZSDubdvZ/e5nHrJw1NSBKRXhw/bhI7tFir7iZ+UNkz3sSNrZ2favCRTOh9AIxqgOqcANNSf5taLvQjjhzpBfJnpNitMVE/so2MaTIwoZ8S5i55AFL11c+kfNHtH1ZNhpP2KIl/x8QOeIUu8K54yLZBKu+IlUYfHL1U+ksBYBE7sMSuBpu5yXWjCui2l/KPr2gZ44rGUp6XQyEFzbdIRqoe4yP3aA6IXCKImFQ0/spHJFrw7UKOnbqBlwPBcYJoSwIsa40a+TlFPWyUfYw9aNKGpSB5wZSWNoRVlu9u4V86DrXE8e6ZAxkBKhcOcSLb4BpBoCRTTcGDkjQuopNJqz4ZvYWoRsKo33DpqWvO+WvVbCAcWYm/lW/LAq8GkuKA00DJ2EeSiHZ/PJ9h6VWJnrKODNMIkujyyM02LOE8xkJ4YmHG1g+zyqeG1bttSRNkLSPQGacKVUTZbGMAQxK7XjwvIxUKeN+7uJ7u5lUfbFvnsrAgJp1iFW3bNlgebKkaQj6fv3+j+1yv5a1cyyxyF4W/gU=', 1, '71.123.48.157', 'Index', '', 0, '', 0, 0, 'on_nl2br', '', 1, 1576);

MySQL Error   : Unknown column 'htmlstate' in 'field list'
Error Number  : 1054
Request Date  : Sunday, June 20th 2010 @ 05:43:17 PM
Error Date    : Sunday, June 20th 2010 @ 05:43:17 PM
Script        : http://www.blincmagazine.com/forum/wiki/BASE_Wiki:Index?do=edit
Referrer      : http://www.blincmagazine.com/forum/wiki/BASE_Wiki:Index?do=edit
IP Address    : 71.123.48.157
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.1.48

Issue Details

Issue Number 1731

Issue Type Bug

Project VaultWiki 3.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 3.0.0

Fixed Version 3.0.1

Milestone VaultWiki 3.0.5

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

June 20, 2010 8:59 PM

pegasus

VaultWiki Team

If you upgraded from vBulletin 3.8 to vBulletin 4 AFTER upgrading from VaultWiki 2.5 to VaultWiki 3, then you need to run the VaultWiki upgrade script again to get the vBulletin 4 integrations.

Reply
June 21, 2010 5:38 AM

mickknutson

Regular Member

the vb 4 upgrade was 1st. Should I still rerun the vault upgrade again anyways?

Reply
June 21, 2010 12:02 PM

pegasus

VaultWiki Team

Yes, go to upgrade.php and see if it redirects you to another upgrade step. You missed upgrade_4x300rc2.php (at least). I am looking into it now.

Reply
June 22, 2010 7:09 PM

mickknutson

Regular Member

I re-ran the upgrade.php, but when I went back to edit, I got the same error.

Reply
June 22, 2010 11:05 PM
pegasus

VaultWiki Team
Can you please post the contents of your database table vault_upgradelog (there should be 3-4 short rows)?

You can fix editing capability in the mean time by running the following query against your database:

Code:

ALTER TABLE vault_revision ADD htmlstate ENUM('off', 'on', 'on_nl2br') DEFAULT 'on_nl2br'
Reply
June 23, 2010 4:36 AM

pegasus

VaultWiki Team

Figured this out. The step was run but the query died silently because of a wrapper vB was adding to already wrapped code. This has been fixed in the current ZIP. Affected users can run the aforementioned script again, the query in the previous post, or wait until the next release to be patched.

Reply
June 23, 2010 5:57 AM
mickknutson

Regular Member
Originally Posted by pegasus

Can you please post the contents of your database table vault_upgradelog (there should be 3-4 short rows)?

You can fix editing capability in the mean time by running the following query against your database:

Code:

ALTER TABLE vault_revision ADD htmlstate ENUM('off', 'on', 'on_nl2br') DEFAULT 'on_nl2br'

Upgrade log:

Code:

3X 3.0.0 4X 3.0.0 RC 2 3P 3.0.0 4P 3.0.0 Beta 3

But the SQL you had me run worked. Tested and we are good!
Thanks much!
Reply

+ Reply

All times are GMT -4. The time now is 11:38 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Revision DB Error editing a page

Issue Tools