Issue: Creating a Translation for a Page doesn't Link the Pages

Issue Tools
- View Changes

April 16, 2010 2:59 PM

Mokonzi

Senior Member

Creating a Translation for a Page doesn't Link the Pages

It doesn't link the two pages together

When Translating a page using the 'Translate this Page' option, a new page is created in the correct language, but the pages aren't linked together. When trying to then subsequently link the two pages together, I get a MySQL Error:

Code:

Database error in vBulletin 4.0.3:

Invalid SQL:

							SELECT *
							FROM vb3_vault_language
							WHERE translate_ = 16013;

MySQL Error   : Unknown column 'translate_' in 'where clause'
Error Number  : 1054
Request Date  : Friday, April 16th 2010 @ 10:56:00 PM
Error Date    : Friday, April 16th 2010 @ 10:56:01 PM
Script        : /showwiki/Hauptseite?do=apply
Referrer      : /showwiki/Hauptseite?redirect=no

Issue Details

Issue Number 1436

Issue Type Bug

Project VaultWiki 3.x Series

Category Translating Pages

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 3.0.0 RC 1

Fixed Version 3.0.0 RC 1

Milestone VaultWiki 3.0.0

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

April 16, 2010 5:02 PM

pegasus

VaultWiki Team

Fixed the pages not being linked after creation (needs a re-down-upload of vault/tabs/special_tab_edit.php). Not sure about your other error though... it's illogical - it should be searching based on the current language ID of the vBulletin page - with a catch to use 1 instead of 0, and right now it's using 0.

Reply
April 16, 2010 7:21 PM
pegasus

VaultWiki Team
Find:

Code:

WHERE $langfield = " . intval($threadinfo['threadid']) . " ")

Add after:

Code:

)

Yes, as I found in my test, there's no language set. However, I was able to reset a page's language after this was fixed by using the apply tab.
Reply

This petition for a change to Confirmed was accepted

April 17, 2010 2:14 AM

Mokonzi

Senior Member

I assume that was in the vault/tabs/special_tab_apply.php file as the special_tab_edit.php doesn't contain that value. I added it in the apply tab, now get a database error:

Code:

Database error in vBulletin 4.0.3:

Invalid SQL:

							SELECT *
							FROM vb3_vault_language
							WHERE translate_ = 16013;

MySQL Error   : Unknown column 'translate_' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, April 17th 2010 @ 10:13:14 AM
Error Date    : Saturday, April 17th 2010 @ 10:13:15 AM
Script        : /showwiki/Hauptseite?do=apply
Referrer      : /showwiki/Hauptseite?redirect=no

Edit: The two pages still aren't linked after I recreate the Hauptseite page, and the error occured trying to link the two

April 17, 2010 2:35 AM

pegasus

VaultWiki Team

Find:

Code:

			$langfield = "translate_" . intval($threadinfo['languageid']);

Replace with:

Code:

			$langfield = $currentfield;

April 17, 2010 2:51 AM

Mokonzi

Senior Member

Done that (was in the special_tab_apply.php file I assume) still getting a MySQL Error:

Code:

Database error in vBulletin 4.0.3:

Invalid SQL:

							SELECT *
							FROM vb3_vault_language
							WHERE translate_ = 16013;

MySQL Error   : Unknown column 'translate_' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, April 17th 2010 @ 10:49:55 AM
Error Date    : Saturday, April 17th 2010 @ 10:49:56 AM
Script        : /showwiki/Hauptseite?do=apply
Referrer      : /showwiki/Hauptseite[/url]

April 17, 2010 3:09 AM
pegasus

VaultWiki Team
Doh! Been looking in the wrong part of the code this whole time. Find:

Code:

$fieldname = 'translate_' . $languageid;

Replace with:

Code:

$fieldname = 'translate_' . $tlanguageid;

Please note that if it looks like the Apply tab simply refreshes, this means it encountered an error, and the error reporting was never added to the front-end yet...
Reply
April 17, 2010 3:59 AM

Mokonzi

Senior Member

I redownloaded the ZIP for the other changes, and assuming this fix was included, it's now holding the change... came across another similar but new error I'll post in a seperate bug report...

Reply

+ Reply

All times are GMT -4. The time now is 12:59 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: Creating a Translation for a Page doesn't Link the Pages

Issue Tools