Samba crashes when trying to settle open tickets


#6

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.


#7

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.


#8

:-/ hmmm if it was an sql install I would have a go at fixed directly in table but not sure how/if this can be done on compact edition.

There is no select customer button on that ticket?
What’s the mapping like for the customer entity screen? Screenshot?


#9

Screen shot of NO Select Customer button for this problem ticket:

Mapping for Customer entity screen:

Screenshot of a new ticket WITH Select Customer button.


#10

Hmmmm, you may need to wait for more experienced help from @kendash or @QMcKay.

Just to clarify, that entity allocated to the problem ticket, is it in your entity list?


#11

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:
http://forum.sambapos.com/t/community-guidelines/3397


#12

Thank you for your help, @JTRTech.

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.


#13

Under ticket type you need to reassign the original entity type that entity belonged too.

You probably renamed it and it needs to be relinked to the ticket type


#14

The ticket’s Entity Type is blank (nothing is written in that box). I don’t know how to re-assign it to another ticket type.


#15

Can you pm me a copy of your database?


#16

PM sent. Thank you for taking a look at it.


#17

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

http://forum.sambapos.com/t/sql-express-2014-installation-sambapos4-database-setup/3363

Scroll down in the tutorial for instructions on converting the SDF file.


#18

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.


#19

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.

Did you delete a Document Type?


#20

Well he definitely renamed the Entity to ... How it let him do that with a ticket assigned I have no clue.

Although It looks like it will let you do that…

There are no documents linked its not paid yet…


#21

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.

@kendash, are you looking in the [TicketEntities] table for this Ticket?


#22

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.


#23

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.


#24

Look at the Ticket Type as well. I am not certain from the error Report that this has anything to do with Entities.


#25

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.