Re: [Gusdev-gusdev] sql change table

[<fed...@bi...>]

Ok! As also Poliana suggested I inserted values in my core.userinfo table;
problems were because my table was empty! Now if I type 'select' I can see
what I inserted. I have inserted random values, except for login and
passward; now my questions are:
1) it's right my tables were empty; in the documentation I read only the
core.machine is empty;
2) it's a problem for values I inserted randomly, like row_user_id..? If
it's a problem, where I can find the right values?
Thanks everyone!
Federica


> Hi Federica,
>
> It sounds like the row doesn't exist...   Did you do the preliminary
> insert?
>
> select count(*) from core.userinfo;
>
> This should be >= 1.  If not, refer back to the documentation about
> populating these tables.
>
> --Mike
>
>
> fed...@bi... wrote:
>> Thanks Poliana,
>> I tried as you suggest; no error appeared but I had always the same
>> reply:
>> '0 rows updated'.
>> I connect to Oracle as 'sys/password as sysdba'.
>> Any other ideas about how to solve the problem?
>> Thanks
>> Federica
>>
>>
>>
>>>Hi Federica,
>>>
>>>Try
>>>
>>>UPDATE core.userinfo SET login='your_login', password='your_password'
>>>WHERE user_id = 1;
>>>
>>>Poliana
>>>
>>>
>>>On Wed, 9 Feb 2005 18:32:14 +0100 (CET), fed...@bi...
>>><fed...@bi...> wrote:
>>>
>>>>Hi guys, I'm Federica! Some months ago I had some problems with GUS
>>>>installation; then I had to perform other tasks, and after that I
>>>>decided
>>>>to delete everything and restart all!!
>>>>I have got a new problem. I've never used sql before: I can't change
>>>> the
>>>>login, password and group in the core.userinfo, core.groupinfo,
>>>>core.projectinfo tables! For example when I try to select or update
>>>> some
>>>>rows of core.userinfo table the replay is always: 0 rows
>>>>selected/updated.
>>>>Anyone can help me?
>>>>Thanks, Federica
>>>>
>>>>-------------------------------------------------------
>>>>SF email is sponsored by - The IT Product Guide
>>>>Read honest & candid reviews on hundreds of IT Products from real
>>>> users.
>>>>Discover which products truly live up to the hype. Start reading now.
>>>>http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>>>>_______________________________________________
>>>>Gusdev-gusdev mailing list
>>>>Gus...@li...
>>>>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>>>
>>>
>>>
>>>-------------------------------------------------------
>>>SF email is sponsored by - The IT Product Guide
>>>Read honest & candid reviews on hundreds of IT Products from real users.
>>>Discover which products truly live up to the hype. Start reading now.
>>>http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>>>_______________________________________________
>>>Gusdev-gusdev mailing list
>>>Gus...@li...
>>>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>>
>>
>>
>>
>>
>>
>> -------------------------------------------------------
>> SF email is sponsored by - The IT Product Guide
>> Read honest & candid reviews on hundreds of IT Products from real users.
>> Discover which products truly live up to the hype. Start reading now.
>> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>> _______________________________________________
>> Gusdev-gusdev mailing list
>> Gus...@li...
>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>