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:

    delimiter //
    
    CREATE PROCEDURE simpleproc()
    BEGIN
    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


Reply

You must log in to post.