[Phpwiki-talk] 2001-02-13 problems (1.3.0pre)

[Reini U. <ru...@x-...>]

Problem 1:
  Fatal error: Call to undefined function: searchpath() in lib/config.php on
line 40
Cause:
  config.php on 
    if (!function_exists ('gettext'))
  requires searchpath() from stdlib.php but stdlib.php is loaded from main.php
  after config.php. 
  classic cyclic dependency problem.
  stdlib neds config
Solution:
  not me.
  perhaps move SearchPath() into config.php

Problem 2:
Loading up virgin wiki
lib/stdlib.php:559: Notice[8]: Undefined index: lastmodified
lib/stdlib.php:566: Notice[8]: Undefined index: content
lib/mysql.php:77: Notice[8]: Undefined index: author
lib/mysql.php:126: Notice[8]: Undefined index: created
lib/mysql.php:128: Notice[8]: Undefined index: version

WikiFatalError
Error writing page 'RecentChanges'
MySQL error: You have an error in your SQL syntax near ' 0, 982105829,
'RecentChanges', 'a:0:{}', )' at line 1 

Cause:
  wrong schemas/schemas.mysql
  missing INDEX definitions
Solution:
  not sure but the syntax below looks fine to me. depends on the mysql version
of course. 
  on my public machine with 3.22 it will not work.
  it has to be a MyISAM table for the BLOB index. it needs a different syntax.
  BLOB indices are troublesome. I would also try to avoid all varchars in wiki
and
  provide a seperate wikiblob table. this way the table has to copied all over
on 
  any update. with fixed lengths in wiki only the blob has to be inserted.

CREATE TABLE wiki (
        pagename VARCHAR(100) NOT NULL,
        version INT NOT NULL DEFAULT 1,
        flags INT NOT NULL DEFAULT 0,
        author VARCHAR(100),
        lastmodified INT NOT NULL,
        created INT NOT NULL,
        content MEDIUMTEXT NOT NULL, INDEX(content(50)),
        refs TEXT,
        PRIMARY KEY (pagename),
        INDEX (lastmodified),
        INDEX (author),
        INDEX (created),
        INDEX (version)
        );

There have been more errors on the setup step so I gave up.
(win32, apache-3.14 with modphp4.0.5, mysql 3.23.28-gamma)