When creating a stored procedure- #1548 - Cannot load from mysql.proc

Discussion in 'Free Hosting' started by cybersle, May 13, 2016.

  1. cybersle

    cybersle New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    I am having an issue creating stored procedures. I keep getting:
    #1548 - Cannot load from mysql.proc. The table is probably corrupted

    Which according to everything I can find on google this happens due to schema changes required for different MySQL server versions. The simple fix to this problem is to run the mysql_upgrade command from the command line. Which obviously I cannot do. I've tried running a fix on the table and updating the database via the GUI provided.

    I also tried utilizing the Create routine tab and entering the items manually without using the deliminator but I still get the same error.

    I also tried creating a new database with very little in it and creating a stored procedure there. Still receive the same error.

    PLEASE HELP!
     
  2. Skizzerz

    Skizzerz Contributors Staff Member Contributors

    Messages:
    2,929
    Likes Received:
    117
    Trophy Points:
    63
    Please try again, I've repaired the mysql.proc table (so if it was indeed corrupted, that would have fixed it).
     
  3. cybersle

    cybersle New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Still having the same issue, I can't even access the table:
    upload_2016-5-13_14-27-13.png


    Can you just delete my entire library and I'll start from scratch?

    When I try deleting and recreating my db the information schema remains unchanged. I don't know what happened but at this point it would be easier to start fresh.

    Thank you!
     

    Attached Files:

  4. cybersle

    cybersle New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Never mind, I'll just direct query what I can, since it has to be done today.
     
  5. bplanx12

    bplanx12 New Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    I have the same issue... could you help me as soon as possible?
    Thanks
     
  6. bplanx12

    bplanx12 New Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    I really need to solve this issue. Could you help me please??
     

Share This Page