Hy,
ich will ein Wiki mit eMail-Confirmation erstellen.
Folgendes HowTo benutze ich:
http://www.mediawiki.org/wiki/Extension:ConfirmAccount
In dem Schritt
Run maintenance/update.php. bekomme ich jedoch folgende Fehlermeldung:
|
Quellcode
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
/usr/bin/php -f ./maintenance/update.php
...
Adding column "account_requests.acr_held"
Warning: pg_query(): Query failed: FEHLER: Relation »account_requests« existiert nicht in /data/www/kernelwiki.tunes23.homelinux.org/htdocs/mediawiki/includes/db/DatabasePostgres.php on line 580
A database error has occurred
Query: ALTER TABLE account_requests ADD acr_held TIMESTAMPTZ
Function:
Error: 1 FEHLER: Relation »account_requests« existiert nicht
Backtrace:
#0 /data/www/kernelwiki.tunes23.homelinux.org/htdocs/mediawiki/includes/db/Database.php(616): DatabasePostgres->reportQueryError('FEHLER: Relati...', 1, 'ALTER TABLE acc...', '', false)
#1 /data/www/kernelwiki.tunes23.homelinux.org/htdocs/mediawiki/maintenance/updaters.inc(1783): Database->query('ALTER TABLE acc...')
#2 /data/www/kernelwiki.tunes23.homelinux.org/htdocs/mediawiki/maintenance/updaters.inc(1067): do_postgres_updates()
#3 /data/www/kernelwiki.tunes23.homelinux.org/htdocs/mediawiki/maintenance/update.php(62): do_all_updates(false, true)
#4 {main}
|
Die Tabelle existiert auch..
|
|
Quellcode
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
kernelwiki=> \d account_credentials_acd_id_seq
Sequenz »mediawiki.account_credentials_acd_id_seq«
Spalte | Typ | Wert
---------------+---------+--------------------------------
sequence_name | name | account_credentials_acd_id_seq
last_value | bigint | 1
start_value | bigint | 1
increment_by | bigint | 1
max_value | bigint | 9223372036854775807
min_value | bigint | 1
cache_value | bigint | 1
log_cnt | bigint | 1
is_cycled | boolean | f
is_called | boolean | f
|
sollte aber so aussehen:
|
|
Quellcode
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
CREATE SEQUENCE account_credentials_acd_id_seq;
CREATE TABLE account_credentials (
acd_id INTEGER NOT NULL DEFAULT nextval('account_credentials_acd_id_seq'),
acd_user_id INTEGER,
acd_real_name TEXT,
acd_email TEXT,
acd_email_authenticated TIMESTAMPTZ,
acd_registration TIMESTAMPTZ,
acd_bio TEXT,
acd_notes TEXT,
acd_urls TEXT,
acd_ip CIDR,
acd_filename TEXT,
acd_storage_key TEXT,
acd_areas TEXT,
acd_accepted TIMESTAMPTZ,
acd_user INTEGER REFERENCES mwuser(user_id) ON DELETE SET NULL,
acd_comment TEXT NOT NULL DEFAULT '',
PRIMARY KEY (acd_id, acd_user_id)
);
CREATE UNIQUE INDEX acd_id_index ON account_credentials (acd_id);
|
Wat mach ich denn da? Kennt sich da jemand aus?
Für jegliche Tipps wäre ich dankbar.
Axo, Versionen:
|
|
Quellcode
|
1
2
3
4
5
6
7
|
[I] www-apps/mediawiki
...
Installed versions: 1.15.1(1.15.1)!t(12:07:39 12/18/09)(imagemagick math ocamlopt postgres vhosts -mysql)
[I] dev-db/postgresql-server
...
Installed versions: 8.4.2(8.4)!t(14:26:27 12/29/09)(kernel_linux nls perl python xml -doc -linguas_af -linguas_cs -linguas_de -linguas_es -linguas_fa -linguas_fr -linguas_hr -linguas_hu -linguas_it -linguas_ko -linguas_nb -linguas_pl -linguas_pt_BR -linguas_ro -linguas_ru -linguas_sk -linguas_sl -linguas_sv -linguas_tr -linguas_zh_CN -linguas_zh_TW -selinux -tcl -uuid)
|
Gruss,
Toni.
