Wednesday, January 07, 2009
You are here:  Forum
 
 
  Forum  Discussions  Google Map GPS ...  error using phpMyAdmin
Previous Previous
 
Next Next
New Post 5/3/2008 6:39 AM
  zamir1
1 posts
No Ranking


error using phpMyAdmin  

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

 

 
New Post 5/3/2008 1:19 PM
  nickfox
38 posts
No Ranking


Re: error using phpMyAdmin  
Modified By nickfox  on 5/3/2008 3:24:20 PM)

 

do you see right below the query box, there is a little text field that says "Delimiter" change that to //

2 forward slashes. and then try to run the query again.

 please let me know if that worked.

thanks

nick

 

 
New Post 5/10/2008 6:38 PM
  zelizeli
2 posts
No Ranking


Re: error using phpMyAdmin  

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

 
New Post 5/11/2008 6:44 AM
  nickfox
38 posts
No Ranking


Re: error using phpMyAdmin  

I've created a 4 minute video on how to install the stored procedures using PHPMyAdmin. I think it will clear up any problems you are having:

http://www.websmithing.com/portal/PHPMyAdminTutorial/tabid/70/Default.aspx

When you get the GPS Tracker working, I would appreciate it if you put a post in the phones section below letting us know what provider and phone model you got working.

thanks

Nick

 

 
New Post 5/11/2008 5:01 PM
  zelizeli
2 posts
No Ranking


Re: error using phpMyAdmin  

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

 
Previous Previous
 
Next Next
  Forum  Discussions  Google Map GPS ...  error using phpMyAdmin
Our Sponsors
Privacy Statement | Terms Of Use