SA-MP Forums Archive
MySQL Datebase problem - 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: MySQL Datebase problem (/showthread.php?tid=515368)



MySQL Datebase problem - 7Ahmad7 - 25.05.2014

Hey,what's up forum!
today i'm gonna ask for this shit, I get this shitty errors from phpmyadmin (( traingle host ))

these is the errors :


Error

Код:
SQL query:



--
-- Dumping routines for database '7Ahmad7_6109'
--
/*!50003 DROP FUNCTION IF EXISTS `GetLockerItemName` */;

MySQL said: Documentation
#1548 - Cannot load from mysql.proc. The table is probably corrupted



Re: MySQL Datebase problem - 7Ahmad7 - 25.05.2014

Hello?


Re: MySQL Datebase problem - Koala818 - 25.05.2014

If you could explain more... Like in what circumstances that error appears, what are you trying to do, etc. But first you can read this, maybe it'll help you: http://www.myguysolutions.com/2013/1...bly-corrupted/


Re: MySQL Datebase problem - 7Ahmad7 - 25.05.2014

Well,i :

Working:
on a Datebase for my new server (( WCRP Actully ))

Need to:
find a working DB or fix my own

The problem is:
When i upload the DB i got ,,,,....,,,, i get these errors :
Код:
Error
ــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــ
SQL query:

DELIMITER ;;
/*!50003 CREATE*/ /*!50020 DEFINER=`CHC`@`24.235.%`*/ /*!50003 FUNCTION `GetLockerItemName`(`type` int,`amount` int) RETURNS varchar(32) CHARSET latin1
BEGIN
	CASE type
	WHEN 0 THEN RETURN 'None';
	WHEN 1 THEN RETURN CONCAT('Money', ' - $', format(amount, 0));
	WHEN 2 THEN RETURN CONCAT('Pot', ' - ', format(amount, 0));
	WHEN 3 THEN RETURN CONCAT('Coke', ' - ', format(amount, 0));
	WHEN 4 THEN 
		BEGIN
			DECLARE weapon SMALLINT DEFAULT 0;
			DECLARE ammo SMALLINT DEFAULT 0;
			CALL DecodeWeapon(amount,weapon,ammo);
			RETURN CONCAT(GetWeaponName(weapon), ' - ', format(ammo, 0));
		END;
	WHEN 5 THEN RETURN CONCAT('Meth', ' - ', format(amount, 0));
	WHEN 6 THEN RETURN CONCAT('Materials A', ' - ', format(amount, 0));
	WHEN 7 THEN RETURN CONCAT('Materials B', ' - ', format(amount, 0));
	WHEN 8 THEN RETURN CONCAT('Materials C', ' - ', format(amount, 0));
	WHEN 9 THEN RETURN CONCAT('Special Item', ' - ', GetSpecialItemName(amount));
	END CASE;
END */;;

MySQL said:
#1046 - No database selected
And I'm using http://37.59.28.180/phpmyadmin/ so i can't " command prompt > MySQL_upgrade "
i just need to know where is the problem with the lines,because of all the MySQL knowledge for me is shit,
and i need this to be fixed so i will open my server as easy as soon.


Re: MySQL Datebase problem - 7Ahmad7 - 25.05.2014

So,what to do! i realy need this to finish my server!