Closed Thread
Results 1 to 4 of 4

Thread: Problem with MySQL upgrade from 5.00.91 to 5.01.58

  1. #1
    vtrub is offline x10Hosting Member vtrub is an unknown quantity at this point
    Join Date
    Nov 2008
    Posts
    3

    Problem with MySQL upgrade from 5.00.91 to 5.01.58

    My web site www.searchauto.ca is down for more than a week now, it returns error:

    "Query Error: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50091, now running 50158. Please use mysql_upgrade to fix this error."

    The similar post
    "http://x10hosting.com/forums/free-hosting/164430-stored-procedures-mysql.html"

    was closed without response.

    Please advice what should I do.
    Thanks.

  2. #2
    Bryon is offline Administrator Bryon has disabled reputation
    Join Date
    Apr 2005
    Location
    Northfield, NH
    Posts
    7,608

    Re: Problem with MySQL upgrade from 5.00.91 to 5.01.58

    Try removing your stored procedure and recreating it.

  3. #3
    vtrub is offline x10Hosting Member vtrub is an unknown quantity at this point
    Join Date
    Nov 2008
    Posts
    3

    Re: Problem with MySQL upgrade from 5.00.91 to 5.01.58

    Thank you, but it's not working. I've tried to drop stored procedure:

    drop PROCEDURE get_all_dealer;

    Response:
    #1558 - Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50091, now running 50158. Please use mysql_upgrade to fix this error.

    I've tried:
    Select * From Information_Schema.routines

    Same response.

  4. #4
    Corey's Avatar
    Corey is offline VPS Migration Professional Corey is a glorious beacon of lightCorey is a glorious beacon of light
    Join Date
    Dec 2004
    Location
    Northfield, NH
    Posts
    17,151

    Re: Problem with MySQL upgrade from 5.00.91 to 5.01.58

    I have fixed your site.
    Corey Arbogast | CEO
    █ 888-X10-9668 - corey[@]x10hosting.com
    x10Hosting - Giving Away Hosting Since 2004
    Premium Hosting | VPS Services

Closed Thread

Similar Threads

  1. PHPBB3 MySQL Screwed Up After MySQL Upgrade
    By xbrav_revolutionz in forum Free Hosting
    Replies: 2
    Last Post: 01-23-2010, 01:14 PM
  2. MySQL Upgrade
    By mattycl2007 in forum Free Hosting
    Replies: 0
    Last Post: 01-05-2008, 07:31 AM
  3. Upgrade to MYSQL 5?
    By ak007 in forum Free Hosting
    Replies: 4
    Last Post: 11-16-2005, 02:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers