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!