| Author |
Re: [PEAR] Re: liveuser admin problem
|
|
| Jeroen Houben 2005-10-12, 8:04 am |
| Lukas Smith wrote:
> Jeroen Houben wrote:
>
....[color=darkred]
>
> damn .. looks like i forgot to add this to the changelog:
> - removed is_active, owner_group_id, owner_user_id from groups table
> (need to be added in the config just like for users now)
Okay. So how would ik upgrade my DB schema to reflect this without
losing the data?
Jeroen
| |
| Lukas Smith 2005-10-12, 8:04 am |
| Jeroen Houben wrote:
>
>
> Okay. So how would ik upgrade my DB schema to reflect this without
> losing the data?
depends on what you want to do ..
if you want to use the is_active field you dont really have to change
your db schema .. all you have to do is add is_active to your config array.
regards,
Lukas
| |
| Jeroen Houben 2005-10-12, 8:04 am |
| Lukas Smith wrote:
> Jeroen Houben wrote:
>
>
>
> depends on what you want to do ..
>
> if you want to use the is_active field you dont really have to change
> your db schema .. all you have to do is add is_active to your config array.
Hmm, no I want to remove the storing (and using) of is_active,
owner_group_id, owner_user_id alltogether.
Jeroen
| |
| Lukas Smith 2005-10-12, 8:04 am |
| Jeroen Houben wrote:
> Hmm, no I want to remove the storing (and using) of is_active,
> owner_group_id, owner_user_id alltogether.
yeah ... then regenerate your xml schema file and run the installer
again .. however i would recommend doing a test run before you hit the
real data .. MDB2_Schema is still heavily under development.
regards,
Lukas
| |
| Lukas Smith 2005-10-12, 8:04 am |
| Lukas Smith wrote:
> Jeroen Houben wrote:
>
>
>
> yeah ... then regenerate your xml schema file and run the installer
> again .. however i would recommend doing a test run before you hit the
> real data .. MDB2_Schema is still heavily under development.
I just added a "disable_query" optional parameter to installSchema() in
CVS that can be used for this exact purpose.
regards,
Lukas
| |
| Jeroen Houben 2005-10-12, 6:57 pm |
| Lukas Smith wrote:
> Lukas Smith wrote:
>
>
>
> I just added a "disable_query" optional parameter to installSchema() in
> CVS that can be used for this exact purpose.
I'm not using this, I just created a backup - that's good enough for now
as I'm still working on a dev server.
generate_schema did not work.
["error_message_prefix"]=>
string(0) ""
["mode"]=>
int(16)
["level"]=>
int(1024)
["code"]=>
int(-6)
["message"]=>
string(25) "MDB2 Error: not supported"
["userinfo"]=>
string(71) "[Error message: alterTable: change type "lu_users\" not
yet supported]
"
....
I'm using postgresql 8.
Jeroen
|
|
|
|