Could not connect to MySQL #35


  • New
  • Defect
Open
Assigned to _ForgeUser2779866
  • sullytheunusual created this issue Feb 28, 2012

    Here's my log snippet:

    http://pastie.org/3479454

    It created a bunch of tables in the database, so it connected at some point to do that.

  • sullytheunusual added the tags New Defect Feb 28, 2012
  • _ForgeUser2779866 unassigned issue from _ForgeUser6869524 Feb 28, 2012
  • _ForgeUser2779866 self-assigned this issue Feb 28, 2012
  • _ForgeUser8281910 posted a comment Feb 28, 2012

    Having this exact same issue. Brand new install, created V1 of the tables, could not update them to V2.

    2012-03-01 02:35:17 [INFO] [Statistician] Loading Statistician v2.0.7. 2012-03-01 02:35:21 [INFO] [Statistician] Patching database from v1 to v8. 2012-03-01 02:35:21 [SEVERE] [Statistician] Critical Error, could not connect to mySQL. Is the database Available? Check config file and try again. (An error occured while executing the database patch v2.) 2012-03-01 02:35:21 [INFO] [Statistician] Unloading Statistician v2.0.7.

  • _ForgeUser8281910 posted a comment Feb 28, 2012

    On further inspection, just run mysql_upgrade.

    This issue occurs on creation / deletion of procedures when the mysql.proc table is corrupted or hasn't been updated since updating mysql.

    This is the first time i've encountered a plugin or application that actually uses procedures, most projects try to avoid them.


    Edited Feb 28, 2012
  • _ForgeUser2779866 posted a comment Feb 28, 2012

    @leonhunter: Go

    Currently we're just keeping Statistician up-to-date from the original author. We do have plans on redoing most of it, which the procedures will most likely be dropped.

  • _ForgeUser8281910 posted a comment Feb 29, 2012

    @Coryf88: Go

    Yeah, I understand that. My reply was purely for the OP as that was no doubt the cause of his error as well. The SQL contained in the patch files works fine, it's just procedures cocking up on some MySQL servers.


To post a comment, please login or register a new account.