Re: [Phpwiki-talk] How can I fix the MySQL table prefix?

[Amilcar do C. L. <am...@id...>]

On Wednesday 01 September 2004 06:25, Reini Urban wrote:
> Amilcar do Carmo Lucas schrieb:
> > Reini Urban wrote:
> >> Amilcar do Carmo Lucas schrieb:
> >>> Hi!
> >>>
> >>> I've seen this line:
> >>> ; Note: This prefix is NOT prepended to the default DBAUTH_
> >>> ;       tables user, pref and member!
> >>> ;DATABASE_PREFIX = phpwiki_
> >>>
> >>> And I would like to know what I need to do to fix it.
> >>
> >> what do you want to fix?
> >
> > I would like _ALL_ phpwiki tables to use the DATABASE_PREFIX
> > Currently the user, pref and member tables do not use it.
>
> you have to fix the schemas/mysql-initialize.sql file.
Yeap, I had done that already

> >> the database tables by using the DATABASE_PREFIX,
> >> or the sql statements defining the access to the user, pref and member
> >> tables?
> >>
> >> if you need a DATABASE_PREFIX and use dbauth and db prefs, fix the sql
> >> statements also.
> >
> > Could you be more specific? And are the sql statements spreaded all over
> > the code, or like phorum5, where they are concentrated in one file ?
>
> one file only. you have to fix config/config.ini
> just the sql statements.
>
> e.g. with mysql and db prefs:
> DBAUTH_PREF_UPDATE = "REPLACE INTO prefix_pref SET
> prefs='$pref_blob',userid='$userid'"
I started to do that too, but it seamed to not help. Now I know that I might 
have missed dome lines. Thanks!!!!

-- 
Amilcar Lucas
Current webmaster
The KDevelop project