Error in SQL when deleting vehicle

5 years 6 months ago #2775 by Steve Scranton
I get this error when deleting a vehicle.
0 SQL=Delete vehicles,vehoption,vehimage,vehreview,message,sellercontactinfo,buyercontact,vehshortlist FROM `sgj_js_auto_vehicles` AS vehicles LEFT JOIN `sgj_js_auto_vehicleoptions` AS vehoption ON vehicles.id= vehoption.vehicleid LEFT JOIN `sgj_js_auto_vehicleimages` AS vehimage ON vehicles.id= vehimage.vehicleid LEFT JOIN `sgj_js_auto_vehiclerankreview` AS vehreview ON vehicles.id= vehreview.vehicleid LEFT JOIN `sgj_js_auto_messages` AS message ON vehicles.id= message.vehicleid LEFT JOIN `sgj_js_auto_seller_contact_info` AS sellercontactinfo ON vehicles.id= sellercontactinfo.vehicleid LEFT JOIN `sgj_js_auto_vehicle_buyer_contact` AS buyercontact ON vehicles.id= buyercontact.vehicleid LEFT JOIN `sgj__js_auto_vehicleshortlist` AS vehshortlist ON vehicles.id= vehshortlist.vehicleid WHERE vehicles.id = 4
Time to create page: 0.328 seconds

Please publish modules in offcanvas position.