search

phpvms / phpvms_v2

Virtual Airline Management (not maintained)
http://www.phpvms.net
BSD 3-Clause "New" or "Revised" License
41 stars 46 forks source link

Cron Problem #70

Closed ghost closed 12 years ago

ghost commented 12 years ago

I am running version v2.1.934-170-g5ca803a (latest install at this point in time)

I am having a weird issue with phpVMS and it counting PIREPs. It is able to count the hours just fine from the PIREPs submitted however it just sets the PIREPs for all pilots to 0. I also have this from the cron script as an error.

Notice: A non well formed numeric value encountered in /home/gocanair/public_html/core/common/StatsData.class.php on line 171

I did the install test and dbcheck and this is what I got.

[Checksum failed] /core/common/PIREPData.class.php did not match, possibly corrupt or out of date [Checksum failed] /core/common/ActivityData.class.php did not match, possibly corrupt or out of date [Checksum failed] /core/templates/activity_list.tpl did not match, possibly corrupt or out of date [Checksum failed] /core/templates/pireps_airportdropdown.tpl did not match, possibly corrupt or out of date [Checksum failed] /core/modules/Activity/Activity.php did not match, possibly corrupt or out of date [Checksum failed] /core/vendors/orm/paris.php did not match, possibly corrupt or out of date

phpVMS Virtual Airline Administration Software Database Check

Checking phpvms_acarsdata...OK Checking phpvms_activityfeed...OK Checking phpvms_adminlog...OK Checking phpvms_aircraft...OK Checking phpvms_airlines...OK Checking phpvms_airports...OK Checking phpvms_awards...OK Checking phpvms_awardsgranted...OK Checking phpvms_bids...OK Checking phpvms_customfields...OK Checking phpvms_downloads...OK Checking phpvms_expenselog...OK Checking phpvms_expenses...OK Checking phpvms_fieldvalues...OK Checking phpvms_financedata...OK Checking phpvms_fuelprices...OK Checking phpvms_groupmembers...OK Checking phpvms_groups...OK Checking phpvms_ledger...OK Checking phpvms_navdata...OK Checking phpvms_news...OK Checking phpvms_pages...OK Checking phpvms_pilots...OK Checking phpvms_pirepcomments...OK Checking phpvms_pirepfields...OK Checking phpvms_pireps...OK Checking phpvms_pirepvalues...OK Checking phpvms_ranks...OK Checking phpvms_schedules...OK Checking phpvms_sessions...OK Checking phpvms_settings...OK Checking phpvms_updates...OK

I am guessing I should replace the files that failed checksum? Also, dbtest gave me this error.

Warning: include(/home/gocanair/public_html/install/loader.inc.php) [function.include]: failed to open stream: No such file or directory in /home/gocanair/public_html/install/dbtest.php on line 3

Warning: include() [function.include]: Failed opening '/home/gocanair/public_html/install/loader.inc.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/gocanair/public_html/install/dbtest.php on line 3

Fatal error: Class 'DB' not found in /home/gocanair/public_html/install/dbtest.php on line 5

Thanks,

Nick

nabeelio commented 12 years ago

Yeah, you should replace those files. I think dbtest is broken. There's a notice on the first line, I'll look into that right now, thanks

nabeelio commented 12 years ago

That notice is a strange one - do you have valid dates for your PIREPs?

ghost commented 12 years ago

Hi,

Even if I replace them specifically, the PIREPData.class.php, it fails the checksum test. As for the dates, this is one of them 06/20/2012 .

Thanks,

Nick

nabeelio commented 12 years ago

Don't worry about the checksum, the master file is likely out of date. The error is this:

Notice: A non well formed numeric value encountered in /home/gocanair/public_html/core/common/StatsData.class.php on line 171

Above that line 171 can you put a

var_dump($start);

And let me know what it says? That's a strange error. Are there any PIREPs with blank dates?

ghost commented 12 years ago

That put out string(19) "2012-06-10 16:02:02" .

Server time not set correctly I am guessing.

ghost commented 12 years ago

