Menu
▾
▴
Re: [Phpwiki-talk] issues with latest cvs version loading virgin wiki on postgres 8. 1
|
From: Reini U. <ru...@x-...> - 2007-01-28 23:01:12
|
John Cole schrieb:
> 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 pages
> in pgsrc throw an error when it's UTF8, this should be noted somewhere.
Should be fixed in 1.3.13rc1
> ----------------------------------------------------------------------
>
> 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
wrong schema. use psql-initialize.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 need
> 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.
The tsearch2.dll couldn't be found. I only tried the cygwin version,
which I maintain. You should complain upstream.
> F:\inetpub\wwwroot\phpwiki_cvs\schemas>"c:\Program
> Files\PostgreSQL\8.1\bin"\psq
> l -U postgres wiki < psql-tsearch2.sql
> prefix = ''
> httpd_user = '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 need
> 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="tightenable bottom top">
>
> * <th rowspan="2">_</th>
> * <th rowspan="2">S'inscrire</th>
> * <th rowspan="2">_</th>
> * <td colspan="2"><p class="tightenable top bottom">¥µ¥¤¥??</p>
> * </td>
> * </tr>
> * <tr class="tightenable top bottom">
> * <th>_</th>
> * <td>_</td>
> * </tr>
>
> f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:664 Warning[512]: no
> lastTR: <tr class="tightenable bottom top">
>
> * <th rowspan="2">Sign In</th>
> * <th rowspan="2">Anmelden</th>
> * <th rowspan="2">_</th>
> * <th rowspan="2">S'inscrire</th>
> * <th rowspan="2">_</th>
> * <td colspan="2"><p class="tightenable top bottom">¥µ¥¤¥??</p>
> * </td>
> * </tr>
> * <tr class="tightenable top bottom">
> * <th>_</th>
> * <td>_</td>
> * </tr>
>
> Fatal Error:
> f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb-errorhandler.inc.php: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_uri,
> request_args,request_time,status,bytes_sent,referer,agent,request_duration)
> 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')")
I improved accesslog handling to be backend specific.
Only oracle uses a data datatype now. All other a simple int.
> f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:664 Warning[512]: no
> lastTR: <tr class="tightenable bottom">
>
> * <th rowspan="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.
int is the new way to go.
I changed the logger function.
> ----------------------------------------------------------------------
>
> 5) trying to edit the sandbox page returns the following error when you hit
> save, and the save fails:
>
> f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb-errorhandler.inc.php: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)=(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)=(144,1) is still referenced from table
> "recent".] in ADODB_Error_Handler(DELETE FROM version WHERE id=144 AND
> version=1, )
> *
Looks like you are using an old postgresql schema.
> ----------------------------------------------------------------------
>
> 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=3448885092, expected=-846082204
yep, that's not fixed yet.
> Stopping there :-)
>
> Thanks,
>
> John
>
--
Reini Urban
http://phpwiki.org/ http://murbreak.at/
http://helsinki.at/ http://spacemovie.mur.at/
|
