Reinstall Issues

[mw308]

Hi all

I've had to reinstall my server which has meant reinstalling phpVMS.  I downloaded the 2.0.854 release (not beta), went through the install document making the necessary folders writeable, imported the old database from my previous 854 install, and now pireps aren't working.

Manually adding results in no error and when the pirep list is displayed it's not shown.

Using Xacars results in "SUCCESS" from the server, but again nothing showed in the pirep list.

Also, nothing is shown in the "Pending Pireps" notification on the admin part.

However, in both the xacars.txt and log.txt logs, the pireps are displayed.  I've double checked folder permissions, but I'm now pulling my hair out!

Any help would be appreciated.

Will

[Nabeel]

Can you post the logs.txt file? Or email it

Also, run install/checkdb.php and install/checkinstall.php

[mw308]

Content of log.txt:

Caller: DB::write_debug->DB::query->PIREPData::fileReport->ACARSData::FilePIREP->include_once->ACARS->__call->ACARS->xacars->call_user_func_array->MainController::RunAllActions
INSERT INTO vaaswv2_pireps(	
						`pilotid`, 
						`code`, 
						`flightnum`, 
						`depicao`, 
						`arricao`, 
						`distance`,
						`aircraft`, 
						`flighttime`, 
						`flighttime_stamp`,
						`landingrate`,
						`submitdate`, 
						`accepted`, 
						`log`,
						`load`,
						`fuelused`,
						`source`,
						`exported`,
						`rawdata`)
				VALUES ( 1, 
						'WOW', 
						'05B', 
						'EGHD', 
						'EGHQ', 
						'34.032825131298',
						'2', 
						'0.12', 
						'0:12:00',
						'0',
						NOW(), 
						0, 
						'',
						'37',
						'537',
						'xacars',
						0,
						'')
Field 'expenselist' doesn't have a default value

Running checkdb and checkinstall show no errors.  From the above log I've checked that expenselist default value is "NULL".

[Nabeel]

That's weird, there is no expenselist field.

Is that all that's in the log?

[mw308]

I've got an expenselist field in the pireps table, right under expenses.

Yes that's all as I reinstalled then turned logging back on to see if it would fix it but it didn't.

[Nabeel]

I meant in that query.

Change the column to "null" or to allow null, that should fix it.

BTW, what mysql version do you have? Someone ran into this before, I wonder if it's version related

[mw308]

I unticked "NOT NULL" and it's started logging Pireps again.  However it's stopped calculating pilot pay and revenue.

I have version 5.1.42 for x64.

[Nabeel]

I unticked "NOT NULL" and it's started logging Pireps again.  However it's stopped calculating pilot pay and revenue.

I have version 5.1.42 for x64.

I'll check that version, see if there's anything funny

[mw308]

Hi Nabeel have you had chance to try this?

[Nabeel]

I've made a change for the next commit, though I think I'll eventually end up dropping that column