phpwiki-talk

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

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

Started setting up phpwiki-1.5.2 and encountered this error:

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

The function isn't defined even in php5. It doesn't look like it can be
simply commented out, either:


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

Really appreciate any clue.

Thanks

jd

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

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

[Marc-Etienne V. <Mar...@al...>]

On 22/11/2014 23:14, jdebert wrote:
> 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.

Hi,

You are right, function posix_times does not always exist,
for example on Windows.

I had removed some function_exists checks for functions
that are supposed to be present in PHP >= 5.3 but for
this one it was not correct.

I have added the check again.

I will look to your SQL problem later.

Thank you for your remarks.

Best regards,

Marc-Etienne Vargenau

-- 
Marc-Etienne Vargenau Mar...@al...
Alcatel-Lucent France, Route de Villejust, 91620 NOZAY, FRANCE
+33 1 60 40 28 33 OnNet 2103 2833

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

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

On Mon, 24 Nov 2014 17:07:39 +0100
Marc-Etienne Vargenau <Mar...@al...> wrote:

> 
> I will look to your SQL problem later.

Reference: mysql 5.6 manual, section 11.5:

BLOB and TEXT data type cannot have a default value.

I do remember that defining default values for blob/text was allowed in
earlier versions.

jd