Need assistance

phpVMS Legacy Support
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( idINT(11) NOT NULL AUTO_INCREMENT,pilotidVARCHAR(11) NOT NULL DEFAULT '0',flightnumVARCHAR(11) NOT NULL DEFAULT '0',pilotnameVARCHAR(100) NOT NULL DEFAULT '',aircraftVARCHAR(12) NOT NULL DEFAULT '',latVARCHAR(15) NOT NULL DEFAULT '',lngVARCHAR(15) NOT NULL DEFAULT '',headingSMALLINT(6) NOT NULL DEFAULT '0',altVARCHAR(6) NOT NULL DEFAULT '',gsINT(11) NOT NULL DEFAULT '0',depicaoVARCHAR(4) NOT NULL DEFAULT '',depaptVARCHAR(255) NOT NULL DEFAULT '',arricaoVARCHAR(4) NOT NULL DEFAULT '',arraptTEXT NOT NULL,deptimeTIME NOT NULL DEFAULT '00:00:00',timeremainingVARCHAR(6) NOT NULL DEFAULT '',arrtimeTIME NOT NULL DEFAULT '00:00:00',routeTEXT NOT NULL,route_detailsTEXT NOT NULL,distremainVARCHAR(6) NOT NULL DEFAULT '',phasedetailVARCHAR(255) NOT NULL DEFAULT '',onlineVARCHAR(10) NOT NULL DEFAULT '',messagel[…]`

MySQL said: 

#1067 - Invalid default value for 'lastupdate'

Can anyone help me, would be appreciated.

Thanks,

Toby

2

Which phpVMS version are you trying to install? Which php version have you installed?

3

You’ll need to log into phpmyadmin through your hosting provider, go into the acarsdata table and go to structure, last update needs to be DATETIME default of as defined: 0000-00-00 00:00:00. Save the changes and you should be good to go. 

1 Like
4

On 7/19/2017 at 6:21 AM, t_bergman said:

You’ll need to log into phpmyadmin through your hosting provider, go into the acarsdata table and go to structure, last update needs to be DATETIME default of as defined: 0000-00-00 00:00:00. Save the changes and you should be good to go. 

 This is the solution.