I've spend last two nights to solve this problem ...
wrrrrrrrrrrrrrrrr
and I foun it!!!!!
there's no problem with data base!
there's no problem with XOOPS files!
there's no problem with .htacces!
so where it is?
in IE
(look on to down of screen in your IE there must be a "page with restictions" double click on in then change access on cookies to the domain)
my personal way to this great discovery:
1. complete XOOPS instalation (1st XOOPS intalation + 1st db)
2. loged into site
3. there was problem to login into admin site
4. I tryed to work with another db (2nd on other server) - the same problem
5. workinng on another instalation(2nd XOOPS instalation + 1st db - no problem - so the problem was in server (rememer - not only host but domain too)
6. there was no .htacces file, so I created it, tryin allmost everytking with it - vieving, php ver etc - no response
7. checking all directories and files chmods .. everything was ok
8. cleanig 1000 times cache, templates_c folders wrr
9. checking site in firefox, and then! no problems
10. and then I saw it - on the bottom of the IE - site with restriction ...
then step as I wrote on beginning - and there's no problems fellows!
WE ALL FORGOT ABOUT COOKIES
PS on the 4th anniversary ...eh XOOPS BLESS YOU ALL ;)