Install problem

[PTY997]

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?

[easyJet Virtual]

Log into your MySQL database and remove all the tables with phpvms_ and try and install it again

[PTY997]

i tried what you said but getting same error as above

[mark1million]

Also delete the local.config.php in the core folder.

[PTY997]

yep tried that also

[mark1million]

Ok just start over again, delete the database and files then reupload.

[servetas]

Try mark1million's solution. Please notice that if your website is on a free webhosting company it maybe have some problems...

[PTY997]

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

[mark1million]

Are you installing the beta a fresh?

If so try to stable release and then update to the latest beta.

[Strider]

Try downloading phpvms again, it may have gotten corrupted when you downloaded it.

[PTY997]

Nope still no luck same errors again

[Strider]

Try changing the PHPVMS_ prefix, to another, if the db has another one in there with the same prefix, it will fail to install.

[PTY997]

tried it still same again