By thalias on

I've installed the latest version of drupal with postgres and everything works properly except I cannot set permissions for users. I check the boxes to allow anonymous users to view content, post comments etc hit submit and the page reloads with all the boxes unchecked and no changes are made to the system. Everything else seems to work okay and registered users can see content. Anonymous users obviously still can't see any content. Any hints?

Comments

moshe weitzman’s picture

moshe weitzman commented

do you see any errors in your watchdog ... can anyone with postgres confirm or deny this behavior? does latest version mean CVS or 4.1?

thalias’s picture

thalias commented

I'm using 4.1, there are lots of sql errors:

age:database: DB Error: unknown error query: INSERT INTO permission (rid, perm, tid) VALUES ('2', 'access Blogger API, access comments, access content, post comments without approval', '')

database: DB Error: unknown error query: SELECT r.rid, p.perm FROM role r LEFT JOIN permission p ON r.rid = p.rid WHERE tid = '' ORDER BY name

There are other errors related to the query as well.

raphaelr’s picture

raphaelr commented

I got the same problem.

PostgreSQL showed this error: ERROR: pg_atoi: zero-length string

Itested it out directly with psql and it has something to do with the value of tid.

dries’s picture

dries commented

PostgreSQL users probably want to upgrade to the latest CVS version of the DRUPAL-4-1-0 branch or to the HEAD branch if you don't mind using a development version. We use the HEAD version on drupal.org with MySQL as the database backend and we have yet to spot problems.

In both branches we fixed SQL queries to be ANSI compliant. This work was done by and for PostgreSQL users. Admittedly, we might not have fixed them all which is why we could do with more testing and with PostgreSQL users that are not afraid to fiddle with Drupal's innards.

In short: we are more than willing to help but we need your help with testing the latest versions.