Jump to content

PhpVms install failure


parthprakash1

Recommended Posts

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

Link to comment
Share on other sites

  • Moderators
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 by joooseb
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...