I am testing a new SIDB installation. I've got
the CVS directly (with a checkout command).
Run install.php. When I try click on an image
from the "my images" menu I see the image and
also the following error message:
Illegal operation performed!
Reported error:
Could not execute query SELECT projectid from projectximages WHERE imageid='30'!
Errormessage reported from database:
ERROR: Relation 'projectximages' does not exist
I guess I should have done something else when
generating the new SIDB installation, but I don't
know what. Also, I don't remember to have seen
the button "projects" before. This one gives me
Illegal operation performed!
Reported error:
Could not execute query SELECT projectid FROM projects WHERE projectid IN (SELECT projectid FROM projects WHERE ( (userid='4') OR ( (rights='2') AND (5=(SELECT groupid FROM USERS
WHERE USERS.userid=projects.userid) ) ) OR (rights='4') ))
AND (( projectid NOT IN (
SELECT daughterid FROM projectxprojects) ) OR (projectid IN (SELECT daughterid FROM projectxprojects WHERE
motherid NOT IN (SELECT projectid FROM projects WHERE ( (userid='4') OR ( (rights='2') AND (5=(SELECT groupid FROM USERS
WHERE USERS.userid=projects.userid) ) ) OR (rights='4') )) ) )) ORDER BY name;!
Errormessage reported from database:
ERROR: Relation 'projects' does not exist
Any thoughts
PS: I still have the old (0.17) installation and
it does work.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This smells like the same problem. I suspect that you have these installations on the same machine and that you are accessing one and the same Postgres database from both. DANGEROUS!!! the cvs version does not find certain table and columns since you did not update nicely. Please delete that folder, get a new cvs export. Rename the database name in config_template/includes/config_inc.php and try the install.php script again.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There we start again...
I am testing a new SIDB installation. I've got
the CVS directly (with a checkout command).
Run install.php. When I try click on an image
from the "my images" menu I see the image and
also the following error message:
Illegal operation performed!
Reported error:
Could not execute query SELECT projectid from projectximages WHERE imageid='30'!
Errormessage reported from database:
ERROR: Relation 'projectximages' does not exist
I guess I should have done something else when
generating the new SIDB installation, but I don't
know what. Also, I don't remember to have seen
the button "projects" before. This one gives me
Illegal operation performed!
Reported error:
Could not execute query SELECT projectid FROM projects WHERE projectid IN (SELECT projectid FROM projects WHERE ( (userid='4') OR ( (rights='2') AND (5=(SELECT groupid FROM USERS
WHERE USERS.userid=projects.userid) ) ) OR (rights='4') ))
AND (( projectid NOT IN (
SELECT daughterid FROM projectxprojects) ) OR (projectid IN (SELECT daughterid FROM projectxprojects WHERE
motherid NOT IN (SELECT projectid FROM projects WHERE ( (userid='4') OR ( (rights='2') AND (5=(SELECT groupid FROM USERS
WHERE USERS.userid=projects.userid) ) ) OR (rights='4') )) ) )) ORDER BY name;!
Errormessage reported from database:
ERROR: Relation 'projects' does not exist
Any thoughts
PS: I still have the old (0.17) installation and
it does work.
This smells like the same problem. I suspect that you have these installations on the same machine and that you are accessing one and the same Postgres database from both. DANGEROUS!!! the cvs version does not find certain table and columns since you did not update nicely. Please delete that folder, get a new cvs export. Rename the database name in config_template/includes/config_inc.php and try the install.php script again.