PhpVms install failure

[parthprakash1]

When I run the install.php I get many errors. I have tried re-downloading for corrupt files. Tried all versions of Php. Nothing works.

 

Below is what I get

 

Writing "phpvms_adminlog" table... success

Writing "phpvms_awards" table... success

Writing "phpvms_awardsgranted" table... success

Writing "phpvms_fuelprices" table... success

Writing "phpvms_updates" table... success

Writing "phpvms_downloads" table... success

Writing "phpvms_expenses" table... success

Writing "phpvms_expenselog" table... success

Writing "phpvms_financedata" table... success

Writing "phpvms_acarsdata" table... failed - manually run this query: 

"CREATE TABLE `phpvms_acarsdata` ( `id` int(11) NOT NULL auto_increment, `pilotid` varchar(11) NOT NULL default '0', `flightnum` varchar(11) NOT NULL default '0', `pilotname` varchar(100) NOT NULL default '', `aircraft` varchar(12) NOT NULL default '', `lat` varchar(15) NOT NULL default '', `lng` varchar(15) NOT NULL default '', `heading` smallint(6) NOT NULL default '0', `alt` varchar(6) NOT NULL default '', `gs` int(11) NOT NULL default '0', `depicao` varchar(4) NOT NULL default '', `depapt` varchar(255) NOT NULL default '', `arricao` varchar(4) NOT NULL default '', `arrapt` text NOT NULL, `deptime` time NOT NULL default '00:00:00', `timeremaining` varchar(6) NOT NULL default '', `arrtime` time NOT NULL default '00:00:00', `route` TEXT NOT NULL, `route_details` TEXT NOT NULL, `distremain` varchar(6) NOT NULL default '', `phasedetail` varchar(255) NOT NULL default '', `online` varchar(10) NOT NULL default '', `messagelog` text NOT NULL, `lastupdate` datetime NOT NULL default '0000-00-00 00:00:00', `client` varchar(20) NOT NULL default '', PRIMARY KEY (`id`), KEY `pilotid` (`pilotid`) ) ENGINE=INNODB;"

Writing "phpvms_airlines" table... failed - manually run this query: 

"CREATE TABLE `phpvms_airlines` ( `id` int(11) NOT NULL auto_increment, `code` char(3) NOT NULL default '', `name` varchar(30) NOT NULL default '', `enabled` smallint(6) NOT NULL default '1', PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`) ) ENGINE=InnoDB;"

Writing "phpvms_aircraft" table... failed - manually run this query: 

"CREATE TABLE `phpvms_aircraft` ( `id` int(11) NOT NULL auto_increment, `icao` varchar(4) NOT NULL default '', `name` varchar(12) NOT NULL default '', `fullname` varchar(50) NOT NULL default '', `registration` varchar(30) NOT NULL, `downloadlink` text NOT NULL, `imagelink` text NOT NULL, `range` varchar(15) NOT NULL default '0', `weight` varchar(15) NOT NULL default '0', `cruise` varchar(15) NOT NULL default '0', `maxpax` FLOAT NOT NULL default '0', `maxcargo` FLOAT NOT NULL default '0', `minrank` INT NOT NULL DEFAULT '0', `ranklevel` INT NOT NULL DEFAULT '0', `enabled` smallint(6) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB;"

Writing "phpvms_navdata" table... success

Writing "phpvms_airports" table... failed - manually run this query: 

"CREATE TABLE `phpvms_airports` ( `id` int(11) NOT NULL auto_increment, `icao` varchar(5) NOT NULL default '', `name` text NOT NULL, `country` varchar(50) NOT NULL default '', `lat` float NOT NULL default '0', `lng` float NOT NULL default '0', `hub` smallint(6) NOT NULL default '0', `fuelprice` FLOAT NOT NULL default '0', `chartlink` TEXT NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `icao` (`icao`) ) ENGINE=InnoDB;"

Writing "phpvms_schedules" table... failed - manually run this query: 

