This document will fix the sequence disorder of the sales log tickets
Procedure
- Open a text document and copy paste the below script and save it with .sql extension (You can assign any name e.g. ticketorder.sql)
ALTER TABLE TICKETS ADD COLUMN DATENEW DATETIME; UPDATE TICKETS T JOIN RECEIPTS R ON R.ID=T.ID SET T.DATENEW=R.DATENEW; SET @row := 1; SET @lastID := 1; UPDATE TICKETS SET TICKETID = @row := @row + 1 WHERE TICKETTYPE=0 AND TICKETID > @lastID ORDER BY DATENEW; ALTER TABLE TICKETS DROP COLUMN DATENEW;
2. Now open the MySQL command prompt and log in using the password as password
3. Type use SALECULATOR; (Press Enter Key)
4. Type source C:\ticketorder.sql (Press Enter Key)
5. Type exit (Press Enter Key)
6. Now login to the Saleculator software and check the Sales Log to see if the ticket# sequence is in ascending order