From: Matthew P. <mj...@ie...> - 2003-02-05 03:26:11
|
I've gotten this report from a user of the Debian package. I think they've got a point, although I don't use PostgreSQL myself, so I can't easily check it. Can someone with PGSQL experience with PHPWiki comment on this problem? -- ----------------------------------------------------------------------- #include <disclaimer.h> Matthew Palmer, Geek In Residence http://ieee.uow.edu.au/~mjp16 ---------- Forwarded message ---------- Date: Tue, 04 Feb 2003 21:03:25 -0500 From: Stephen van Egmond <sva...@ti...> To: Debian Bug Tracking System <su...@bu...> Subject: Bug#179860: phpwiki: initial page load fails for pgsql Resent-Date: Wed, 05 Feb 2003 02:18:01 GMT Resent-From: Stephen van Egmond <sva...@ti...> Resent-To: deb...@li... Resent-cc: Matthew Palmer <mp...@de...>, ph...@pa... Package: phpwiki Version: 1.3.3-6 Severity: normal When following the documentation in INSTALL.pgsql, there is one unstated dependency and one error. The unstated dependency is that the database must be created with LATIN-1 encoding. This statement will suffice: createdb -E LATIN-1 wiki in recent versions of postgres. Failure to do so results in a database error while inserting the pages on the first visit to the wiki home page. There is a page G?stboken, where ? is a wierd a. Correcting for above, the following error is produced during the intial page load, farther below G?stboken: (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) Editing /usr/share/doc/phpwiki/schemas/psql.sql to increase the length of the "pagename" column to, say, 200, solves this. It's unclear where that loooong value should be a page name at this point. Both of these errors render the phpwiki unusable, since each visit to the HomePage entry causes it to attempt to reload the default set of pages. -- System Information Debian Release: testing/unstable Architecture: powerpc Kernel: Linux floyd 2.4.20-rc4-ben0 #2 Mon Dec 2 17:51:45 EST 2002 ppc Locale: LANG=C, LC_CTYPE=C Versions of packages phpwiki depends on: ii apache 1.3.26-1.1 Versatile, high-performance HTTP s ii debconf 1.2.21 Debian configuration management sy ii php4 4:4.1.2-5 A server-side, HTML-embedded scrip ii php4-pear 4:4.1.2-5 PEAR - PHP Extension and Applicati |