Menu
▾
▴
[Phpwiki-talk] issues with latest cvs version loading virgin wiki on postgres 8. 1
|
From: John C. <joh...@ua...> - 2007-01-25 14:44:29
|
Reini,
Just updated my test server :-) I want to upgrade to postgres, so I've=
created the database and the wikiuser user and have the database loaded
(though, I'm using the postgres account to connect).
Here are some issues:
1) when creating the database, don't create it using UTF8, lots of pag=
es
in pgsrc throw an error when it's UTF8, this should be noted somewhere.
----------------------------------------------------------------------
2) running the schema scripts throws several errors... Here are my
results for 8.1 on windows.
F:\inetpub\wwwroot\phpwiki_cvs\schemas>"c:\Program
Files\PostgreSQL\8.1\bin"\psq
l -U postgres wiki < psql-1_3_12.sql
schema enhancements
ERROR: type "serial" does not exist
ERROR: cannot alter type of a column used by a view or rule
DETAIL: rule _RETURN on view curr_page depends on column "id"
ERROR: cannot alter type of a column used by a view or rule
DETAIL: rule _RETURN on view existing_page depends on column "id"
Creating experimental page views (not yet used)
ERROR: relation "existing_page" already exists
ERROR: relation "curr_page" already exists
ERROR: column "relation" of relation "link" already exists
ERROR: relation "relation_idx" already exists
add tsearch2 fulltextsearch extension
ERROR: relation "pg_ts_dict" does not exist
ERROR: type "tsvector" does not exist
ERROR: function to_tsvector("unknown", text) does not exist
HINT: No function matches the given name and argument types. You may nee=
d
to ad
d explicit type casts.
ERROR: column "idxfti" does not exist
ERROR: function tsearch2() does not exist
Initializing stored procedures
ERROR: cannot change return type of existing function
HINT: Use DROP FUNCTION first.
F:\inetpub\wwwroot\phpwiki_cvs\schemas>"c:\Program
Files\PostgreSQL\8.1\bin"\psq
l -U postgres wiki < psql-tsearch2.sql
prefix =3D ''
httpd_user =3D 'phpwiki'
ERROR: relation "pg_ts_dict" does not exist
ERROR: type "tsvector" does not exist
ERROR: function to_tsvector("unknown", text) does not exist
HINT: No function matches the given name and argument types. You may nee=
d
to ad
d explicit type casts.
ERROR: column "idxfti" does not exist
ERROR: function tsearch2() does not exist
F:\inetpub\wwwroot\phpwiki_cvs\schemas>
----------------------------------------------------------------------
3) Loading the virgin wiki throws the following errors:
f:\inetpub\wwwroot\phpwiki_cvs\lib\plugin\Template.php:89 Notice[8]:
Undefined index: page
f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:561 Notice[1024]:
Internal Error: no block advance
f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:664 Warning[512]: no
lastTR: <tr class=3D"tightenable bottom top">
* <th rowspan=3D"2">_</th>
* <th rowspan=3D"2">S'inscrire</th>
* <th rowspan=3D"2">_</th>
* <td colspan=3D"2"><p class=3D"tightenable top bottom">=A5=B5=A5=A4=A5=
??</p>
* </td>
* </tr>
* <tr class=3D"tightenable top bottom">
* <th>_</th>
* <td>_</td>
* </tr>
f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:664 Warning[512]: no
lastTR: <tr class=3D"tightenable bottom top">
* <th rowspan=3D"2">Sign In</th>
* <th rowspan=3D"2">Anmelden</th>
* <th rowspan=3D"2">_</th>
* <th rowspan=3D"2">S'inscrire</th>
* <th rowspan=3D"2">_</th>
* <td colspan=3D"2"><p class=3D"tightenable top bottom">=A5=B5=A5=A4=A5=
??</p>
* </td>
* </tr>
* <tr class=3D"tightenable top bottom">
* <th>_</th>
* <td>_</td>
* </tr>
Fatal Error:
f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb-errorhandler.inc.ph=
p:7
6 Error[256]: postgres7 error: [ERROR: invalid input syntax for integer:
"25-Jan-2007 08:23:49": ERROR: invalid input syntax for integer:
"25-Jan-2007 08:23:49"] in EXECUTE("INSERT INTO accesslog
(time_stamp,remote_host,remote_user,request_method,request_line,request_u=
ri,
request_args,request_time,status,bytes_sent,referer,agent,request_duratio=
n)
VALUES('25-Jan-2007 08:23:49','192.168.243.84','-','GET','GET
/phpwiki_cvs/index.php/HomePage
HTTP/1.1','/phpwiki_cvs/index.php/HomePage','','25/Jan/2007:08:23:49
-0600',200,0,'http://cvs.uai.com/phpwiki_cvs/index.php/HomePage','Mozilla=
/5.
0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.1) Gecko/20061204
Firefox/2.0.0.1','12.478621')")
f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:664 Warning[512]: no
lastTR: <tr class=3D"tightenable bottom">
* <th rowspan=3D"7"><em>Automatically generated pages</em></th>
* <th>English (en)</th>
* <th>Deutsch (de)</th>
* <th>Espa?(es)</th>
* <th>Fran?s (fr)</th>
* <th>Italiano (it)</th>
* <th>Japanese (ja)</th>
* <th>Nederlands (nl)</th>
* <td>Svenska (sv)</td>
* </tr>
f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiPlugin.php:524 Warning[2]:
getplugin(lib/plugin/New.php): failed to open stream: No such file or
directory
----------------------------------------------------------------------
4) the 'time_stamp' column on the accesslog table is set to an int type=
,
which is wrong. Changing it to a timestamp type fixed the fatal error in=
3)
which was happening on every page.
----------------------------------------------------------------------
5) trying to edit the sandbox page returns the following error when you h=
it
save, and the save fails:
f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb-errorhandler.inc.ph=
p:7
6 Error[256]: postgres7 error: [ERROR: update or delete on "version"
violates foreign key constraint "recent_id_fkey1" on "recent"
* DETAIL: Key (id,version)=3D(144,1) is still referenced from table
"recent".: ERROR: update or delete on "version" violates foreign key
constraint "recent_id_fkey1" on "recent"
* DETAIL: Key (id,version)=3D(144,1) is still referenced from table
"recent".] in ADODB_Error_Handler(DELETE FROM version WHERE id=3D144 AND
version=3D1, )
*
----------------------------------------------------------------------
6) trying to upload a zipdump (made with the same version of phpwiki)
results in the following error:
f:\inetpub\wwwroot\phpwiki_cvs\lib\ziplib.php:197 Error[256]: CRC32
mismatch: calculated=3D3448885092, expected=3D-846082204
Stopping there :-)
Thanks,
John
--=20
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.10/651 - Release Date: 1/24/200=
7
6:48 PM
=20
This email and any files transmitted with it are confidential and intende=
d solely for the use of the individual or entity to whom they are address=
ed. If you have received this email in error please notify the sender. Th=
is message contains confidential information and is intended only for the=
individual named. If you are not the named addressee you should not diss=
eminate, distribute or copy this e-mail.
|
