unable to update custome setting from force.com sites

Ok i give up and need some help....

I have pageRefrenece method that needs to generate a list of strings for the search auto complete to use, based on search params and cache time. (This is all using force.com sites) So when the user goes to search i first check to see if any of the params have changed by comparing them to a saved custom setting that holds the last searched data. If its a new search or one of the params have changed, the method updates the list of strings accordingly and then updates the custom setting with the new search params... this is where it is failing.

As a part of trouble shooting i took the block of code and put it in the Execute Anonymous and ran it with more system.debug lines to see why it might be failing.... but no error this time. In the system logs for the page, when i run it i see the error System.LimitException: DML currently not allowed as shown below:

but when i run the block in the Execute Anonymous the logs dont show the same error:

I thought the issue might be the 'with sharing' i had on the class but it still failed even when i removed that...

here is the code....

string lang = 'en';
string prod = 'lmipro2';
list<string> titleListToShow = new List<string>();
List<string> doctypes = new List<string>();
//normally more than one added to list but for testing lets just deal with one
doctypes.add('Video__kav');	
if(selfservicehelperclass.seeIfNewListIsNeeded(doctypes, lang, prod) || titleListToShow == null){
  titleListToShow = selfservicehelperclass.getAllTitleLists(doctypes, lang, prod);
  system.debug('\n\n in titleSearch titleListToShow: ' + titleListToShow + '\n\n ');
  string dcToSave;
  for(string stype: doctypes){
    if(selfservicehelperclass.CheckForNullString(dcToSave)){
      dcToSave = dcToSave + ',' + stype;
    }else{
      dcToSave = stype;
    }
  }
  system.debug('\n\n in titleSearch dcToSave: ' + dcToSave + '\n\n ');
  SelfServiceSettings__c selfSerSet = SelfServiceSettings__c.getOrgDefaults();
  system.debug('\n\n in titleSearch selfSerSet before update: ' + selfSerSet + '\n\n ');
  selfSerSet.LastTitleSearch__c = datetime.now();
  selfSerSet.docTypesSearched__c = dcToSave;
  try{
    database.update(selfSerSet);
    system.debug('\n\n in titleSearch sss: ' + selfSerSet + '\n\n ');
  }catch(exception e){
    system.debug('\n\n in titleSearch e: ' + e + '\n\n ');
  }
}

November 10, 2010
·
Answer
·
Like
0
·
Follow
0

TankGirl
I just tried changing the custom setting from a Hierarchy to a list, thinking that maybe the sharing rules wouldnt allow them to update the org defaults of the Hierarchy.... but it still gave the same error...

November 10, 2010
·
Like
0
·
Dislike
0

paul-lmi

saving any custom setting for sites that's "per user" won't work. all sites traffic runs as a single user, so users' actions wouuld conflict with each other. save that in a cookie instead. in this scenario, you wouldn't be able to save the titles in a cookie because it's require an extra page load to pick them back up (so would the settings for last searched/updated/etc).

because the title cache is already in a custom setting, there's no big issue in querying this in real time and on any change of params. no performance hit when you query custom settings vs. custom objects which have a soql performance hit.

i know generating a new list of titles from the cache seems wasteful because the query syntax is the same, but it's really not, if the cache is populate by a separate process (scheduler).

November 10, 2010
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

unable to update custome setting from force.com sites

You need to sign in to do that.