2011-08-09 06:28:51 PDT
Please suggest, getting SQL error when importing the app db. Took the dump files from -
https://sourceforge.net/projects/it-dashboard/files/Release%201.0.4/
Error SQL query: DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `addOrDeleteInvestmentsForDemoDatabase`(budYear VARCHAR(4), OUT execution_status INT) BEGIN DECLARE previousUPIs TEXT DEFAULT NULL; DECLARE finalUPIs TEXT DEFAULT NULL; DECLARE modifiedPreviousUPIs TEXT DEFAULT NULL; DECLARE sql_del_majoragencyallinvestments VARCHAR(4000); DECLARE sql_del_majoragencybusinesscasesmv VARCHAR(4000); DECLARE buscaseUPIs, sandcUPIs TEXT DEFAULT NULL; DECLARE finalbuscaseUPIs, finalsandcUPIs TEXT DEFAULT NULL; DECLARE modifiedbuscaseUPIs, modifiedsandcUPIs TEXT DEFAULT NULL; DECLARE sql_bmv, sql_bmv_sandc VARCHAR(4000); DECLARE buscId, buscId_sandc INT; DECLARE index1, businesscount, businesscount_sandc, index_sandc, upicount, index2, index3, conscount, consElimRecs INT DEFAULT 0; [...] MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `addOrDeleteIn' at line 1
I'm trying to import the "itdashboard_sample_application_db_populated.zip" file and have tried a few times with no luck.
