If you do a new ticket to an entity does that work ok?
Have you tried changing the customer? Ie if the entity name is ‘out of date’ as been changed in management it would ‘update’
Open the ticket click select customer again and search for different one and select that.
When I open up the unpaid ticket (from customer “Lost Hermanos”), there is NO “Select Customer” button. Even when I try to close this ticket (without settling), the crash occurs.
If I create a new order, save the unpaid order to a new customer, then re-open that customer’s ticket, then everything works fine. There is a “Select Customer” button with this new customer.
I changed it to question this is a configuration error and not a real SambaPOS issue. It seems you changed or deleted the entity type for that entity. It was assigned to that ticket type originally. You need to remake and reassign that entity type to that ticket type. I am out of town today but when I get home I can look deeper.
Did you rename or delete any Entity Types?
Please look here for when and how to use the Issue category:
No, the entity allocated to the problem ticket is NOT in the entity list.
The problem is that I did mess with Entity Type, but I don’t even remember what it was. I hoped that was just a small issue that I overlooked. It looks like I might have to dig deep.
I am going to recommend you stop using CE and try either LocalDB SQL Express or install SQL Express 2014 and convert your database to SQL. CE is limited and frankly slower and underpowered compared to SQL.
PS. I am still looking. It is because of the Entity but I am converting your database to SQL so I can look at it in MSSMS to see whats going on.
Great tutorial for converting it to SQL express 2014
Scroll down in the tutorial for instructions on converting the SDF file.
Well apparently you changed the Entity to ... it was originally Lost Hermanos… changing it back did not fix it so there is more links missing I am still looking.
Ok its the Entity Type ID is not matching you must have deleted the Entity Type or did something to it. It originally was 1 now its 5. But that Ticket the entity assigned still thinks the Type is 1. I am looking how to fix it.
Essentially you messed up the database relation for that Entity to the Entity Type.
Kinda strange dont think ive seen this before. I wasnt even sure it was possible lol.
Throwing out a guess here, but you cannot delete an Entity nor an Account if it has been used in a Ticket Transaction. SambaPOS prevents you from doing this. If you manually deleted something from the DB using a query, then I could see how this issue would arise.
Also, renaming an Entity or Account (or pretty much anything for that matter) should have almost no effect, since the Transactions are based on IDs, not names.
Yes, that is what I am saying. Renaming an Entity (or Entity Type) is allowed - it should have no effect. Perhaps the fact that the Entity Name is . . . it is throwing things off.
@Jesse, are you looking in the [TicketEntities] table for this Ticket?
I changed it back and its still crashing so its not that. The fact that the Change Entity button is not showing makes me think its something to do with the Entity Type.
Yes I am lookiing at all the tables involving this ticket trying to piece it together.
The Entity ID is 5… that Entity was ... but the ticket it says Lost Hermanos… so it was previously Lost Hermanos at one point… I changed it back and had no effect.
EDIT: Maybe I am looking at wrong thing. Will look a little deeper at accounts etc.
You know what… thats it… the Ticket Type id was 1. He only has a ticket type with id of 2 I am not sure how that got changed with a ticket assigned.
Apparently right after this ticket was made you switched ticket types somehow. This was last ticket with Ticket Type id of 1
How in the world did it let him delete the ticket type.
I am not sure how to fix that other than editing the database. It definitely had Ticket Type ID of 1 and that changed to 2 so somehow the TicketType changed or got deleted that used to be 1.