From: John S. <jst...@gm...> - 2005-10-12 23:29:08
|
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 > |