"CREATE TABLE `phpvms_schedules` ( `id` int(11) NOT NULL auto_increment, `code` char(3) NOT NULL default '', `flightnum` varchar(10) NOT NULL default '0', `depicao` varchar(4) NOT NULL default '', `arricao` varchar(4) NOT NULL default '', `route` text NOT NULL, `route_details` TEXT NOT NULL, `aircraft` text NOT NULL, `flightlevel` VARCHAR( 6 ) NOT NULL, `distance` float NOT NULL default '0', `deptime` varchar(15) NOT NULL default '', `arrtime` varchar(15) NOT NULL default '', `flighttime` FLOAT NOT NULL default '0', `daysofweek` VARCHAR( 7 ) NOT NULL DEFAULT '0123456', `price` FLOAT NOT NULL, `flighttype` VARCHAR( 1 ) NOT NULL DEFAULT 'P', `timesflown` int(11) NOT NULL default '0', `notes` text NOT NULL, `enabled` int(11) NOT NULL default '1', `bidid` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `depicao` (`depicao`), KEY `flightnum` (`flightnum`), KEY `depicao_arricao` (`depicao`,`arricao`), KEY `code` (`code`) ) ENGINE=InnoDB ;"

Writing "phpvms_news" table... failed - manually run this query: 

"CREATE TABLE `phpvms_news` ( `id` int(11) NOT NULL auto_increment, `subject` varchar(30) NOT NULL default '', `body` text NOT NULL, `postdate` datetime NOT NULL default '0000-00-00 00:00:00', `postedby` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=InnoDB ;"

Writing "phpvms_news" table... failed - manually run this query: 

"INSERT INTO `phpvms_news` (`subject`,`body`,`postdate`,`postedby`) VALUES ('Welcome to phpVMS!', 'Thanks for installing and using phpVMS!
Check out the docs for help and information on getting started on your VA.

This is just a starter skin - customize yours completely. This is just a basic, barebones example of what a skin is and how it works. Check out the crystal folder in the lib/skins directory. Make your own copy and fiddle around. For help, check out the forum, and skinning docs. Also, be sure to check out the skinning tutorials for a quick primer. The forums are also filled with plenty of helpful people for any questions you may have.

Good luck!', NOW(), 'phpVMS Installer');"

Writing "phpvms_pages" table... failed - manually run this query: 

"CREATE TABLE `phpvms_pages` ( `pageid` int(11) NOT NULL auto_increment, `pagename` varchar(30) NOT NULL default '', `filename` varchar(30) NOT NULL default '', `order` smallint(6) NOT NULL default '0', `postedby` varchar(50) NOT NULL default '', `postdate` datetime NOT NULL default '0000-00-00 00:00:00', `public` smallint(6) NOT NULL default '0', `enabled` smallint(6) NOT NULL default '1', PRIMARY KEY (`pageid`), UNIQUE KEY `pagename` (`pagename`) ) ENGINE=InnoDB ;"

Writing "phpvms_ranks" table... failed - manually run this query: 

"CREATE TABLE `phpvms_ranks` ( `rankid` int(11) NOT NULL auto_increment, `rank` varchar(32) NOT NULL default '', `rankimage` text NOT NULL, `minhours` smallint(6) NOT NULL default '0', `payrate` float NOT NULL default '0', PRIMARY KEY (`rankid`), UNIQUE KEY `rank` (`rank`) ) ENGINE=InnoDB ;"

Writing "phpvms_ranks" table... failed - manually run this query: 

"INSERT INTO `phpvms_ranks` VALUES(1, 'New Hire','', 0, 18.0);"

Writing "phpvms_sessions" table... success

Writing "phpvms_pilots" table... failed - manually run this query: 

