Problem with MSQL database - Printable Version

Problem with MSQL database - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Problem with MSQL database (/showthread.php?tid=636193)

Problem with MSQL database - Ilias_ - 22.06.2017

i tried to upload my msql database on my host and i get these error"ERROR 1227 (42000) at line 27: Access denied; you need (at least one of) the SUPER privilege(s) for this operation"

Re: Problem with MSQL database - Ultraz - 22.06.2017

Quote:

Originally Posted by iliasGR

i tried to upload my msql database on my host

What this means?
The title says Problem with MSQL Database it should be MYSQL but no problem
Second on db(database) you aren't "uploading my msql database on my host", You're importing a sql file on the database which is created on the Mysql host. Try to explain more what is your problem.

Re: Problem with MSQL database - Ilias_ - 22.06.2017

Quote:

Originally Posted by Ultraz

i uploaded mysql database to phpmyadmin and i got those errors

Код:

CREATE DEFINER=`port_2569`@`localhost` FUNCTION `time_function`(`ATIME` DATETIME) RETURNS varchar(100) CHARSET latin1
BEGIN
  DECLARE INF VARCHAR(100);
  DECLARE NWT VARCHAR(100);
  DECLARE TAG TINYINT;
  
  SET TAG = 0;  
  SET INF = DATE_FORMAT(ATIME, "%Y%m%d%H%i%s");
  SET NWT = DATE_FORMAT(NOW(), "%Y%m%d%H%i%s");
  
  
  IF (INF = NWT) THEN
    SET INF = 'Just a moment';
    SET TAG = 1;
  END IF;  
  
  
  
  IF (SUBSTR(INF, 1, 12) =  SUBSTR(NWT, 1, 12))  AND (TAG = 0) THEN
    SET INF = CONCAT(SUBSTR(NWT, 13, 2) - SUBSTR(INF, 13, 2), ' seconds ago');
    SET TAG = 1;
  END IF;  
  
  
  IF (SUBSTR(INF, 1, 10) =  SUBSTR(NWT, 1, 10)) AND (TAG = 0) THEN
    SET INF = CONCAT(SUBSTR(NWT, 11, 2) - SUBSTR(INF, 11, 2), ' minutes ago');
    SET TAG = 1;
  END IF;  
  
  
  
  IF (SUBSTR(INF, 1, 8) =  SUBSTR(NWT, 1, 8)) AND (TAG = 0) THEN
    SET INF = CONCAT(SUBSTR(NWT, 9, 2) - SUBSTR(INF, 9, 2), ' hours ago');
    SET TAG = 1;
  END IF;  
  
  
  IF ([...]
Η MySQL επέστρεψε το μήνυμα: Τεκμηρίωση

Re: Problem with MSQL database - Astralis - 22.06.2017

Did this database worked before? On another host? Or is it first time you're adding it.

Re: Problem with MSQL database - Ilias_ - 22.06.2017

Quote:

Originally Posted by Astralis

Did this database worked before? On another host? Or is it first time you're adding it.

its the first time

oh i think that i did something i found this on my server logs

Код:

Mysql Status : 
MySQL server has gone away

Re: Problem with MSQL database - NewFreeroamStunt - 22.06.2017

mas kulinn...

Re: Problem with MSQL database - Ilias_ - 22.06.2017

Quote:

Originally Posted by NewFreeroamStunt

mas kulinn...

what?

Re: Problem with MSQL database - JasonRiggs - 22.06.2017

This is totally a problem of the sql, Try using another .sql if it failed, then it's a host problem and you will have to report it to your host..