Installation of reporting objects quits with Mysql Error 1307

(3 posts) (2 voices)


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:

    delimiter //
    CREATE PROCEDURE simpleproc()
    SELECT 'Hello World';
    END// 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


You must log in to post.