I checked the server time, I am getting this for the server time 'Thu Jun 21 09:04:16 CDT 2012'

nabeelio commented 12 years ago

Are the PIREPS approved?

ghost commented 12 years ago

Yes they are all approved.

nabeelio commented 12 years ago

Ah, okay. I'll need the logs that are in these instructions:

http://forum.phpvms.net/page/index.html/_/getting-started/debugging-issues-r31

ghost commented 12 years ago

Ok all done, here is the output.

errors.txt

[21-Jun-2012 15:03:04 UTC] PHP Notice: A non well formed numeric value encountered in /home/gocanair/public_html/core/common/StatsData.class.php on line 171

log.txt

Time: 06.21.12 10:03:17

Time: 06.21.12 10:03:17 Backtrace: DB::write_debug > DB::get_results > PIREPData::findPIREPS > PIREPData::getReportsByAcceptStatus > Maintenance::resetpirepcount > MainController::Run Query: SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate, UNIX_TIMESTAMP(p.modifieddate) as modifieddate, u.pilotid, u.firstname, u.lastname, u.email, u.rank, u.code AS pcode, a.id AS aircraftid, a.name as aircraft, a.registration, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms_pireps p LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_pilots u ON u.pilotid = p.pilotid WHERE pilotid = '101' AND accepted = '1' ORDER BY p.submitdate DESC

Error: (1052) - Column 'pilotid' in where clause is ambiguous

Time: 06.21.12 10:03:17

Time: 06.21.12 10:03:17 Backtrace: DB::write_debug > DB::get_results > PIREPData::findPIREPS > PIREPData::getReportsByAcceptStatus > Maintenance::resetpirepcount > MainController::Run Query: SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate, UNIX_TIMESTAMP(p.modifieddate) as modifieddate, u.pilotid, u.firstname, u.lastname, u.email, u.rank, u.code AS pcode, a.id AS aircraftid, a.name as aircraft, a.registration, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms_pireps p LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_pilots u ON u.pilotid = p.pilotid WHERE pilotid = '141' AND accepted = '1' ORDER BY p.submitdate DESC

Error: (1052) - Column 'pilotid' in where clause is ambiguous

Time: 06.21.12 10:03:17

Time: 06.21.12 10:03:17 Backtrace: DB::write_debug > DB::get_results > PIREPData::findPIREPS > PIREPData::getReportsByAcceptStatus > Maintenance::resetpirepcount > MainController::Run Query: SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate, UNIX_TIMESTAMP(p.modifieddate) as modifieddate, u.pilotid, u.firstname, u.lastname, u.email, u.rank, u.code AS pcode, a.id AS aircraftid, a.name as aircraft, a.registration, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms_pireps p LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_pilots u ON u.pilotid = p.pilotid WHERE pilotid = '429' AND accepted = '1' ORDER BY p.submitdate DESC

Error: (1052) - Column 'pilotid' in where clause is ambiguous

Time: 06.21.12 10:03:17

Time: 06.21.12 10:03:17 Backtrace: DB::write_debug > DB::get_results > PIREPData::findPIREPS > PIREPData::getReportsByAcceptStatus > Maintenance::resetpirepcount > MainController::Run Query: SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate, UNIX_TIMESTAMP(p.modifieddate) as modifieddate, u.pilotid, u.firstname, u.lastname, u.email, u.rank, u.code AS pcode, a.id AS aircraftid, a.name as aircraft, a.registration, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms_pireps p LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_pilots u ON u.pilotid = p.pilotid WHERE pilotid = '881' AND accepted = '1' ORDER BY p.submitdate DESC

Error: (1052) - Column 'pilotid' in where clause is ambiguous

I also did the checkdb and check install. Those are pasted below.

phpVMSVirtual Airline Administration Software Database Check

