Hello  
 
I HAVE CHANGED IN THE DATABASE GPSTracker2 THE LINE FROM CREATE DEFINER=`root`@`localhost` PROCEDURE `prcDeleteRoute`( 
TO : CREATE PROCEDURE `prcDeleteRoute`( 
 
AND I STILL RECIVE THE FOLLOWING ERROR : 
 
SQL query:  
 
DELIMITER $$/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */$$ CREATE PROCEDURE `prcDeleteRoute` ( _sessionID VARCHAR( 20 ) , _phoneNumber VARCHAR( 25 ) ) BEGIN DELETE FROM gpslocations2 WHERE sessionID = _sessionID AND phoneNumber = _phoneNumber ORDER BY lastupdate; 
 
 
 
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 'DELIMITER $$ 
 
SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' $$ 
CREATE PROCEDURE `' at line 1

Hi,

I have the same problem.

I first change my .sql TO : CREATE PROCEDURE `prcDeleteRoute

and then commented (//) the delimiter lines (the ones with the $$ and the ;

Can anyone please help with this. It seems like a very exiting application and I can't wait to test it but need to get the database running.

Thanks,

Ori

Thank you for the video. It works now that I manually entered the procedures.

I will update the forum once i test it and let you know which phone and provider I used.

Thanks again