From: Mirko V. <mir...@rc...> - 2002-12-02 14:56:47
|
Ciao! I've installed phpwiki 1.3.3 with php4 and postgres 7.2.3 All is working correctly, db is populated and I can create new pages, but the first page stops with this error: [...] TitleSearch from MIME file ./pgsrc/TitleSearch is identical to current version 1 - skipped lib/WikiDB/backend/PearDB.php:680: Fatal[256]: wikidb_backend_pgsql: fatal database error * DB Error: unknown error * (INSERT INTO page (id,pagename,hits) VALUES (236,']. See footnote for counterpart. (If the is in the first column, it is a footnote ''''definition'''' rather than a footnote ''''reference'''' [',0) [nativecode=ERROR: value too long for type character varying(100) * ]) * lib/loadsave.php:359: Notice[1024]: Loading InterWikiMap from external file lib/interwiki.map. Any info ? Thanks. -- Bye, Mirko |
From: Joby W. <joby@u.washington.edu> - 2002-12-02 16:45:11
|
Looks to me like it is not an issue with PostgreSQL but with the page loading for your virgin wiki. The text is from TextFormattingRules in the section on creating footnotes. I haven't looked at the page loading at all so it would take me a while to figure the exact issue is. Looks like Jeff Dairiki was the last to modify what seems to be the two pages in question (lib/loadsave.php and lib/ziplib.php). Jeff, It looks like the text that it causing the problem is the old markup unescaped footnote link. The line: ----------------------------------------------------------------------- * You can create footnotes by using [[1], [[2], [[3], ... like this here [1]. See footnote for counterpart. (If the [[ is in the first column, it is a footnote ''definition'' rather than a footnote ''reference'' [1].) ----------------------------------------------------------------------- So it is starting and ending with the [1] elements. Any ideas? jbw Mirko Viviani wrote: > Ciao! > > I've installed phpwiki 1.3.3 with php4 and postgres 7.2.3 > All is working correctly, db is populated and I can create new pages, but the > first page stops with this error: > > [...] > TitleSearch > from MIME file ./pgsrc/TitleSearch is identical to current version 1 - skipped > > lib/WikiDB/backend/PearDB.php:680: Fatal[256]: wikidb_backend_pgsql: fatal > database error > > * DB Error: unknown error > * (INSERT INTO page (id,pagename,hits) VALUES (236,']. See footnote for > counterpart. (If the is in the first column, it is a footnote > ''''definition'''' rather than a footnote ''''reference'''' [',0) > [nativecode=ERROR: value too long for type character varying(100) > * ]) > * > > lib/loadsave.php:359: Notice[1024]: Loading InterWikiMap from external file > lib/interwiki.map. > > > Any info ? > Thanks. > |
From: Jeff D. <da...@da...> - 2002-12-04 15:49:02
|
I think Mirko's problem was due to a known (fixed in CVS) bug in ExtractWikiPageLinks() (in lib/stdlib.php). (It only shows up (so obviously) when using the postgres backend because (I'm guessing) MySQL silently truncates overly long strings, while postgres signals an error...) (I think loadsave.php and ziplib.php are red herrings, in this case...) ExtractLinks() is fundamentally flawed. The link extraction should use the transform engine to find the links. This is more reason for me to work on that.... On Mon, 02 Dec 2002 08:45:04 -0800 Joby Walker <joby@u.washington.edu> wrote: > Looks to me like it is not an issue with PostgreSQL but with the page > loading for your virgin wiki. The text is from TextFormattingRules in > the section on creating footnotes. I haven't looked at the page loading > > at all so it would take me a while to figure the exact issue is. > > Looks like Jeff Dairiki was the last to modify what seems to be the two > pages in question (lib/loadsave.php and lib/ziplib.php). > > Jeff, It looks like the text that it causing the problem is the old > markup unescaped footnote link. The line: > > ----------------------------------------------------------------------- > * You can create footnotes by using [[1], [[2], [[3], ... like this here > > [1]. See footnote for counterpart. (If the [[ is in the first column, > it is a footnote ''definition'' rather than a footnote ''reference'' > [1].)------------------------------------------------------------------ > ----- > > So it is starting and ending with the [1] elements. > > Any ideas? > > jbw > > > > Mirko Viviani wrote: > > Ciao! > > > > I've installed phpwiki 1.3.3 with php4 and postgres 7.2.3 > > All is working correctly, db is populated and I can create new pages, > > but the first page stops with this error: > > > > [...] > > TitleSearch > > from MIME file ./pgsrc/TitleSearch is identical to current version 1 - > > skipped > > > > lib/WikiDB/backend/PearDB.php:680: Fatal[256]: wikidb_backend_pgsql: > > fatal database error > > > > * DB Error: unknown error > > * (INSERT INTO page (id,pagename,hits) VALUES (236,']. See > > footnote for > > counterpart. (If the is in the first column, it is a footnote > > ''''definition'''' rather than a footnote ''''reference'''' [',0) > > [nativecode=ERROR: value too long for type character varying(100) > > * ]) > > * > > > > lib/loadsave.php:359: Notice[1024]: Loading InterWikiMap from external > > file lib/interwiki.map. > > > > > > Any info ? > > Thanks. > > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Get the new Palm Tungsten T > handheld. Power & Color in a compact size! > http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en > _______________________________________________ > Phpwiki-talk mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk -- -- Jeff Dairiki <da...@da...> |