The main Wikipedia.org site has many such "portals" and they function
well. Interested in how a "portal" is structured and set up within a
MediaWiki site?
Thanks!
Keith
Dear Colleagues,
I'm trying to upgrade my Wiki to MediaWiki 1.27.3 (FreeBSD 10.3, PostgreSQL 9.2).
The wiki/mw-config script correctly finds the existing
LocalSettings.php, I enter the upgrade key, then it says "The
environment has been checked. You can install MediaWiki."
On the next page I check "Use the same account as for installation"
On the next page, the installer asks me to enter "Name of wiki",
"Project namespace", administrator username/password etc. Why? I'm
upgrading, not installing from scratch. Everything's already there in
LocalSettings.php!
Never mind, I enter all this anew. On the next step: a database error.
Please see the traceback below.
It looks like the installer is trying to create a new wiki instead of upgrading the existing one.
Can you please help?
A database query error has occurred. This may indicate a bug in the software.
Query:
CREATE TABLE mwuser ( -- replace reserved word 'user'
user_id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('user_user_id_seq'),
user_name TEXT NOT NULL UNIQUE,
user_real_name TEXT,
user_password TEXT,
user_newpassword TEXT,
user_newpass_time TIMESTAMPTZ,
user_token TEXT,
user_email TEXT,
user_email_token TEXT,
user_email_token_expires TIMESTAMPTZ,
user_email_authenticated TIMESTAMPTZ,
user_touched TIMESTAMPTZ,
user_registration TIMESTAMPTZ,
user_editcount INTEGER,
user_password_expires TIMESTAMPTZ NULL
)
Function: DatabaseBase::sourceFile( /usr/local/www/mediawiki/maintenance/postgres/tables.sql )
Error: 42P07 ERROR: relation "mwuser" already exists
Backtrace:
#0 /usr/local/www/mediawiki/includes/db/DatabasePostgres.php(448): DatabaseBase->reportQueryError('ERROR: relatio...', '42P07', 'CREATE TABLE mw...', 'DatabaseBase::s...', false)
#1 /usr/local/www/mediawiki/includes/db/Database.php(901): DatabasePostgres->reportQueryError('ERROR: relatio...', '42P07', 'CREATE TABLE mw...', 'DatabaseBase::s...', false)
#2 /usr/local/www/mediawiki/includes/db/Database.php(3057): DatabaseBase->query('CREATE TABLE mw...', 'DatabaseBase::s...')
#3 /usr/local/www/mediawiki/includes/db/Database.php(2978): DatabaseBase->sourceStream(Resource id #51, false, false, 'DatabaseBase::s...', false)
#4 /usr/local/www/mediawiki/includes/installer/PostgresInstaller.php(609): DatabaseBase->sourceFile('/usr/local/www/...')
#5 [internal function]: PostgresInstaller->createTables(Object(PostgresInstaller))
#6 /usr/local/www/mediawiki/includes/installer/Installer.php(1476): call_user_func(Array, Object(PostgresInstaller))
#7 /usr/local/www/mediawiki/includes/installer/WebInstallerInstall.php(45): Installer->performInstallation(Array, Array)
#8 /usr/local/www/mediawiki/includes/installer/WebInstaller.php(279): WebInstallerInstall->execute()
#9 /usr/local/www/mediawiki/mw-config/index.php(81): WebInstaller->execute(Array)
#10 /usr/local/www/mediawiki/mw-config/index.php(39): wfInstallerMain()
#11 {main}
--
Victor Sudakov, VAS4-RIPE, VAS47-RIPN
AS43859
I'm not sure what is the Wikipage Structure that was meant for Polyglot
when created
For example, lets say that we start with Main_Page
We install Polyglot, then if we create Main_Page/es automatically we will
have Interlanguage link for Spanish in the left, same happens if we have
Main_Page/en, with ULS and English selected for anonymus visitors.
But for example, if we prefer to have a Page called Pagina_Principal (Main
Page in Spanish), then, how may we adequately perform this linking?
What I've done is:
1. Create a new page called Pagina_Principal
2. Put a REDIRECT in Main_Page/es to Pagina_Principal
3. Create a new page called Pagina_Principal/en
4. Put a REDIRECT in Pagina_Principal/en to Main_Page/en
5. This way I have interlanguage links in both Pages (Main_Page/en +
Pagina_Principal)
What I'm thinking it's if I should be doing for just every page in my site,
it will be really difficult to maintain:
Lets say I create a new Page call Rice
1. Then I will have to create a page called Rice/es
2. Then another page called Arroz
3. Then another page called Arroz/en
4. Redirect Rice/es to Arroz
5. And Redirect Arroz/en to Rice
Four Page for two languages, and 2 redirects
Things will go worse if I have to maintain 3 language (or 4)
If I add french then I will have to create Rice/fr + Riz + Riz/es + Riz/en
+ Arroz/fr
1. Redirect Rice/fr to Riz
2. Redirect Riz/es to Arroz
3. Redirect Riz/en to Rice
4. Redirect Arroz/fr to Riz
Therefore, 9 pages for 3 languages and 6 Redirects.
With 4 languages, lets say Riso (it), I will have to create:
1. Riso
2. Riso/es
3. Riso/en
4. Riso/fr
5. Riz/it
6. Arroz/it
7. Rice/it
And Redirects:
1. Riso/es to Arroz
2. Riso/en to Rice
3. Riso/fr to Riz
4. Riz/it to Riso
5. Arroz/it to Riso
6. Rice/it to Riso
Therefore 16 Pages in total + 12 redirects.
Summary: It's nearly impossible to properly scale the Wiki with this
structure. So at this point I think I'm doing something wrong
Any ideas to solve this?