Issue: Get error message, after clicking Translate to language: Go button

Issue Tools
- View Changes

April 3, 2011 4:30 AM

basketmen

Junior Member

Get error message, after clicking Translate to language: Go button

After clicking Translate to language: Go button, i get this error message, please help how to fix this

Code:

Database error in vBulletin 3.6.12:
Invalid SQL:
SELECT trans.*, thread.title, thread.prefixid
FROM vault_language AS trans
INNER JOIN thread AS thread ON (trans.translate_1 = thread.threadid)
WHERE trans.translate_1 = 100329;
MySQL Error
: Unknown column 'thread.prefixid' in 'field list'
Error Number : 1054
Date
: Sunday, April 3rd 2011 @ 03:25:19 PM
Script
: http://www.domain.com/newthread.php?f=3046
Referrer
: http://www.domain.com/wiki/test53
IP Address
: 111.222.333.444
Username
: admin
Classname
: vB_Database

but i can using Edit Translations link, and add another page in another language. I just cant using Translate to language: feature

Issue Details

Issue Number 2267

Issue Type Bug

Project VaultWiki 3.x Series

Category Translating Pages

Status Fixed

Priority 4 - Warnings / Script Errors

Affected Version 3.0.11

Fixed Version 3.0.12

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

April 3, 2011 3:46 PM

pegasus

VaultWiki Team

In vault/plugins/newthread.php, find:

Code:

SELECT trans.*, thread.title, thread.prefixid

Replace with:

Code:

SELECT trans.*, thread.title
" . (!VAULT_36X_COMPAT ? ", thread.prefixid" : "") . "

This petition for a change to Confirmed was rejected
April 3, 2011 4:39 PM

basketmen

Junior Member

thank you, its fixed
April 8, 2011 11:07 AM

basketmen

Junior Member

pegasus i am sorry, there is another problem

i already can go to the edit page, after clicking Translate to language: Go button,

but after clicking Post new article button, i've got this message

This page has already been translated for the selected language.

screenshot

i try many way but still get that message

and in original page >> Page Language Options >> View in language, i see still no other language added, only the original language

please fix this too if you can

you can see my forum in the pm before if you want to try it live, using admin account

Reply

April 8, 2011 11:39 AM

pegasus

VaultWiki Team

Fixed in your install and the next build. In vault/tab/edit.php, find:

Code:

			if ($db->query_first("
				SELECT *
				FROM " . TABLE_PREFIX . "vault_language
				WHERE translate_" . intval($transpage['languageid']) . " = " . intval($vbulletin->GPC['translateid']) . "
			"))

Replace with:

Code:

			$tranny = $db->query_first("
				SELECT *
				FROM " . TABLE_PREFIX . "vault_language
				WHERE translate_" . intval($transpage['languageid']) . " = " . intval($vbulletin->GPC['translateid']) . "
				LIMIT 1
			");

			if ($tranny['translate_' . $vbulletin->GPC['langid']])

+ Reply

All times are GMT -4. The time now is 9:25 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: Get error message, after clicking Translate to language: Go button

Issue Tools