forum.webdiplomacy.net

webDip dev coordination forum / public access todo list
It is currently Sat May 26, 2018 11:46 am

All times are UTC




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Create function sql
PostPosted: Wed Jun 17, 2009 1:58 pm 
Offline

Joined: Wed Jun 17, 2009 1:55 pm
Posts: 2
Hello,

well I've some problems to create tu SQL function. In my opignion I don't have the right on my server to create a function (I can't change it, it's not a dedicated server). Well I paste the message i get from SQL here, if any have an idea to bypass this problem, maybe by replacing this sql function by a php function.

PS: i'm using MYSQL 5.XXX and PHP 5.XXX

Code:
requête SQL:

CREATE FUNCTION `deCoast` (
c VARCHAR( 50 )
) RETURNS varchar( 50 ) DETERMINISTIC RETURN REPLACE( REPLACE( c, ' (North Coast)', '' ) , ' (South Coast)', '' ) ;

MySQL a répondu:Documentation
#1044 - Access denied for user 'XXXXX'@'localhost' to database 'XXXXXX'


Top
 Profile  
 
 Post subject: Re: Create function sql
PostPosted: Wed Jun 17, 2009 6:36 pm 
Offline

Joined: Wed Oct 08, 2008 12:47 pm
Posts: 726
You're right, you don't have the permissions, hence the access denied code
Code:
#1044 - Access denied for user 'XXXXX'@'localhost' to database 'XXXXXX'

This is currently a required function however, and there are threads about it in the webmasters section (after all, its not actually a bug).

http://forum.phpdiplomacy.net/viewtopic.php?f=10&t=110

I think somewhere Kestas said the function was going to be removed from the database in the next release, but I'm not certain.


Top
 Profile  
 
 Post subject: Re: Create function sql
PostPosted: Thu Jun 18, 2009 10:48 pm 
Offline

Joined: Wed Jun 17, 2009 1:55 pm
Posts: 2
would be very cool they remove this :(. Well for the moment I can't install diplomacy to my server then.


Keep the good job, I enjoyed play diplomacy by mail and hope I will be able to host such a server very soon.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group