"CREATE TABLE `phpvms_pilots` ( `pilotid` int(11) NOT NULL auto_increment, `firstname` varchar(25) NOT NULL default '', `lastname` varchar(25) NOT NULL default '', `email` varchar(100) NOT NULL default '', `code` char(3) NOT NULL default '', `location` varchar(32) NOT NULL default '', `hub` varchar(4) NOT NULL default '', `password` varchar(32) NOT NULL default '', `salt` varchar(32) NOT NULL default '', `bgimage` varchar(30) NOT NULL default '', `lastlogin` date NOT NULL default '0000-00-00', `totalflights` int(11) NOT NULL default '0', `totalhours` float NOT NULL default '0', `totalpay` float NOT NULL default '0', `transferhours` float NOT NULL default '0', `rankid` INT NOT NULL DEFAULT '0', `rank` varchar(32) NOT NULL default 'New Hire', `ranklevel` INT NOT NULL DEFAULT '0', `confirmed` smallint(5) unsigned NOT NULL default '0', `retired` smallint(6) NOT NULL default '0', `joindate` datetime NOT NULL default '0000-00-00 00:00:00', `lastpirep` datetime NOT NULL default '0000-00-00 00:00:00', `lastip` VARCHAR( 25 ) NULL DEFAULT '', PRIMARY KEY (`pilotid`), KEY `code` (`code`), KEY `rank` (`rank`) ) ENGINE=InnoDB;"

Writing "phpvms_pireps" table... failed - manually run this query: 

"CREATE TABLE `phpvms_pireps` ( `pirepid` int(11) NOT NULL auto_increment, `pilotid` int(11) NOT NULL default '0', `code` char(3) NOT NULL default '', `flightnum` varchar(10) NOT NULL default '0', `depicao` varchar(4) NOT NULL default '', `arricao` varchar(4) NOT NULL default '', `route` TEXT NOT NULL, `route_details` TEXT NOT NULL, `aircraft` varchar(12) NOT NULL default '', `flighttime` varchar(10) NOT NULL default '', `flighttime_stamp` TIME NOT NULL, `distance` smallint(6) NOT NULL default '0', `landingrate` FLOAT NOT NULL DEFAULT 0.0, `submitdate` datetime NOT NULL default '0000-00-00 00:00:00', `accepted` smallint(6) NOT NULL default '0', `log` text NOT NULL, `load` INT(11) NOT NULL, `fuelused` FLOAT NOT NULL DEFAULT 0.0, `fuelunitcost` FLOAT NOT NULL DEFAULT 0.0, `fuelprice` FLOAT NOT NULL DEFAULT 5.10, `price` FLOAT NOT NULL, `flighttype` VARCHAR( 1 ) NOT NULL DEFAULT 'P', `gross` FLOAT NOT NULL, `pilotpay` FLOAT NOT NULL, `expenses` FLOAT NOT NULL, `expenselist` BLOB NOT NULL, `revenue` FLOAT NOT NULL, `source` VARCHAR(25) NOT NULL, `exported` TINYINT NOT NULL, `rawdata` TEXT NOT NULL, PRIMARY KEY (`pirepid`) ) ENGINE=InnoDB;"

Writing "phpvms_pirepcomments" table... failed - manually run this query: 

"CREATE TABLE `phpvms_pirepcomments` ( `id` INT NOT NULL AUTO_INCREMENT , `pirepid` INT NOT NULL , `pilotid` INT NOT NULL , `comment` TEXT NOT NULL , `postdate` DATETIME NOT NULL , PRIMARY KEY ( `id` ) )ENGINE=INNODB;"

Writing "phpvms_customfields" table... failed - manually run this query: 

"CREATE TABLE `phpvms_customfields` ( `fieldid` INT NOT NULL AUTO_INCREMENT , `title` VARCHAR( 75 ) NOT NULL , `fieldname` VARCHAR( 75 ) NOT NULL , `value` TEXT NOT NULL , `type` VARCHAR( 25 ) NOT NULL DEFAULT 'text', `public` smallint(6) NOT NULL default '0', `showonregister` smallint(6) NOT NULL default '0', PRIMARY KEY ( `fieldid` ), UNIQUE KEY `fieldname` (`fieldname`) )ENGINE=INNODB;"

Writing "phpvms_fieldvalues" table... failed - manually run this query: 

"CREATE TABLE `phpvms_fieldvalues` ( `id` INT NOT NULL AUTO_INCREMENT , `fieldid` INT NOT NULL , `pilotid` INT NOT NULL , `value` TEXT NOT NULL , PRIMARY KEY ( `id` ) )ENGINE=INNODB;"

