• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

Troble with MySQL after Upgrading from .32 to 1.2.0

Scheduled Pinned Locked Moved
FOG Problems
1
2
1.8k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • T
    TJ333
    last edited by Aug 1, 2014, 4:53 PM

    After upgrading to 1.2.0 one of my FOG servers is not completing the upgrade.

    I get a lot oferrors when I click the Install/Upgrade Now button. I would think it is a SQL password issue. I cannot find the config.php files in order to change that on for 1.2.0. Here is a sample of the errors I get.

    [QUOTE]
    Update/Install Failed!

    [SIZE=5][B]The following errors occured[/B][/SIZE]

    [B]Update ID:[/B] 1 - 0

    [B]Database Error:[/B]

    [B]Database SQL:[/B]
    CREATE DATABASE fog

    [B]Update ID:[/B] 1 - 1

    [B]Database Error:[/B]

    [B]Database SQL:[/B]
    CREATE TABLE fog.groupMembers (
    gmID int(11) NOT NULL auto_increment,
    gmHostID int(11) NOT NULL,
    gmGroupID int(11) NOT NULL,
    PRIMARY KEY (gmID),
    KEY new_index (gmHostID),
    KEY new_index1 (gmGroupID)
    ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC

    [B]Update ID:[/B] 1 - 2

    [B]Database Error:[/B]

    [B]Database SQL:[/B]
    CREATE TABLE fog.groups (
    groupID int(11) NOT NULL auto_increment,
    groupName varchar(50) NOT NULL,
    groupDesc longtext NOT NULL,
    groupDateTime datetime NOT NULL,
    groupCreateBy varchar(50) NOT NULL,
    groupBuilding int(11) NOT NULL,
    PRIMARY KEY (groupID),
    KEY new_index (groupName)
    ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

    [B]Update ID:[/B] 1 - 3

    [B]Database Error:[/B]

    [B]Database SQL:[/B]
    CREATE TABLE fog.history (
    hID int(11) NOT NULL auto_increment,
    hText longtext NOT NULL,
    hUser varchar(200) NOT NULL,
    hTime datetime NOT NULL,
    hIP varchar(50) NOT NULL,
    PRIMARY KEY (hID)
    ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1[/QUOTE]

    and the apache error log files has:
    [QUOTE]
    Update/Install Failed!

    [SIZE=5][B]The following errors occured[/B][/SIZE]

    [B]Update ID:[/B] 1 - 0

    [B]Database Error:[/B]

    [B]Database SQL:[/B]
    CREATE DATABASE fog

    [B]Update ID:[/B] 1 - 1

    [B]Database Error:[/B]

    [B]Database SQL:[/B]
    CREATE TABLE fog.groupMembers (
    gmID int(11) NOT NULL auto_increment,
    gmHostID int(11) NOT NULL,
    gmGroupID int(11) NOT NULL,
    PRIMARY KEY (gmID),
    KEY new_index (gmHostID),
    KEY new_index1 (gmGroupID)
    ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC

    [B]Update ID:[/B] 1 - 2

    [B]Database Error:[/B]

    [B]Database SQL:[/B]
    CREATE TABLE fog.groups (
    groupID int(11) NOT NULL auto_increment,
    groupName varchar(50) NOT NULL,
    groupDesc longtext NOT NULL,
    groupDateTime datetime NOT NULL,
    groupCreateBy varchar(50) NOT NULL,
    groupBuilding int(11) NOT NULL,
    PRIMARY KEY (groupID),
    KEY new_index (groupName)
    ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

    [B]Update ID:[/B] 1 - 3

    [B]Database Error:[/B]

    [B]Database SQL:[/B]
    CREATE TABLE fog.history (
    hID int(11) NOT NULL auto_increment,
    hText longtext NOT NULL,
    hUser varchar(200) NOT NULL,
    hTime datetime NOT NULL,
    hIP varchar(50) NOT NULL,
    PRIMARY KEY (hID)
    ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1[/QUOTE]

    1 Reply Last reply Reply Quote 0
    • T
      TJ333
      last edited by Aug 1, 2014, 5:03 PM

      Found the answers while looking through the release thread. The config.php has become /var/www/fog/lib/fog/Config.class.php. Added my SQL password in and it all worked.

      1 Reply Last reply Reply Quote 0
      • 1 / 1
      1 / 1
      • First post
        2/2
        Last post

      148

      Online

      12.0k

      Users

      17.3k

      Topics

      155.2k

      Posts
      Copyright © 2012-2024 FOG Project