_Checking phpvms_acarsdata..._OK _Checking phpvms_activityfeed..._OK _Checking phpvms_adminlog..._OK _Checking phpvms_aircraft..._OK _Checking phpvms_airlines..._OK _Checking phpvms_airports..._OK _Checking phpvms_awards..._OK _Checking phpvms_awardsgranted..._OK _Checking phpvms_bids..._OK _Checking phpvms_customfields..._OK _Checking phpvms_downloads..._OK _Checking phpvms_expenselog..._OK _Checking phpvms_expenses..._OK _Checking phpvms_fieldvalues..._OK _Checking phpvms_financedata..._OK _Checking phpvms_fuelprices..._OK _Checking phpvms_groupmembers..._OK _Checking phpvms_groups..._OK _Checking phpvms_ledger..._OK _Checking phpvms_navdata..._OK _Checking phpvms_news..._OK _Checking phpvms_pages..._OK _Checking phpvms_pilots..._OK _Checking phpvms_pirepcomments..._OK _Checking phpvms_pirepfields..._OK _Checking phpvms_pireps..._OK _Checking phpvms_pirepvalues..._OK _Checking phpvms_ranks..._OK _Checking phpvms_schedules..._OK _Checking phpvms_sessions..._OK _Checking phpvms_settings..._OK _Checking phpvms_updates..._OK

phpVMSVirtual Airline Administration Software Install Check

_phpVMS Build Number:_v2.1.934-170-g5ca803a

Checking PHP version [OK]PHP version is 5.3.13.x

ASP Tags [OK]ASP-style tags are disabled

Checking connectivity... [OK]Can contact outside servers

Checking for SimpleXML module... [OK]SimpleXML module exists!

Checking file hashes for corrupt or mismatched files [Checksum failed]/core/common/PIREPData.class.php did not match, possibly corrupt or out of date [Checksum failed]/core/common/ActivityData.class.php did not match, possibly corrupt or out of date [Checksum failed]/core/templates/activity_list.tpl did not match, possibly corrupt or out of date [Checksum failed]/core/templates/pireps_airportdropdown.tpl did not match, possibly corrupt or out of date [Checksum failed]/core/modules/Activity/Activity.php did not match, possibly corrupt or out of date [Checksum failed]/core/vendors/orm/paris.php did not match, possibly corrupt or out of date

-- Checked 186 files, found 6 errors

nabeelio commented 12 years ago

I think I know where this issue is coming from.

@Vansers

ghost commented 12 years ago

Ok, so what should I do to fix it?

nabeelio commented 12 years ago

I don't know if you checked out the code or you downloaded a zip, but try re-downloading or doing the git pull, it should hopefully be fixed now.

ghost commented 12 years ago

Hi Nabeel,

I have ran the update.php but this is all it does.

  phpVMS Updater

Starting the update...

Nothing else

nabeelio commented 12 years ago

That's fine, you don't need to run the updater, just replace the files

ghost commented 12 years ago

Hi Nabeel,

I think checkdb is broken now as it gives out these errors.

