search

caljer1 / auto-repair-shop

Automatically exported from code.google.com/p/auto-repair-shop
0 stars 0 forks source link

Hosted version of app crashes on Find operation. #3

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Go to http://auto-repair-shop.appspot.com/
2. Enter a new customer
3. Hit Find Customer button on left side.
4. Enter first name of customer just added.
5. Hit the Search button.

Expect to see a list of customers below the search fields.  Instead see
error message.  Traceback info, followed by:

NeedIndexError: no matching index found.
This query needs this index:
- kind: CustomerEnt
  properties:
  - name: first_name
  - name: last_name

There seems to be some difference between the local environment and the
hosted environment that causes this error to occur.

Original issue reported on code.google.com by bd.gai...@gmail.com on 6 Jun 2009 at 12:54

GoogleCodeExporter commented 9 years ago 
I remember reading about indexes. Will look it up.

Original comment by fionawhw...@gmail.com on 6 Jun 2009 at 3:59

GoogleCodeExporter commented 9 years ago 
Found out how to handle indexes.
Now the task is to run all possible query during testing so that we have all 
indexes 
ready.
Besides, we also want to determine if "ORDER by last_name, first_name" is the 
sort 
order we want.

Original comment by fionawhw...@gmail.com on 7 Jun 2009 at 4:29

GoogleCodeExporter commented 9 years ago 
I would suggest we stick with last_name, first_name.  We can change the 
presentation
in the user interface to match the sort order.

I suspect this decision is fairly arbitrary, so since last_name, first_name is 
fairly
conventional, maybe this is the way to go.

Original comment by bd.gai...@gmail.com on 7 Jun 2009 at 5:52

GoogleCodeExporter commented 9 years ago

Original comment by bd.gai...@gmail.com on 12 Jun 2009 at 9:11