[Phpwiki-talk] Pageloading failure [WAS: Problems with pgsql]

[Joby W. <joby@u.washington.edu>]

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.
>