From: <fed...@bi...> - 2005-02-09 17:32:27
|
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 |
From: Poliana M. <pol...@gm...> - 2005-02-09 18:02:54
|
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 > |
From: <fed...@bi...> - 2005-02-10 09:25:37
|
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 > |
From: Michael S. <msa...@pc...> - 2005-02-10 13:02:29
|
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 |
From: <fed...@bi...> - 2005-02-10 14:07:54
|
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 > |