25/11/2019 09:36:02 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0103','Tewkesbury Road, Cheltenham','Ken Blowing','2019/11/25','Open','1001','American Golf Cheltenham','Ken@codeworx.ltd.uk')
25/11/2019 09:36:02 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status) VALUES ('KB0103','ADI-001','2','Pending')
25/11/2019 10:08:12 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0104','Lowesmoor, Worcester','Ken Blowing','2019/11/25','Open','1002','American Golf Worcester','Ken@codeworx.ltd.uk')
25/11/2019 10:08:12 ****Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Pending,N)' at line 1****
25/11/2019 10:08:12 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0104','ADI-001','1','Pending,N)
25/11/2019 10:13:06 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0105','Tewkesbury Road, Cheltenham','Ken Blowing','2019/11/25','Open','1001','American Golf Cheltenham','Ken@codeworx.ltd.uk')
25/11/2019 10:13:07 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0105','ADI-001','1','Pending','N')
25/11/2019 10:22:13 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0106','Tewkesbury Road, Cheltenham','Ken Blowing','2019/11/25','Open','1001','American Golf Cheltenham','Ken@codeworx.ltd.uk')
25/11/2019 10:22:13 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0106','ADI-001','1','Pending','N')
25/11/2019 10:27:34 SQL used: INSERT INTO adidaspos.returns (acctno, partno, retreason, status, asm, asmemail, orderno, retdate) VALUES ('1001','ADI-001','Item damaged can you swap out','Pending','Ken Blowing','Ken@codeworx.ltd.uk','KB0022','2019/11/25')
25/11/2019 10:28:17 SQL used: INSERT INTO adidaspos.queries (raisedby, type, details, status, dateopened, asmemail) VALUES ('Ken Blowing','System','How do I update ','Open','2019/11/25','Ken@codeworx.ltd.uk')
25/11/2019 15:18:22 Returns Account Details error: Select  acctname,acctaddress FROM adidaspos.accounts WHERE acctno = '1234567890'
25/11/2019 15:18:48 Returns Account Details error: Select  acctname,acctaddress FROM adidaspos.accounts WHERE acctno = '123456789'
25/11/2019 17:06:13 Returns Account Details error: Select  acctname,acctaddress FROM adidaspos.accounts WHERE acctno = '66'
25/11/2019 17:46:04 Returns Account Details error: Select  acctname,acctaddress FROM adidaspos.accounts WHERE acctno = '1234567890'