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=&... [1] : http://bugs.mysql.com/bug.php?id=50183
Regards !
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=&... [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 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=&... [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.
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=&...
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.
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=&... [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.