[Phpwiki-talk] issues with latest cvs version loading virgin wiki on postgres 8. 1

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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.