The center for all Wikitravel images!

Tech:Database error on posting in it:

From Wikitravel Shared
Jump to: navigation, search

What happens[edit]

I get an error like below:

Database error

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: 

(SQL query hidden)

from within function "LinksUpdate::getExistingInterlangs". MySQL returned error "1146: Table 'wikitravel_org_-_it.langlinks' doesn't exist (".

When it happens[edit]

Whenever I post any edit (even a dummy edit) in Italian Wikitravel.

In fact, the edit is saved (next time I try to edit the same page, the previous edit is retained) but does not appear in the rendered page.

Platform: Windows XP Japanese, Internet Explorer 6, Mozilla Firefox 1.5

What should happen[edit]

Posting should complete normally.

How to fix it[edit]

No idea.

Argh. That's a problem with the upgrade from 1.6.8 to 1.7.1. I have to run a database update script for each database, and I've got the process automated, but it, being the newest wiki, wasn't in my list, so it got skipped. I've run the updater now, and it seems to have worked, so I think this bug should be fixed. --Evan 01:56, 23 August 2006 (EDT)

Here is a suggested solution. Create a table called language links in your Mysql database.

Required SQL query to create the table:

CREATE TABLE `wiki_langlinks` (
  `ll_from` int(8) unsigned NOT NULL default '0',
  `ll_lang` varchar(10) character set latin1 collate latin1_bin NOT NULL default ,
  `ll_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default ,
  UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`),
  KEY `ll_lang` (`ll_lang`,`ll_title`)

You might need to change the table prefix (wiki_) to match your installation's table prefix. This problem occurs when updating mediawiki from version 1.6.x to 1.7.x. The earlier version does not have the table langlinks.

Sorry, I guess I should have marked this problem as fixed. It's fixed. -- 20:15, 17 September 2006 (EDT)