Cannot Import sql File

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

Cannot Import sql File

Postby NirvashNeo » 20. November 2022 14:53

Every time I try to import the sql file this shows up

SQL query: Copy


--
-- Procedures
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `Add Blood Inventory Record` () INSERT INTO `blood inventory`(`Donor Name`, `Donor ID`, `Donor Phone Number`, `Donor Gender`, `Concentration of Plasma`, `Hemoglobin`, `Blood Type`, `Blood Volume`, `Blood Pack ID`, `Storage Staff Name (IN)`, `Storage Staff ID (IN)`, `Storage Staff Name (OUT)`, `Storage Staff ID (OUT)`, `Entry Date`, `Expiry Date`, `Storage Location`, `Storage ID`, `Blood Pack Expired`, `Blood Pack Used`, `Blood Pack Usage Venue`, `Blood Pack Usage Case ID`) VALUES ('Jane Doe','H1788279',74631234,'F',55,12.4,'A+',455,'50474039875713004598','Susan Un','B8813433','N/A','N/A',20010421,20010602,'Queen Mary Hospital','5859554430037152487','Y','N','N/A','N/A');
MySQL said: Documentation

#1558 - Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100108, now running 100421. Please use mysql_upgrade to fix this error

I've already use mysql_upgrade and have already upgraded to 10.4.21-MariaDBB
NirvashNeo
 
Posts: 1
Joined: 20. November 2022 14:51
XAMPP version: 8.1.6
Operating System: MacOS 12.0.1

Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 23 guests