PTY997

December 18, 2011

found the problem it was The ISAPI filter were restricting the asp4 dlls to run.

December 18, 2011

Sure also now ive sorted this all my other pages like support and forums have 404 errors dont supose you know how to sort this?

December 18, 2011

Solved it took soem time but did it Had to check every config in MySQL and PHPmyadmin and make sure it was enabled there

December 17, 2011

It tells me that your database isn't supporting the engine INNODB database type. I think you would have to talk to your host about it.

thanks i spoke to them and they said the mysql is active, I checked phpmyadmin and is disabled i dont surpose anyneone knows how to enable it ive tried it but not getting anywhere

December 17, 2011

I have followed the instruction on how to install it and i seem to keep hitting the same wall. This is the log I receive.

Installing the tables...
Writing "CREATE TABLE `adminlog" table... success

Writing "CREATE TABLE `awards" table... success

Writing "CREATE TABLE `awardsgranted" table... success

Writing "CREATE TABLE IF NOT EXISTS `fuelprices" table... success

Writing "CREATE TABLE `updates" table... success

Writing "CREATE TABLE `downloads" table... success

Writing "CREATE TABLE `expenses" table... success

Writing "CREATE TABLE `expenselog" table... success

Writing "CREATE TABLE IF NOT EXISTS `financedata" table... success

Writing "CREATE TABLE `acarsdata" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `airlines" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `aircraft" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE IF NOT EXISTS `navdata" table... success

Writing "CREATE TABLE `airports" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `schedules" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `news" table... failed - manually run this query:

"CREATE TABLE `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 "INSERT INTO `news" table... failed - manually run this query:

"INSERT INTO `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 "CREATE TABLE `pages" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `ranks" table... failed - manually run this query:

"CREATE TABLE `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 "INSERT INTO `ranks" table... failed - manually run this query:

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

Writing "CREATE TABLE `sessions" table... success

Writing "CREATE TABLE `pilots" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `pireps" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `pirepcomments" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `customfields" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `fieldvalues" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `groups" table... failed - manually run this query:

"CREATE TABLE `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 "INSERT INTO `groups" table... failed - manually run this query:

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

Writing "INSERT INTO `groups" table... failed - manually run this query:

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

Writing "CREATE TABLE `groupmembers" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `pirepfields" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `pirepvalues" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `bids" table... failed - manually run this query:

"CREATE TABLE `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 "CREATE TABLE `settings" table... failed - manually run this query:

"CREATE TABLE `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 " ADD CONSTRAINT `fieldvalues_ibfk_1` FOREIGN KEY (`fieldid`) REFERENCES `customfields" table... failed - manually run this query:

"ALTER TABLE `fieldvalues` ADD CONSTRAINT `fieldvalues_ibfk_1` FOREIGN KEY (`fieldid`) REFERENCES `customfields` (`fieldid`) ON DELETE CASCADE, ADD CONSTRAINT `fieldvalues_ibfk_2` FOREIGN KEY (`pilotid`) REFERENCES `pilots` (`pilotid`) ON DELETE CASCADE;"

Writing " ADD CONSTRAINT `groupmembers_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `groups" table... failed - manually run this query:

"ALTER TABLE `groupmembers` ADD CONSTRAINT `groupmembers_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `groups` (`groupid`) ON DELETE CASCADE, ADD CONSTRAINT `groupmembers_ibfk_2` FOREIGN KEY (`pilotid`) REFERENCES `pilots` (`pilotid`) ON DELETE CASCADE;"

Writing " ADD CONSTRAINT `pilots_ibfk_1` FOREIGN KEY (`code`) REFERENCES `airlines" table... failed - manually run this query:

"ALTER TABLE `pilots` ADD CONSTRAINT `pilots_ibfk_1` FOREIGN KEY (`code`) REFERENCES `airlines` (`code`) ON UPDATE CASCADE;"

Writing " ADD CONSTRAINT `pirepcomments_ibfk_1` FOREIGN KEY (`pirepid`) REFERENCES `pireps" table... failed - manually run this query:

"ALTER TABLE `pirepcomments` ADD CONSTRAINT `pirepcomments_ibfk_1` FOREIGN KEY (`pirepid`) REFERENCES `pireps` (`pirepid`) ON DELETE CASCADE ON UPDATE CASCADE;"

Writing " ADD CONSTRAINT `schedules_ibfk_1` FOREIGN KEY (`code`) REFERENCES `airlines" table... failed - manually run this query:

"ALTER TABLE `schedules` ADD CONSTRAINT `schedules_ibfk_1` FOREIGN KEY (`code`) REFERENCES `airlines` (`code`) ON UPDATE CASCADE;"

Writing "INSERT INTO `settings" table... failed - manually run this query:

"INSERT INTO `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 "INSERT INTO `settings" table... failed - manually run this query:

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

Writing "INSERT INTO `settings" table... failed - manually run this query:

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

Writing "INSERT INTO `settings" table... failed - manually run this query:

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

Writing "INSERT INTO `settings" table... failed - manually run this query:

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

Writing "INSERT INTO `settings" table... failed - manually run this query:

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

Continue to the next step

How do i solve this?

June 14, 2011

tried it still same again

June 14, 2011

Nope still no luck same errors again

June 13, 2011

Ok i have deleted the database and completely restarted from the beginning but i get same errors. Its my own server not a free hosting one, i no the PHPVMS should work as one of my friends is running his database off my server

June 13, 2011

yep tried that also

June 13, 2011

i tried what you said but getting same error as above

June 13, 2011

i created a table correctly and it all work but then i place the information in to start the table creationonly a few are created

this is the error:

Installing the tables...
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);"

Continue to the next step

Why is this?

Sign In

PTY997

Posts

Joined

Last visited

Content Type

Profiles

Forums

phpVMS Resources

Downloads

Posts posted by PTY997

Install help

Install help

Install help

Install help

Install help

Install problem

Install problem

Install problem

Install problem

Install problem

Install problem