[7Ahmad7]

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

[7Ahmad7]

Hello?

[Koala818]

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/

[7Ahmad7]

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.

[7Ahmad7]

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