phpwiki-talk

[Phpwiki-talk] Curious Behaviour of Wiki

[Mickey <par...@pa...>]

Hi,

I just installed phpwiki, version 1.2, at my home 
computer: a debian potato.

Everytime I modified the front page, I got an error.
I searched and found that the error was due to the
following SQL query:
wiki (author, content, created, flags, lastmodified, pagename, refs,
version) values ('', '____September 2, 2001 * [FrontPage]
([diff|phpwiki:?diff=FrontPage]) ..... 217.128.30.29 ', ,//
 0, 999454843, 'RecentChanges', 'a:0:{}', )

so I change the lib/mysql.php file:
      $VALUES =  "'$pagehash[author]', '$pagehash[content]', " .
                 "$pagehash[created], $pagehash[flags], " .
                 "$pagehash[lastmodified], '$pagehash[pagename]', " .
                 "'$pagehash[refs]', $pagehash[version]";
became:
      $VALUES =  "'$pagehash[author]', '$pagehash[content]', " .
                 "'$pagehash[created]', '$pagehash[flags]', " .
                 "'$pagehash[lastmodified]', '$pagehash[pagename]', " .
                 "'$pagehash[refs]', '$pagehash[version]'";

and now it works well.


thanks you for this beautiful program,

bye

Re: [Phpwiki-talk] Curious Behaviour of Wiki

[Steve W. <sw...@pa...>]

Hi Mickey!

That's odd. The field that was showing blank (created) is an INT. Quoting
it should just create more barf. Unless MySQL lets one quote INTs. Hmm. I
wonder why it comes out blank to begin with? Perhaps this the state after
the installation? I'll take a look.

~swain

On Sun, 2 Sep 2001, Mickey wrote:

>
> Hi,
>
> I just installed phpwiki, version 1.2, at my home
> computer: a debian potato.
>
> Everytime I modified the front page, I got an error.
> I searched and found that the error was due to the
> following SQL query:
> wiki (author, content, created, flags, lastmodified, pagename, refs,
> version) values ('', '____September 2, 2001 * [FrontPage]
> ([diff|phpwiki:?diff=FrontPage]) ..... 217.128.30.29 ', ,//
>  0, 999454843, 'RecentChanges', 'a:0:{}', )
>
> so I change the lib/mysql.php file:
>       $VALUES =  "'$pagehash[author]', '$pagehash[content]', " .
>                  "$pagehash[created], $pagehash[flags], " .
>                  "$pagehash[lastmodified], '$pagehash[pagename]', " .
>                  "'$pagehash[refs]', $pagehash[version]";
> became:
>       $VALUES =  "'$pagehash[author]', '$pagehash[content]', " .
>                  "'$pagehash[created]', '$pagehash[flags]', " .
>                  "'$pagehash[lastmodified]', '$pagehash[pagename]', " .
>                  "'$pagehash[refs]', '$pagehash[version]'";
>
> and now it works well.
>
>
> thanks you for this beautiful program,
>
> bye
>
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>

---
                  http://www.panix.com/~swain/
"Without music to decorate it, time is just a bunch of boring
production deadlines or dates by which bills must be paid."
                     -- Frank Zappa
http://pgp.document_type.org:11371/pks/lookup?op=get&search=0xF7323BAC