Issue: REPLACE INTO vb_vault_language

Issue Tools
- View Changes

December 7, 2011 6:24 PM

cosy

Junior Member

REPLACE INTO vb_vault_language

Code:

Database error in vBulletin 4.1.8:

Invalid SQL:

					REPLACE INTO vb_vault_language
						(translate_3)
					VALUES
						(8);

MySQL Error   : Unknown column 'translate_3' in 'field list'
Error Number  : 1054

i get this because i got vb in 2 languages and have the languages support enabled

Issue Details

Issue Number 2554

Issue Type Bug

Project VaultWiki 3.x Series

Category Language / Phrasing

Status Won't Fix

Priority 2 - Fatal / Database Errors

Affected Version Unknown

Fixed Version (none)

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

December 8, 2011 5:05 AM
pegasus

VaultWiki Team
If you added extra languages after installing VaultWiki, while VaultWiki was disabled, or if there was some error, you will have to manually add the column to the database:

Code:

ALTER TABLE vb_vault_language ADD COLUMN translate_3 INT UNSIGNED NOT NULL, ADD INDEX translate_3 (translate_3)

The likelihood of this happening is low, and this is already fixed in version 4 so I'm marking this as Won't Fix.
Reply
December 8, 2011 10:41 AM

cosy

Junior Member

this fix can be a problem when i update to version 4?

Reply
December 8, 2011 5:08 PM

pegasus

VaultWiki Team

The upgrade to version 4 doesn't reference any columns in this table directly, so you can have the added column or not. Languages are stored differently in version 4 and this issue is avoided.

Reply

+ Reply

All times are GMT -4. The time now is 3:52 AM.

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: REPLACE INTO vb_vault_language

Issue Tools