Jump to content

Is there anyone who can help me with this PIREP submitting problem?


James7193

Recommended Posts

on the beginning days of this month i had started my own VA Site using the latest version of PHPVMS downloaded from the main site.

However, i had encountered a frustrating problem that i cannot sumbit any PIREPS to the system.

The MANUAL Submitting option processed and return me nothing but "No reports have been found.

I submit via XACARS, it saids " creating default object from empty value in line 337 of PIREPData.class.php"

I founded these code:

public static function getReportDetails($pirepid)

{

$sql = 'SELECT p.*, s.*, s.id AS scheduleid, p.route, p.route_details,

u.pilotid, u.firstname, u.lastname, u.email, u.rank,

dep.name as depname, dep.lat AS deplat, dep.lng AS deplng,

arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng,

p.code, p.flightnum, p.depicao, p.arricao, p.price AS price,

a.id as aircraftid, a.name as aircraft, a.registration, p.flighttime,

p.distance, UNIX_TIMESTAMP(p.submitdate) as submitdate, p.accepted, p.log

FROM '.TABLE_PREFIX.'pilots u, '.TABLE_PREFIX.'pireps p

LEFT JOIN '.TABLE_PREFIX.'airports AS dep ON dep.icao = p.depicao

LEFT JOIN '.TABLE_PREFIX.'airports AS arr ON arr.icao = p.arricao

LEFT JOIN '.TABLE_PREFIX.'aircraft a ON a.id = p.aircraft

LEFT JOIN '.TABLE_PREFIX.'schedules s ON s.code = p.code AND s.flightnum = p.flightnum

WHERE p.pilotid=u.pilotid AND p.pirepid='.$pirepid;

$row = DB::get_row($sql);

$row->rawdata = unserialize($row->rawdata);

and the line337 with problem is "$row->rawdata = unserialize($row->rawdata);"

Then i delete the whole line, XACARS said submission successful..

however THERE IS STILL NOTHING IN MY SYSTM!

I CHECKED THE ADMIN PANEL, THE PHPMYADMIN TABLES,

NOTHING IS UPLOADED THERE......

I did not do any modifications to the system. and the PIREPData.class.php I had change back to original.

phpVMS-master (1).zip

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...