Last modified: 2010-05-15 15:41:03 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T8649, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 6649 - Error in database on saving articel after upgrade from 1.6.7 to 1.7.1
Error in database on saving articel after upgrade from 1.6.7 to 1.7.1
Status: RESOLVED WORKSFORME
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.7.x
PC Linux
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-07-12 13:43 UTC by Sven Wappler
Modified: 2010-05-15 15:41 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Sven Wappler 2006-07-12 13:43:16 UTC
The error:
Es gab einen Syntaxfehler in der Datenbankabfrage. Die letzte Datenbankabfrage
lautete:

    (SQL query hidden)

aus der Funktion „LinksUpdate::getExistingInterlangs“. MySQL meldete den Fehler
„1146: Table 'personalwikidb.langlinks' doesn't exist (localhost)“.

I ran the config-script but it seems that the table wasn't created.

# MediaWiki: 1.7.1
# PHP: 5.1.2 (apache2handler)
# MySQL: 4.1.13
Comment 1 Sven Wappler 2006-07-12 13:49:28 UTC
I have fixed this error by creating the table manually:

CREATE TABLE langlinks(
-- page_id of the referring page
ll_from int( 8 ) unsigned NOT NULL default '0',
-- Language code of the target
ll_lang varchar( 10 ) binary NOT NULL default '',
-- Title of the target, including namespace
ll_title varchar( 255 ) binary NOT NULL default '',
UNIQUE KEY ( ll_from, ll_lang ) ,
KEY ( ll_lang, ll_title )
) TYPE = InnoDB;
Comment 2 Rob Church 2006-07-12 13:56:48 UTC
When upgrading MediaWiki, don't forget to run the maintenance/update.php script
to check and upgrade the database schema as needed.
Comment 3 Sven Wappler 2006-07-12 14:23:21 UTC
Hi, this step is ok, but not well because this directory is standardly protected
by htaccess. This script should be run by the config script.
Comment 4 Rob Church 2006-07-12 14:25:26 UTC
You run it from the command line. The configuration script can be re-run to
perform upgrades, too, but an AdminSettings.php file needs to be available to do
that.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links