Re: [Phpwiki-talk] phpwiki-1.5.2: Fatal PHP error.

[jdebert <jd...@ga...>]

In re last,

On Fri, 21 Nov 2014 17:25:25 -0800
jdebert <jd...@ga...> wrote:

> PHP Fatal error:  Call to undefined function posix_times()
> in $PHPWIKI/lib/prepend.php on line 72, referer:
> http://localhost/
> 

[snip]
> 
>     function DebugTimer()
>     {
>         $this->_start = $this->microtime();
>         $this->_times = posix_times();
>     }
> 

I inserted a line from 1.4.0:

      function DebugTimer() {
          $this->_start = $this->microtime();
          if (function_exists('posix_times'))  <----- from 1.4.0
              $this->_times = posix_times();
      }
  
which seems to work so far and even took care of the deprecated
function warnings. I had installed the php5 posix module before this
thinking it may resolve the error but it did not.

However, this error seems to have prevented loading the virgin wiki
pages and there were sql errors about the page table being empty when
phpwiki was accessed after this. I had to destroy and re-create the
database over again so that phpwiki would load the pages into the db.

But here again, I encountered a problem. The schemas as written did not
work. mysql did not like defaults for the blob/text datatypes:

    ERROR 1101 (42000) at line 72: BLOB/TEXT column 'prefs' 
     can't have a default value

Deleting "DEFAULT ''" from every line defining a blob/text type in
mysql-initialize.sql schema allowed the tables to be created without
problem. IIRC, since at least mysql 5.6 and at least mariadb 5.6,
DEFAULT is no longer legal for types blob/text.

So far, the wiki is readable. In lynx, at least. I'll try editing,
creating pages and transferring pages from the old phpwiki later and
see if that works as well.

jd