Menu
▾
▴
phpwiki-talk
|
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.
|
|
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/
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X