Print  
Gray star Gray star Gray star Gray star Gray star --Not rated--
506 Visits 10 Comments
Created
Marcel Dekker Marcel Dekker
Feb 18, 2009 2:13 PM
Modified by
Marcel Dekker Marcel Dekker
Feb 18, 2009 2:13 PM
Kablink Component
  • Teaming

Hi all,

today I installed a new build to fix (amongst other things) the thumbnail view in photoalbums. But now I cannot open the  Access Control page. It gives the following error:

class org.springframework.dao.InvalidDataAccessResourceUsageException
could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

Marcel

Workflow
Process State Action
Discussion workflow Active
This entry is currently active
Attachments(0)
Entry History
Tags
  
Replies
Thumbnail Image
Marcel Dekker Marcel Dekker
Feb 18, 2009 2:20 PM
Second thing is that my personal account is no longer a site administrator after installing the new build
Thumbnail Image
Marcel Dekker Marcel Dekker
Feb 18, 2009 2:21 PM
Seems the Who has access link gives me the same error
Thumbnail Image
Marcel Ramaker Marcel Ramaker
Feb 19, 2009 12:05 AM

Hi Marcel,

Which version of MySQL are you using? 
Thumbnail Image
Marcel Dekker Marcel Dekker
Feb 19, 2009 8:08 AM

Hi,

MySQL version is 5.0.45. Used it on the previous build and it was working then.

Thumbnail Image
Marcel Dekker Marcel Dekker
Feb 19, 2009 10:08 AM

Just checked my ssf.log file and I think this error might be why I cannot open Access Control page.

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'this_.internalId' in 'field list'

Looks like there was a little change in the database. Is there a way to fix this without recreating the database?

Marcel

Thumbnail Image
Brent McConnell Brent McConnell
Feb 19, 2009 2:17 PM

There is currently work being done in this area.   If a column has been added it should be in your SVN tree.  If you are running MySQL look for ...

 ./tools/sql/update-1.0.0-1.1.0/update-mysql.sql

Be sure to run mysqldump beforehand to backup  your database as there are no guarantees :-0)

 
Thumbnail Image
Marcel Dekker Marcel Dekker
Feb 21, 2009 9:37 AM

Hi Brent,

the update script didn't want to run on my database, so I recreated the database. That solved the problem, but I'm not able to restore the old database. It is complaining about some key constraints failing.

#1452 - Cannot add or update a child row: a foreign key constraint fails (`sitescape2/JBPM_ACTION`, CONSTRAINT `FK_ACTION_EVENT` FOREIGN KEY (`EVENT_`) REFERENCES `JBPM_EVENT` (`ID_`)) 

Do you have any idea what might be causing this?

Marcel

Thumbnail Image
Nathan B Jensen Nathan B Jensen
Feb 25, 2009 12:33 AM

Hi Marcel,

You will have a problem restoring a 1.0 database if you recreated your database with the lastest db scripts.  The newer database has some columns and constraints that have changed from 1.0.0 to 1.1.0 and the upgrade scripts handle that process of altering constraints and removing unused columns.

You will need to recreate your database with the 1.0 scripts and then restore it.   Once your database is restored you can try the update scripts, again.

If you continue to have issues with the update scripts let me know.

Thumbnail Image
Marcel Dekker Marcel Dekker
Feb 25, 2009 7:46 AM

Hi Nathan,

de update from a 1.0 database works fine. In this case I was restoring a database from a previous 1.1.0 build and database (from somewhere in December) and that didn't work.

Marcel

Thumbnail Image
Nathan B Jensen Nathan B Jensen
Feb 25, 2009 5:13 PM

The following db changes since december may require a manual update.  The update scripts will have the necessary changes in them from 1.0 to 1.10 database but if you are in an intermediate state these are the following changes that have been made in the last month or so.

Database changes checked in on 12/18/08

I just removed one of the quartz jobs from the build. You need to manually remove from your db tables.
 
delete from SSQRTZ_simple_triggers where TRIGGER_NAME='1' and TRIGGER_GROUP='deployer';
delete from SSQRTZ_triggers where JOB_NAME='1' and JOB_GROUP='deployer';
delete from SSQRTZ_job_listeners where JOB_NAME='1' and JOB_GROUP='deployer';
delete from SSQRTZ_job_details where JOB_NAME='1' and JOB_GROUP='deployer';
commit;
 
Changes on 1/5/09
 
You will need to execute the following commands before restarting.
 
With this update, we have renamed the right siteAdministration to zoneAdministration and added right addGuestAccess.  Both of these rights are now available only under the adminMenu/access control.  In 1.0.3 siteAdministration right was seen on all binders but was meaningless unless you were at the top.  Now it is available only where it makes sense.  The role siteAdministration still exists for old customers but is not created for new sites.
 
In addition 2 new roles are added to contain the 2 new rights (this just makes it easier to fit into the existing infrastructure).  These roles are pre-configured and cannot be changed. 
 
The new addGuestAccess right contains the users/groups that can add guest access to workspaces/bolders that they manage. 
 
Janet
 
Mysql:
alter table SS_Functions add column internalId varchar(32);
alter table SS_Functions add column zoneWide bit;
update SS_Functions set zoneWide=b'0';
 
Oracle:
alter table SS_Functions add internalId varchar2(32 char);
alter table SS_Functions add zoneWide number(1,0);
update SS_Functions set zoneWide=0
 
Sqlserver:
alter table SS_Functions add internalId varchar(32);
alter table SS_Functions add zoneWide tinyint;
update SS_Functions set zoneWide=0;
 
Update on 01/26/2009
 
You will need to do the following after the next update.
 
update SS_LdapConnectionConfig set credentials=null;
mysql:
alter table SS_Postings add column credentials varchar(64);
sqlserver:
alter table SS_Postings add credentials varchar(64);
oracle:
alter table SS_Postings add credentials varchar2(64 char);
 

 
Skip Footer Toolbar
Permalink