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

[Reini U. <ru...@x-...>]

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.

>> 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'"

-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/