Installation of reporting objects quits with Mysql Error 1307

(3 posts) (2 voices)

Tags:

No tags yet.

  1. tyrub, Member

    No matter if I'm running the .sql by php or directly through mysql

    ERROR 1307 (HY000) at line 289: Failed to CREATE PROCEDURE sp_MyDBR_FixTables

    mysql Ver 14.14 Distrib 5.1.37, for debian-linux-gnu (i486)

  2. myDBR Team, Key Master

    Are you able to otherwise create stored procedures in your database?

    For example you could try if the following code can be executed:

    1.delimiter //
    2. 
    3.CREATE PROCEDURE simpleproc()
    4.BEGIN
    5.    SELECT 'Hello World';
    6.END//
    7. 
    8.call simpleproc//

    This should print out "Hello World".

    Best Regards,

    myDBR Team

  3. tyrub, Member

    Thank you.

    I had to run mysql_update to fix some issues and now it's running smooth


Reply

You must log in to post.