Forum OpenACS Q&A: HELP!!!!!! First page is not accessible!

Hi all, our dev envieroment is not accessible for some users!!! If I try to access the system I get from the browser the error :
http://62.99.149.182:8000/register/?return_url=%2fregister%2f%3freturn%5furl%3d%252fregister%252f%253freturn%255furl%253d%25252fregister%25252f%25253freturn%25255furl%25253d%2525252fregister%2525252f%2525253freturn%2525255furl%2525253d%252525252fregister%252525252f%252525253freturn%252525255furl%252525253d%25252525252fregister%25252525252f%25252525253freturn%25252525255furl%25252525253d%2525252525252fregister%2525252525252f%2525252525253freturn%2525252525255furl%2525252525253d%252525252525252fregister%252525252525252f%252525252525253freturn%252525252525255furl%252525252525253d%25252525252525252fregister%25252525252525252f%25252525252525253freturn%25252525252525255furl%25252525252525253d%2525252525252525252fregister%2525252525252525252f%2525252525252525253freturn%2525252525252525255furl%2525252525252525253d%252525252525252525252fregister%252525252525252525252f%252525252525252525253freturn%252525252525252525255furl%252525252525252525253d%25252525252525252525252fregister%25252525252525252525252f%25252525252 525252525253freturn%25252525252525252525255furl%2525 2525252525252525253d%2525252525252525252525252f ---------
Form the db i get the error:
NOTICE: identifier "acs_permission__grant_permission" will be truncated to "acs_permission__grant_permissio"
DEBUG: pq_recvbuf: unexpected EOF on client connection
DEBUG: pq_recvbuf: unexpected EOF on client connection
DEBUG: pq_recvbuf: unexpected EOF on client connection -- For some users the system works fine. Thanks in advance!!!

Hi Jeff, Thanks for fast answer. I already cchecked it. It is set to 0!! So mybe on other idea?

I just realized that you may not be able to access the site-map via the browser.  So you can try:

    select * from acs_permissions where object_id = (select object_id from site_nodes where parent_id is null)

I guess you could also add this clause since your main site surely inherits from the 'default context':

    union select * from acs_permissions where object_id = acs__magic_object_id('default_context')

G'luck...

I do not see the problem either.  What changes have you made to the site since it was last working?  Anything interesting in your logs?

The problem was related to the upgrade script from 4.6 to 4.6.1 in pg.
acs-kernel/sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql

this gave back an error:
insert into acs_objects
  (object_id, object_type)
values
  (0, 'person');

so did an update like this:
update acs_objects
set object_type = 'person'
where object_id = 0;

and everything works fine.

If you explain which thing you did made it work, that will help other people in the future. In general, this is good community practice 😊

That way, the next person who comes along can save themselves some time.