sql - Column 'ID' is constrained to be unique. Value is already present -

-

i constraint error not understand. 

system.data.constraintexception: column 'id' constrained unique.  value '01d3eb89-f4e1-4782-9519-da8f08e0638f' present.

the value repeated in member data - not see how constrained unique.

the query 

select memberdata.userid, memberdata.formrow, memberdata.value  authusers, memberdata   (authusers.groupid = @groupid , authusers.id = memberdata.userid       , memberdata.formid = @formid)   group memberdata.userid, memberdata.formrow, memberdata.value

authusers asp.net user table groupid field added guid.

memberdata data form data. has
formrow (guid) - points form definition row in formrow value (string)
id (int) - unique auto-increment key
userid (string) - userid authuser table
formid (guid) - points form definition in forms

memberdata has
memberdata.userid repeated each formrow, user's form data collection.
memberdata.formrow has many repeated every different userid, each user's data formrow in formid's form.
memberdata.formid repeated every formrow in form.
memberdata.value arbitrary user entered value.

the error user id repeated 5 times in data 5 fields in.

i trying populate member grid summary getting data rows in memberdata grouped userid summary row. groupid used because summary users in group.

this little embarrassing, message grid being loaded not database. pretty confusing, fixing sql query problems similar messages , final error message looked others in database consistent way. problems fixed in code logic.


Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

gradle error "Cannot convert the provided notation to a File or URI" -

-
i have defined 2 system properties in gradle.properties: systemprop.builddir=build systemprop.cfgdir=build\\cfg and have following task defined in build.gradle: task clean(group:'clean',description:'clean project') << { ant.sequential { delete(dir: system.properties.builddir) mkdir(dir: system.properties.builddir) delete(dir: system.properties.cfgdir) mkdir(dir: system.properties.cfgdir) } } this generates following error: execution failed task ':clean'. > cannot convert provided notation file or uri: {dir=build}. following types/formats supported: - string or charsequence path, e.g 'src/main/java' or '/usr/include' - string or charsequence uri, e.g 'file:/usr/include' - file instance. - uri or url instance. but equivalent block of code not generate error , works expected: task clean(group:'clean',description:'clean project') << { ...
Read more

python - NameError: name 'subprocess' is not defined -

-
i'm trying make rng website: http://jamesdotcom.com/?p=417 . when run following code: captureimage = subprocess.popen( [ "fswebcam", "-r", "356x292", "-d", "/dev/video0", "static.jpg", "--skip", "10" ], stdout=devnull, stderr=devnull) captureimage.communicate() i following error message: nameerror: name 'subprocess' not defined what should do? thanks have imported first? import subprocess captureimage = subprocess.popen(["fswebcam", ...) subprocess included in python standard library since python 2.4. should not necessary install it.
Read more