phpwiki-talk

[Phpwiki-talk] DBAUTH_PREF_INSERT

[<tho...@la...>]

Hello,
I've just updated my cvs repository.

In config/config-dist.ini, I see :
; DBAUTH_PREF_INSERT = "INSERT INTO pref SET prefs='$pref_blob', userid='$userid'"

This is not compatible with Postgresql !

The good statement for _all_ SQL SGBDRs is :
DBAUTH_PREF_INSERT = "INSERT INTO pref (prefs,userid) VALUES ('$pref_blob','$userid')"

While config-dist.ini is used by the configurator, it will be wise to
correct this :)

Greetings,
-- 
Thomas Harding

Re: [Phpwiki-talk] DBAUTH_PREF_INSERT

[<tho...@la...>]

On Wed, Oct 12, 2005 at 09:18:48PM +0200, Thomas Harding wrote:
> DBAUTH_PREF_INSERT = "INSERT INTO pref (prefs,userid) VALUES ('$pref_blob','$userid')"

It seems to be the reverse :
DBAUTH_PREF_INSERT = "INSERT INTO pref (userid,prefs) VALUES ('$userid','$pref_blob')"
 
The user's administration patch I've just sent correct this.

-- 
Thomas Harding

Re: [Phpwiki-talk] DBAUTH_PREF_INSERT

[John S. <jst...@gm...>]

Hi Thomas,
It was meant to allow for you to configure the INSERT clause for the backen=
d
DB you use. This was the for Oracle. Since Oracle does not have a REPLACE
clause (MySQL specific), I used this to to do an initial INSERT for user
prefs. Without it, user prefs were never saved or updated. See my Rant ;)
Regards

On 10/13/05, Thomas Harding <tho...@la...> wrote:
>
> Hello,
> I've just updated my cvs repository.
>
> In config/config-dist.ini, I see :
> ; DBAUTH_PREF_INSERT =3D "INSERT INTO pref SET prefs=3D'$pref_blob',
> userid=3D'$userid'"
>
> This is not compatible with Postgresql !
>
> The good statement for _all_ SQL SGBDRs is :
> DBAUTH_PREF_INSERT =3D "INSERT INTO pref (prefs,userid) VALUES
> ('$pref_blob','$userid')"
>
> While config-dist.ini is used by the configurator, it will be wise to
> correct this :)
>
> Greetings,
> --
> Thomas Harding
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>

Re: [Phpwiki-talk] DBAUTH_PREF_INSERT

[Reini U. <rei...@gm...>]

Thanks guys.
I also fixed the second INSERT.

And made the simple methods to the pref table default.
I want to deprecate the old users table.

On 10/13/05, John Stevens <jst...@gm...> wrote:
> Hi Thomas,
>  It was meant to allow for you to configure the INSERT clause for the
> backend DB you use.  This was the for Oracle.  Since Oracle does not have=
 a
> REPLACE clause (MySQL specific), I used this to to do an initial INSERT f=
or
> user prefs.  Without it, user prefs were never saved or updated.  See my
> Rant ;)
>  Regards
>
>
> On 10/13/05, Thomas Harding <tho...@la...> wrote:
> > Hello,
> > I've just updated my cvs repository.
> >
> > In config/config-dist.ini, I see :
> > ; DBAUTH_PREF_INSERT =3D "INSERT INTO pref SET prefs=3D'$pref_blob',
> userid=3D'$userid'"
> >
> > This is not compatible with Postgresql !
> >
> > The good statement for _all_ SQL SGBDRs is :
> > DBAUTH_PREF_INSERT =3D "INSERT INTO pref (prefs,userid) VALUES
> ('$pref_blob','$userid')"
> >
> > While config-dist.ini is used by the configurator, it will be wise to
> > correct this :)
--
Reini Urban