Writing "phpvms_groups" table... failed - manually run this query: 

"CREATE TABLE `phpvms_groups` ( `groupid` int(11) NOT NULL auto_increment, `name` varchar(25) NOT NULL default '', `permissions` varchar(25) NOT NULL default '', PRIMARY KEY (`groupid`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB ;"

Writing "phpvms_groups" table... failed - manually run this query: 

"INSERT INTO `phpvms_groups` (`name`, `permissions`) VALUES ('Administrators', '35651519');"

Writing "phpvms_groups" table... failed - manually run this query: 

"INSERT INTO `phpvms_groups` (`name`) VALUES ('Active Pilots');"

Writing "phpvms_groupmembers" table... failed - manually run this query: 

"CREATE TABLE `phpvms_groupmembers` ( `id` int(11) NOT NULL auto_increment, `groupid` int(11) NOT NULL default '0', `pilotid` int(11) NOT NULL default '0', PRIMARY KEY (`id`) )ENGINE=INNODB;"

Writing "phpvms_pirepfields" table... failed - manually run this query: 

"CREATE TABLE `phpvms_pirepfields` ( `fieldid` INT NOT NULL AUTO_INCREMENT , `title` VARCHAR( 25 ) NOT NULL , `name` VARCHAR( 25 ) NOT NULL , `type` VARCHAR (25) NOT NULL, `options` TEXT NOT NULL, PRIMARY KEY ( `fieldid` ), UNIQUE KEY `name` (`name`) ) ENGINE = INNODB;"

Writing "phpvms_pirepvalues" table... failed - manually run this query: 

"CREATE TABLE `phpvms_pirepvalues` ( `id` INT NOT NULL AUTO_INCREMENT , `fieldid` INT NOT NULL , `pirepid` INT NOT NULL , `value` TEXT NOT NULL , PRIMARY KEY ( `id` ) )ENGINE=INNODB;"

Writing "phpvms_bids" table... failed - manually run this query: 

"CREATE TABLE `phpvms_bids` ( `bidid` INT NOT NULL AUTO_INCREMENT , `pilotid` int(11) NOT NULL default '0', `routeid` int(11) NOT NULL default '0', `dateadded` DATE NOT NULL, PRIMARY KEY ( `bidid` ) ) ENGINE = INNODB;"

Writing "phpvms_settings" table... failed - manually run this query: 

"CREATE TABLE `phpvms_settings` ( `id` int(11) NOT NULL auto_increment, `friendlyname` varchar(25) NOT NULL default '', `name` varchar(25) NOT NULL default '', `value` varchar(150) NOT NULL default '', `descrip` varchar(150) NOT NULL default '', `core` smallint(6) NOT NULL default '1', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) )ENGINE=INNODB;"

Writing "phpvms_fieldvalues_ibfk_1` FOREIGN KEY (`fieldid`) REFERENCES `phpvms_customfields" table... failed - manually run this query: 

"ALTER TABLE `phpvms_fieldvalues` ADD CONSTRAINT `phpvms_fieldvalues_ibfk_1` FOREIGN KEY (`fieldid`) REFERENCES `phpvms_customfields` (`fieldid`) ON DELETE CASCADE, ADD CONSTRAINT `phpvms_fieldvalues_ibfk_2` FOREIGN KEY (`pilotid`) REFERENCES `phpvms_pilots` (`pilotid`) ON DELETE CASCADE;"

Writing "phpvms_groupmembers_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `phpvms_groups" table... failed - manually run this query: 

"ALTER TABLE `phpvms_groupmembers` ADD CONSTRAINT `phpvms_groupmembers_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `phpvms_groups` (`groupid`) ON DELETE CASCADE, ADD CONSTRAINT `phpvms_groupmembers_ibfk_2` FOREIGN KEY (`pilotid`) REFERENCES `phpvms_pilots` (`pilotid`) ON DELETE CASCADE;"

Writing "phpvms_pilots_ibfk_1` FOREIGN KEY (`code`) REFERENCES `phpvms_airlines" table... failed - manually run this query: 

