First time here? Check out the FAQ!
Ask Your Question
0

duplicate key value violates unique constraint "livesettings_setting_site_id_key"
 
   
  
 
 
I get the following error.  Any idea whats wrong here?
 
IntegrityError at /settings/SIDEBAR_MAIN/
 
duplicate key value violates unique constraint "livesettingssettingsiteidkey"
 
Request Method:     POST
Request URL:    http://ask.stg.fedoraproject.org/settings/SIDEBARMAIN/
Django Version:     1.2.6
Exception Type:     IntegrityError
Exception Value:    
 
duplicate key value violates unique constraint "livesettingssettingsiteidkey"
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 mether's avatar

      1.5k
    
 
 
 
 mether 
 
 
    asked 13 years ago 
 
 
 
 
        
 
 
 
Comments
 
 
 
 
  
 
 
 
@mether, do you remember how we solved this?
 
 
 Evgeny's avatar Evgeny (13 years ago)   
 
 
  
 
 
1
  
 
 
 
You logged in and fixed something and then later fixed it in Askbot as well.  It was some bug.  
 
 
 mether's avatar mether (13 years ago)   
 
 
  
 
  see more comments  
 
 
 
 
 
 2 Answers
  
  
   
 
 
 
 
1
 
 
  
 
 
 
 
 
 
The result? 'impossible to use livesettings without memcached' ... we found it out on our own, but the livesettings author confirms it to be the case too.
 
https://bitbucket.org/bkroeze/django-livesettings/issue/32/impossible-to-easy-use-livesettings
 
"If the cache backend configuration is "locmem", it works good only with development server. For production with multiprocess deployment it is necessary to use memcached, otherwise old values can be randomly used so long, until the CACHE_TIMEOUT expires. It is very annoying if a change have been saved and shortly other change should be submitted, because the old vaue can remain in the form and be resubmitted back."
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 drpoovilleorg's avatar

      51
    
 
 
 
 drpoovilleorg 
 
 
    answered 13 years ago 
 
 
 
 
     link   
 
 
 
Comments
 
 
 
  see more comments  
 
 
 
   
 
 
 
 
0
 
 
  
 
 
 
 
 
 
We'll help you with more detail tomorrow, but possibly you are behind on migrations or dependencies. Did you take code from github?
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 Evgeny's avatar

      13.2k
    
 
 
 
 Evgeny 
 
 
    answered 13 years ago 
 
 
 
 
     link   
 
 
 
Comments
 
 
 
 
  
 
 
 
No.  This is the latest release, Not git snapshot
 
 
 mether's avatar mether (13 years ago)   
 
 
  
 
 
  
 
 
 
Please try python manage.py migrate --list that will show the list of migrations and which ones are pending, there must be some that have not been applied after you updated the code. And to apply any pending migrations - just type python manage.py migrate.
 
 
 Evgeny's avatar Evgeny (13 years ago)   
 
 
  
 
 
  
 
 
 
I'm seeing this issue too when trying to update settings. Did you ever find a root cause? I have a fresh install (followed instructions from your docs) , on a freshly installed system. Sometimes i don't see the error at all, but when i try to 'save' settings, the page appears to refresh but the setting doesn't appear to have actually changed... not sure what's going on, it's late but just wanted to see for now if you've seen this again since this question came up a while ago...
 
 
 drpoovilleorg's avatar drpoovilleorg (13 years ago)   
 
 
  
 
 
  
 
 
 
Did you use askbot-setup to create the project? Please feel free to email me your settings.py file at evgeny.fadeev@gmail.com. We had this problem before, but I don't remember how we overcame it. Possibly there is some missing dependency and the db transaction error is masking the real issue.
 
 
 Evgeny's avatar Evgeny (13 years ago)   
 
 
  
 
 
  
 
 
 
https://bitbucket.org/bkroeze/django-livesettings/issue/21/values-are-not-saved-in-the-database-in
 
 
 drpoovilleorg's avatar drpoovilleorg (13 years ago)   
 
 
  
 
  see more comments