1.1.2 Update/Install Failed!

[Alain Fournier]

i upgraded to the latest version but accidentally pressed enter when asked to access the management portal to update the database schema. so when i try to do this after, i got that error which i did not fully cipy because it’S way too long.

so how to fix that ?

[SIZE=6][B][FONT=Ubuntu][CENTER][SIZE=32px][COLOR=#666666]Database Schema Installer / Updater[/COLOR][/SIZE][/CENTER][/FONT][/B][/SIZE]

[FONT=Ubuntu][COLOR=#555555]Update/Install Failed!
[SIZE=5][B][CENTER][SIZE=18px][COLOR=#4c68a0]The following errors occured[/COLOR][/SIZE][/CENTER][/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

[B]Update ID:[/B] 1 - 4
[B]Database Error:[/B]

[B]Database SQL:[/B]
CREATE TABLE fog.hosts (
hostID int(11) NOT NULL auto_increment,
hostName varchar(16) NOT NULL,
hostDesc longtext NOT NULL,
hostIP varchar(25) NOT NULL,
hostImage int(11) NOT NULL,
hostBuilding int(11) NOT NULL,
hostCreateDate datetime NOT NULL,
hostCreateBy varchar(50) NOT NULL,
hostMAC varchar(20) NOT NULL,
hostOS int(10) unsigned NOT NULL,
PRIMARY KEY (hostID),
KEY new_index (hostName),
KEY new_index1 (hostIP),
KEY new_index2 (hostMAC),
KEY new_index3 (hostOS)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

[B]Update ID:[/B] 1 - 5
[B]Database Error:[/B]

[B]Database SQL:[/B]
CREATE TABLE fog.images (
imageID int(11) NOT NULL auto_increment,
imageName varchar(40) NOT NULL,
imageDesc longtext NOT NULL,
imagePath longtext NOT NULL,
imageDateTime datetime NOT NULL,
imageCreateBy varchar(50) NOT NULL,
imageBuilding int(11) NOT NULL,
imageSize varchar(200) NOT NULL,
PRIMARY KEY (imageID),
KEY new_index (imageName),
KEY new_index1 (imageBuilding)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

[/COLOR][/FONT]

[RLane]

Refer to the following link:

[url]http://fogproject.org/forum/threads/fog-upgrade-1-1-1-1-1-2-database-error.10956/#post-31804[/url]

[Alain Fournier]

Worked! You guys rocks! thanks !!