[Phpmyadmin-devel] Cannot Create Procedure in Demo ?
Hi, I tried to create a procedure in the demo server [0], and got an error message '#1548 - Cannot load from mysql.proc. The table is probably corrupted '. Seems this is related to MySQL bug [1]. [0] : http://demo.phpmyadmin.net/master-config/#PMAURL-0:index.php?db=&table=&serv... [1] : http://bugs.mysql.com/bug.php?id=50183 Regards ! -- Chanaka Dharmarathna *Virtusa (Pvt) Ltd. | **Sri Lanka*
Le 2013-12-16 02:57, Chanaka Dharmarathna a écrit :
Hi,
I tried to create a procedure in the demo server [0], and got an error message '|#1548 - Cannot load from mysql.proc. The table is probably corrupted |'. Seems this is related to MySQL bug [1].
[0] : http://demo.phpmyadmin.net/master-config/#PMAURL-0:index.php?db=&table=&serv... [1] : http://bugs.mysql.com/bug.php?id=50183
Hi Chanaka, indeed, mysql.proc.comment is CHAR(64), a sign that the upgrade has not been done on the system tables. -- Marc Delisle http://infomarc.info | http://phpmyadmin.net
Marc Delisle a écrit :
Le 2013-12-16 02:57, Chanaka Dharmarathna a écrit :
Hi,
I tried to create a procedure in the demo server [0], and got an error message '|#1548 - Cannot load from mysql.proc. The table is probably corrupted |'. Seems this is related to MySQL bug [1].
[0] : http://demo.phpmyadmin.net/master-config/#PMAURL-0:index.php?db=&table=&serv... [1] : http://bugs.mysql.com/bug.php?id=50183
Hi Chanaka, indeed, mysql.proc.comment is CHAR(64), a sign that the upgrade has not been done on the system tables.
Chanaka, this has been fixed on the new demo server. -- Marc Delisle http://infomarc.info | http://phpmyadmin.net
On Wed, Dec 18, 2013 at 11:27 PM, Marc Delisle <marc@infomarc.info> wrote:
Marc Delisle a écrit :
Le 2013-12-16 02:57, Chanaka Dharmarathna a écrit :
Hi,
I tried to create a procedure in the demo server [0], and got an error message '|#1548 - Cannot load from mysql.proc. The table is probably corrupted |'. Seems this is related to MySQL bug [1].
[0] :
http://demo.phpmyadmin.net/master-config/#PMAURL-0:index.php?db=&table=&serv...
Hi Chanaka, indeed, mysql.proc.comment is CHAR(64), a sign that the upgrade has not been done on the system tables.
Chanaka, this has been fixed on the new demo server.
Great, It's working now. -- Chanaka Dharmarathna *Virtusa (Pvt) Ltd. | **Sri Lanka*
Hi Dne Mon, 16 Dec 2013 18:21:34 -0500 Marc Delisle <marc@infomarc.info> napsal(a):
Le 2013-12-16 02:57, Chanaka Dharmarathna a écrit :
Hi,
I tried to create a procedure in the demo server [0], and got an error message '|#1548 - Cannot load from mysql.proc. The table is probably corrupted |'. Seems this is related to MySQL bug [1].
[0] : http://demo.phpmyadmin.net/master-config/#PMAURL-0:index.php?db=&table=&serv... [1] : http://bugs.mysql.com/bug.php?id=50183
Hi Chanaka, indeed, mysql.proc.comment is CHAR(64), a sign that the upgrade has not been done on the system tables.
Indeed this error was there for more than year without nobody complaining. Now with new setup such things should no more appear. -- Michal Čihař | http://cihar.com | http://phpmyadmin.net
participants (3)
-
Chanaka Dharmarathna -
Marc Delisle -
Michal Čihař