Comments (8)
This is a Django bug caused by a MySQL limitation:
http://code.djangoproject.com/ticket/2495
Basically, MySQL's complaining because it won't let you index a whole BLOB. The
workaround is to leave the UNIQUE off and add the index later using an ALTER
table
command.
Original comment by [email protected]
on 7 Oct 2008 at 3:54
from django-survey.
This should already be fixed (thank to brosner)
Original comment by [email protected]
on 17 Oct 2008 at 4:29
- Changed state: Fixed
from django-survey.
oops, confused this with something else.
This issue has yet to be fixed in django.
I am still not comfortable marking the text field non-unique.
Original comment by [email protected]
on 17 Oct 2008 at 4:33
- Changed state: New
from django-survey.
Still a problem with MySQL that should be fixed in the DJango cod, but hasn't
been.
Problem has been around since Jun 2008
Comment out the unique_together(...) call, syncdb, then turn it back on.....
Can't find any docs on unique_together, but if you could specify a keylength,
maybe
this could be fixed here.....
Original comment by [email protected]
on 27 Dec 2008 at 7:14
from django-survey.
This problem still exists. I followed the approach from mandric in the original
post--that is, I changed the TextField to a CharField with a max_length of 500.
Original comment by [email protected]
on 28 Aug 2009 at 3:53
from django-survey.
it is needed to limit UNIQUE keys like that:
UNIQUE (`survey_id`, `text`(100))
Original produces
UNIQUE (`survey_id`, `text`)
and mysql does not allow UNIQUE keys more than 1000 byte.
Modified sql is attached. Or do like that
$ /manage.py sqlall survey > survey.sql
and open and change lines below in survey.sql
UNIQUE (`survey_id`, `text`)
to
UNIQUE (`survey_id`, `text`(100))
and
UNIQUE (`question_id`, `text`)
to
UNIQUE (`question_id`, `text`(100))
and save survey.sql and execute this file with your mysql client app on your
database.
Original comment by [email protected]
on 10 Mar 2010 at 11:24
Attachments:
from django-survey.
Hey ... why I'm still having this problem ?
Original comment by [email protected]
on 4 Jul 2011 at 3:59
from django-survey.
Hey ... why I'm still having this problem ?
Original comment by [email protected]
on 4 Jul 2011 at 3:59
from django-survey.
Related Issues (20)
- Some views were accepting a template argument but never actually using it HOT 1
- a number of survey url patterns using '\d' instead of '\d+' ... more then 10 questions or 10 choices and bad stuff.. HOT 1
- No submission_count HOT 2
- Survey title longer than slug length limit errors on save HOT 2
- KeyError when editing questions via admin HOT 1
- ReverseMatch error when attempting to delete questions HOT 3
- Docs for recipient type, recipient id HOT 5
- Allow definition of 'next_page' in Survey model [patch attached] HOT 2
- Wrong confirmation msg when deleting a question HOT 1
- Answering survey with checkbox choices generates 500 HOT 1
- Related field question type HOT 2
- Non-staff can
- Submissions count off by one HOT 1
- Survey locking
- Multipage surveys HOT 4
- Add an interview table to help custom query reports. HOT 1
- Add an interview table to help custom query reports. HOT 2
- Checkbox answers don't save with user. HOT 3
- Adding multiple type choices in a question
- 'AdminSite' object has no attribute 'root' when example is run.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from django-survey.