List:General Discussion« Previous MessageNext Message »
From:Jacques Marneweck Date:December 1 2006 12:16pm
Subject:Re: unable to create function in MySQL 5.0
View as plain text  
Ted Yu wrote:
> I got an error that I don't understand:
>
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or
> \g.
> Your MySQL connection id is 3080 to server version:
> 5.0.18-log
>
> mysql> create function do_system returns integer
> soname 'raptor_udf.so'//
> ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
>
>   
It's a known MySQL bug - http://bugs.mysql.com/bug.php?id=24750

Use the schema mentioned there to recreate the mysql proc table.

Regards
--jm

-- 
Jacques Marneweck
http://www.powertrip.co.za/
http://www.powertrip.co.za/blog/

#include <std/disclaimer.h>

Thread
username audit columnTed Yu30 Nov
  • Re: username audit columnTed Yu30 Nov
    • Re: username audit columnDan Nelson30 Nov
      • unable to create function in MySQL 5.0Ted Yu30 Nov
        • Re: unable to create function in MySQL 5.0Martijn Tonies1 Dec
          • Re: unable to create function in MySQL 5.0Ted Yu1 Dec
            • Re: unable to create function in MySQL 5.0Martijn Tonies1 Dec
        • Re: unable to create function in MySQL 5.0Jacques Marneweck1 Dec