30/09/2021 08:52:21 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
30/09/2021 08:52:31 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
30/09/2021 09:01:29 Get Username error: Select username,userlevel FROM adidaspos.users WHERE email = 'Ken@codeworx.ltd.uk' AND password = 'a208lLFZDiOspR4aCfxycb8dCuk='
30/09/2021 09:01:35 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
30/09/2021 09:47:22 Get Order History error: Select t1.orderno,t1.acctname,t2.status,t2.partno,t1.acctno,t2.qty,CONCAT(t2.courier,' - ',t2.consignment) as pod,date_format(t1.orderdate,'%d/%m/%y') as orderdate FROM adidaspos.posorders as t1, adidaspos.orderitems as t2 WHERE t1.asmemail = 'Ken@codeworx.ltd.uk' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 12 MONTH) ORDER BY t1.orderdate DESC
30/09/2021 09:47:52 Returns History error: Select t1.orderno,t1.acctname,t2.status,t2.partno,t1.acctno FROM adidaspos.posorders as t1, adidaspos.orderitems as t2 WHERE t1.asmemail = 'Ken@codeworx.ltd.uk' AND t2.status = 'Shipped' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 3 MONTH) ORDER BY orderdate DESC
30/09/2021 09:47:57 Returns History error: Select t1.orderno,t1.acctname,t2.status,t2.partno,t1.acctno FROM adidaspos.posorders as t1, adidaspos.orderitems as t2 WHERE t1.asmemail = 'Ken@codeworx.ltd.uk' AND t2.status = 'Shipped' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 3 MONTH) ORDER BY orderdate DESC
30/09/2021 09:47:59 Get Order History error: Select t1.orderno,t1.acctname,t2.status,t2.partno,t1.acctno,t2.qty,CONCAT(t2.courier,' - ',t2.consignment) as pod,date_format(t1.orderdate,'%d/%m/%y') as orderdate FROM adidaspos.posorders as t1, adidaspos.orderitems as t2 WHERE t1.asmemail = 'Ken@codeworx.ltd.uk' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 12 MONTH) ORDER BY t1.orderdate DESC
30/09/2021 14:37:39 Get Order History error: Select t1.orderno,t1.acctname,t2.status,t2.partno,t1.acctno,t2.qty,CONCAT(t2.courier,' - ',t2.consignment) as pod,date_format(t1.orderdate,'%d/%m/%y') as orderdate FROM adidaspos.posorders as t1, adidaspos.orderitems as t2 WHERE t1.asmemail = 'Ken@codeworx.ltd.uk' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 12 MONTH) ORDER BY t1.orderdate DESC
30/09/2021 14:37:42 Returns History error: Select t1.orderno,t1.acctname,t2.status,t2.partno,t1.acctno FROM adidaspos.posorders as t1, adidaspos.orderitems as t2 WHERE t1.asmemail = 'Ken@codeworx.ltd.uk' AND t2.status = 'Shipped' AND t1.orderno = t2.orderno AND orderdate >= (now() - INTERVAL 3 MONTH) ORDER BY orderdate DESC
30/09/2021 14:40:07 Get Username error: Select username,userlevel FROM adidaspos.users WHERE email = 'nick@codeworx.ltd.uk' AND password = 'QkD1or8mXHUr/2GyPlMuWcq5b4s='
30/09/2021 14:40:52 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
30/09/2021 14:40:59 Returns Account List error: Select  acctno,acctname,acctaddress FROM adidaspos.accounts WHERE asm = 'Nick Franklin' ORDER BY acctname ASC
30/09/2021 14:41:05 Returns Account Details error: Select  acctname,acctaddress FROM adidaspos.accounts WHERE acctno = ''
30/09/2021 14:48:18 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
30/09/2021 14:48:23 Returns Account List error: Select  acctno,acctname,acctaddress FROM adidaspos.accounts WHERE asm = 'Nick Franklin' ORDER BY acctname ASC
30/09/2021 14:48:32 Returns Account Details error: Select  acctname,acctaddress FROM adidaspos.accounts WHERE acctno = ''
30/09/2021 14:48:40 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
30/09/2021 14:48:45 Returns Account List error: Select  acctno,acctname,acctaddress FROM adidaspos.accounts WHERE asm = 'Nick Franklin' ORDER BY acctname ASC
30/09/2021 14:48:51 Returns Account Details error: Select  acctname,acctaddress FROM adidaspos.accounts WHERE acctno = ''
30/09/2021 14:49:18 Returns Account List error: Select  acctno,acctname,acctaddress FROM adidaspos.accounts WHERE asm = 'Ken Blowing' ORDER BY acctname ASC
30/09/2021 14:49:26 Returns Account Details error: Select  acctname,acctaddress FROM adidaspos.accounts WHERE acctno = ''
30/09/2021 14:50:12 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
30/09/2021 14:50:53 Returns Account List error: Select  acctno,acctname,acctaddress FROM adidaspos.accounts WHERE asm = 'Nick Franklin' ORDER BY acctname ASC
30/09/2021 14:51:21 Returns Account List error: Select  acctno,acctname,acctaddress FROM adidaspos.accounts WHERE asm = 'Ken Blowing' ORDER BY acctname ASC
30/09/2021 14:51:24 Returns Account Details error: Select  acctname,acctaddress FROM adidaspos.accounts WHERE acctno = ''
30/09/2021 14:51:30 Returns Account Details error: Select  acctname,acctaddress FROM adidaspos.accounts WHERE acctno = '666666'
30/09/2021 14:53:16 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0306','Nowhere Street, Nowhere. NO99, 9NO','Ken Blowing','2021/9/30','Open','999999','Test Account Only','Ken@codeworx.ltd.uk')
30/09/2021 14:53:16 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0306','ADI-003','1','Pending','N')