05-09-2022 13:26:08.782+0530 [error] : [500] POST - /v1/invoice Cannot add or update a child row: a foreign key constraint fails (`tbbdev_devdb`.`customers`, CONSTRAINT `customers_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`))  
Payload : {"customerMobileNo":"8970324593","customerName":"manju","discount":0,"gstBillNo":0,"invoiceDate":"2022-09-05","items":[{"gst":0,"gstAmount":9000,"gstType":"CGST/SGST (Local customer)","id":-1,"imei":"","invoiceid":-1,"is_active":true,"measurementId":1,"name":"half t shirt lower print ","price":180,"quantity":50,"serial_no":"","totalAmount":9000},{"gst":0,"gstAmount":2000,"gstType":"CGST/SGST (Local customer)","id":-1,"imei":"","invoiceid":-1,"is_active":true,"measurementId":1,"name":"print ","price":40,"quantity":50,"serial_no":"","totalAmount":2000}],"nonGstBillNo":31,"totalAfterDiscount":11000,"totalAmount":11000,"totalAmountBeforeGST":11000,"userid":"224689"} Error: Cannot add or update a child row: a foreign key constraint fails (`tbbdev_devdb`.`customers`, CONSTRAINT `customers_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`))
    at Packet.asError (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/packets/packet.js:708:17)
    at Execute.execute (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/commands/command.js:28:26)
    at Connection.handlePacket (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/connection.js:408:32)
    at PacketParser.Connection.packetParser.p [as onPacket] (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/connection.js:70:12)
    at PacketParser.executeStart (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.Connection.stream.on.data (/home/tbbdev/public_html/billbook/node_modules/mysql2/lib/connection.js:77:25)
    at Socket.emit (events.js:198:13)
    at Socket.EventEmitter.emit (domain.js:448:20)
    at addChunk (_stream_readable.js:288:12)
    at readableAddChunk (_stream_readable.js:269:11)
    at Socket.Readable.push (_stream_readable.js:224:10)
    at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)



