Jump to content

Rabso

Members
  • Posts

    9
  • Joined

  • Last visited

Everything posted by Rabso

  1. I am using MySQL 5.7 but even when it was on 5.5 had same issue. I tested the code through phpmyadmin and run the SQL, I can see 3 columns as aircraft but 3rd one contains aircraft name not id
  2. Hi, So while checking errors, I got following: ===== Time: 10.05.20 19:18:06 Backtrace: DB::write_debug > DB::get_row > OperationsData::getAircraftInfo > FinanceData::getLoadCount > PIREPData::populatePIREPFinance > PIREPData::fileReport > ACARSData::FilePIREP > smartCARS::filepirep Query: SELECT * FROM phpvms_aircraft WHERE `id`=A330-243 Error: (1054) - Unknown column 'A330' in 'where clause' ===== I searched in codes and found this bug (PIREPData.class.php), line 950: $pirep->load = FinanceData::getLoadCount($pirep->aircraft, $sched->flighttype); Now $pirep->aircraft should be corrected to $pirep->aircraftid Why?, $pirep array is coming from line 931, PIREPData::getReportDetails($pirep) Checking function getReportDetails, line 307 $sql = 'SELECT p.*, s.*, s.id AS scheduleid, p.route, p.route_details, p.rawdata, u.pilotid, u.firstname, u.lastname, u.email, u.rank, u.code AS pcode, 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, UNIX_TIMESTAMP(p.modifieddate) as modifieddate, 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; Problem is in 'a.name as aircraft', if we look at output of 'aircraft', we will see 3 times; - first one is containing aircraft id from table pireps - second one is containing aircraft id from table schedules - and last one is containing aircraft name from table aircraft. So when code called $pirep->aircraft, it's reading last selected from 3 which is aircraft name. Checking this raised a question, why 'getReportDetails' is calling many columns from pireps table several times? at first p* to call all column, then p.route then p.route_details and so on. regards
  3. I upgraded IPS to work with PHP 7.2, tested and works ok (no error) I need to test when it's working with cron I checked all error nothing (other than above), small changes I made based on this update: https://github.com/ProAviaAZ/phpvms_5.5.2.72 UPDATE: so it seems IPS code in getting data from IVAO is really bad, with cron after several time, everything is slow and stuck, is like codes are running without stop. I will change full way of that and give update
  4. so I turned on error reporting and this what error_log shows: [02-Oct-2020 11:03:36 UTC] PHP Deprecated: Non-static method SimpleNews::NewsList() should not be called statically in /homepages/24/d391698823/htdocs/Virtual/Saudia/lib/skins/saudia/frontpage_main.php on line 86 and this its code: <?php SimpleNews::NewsList(3); ?> I believe this is nothing as only happen when someone open main page. I also turned on DEBUG_MODE in local.config.php and got following: errors.txt file: Update: No errors, I fixed it now there was another file log.txt, it was showing some error when I use smartCARS: Time: 10.01.20 19:15:00 ===== Time: 10.01.20 19:15:00 Backtrace: DB::write_debug > DB::query > ACARSData::updateFlightData > smartCARS::positionreport Query: INSERT INTO phpvms_acarsdata (`0`,`1`,`2`,`3`,`4`,`5`,`6`,`7`,`8`,`9`,`10`,`11`,`12`,`13`,`14`,`15`,`16`,`17`,`18`,`19`,`20`,`21`,`22`,`23`,`24`,`25`,`26`,`27`,`28`,`29`,`30`,`31`,`32`,`33`,`34`,`35`,`36`,`37`,`38`,`39`,`40`,`41`,`42`,`43`,`44`,`45`,`46`,`47`,`48`,`pilotid`,`pilotname`,`heading`,`lastupdate`) VALUES ('ZX48','449045','449045','PILOT','','54.3762','-130.528','1500','80','1/C172/L-SDFGY/S','N0180','CZST','VFR','CYPR','SHARD3','B','4','1200','0','50','0','V','1830','1830','0','50','5','0','CYZP','DOF/201001 / PFPX / XP11 / ENG EASY / RMK/WORLDTOUR','55N130W DCT 54N130W DCT PR','','','','','','','20201001181213','Altitude/win','1.10.0b','2','4','CZMT','G','1','152','0','16','','6','Jehad Hamdan','0',NOW()) Error: (1054) - Unknown column '0' in 'field list' it seems somthing not right with table am trying to figure it
  5. around 2 months ago I upgraded from 7.2 to 7.3 and then things were ok. Nothing after that has been changed and host nothing informed me about any changes. only from 9 days ago issues started. I returned PHP to 7.2 but still same. our host is forcing me to upgrade to 7.3 by end of this year. I was thinking to go for vmsPHP 7 but it's still Beta and smartACARS not ready Now I noticed that when I run IPS script through SSH (sure under PHP5), it will take hell of time. The cron of this sometimes update smoothly every 3 mint and sometimes stuck for 20. my PIREPs ID reached almost 60K, will that be reason of slow?
  6. no, could be host issue? I have several light websites and they are ok I start thinking maybe our VA database became large but not sure
  7. Hi, Our VA was online for some good years but past 2 weeks I started suffering a lot of problems and slow. System is running with PHP7.2 and MySQL 5.5, we have IPS integrated too . phpVMS Version 5.5.2 what issue am suffering now is sometimes database connection will not establish for while even I got several time max connection reach while checking my tables in phpmyadmin. am not sure really what is casing problem. We have cron for IPS every minute and will download data from IVAO every 3 minutes but I can see that from time to time it will skip the 3 min and don't update up to 20 minutes sometimes. while this happening everything seems stuck and slow. so current flight keep getting duplicated and not accurate. what I should look for first? regards
  8. Hi, Is there way to prevent or turn off the option for Manually-filed PIREPs? thanks
×
×
  • Create New...