"ALTER TABLE `phpvms_pilots` ADD CONSTRAINT `phpvms_pilots_ibfk_1` FOREIGN KEY (`code`) REFERENCES `phpvms_airlines` (`code`) ON UPDATE CASCADE;"

Writing "phpvms_pirepcomments_ibfk_1` FOREIGN KEY (`pirepid`) REFERENCES `phpvms_pireps" table... failed - manually run this query: 

"ALTER TABLE `phpvms_pirepcomments` ADD CONSTRAINT `phpvms_pirepcomments_ibfk_1` FOREIGN KEY (`pirepid`) REFERENCES `phpvms_pireps` (`pirepid`) ON DELETE CASCADE ON UPDATE CASCADE;"

Writing "phpvms_schedules_ibfk_1` FOREIGN KEY (`code`) REFERENCES `phpvms_airlines" table... failed - manually run this query: 

"ALTER TABLE `phpvms_schedules` ADD CONSTRAINT `phpvms_schedules_ibfk_1` FOREIGN KEY (`code`) REFERENCES `phpvms_airlines` (`code`) ON UPDATE CASCADE;"

Writing "phpvms_settings" table... failed - manually run this query: 

"INSERT INTO `phpvms_settings` VALUES(NULL, 'Virtual Airline Name', 'SITE_NAME', 'PHPVMS', 'The name of your site. This will show up in the browser title bar.', 1);"

Writing "phpvms_settings" table... failed - manually run this query: 

"INSERT INTO `phpvms_settings` VALUES(NULL, 'Webmaster Email Address', 'ADMIN_EMAIL', '', 'This is the email address that email will get sent to/from', 1);"

Writing "phpvms_settings" table... failed - manually run this query: 

"INSERT INTO `phpvms_settings` VALUES(NULL, 'Date Format', 'DATE_FORMAT', 'm/d/Y', 'This is the date format to be used around the site.', 1);"

Writing "phpvms_settings" table... failed - manually run this query: 

"INSERT INTO `phpvms_settings` VALUES(NULL, 'Current Skin', 'CURRENT_SKIN', 'crystal', 'Available skins', 1);"

Writing "phpvms_settings" table... failed - manually run this query: 

"INSERT INTO `phpvms_settings` VALUES(NULL, 'Default User Group', 'DEFAULT_GROUP', 'Active Pilots', 'This is the default group if they are not explicitly denied', 1);"

Writing "phpvms_settings" table... failed - manually run this query: 

"INSERT INTO `phpvms_settings` VALUES(NULL , 'Total VA Hours', 'TOTAL_HOURS', '0', 'Your total hours', 0);"

 

checkinstall.php gives

 

phpVMS Build Number: 936 

Checking PHP version
[OK] PHP version is 5.4.45.x

ASP Tags
[OK] ASP-style tags are disabled

Checking connectivity...
[OK] Can contact outside servers

Checking for SimpleXML module...
[OK] SimpleXML module exists!

Checking file hashes for corrupt or mismatched files
[Checksum failed] /core/classes/CodonModule.class.php did not match, possibly corrupt or out of date
[Checksum failed] /core/classes/Vars.class.php did not match, possibly corrupt or out of date
[Checksum failed] /core/common/OFCharts.class.php did not match, possibly corrupt or out of date

-- Checked 183 files, found 3 errors

[ProSkyDesign]

Wich version of phpvms did you install?

.tpl or .php?

is the first installation or did you have the phpvms installed before?

[parthprakash1]

This is a new installation on a new website. PhpVMS is the latest version available on github. What Php version should I set it to? Maybe the host itself is the problem?

[ProSkyDesign]

On 6/4/2017 at 5:17 AM, parthprakash1 said:

This is a new installation on a new website. PhpVMS is the latest version available on github. What Php version should I set it to? Maybe the host itself is the problem?

if you are using the lastest version (https://github.com/DavidJClark/phpvms_5.5.x) the php version would you set is 5.5.

The problem could be with the permissions of the user and database tables,

If you want I can help you with the cpanel (I need a account)

Edited April 7, 2017 by joooseb