[[Redacted]]

On 11/3/2017 at 2:21 AM, vbegin7 said:

Job accepted ill be happy to join teamspeak if you'd like to so we can go over everything that needs to be done

[Redacted]

[[Redacted]]

On 11/2/2017 at 9:42 PM, mischka said:

$40? like, per hour? I think you have a nice looking site already

[Redacted]

[[Redacted]]

[Redacted]

[Live flight not working]

On 14/08/2017 at 12:31 PM, web541 said:

Yes, you're correct, smartCARS would report their own errors in their log file including if it failed to connect to the web server. If the authentication failed to connect to the database through the phpVMS root, then you will most likely find an error in the phpVMS logs (and this may lead to an error in smartCARS which may also log the issue). The fact that @HCStrike reported an error called AUTH_FAILED tells me that according to the smartCARS module, it cannot verify the session data which is why it is more of a TFDi issue as far as I can see, I could be wrong though.

The error message is now in the phpVMS logs. It now states that there is an SQL error when smartCARS sends a position report, as smartCARS sends no data for route_details and "route_details" doesn't have a default value.

[Route_Details]

On 05/10/2017 at 3:52 PM, servetas said:

I had the same problem with one of the servers I administrate. Check this for more information: https://stackoverflow.com/questions/15438840/mysql-error-1364-field-doesnt-have-a-default-values

Alternatively, you can get into your database via phpmyadmin and set a default value into the route_details field of the phpvms_acarsdata database table.

Tried that, but A ) I don't know what the default value is, and B ) phpMyAdmin seemed to change it back to "NULL" (what it currently is) straight away

[Route_Details]

Going to bump this as I am having a similar issue with the following error, meaning flights don't get logged either:

Time: 10.03.17 21:39:01
Backtrace: DB::write_debug > DB::query > ACARSData::updateFlightData > smartCARS::positionreport
Query: INSERT INTO phpvms_acarsdata (`pilotid`,`flightnum`,`pilotname`,`aircraft`,`lat`,`lng`,`heading`,`alt`,`gs`,`depicao`,`arricao`,`deptime`,`arrtime`,`route`,`distremain`,`timeremaining`,`phasedetail`,`online`,`client`,`depapt`,`arrapt`,`lastupdate`) VALUES ('2','MTC4803','Calum Shepherd','G-MTTE','43.537946850823','16.298493842888','230','86','0','LDSP','OTHH',FROM_UNIXTIME(1507063141),FROM_UNIXTIME(1507063141),'DCT','2043','N/A','Preflight','VATSIM','smartCARS','Split Airport','Hamad International Airport',NOW())
Error: (1364) - Field 'route_details' doesn't have a default value

[Live flight not working]

Hello, I'm working on the VA with @HCStrike, hence why I am following up on this post.

If it was a smartCARS issue, wouldn't smartCARS report errors on the client side as if it were failing to connect to the VA? Or is smartCARS only concerned with connecting to the local files within the phpVMS root, in which case is the issue between the smartCARS folder within the phpVMS folder, possibly not connecting from there to phpVMS?