Rshiny Startup Output Error Fix

Job ID: 37656260

Budget: ₹600 – ₹1,500 INR

<SQL> SELECT o.sales_order_number AS 'Order', t.epc AS Container, t.tag_id AS Tag,
IFNULL(p.code, 'ALL') AS Priority, Pickup_Location AS Origin,
Delivery_Location AS Destination, DATE(Delivery_Time) AS Delivery_Date,
Tender_Time, Pickup_Time, Depart_Time, Arrival_Time, Delivery_Time,
Deliver_Driver AS Driver,
m.Business_Unit, party.name AS Party_Name
FROM summary AS m LEFT JOIN tag AS t ON m.tag_row = t.id
LEFT JOIN priority AS p ON t.priority = p.id
LEFT JOIN shipment_packing AS k ON m.tag_id = k.tag
LEFT JOIN shipment AS s ON k.shipment = s.id
LEFT JOIN table_order AS o ON s.buy_order = o.id
LEFT JOIN business_unit ON CAST(m.business_unit AS SIGNED) = business_unit.id
LEFT JOIN party ON business_unit.party = party.id
WHERE Deliver_Driver IS NOT NULL and Delivery_Time >= date_sub(now(), interval 6 month);
[1] "Disconnected from db successfully!"
Warning: Error in left_join: Can't join `x$Business_Unit` with `y$Business_Unit` due to incompatible types.
ℹ `x$Business_Unit` is a <character>.
ℹ `y$Business_Unit` is a <integer>.

And Other Related Issue
Related categories: R Programming Language Spring Boot