Jump to content

TobyFlies

Members
  • Posts

    1
  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

TobyFlies's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Hello, I seem to be having some trouble installing phpVMS, when I attempt to install it, I can check the sql connection (it is good) - and then I try to install it (it tries to make the tables) (oh, this is all via wamp server by the way) - when it makes the tables, some of them are successful, but then some of them look like this: SQL query: CREATE TALE `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 '', `messagel[...] MySQL said: #1067 - Invalid default value for 'lastupdate' Can anyone help me, would be appreciated. Thanks, Toby
×
×
  • Create New...