[Phpwiki-talk] FW: v1.3.3 with MS SQL working

[Quinlan D <Da...@mf...>]

hi,

I found out what this(see below) was.  
the PHP mssql library uses DB-LIB which only supports retrieving 255 chars
on a VARCHAR field.
It's a known issue and Microsoft's response to it is 'use a newer library,
we don't support DB-LIB anymore'
so I changed the schema to use TEXT fields and changed the relevant SQL
queries in the backend/mssql.php
it works now, the virgin pages load properly, I can edit but searching is
borked

the form that the TitleSearch generates under IIS uses code like this

<base href="http://server/wiki/index.php" />
<form action="index.php?pagename=TitleSearch" method="get"

and the parameter 'pagename=TitleSearch' only seems to get passed along if
the method is POST
so the pagename isn't being passed along and the GET query looks like this

http://server/wiki/index.php?s=searchterm

which just displays the HomePage

Now on my linux/apache/mysql box the form looks like this

<base href="http://linux_server/wiki/index.php/" />
<form action="TitleSearch" method="get"

and this works.

I've been wading through the code trying to work out why it's putting
?pagename=TitleSearch and not
<input type=hidden name=pagename value=TitleSearch> in the form
but I'm still learning the guts of this and there seems to be alot of
abstraction

unfortunately I have to use NT/IIS/MSSQL (the linux box is hidden under my
desk) if I want to use PHPWiki

can anybody help???

thanks,
Daniel Quinlan

> -----Original Message-----
> From: Quinlan D 
> Sent: 12 April 2002 15:31
> To: 'php...@li...'
> Subject: v1.3.3 with MS SQL
> 
> 
> hi,
> 
>   I've been working on adding MS SQL support to v1.3.3
> I've got the schema and the backend/mssql.php mostly done but 
> I'm getting a weird truncation error.
> 
> when I first browse to the wiki the Virgin pages generate 
> fine but they all get truncated to 254 characters.
> I'm using VARCHAR(4000) in the schema (T-SQL won't allow some 
> of the statements in phpwiki on a TEXT field)
> so there should be more than enough room.
> 
> before I start digging through the code has anyone seen this before?
> 
> regards,
> Daniel Quinlan
> 


***************************************************************************************
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. 
If you have received this email in error please notify pos...@mf... immediately.

This footnote also confirms that this email message has been swept for the 
presence of computer viruses.
***************************************************************************************