search

tomay / rebioma

Automatically exported from code.google.com/p/rebioma
0 stars 0 forks source link

Cannot delete all "My Occurrences" #362

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Upload data
2. Search on "My Occurrences", "Private or public"
3. Select all records, apply action to all records, delete
3. Select action "delete"

What is the expected output? What do you see instead?
Expect to delete records. Instead, get the following pop-up error
Delete failed: org.hibernate.QueryException: unexpected char: '@' [delete
org.rebioma.client.Occurrence where (ownerEmail='tom.allnutt@gmail.com')
and (ownerEmail = 'tom.allnutt@gmail.com') and (public_=true or
public_=false and ownerEmail=tom.allnutt@gmail.com)]

Please use labels and text to provide additional information.
Have not tested this on the server, this is on development machine only

Original issue reported on code.google.com by tom.alln...@gmail.com on 14 Jan 2010 at 9:08

GoogleCodeExporter commented 9 years ago 
replicated on server
could be as simple as quoting the third instance of "ownerEmail". then again, 
why is there a third (or second) instance of ownerEmail? this entire query 
seems quite contorted:
delete org.rebioma.client.Occurrence where (ownerEmail='tom.allnutt@gmail.com')
and (ownerEmail = 'tom.allnutt@gmail.com') and (public_=true or
public_=false and ownerEmail=tom.allnutt@gmail.com)

Original comment by tom.alln...@gmail.com on 29 Sep 2010 at 6:45

GoogleCodeExporter commented 9 years ago

Original comment by tom.alln...@gmail.com on 18 Feb 2011 at 4:29

GoogleCodeExporter commented 9 years ago 
need to check if the same issue applies to other actions

Original comment by tom.alln...@gmail.com on 18 Feb 2011 at 4:55

GoogleCodeExporter commented 9 years ago 
additional information:
>>> it is only an error when you have query
>>> filter set to "Public and Private", "Shared and unshared"
>>>
>>> If I just query "public" and then delete all - it works as expected

Original comment by tom.alln...@gmail.com on 30 Jun 2011 at 6:04

GoogleCodeExporter commented 9 years ago 
I'm not able to reproduce the issue

Original comment by ajmrakot...@gmail.com on 10 Aug 2011 at 2:21

GoogleCodeExporter commented 9 years ago 
Fixed with r1561

Original comment by tom.alln...@gmail.com on 10 Aug 2011 at 3:25