Warning: simplexml_load_file() [function.simplexml-load-file http://gocanair.com/install/function.simplexml-load-file]: /home/gocanair/publichtml/install/sql/structure.xml:1: parser error : Document is empty in/home/gocanair/public_html/install/checkdb.php_on line30

Warning: simplexml_loadfile() [function.simplexml-load-file http://gocanair.com/install/function.simplexml-load-file]: in/home/gocanair/public_html/install/checkdb.php_on line30

Warning: simplexml_loadfile() [function.simplexml-load-file http://gocanair.com/install/function.simplexml-load-file]: ^ in/home/gocanair/public_html/install/checkdb.php_on line30

Warning: simplexml_load_file() [function.simplexml-load-file http://gocanair.com/install/function.simplexml-load-file]: /home/gocanair/publichtml/install/sql/structure.xml:1: parser error : Start tag expected, '<' not found in/home/gocanair/public_html/install/checkdb.php_on line30

Warning: simplexml_loadfile() [function.simplexml-load-file http://gocanair.com/install/function.simplexml-load-file]: in/home/gocanair/public_html/install/checkdb.php_on line30

Warning: simplexml_loadfile() [function.simplexml-load-file http://gocanair.com/install/function.simplexml-load-file]: ^ in/home/gocanair/public_html/install/checkdb.php_on line30

Warning: Invalid argument supplied for foreach() in_/home/gocanair/public_html/install/checkdb.php_on line*31

*Also check install does not provide a version number and also it still thinks that hashnumbers are wrong.

nabeelio commented 12 years ago

Yeah, I made a mistake and put another commit up, I guess you downloaded it before that fix went up. Try downloading again, sorry

ghost commented 12 years ago

Hi Nabeel,

The missing version number still happens with the last commit. Should I just leave it the way it is?

nabeelio commented 12 years ago

Yeah, don't worry about that

ghost commented 12 years ago

Should I worry about these errors on the latest posted version?

Database Check

Warning: simplexml_load_file() [function.simplexml-load-file http://gocanair.com/install/function.simplexml-load-file]: /home/gocanair/publichtml/install/sql/structure.xml:1: parser error : Document is empty in/home/gocanair/public_html/install/checkdb.php_on line30

Warning: simplexml_loadfile() [function.simplexml-load-file http://gocanair.com/install/function.simplexml-load-file]: in/home/gocanair/public_html/install/checkdb.php_on line30

Warning: simplexml_loadfile() [function.simplexml-load-file http://gocanair.com/install/function.simplexml-load-file]: ^ in/home/gocanair/public_html/install/checkdb.php_on line30

Warning: simplexml_load_file() [function.simplexml-load-file http://gocanair.com/install/function.simplexml-load-file]: /home/gocanair/publichtml/install/sql/structure.xml:1: parser error : Start tag expected, '<' not found in/home/gocanair/public_html/install/checkdb.php_on line30

Warning: simplexml_loadfile() [function.simplexml-load-file http://gocanair.com/install/function.simplexml-load-file]: in/home/gocanair/public_html/install/checkdb.php_on line30

Warning: simplexml_loadfile() [function.simplexml-load-file http://gocanair.com/install/function.simplexml-load-file]: ^ in/home/gocanair/public_html/install/checkdb.php_on line30

Warning: Invalid argument supplied for foreach() in_/home/gocanair/public_html/install/checkdb.php_on line31

And

Install Check

phpVMS Build Number:

Checking PHP version [OK]PHP version is 5.3.13.x

ASP Tags [OK]ASP-style tags are disabled

Checking connectivity... [OK]Can contact outside servers

Checking for SimpleXML module... [OK]SimpleXML module exists!

Checking file hashes for corrupt or mismatched files [Checksum failed]/admin/modules/Import/Import.php did not match, possibly corrupt or out of date [Checksum failed]/admin/templates/pireps_list.tpl did not match, possibly corrupt or out of date [Checksum failed]/admin/templates/pirepadmin_approved.tpl did not match, possibly corrupt or out of date [Checksum failed]/admin/templates/groups_grouplist.tpl did not match, possibly corrupt or out of date [Checksum failed]/core/vendors/orm/paris.php did not match, possibly corrupt or out of date [Checksum failed]/core/modules/Activity/Activity.php did not match, possibly corrupt or out of date [Checksum failed]/core/modules/ACARS/ACARS.php did not match, possibly corrupt or out of date [Checksum failed]/core/modules/kACARS_Free/kACARS_Free.php did not match, possibly corrupt or out of date [Checksum failed]/core/classes/ezdb/ezdb_base.class.php did not match, possibly corrupt or out of date [Checksum failed]/core/common/ActivityData.class.php did not match, possibly corrupt or out of date [Checksum failed]/core/common/PIREPData.class.php did not match, possibly corrupt or out of date [Checksum failed]/core/templates/activity_list.tpl did not match, possibly corrupt or out of date [Checksum failed]/install/dbtest.php did not match, possibly corrupt or out of date

-- Checked 186 files, found 13 errors

nabeelio commented 12 years ago

Nope, I have to fix the checkdb scripts. Did you download just now from github a fresh zip? And it's all overwritten?

ghost commented 12 years ago

Yes all fresh and overwritten

nabeelio commented 12 years ago

In the admin panel. under maintenance, there's an option to recount

nabeelio commented 12 years ago

Is this still open?

icebox3d commented 12 years ago

It can be closed