Jump to content

Pireps not submitting correctly


Strider

Recommended Posts

I have an issue that I dont know why it is happening. No pireps have been recorded today yet pilots have flown and have filed the pireps as I have gotten the emails stating they have. But they are not submitted, but it shows on the front page as they have flown, but the pirep ID is some really big number but the ID in the pirep table is not that big. Anyone know what could cause an issue like that? Or has anyone encountered this problem and fixed it, if so how did you fix it. I had to move to a new db, recently, and had to reimport the schedules db. Could that have caused a problem with the bids?

Link to comment
Share on other sites

  • Administrators

Were PIREPS working properly prior to today or the last few days?

Did your host happen to "upgrade" your PHP or MySQL/MariaDB version?

What have you added/edited in the last week or so?

Manual PIREPS, automated PIREPS (what ACARS program?), or both?

Have you checked the error_log file in main phpVMS directory and in /admin directory for any errors?

 

phpVMS version?

PHP version?

MySQL/MariaDB version?

 

Maybe check to see if the PHP configuration has changed in the last week. Maybe create a phpinfo.php file to check. For others who read this that don't know how... https://www.hostinger.com/tutorials/how-to-create-phpinfo-file

 

 

Link to comment
Share on other sites

phpvms version 5.5.2

php version 7.1

mysql/mariadb version: 10.3.23-MariaDB-cll-lve

 

It was working fine up until yesterday. Now nothing is really working the way it should do. I can add schedules and codeshares, but sending airmail, submitting pireps are not working. The subitting pireps sends the email a pirep has been submitted, and it shows on the front page but with the wrong url the pirep id is way outside the number it should be, and when i check the db the pirep is not there. So it seems that it has given itself it's own db

Link to comment
Share on other sites

  • Administrators

A few members have reported issues with MariaDB 10.2 and higher - don't remember exactly what the issues were though. Rolling back to MariaDB 10.1 resolved the issues for them. Of course, rolling back is not an option for all though.

 

I can't comment on your use of PHP 7.1 with phpVMS 5.5.2 - I know that 5.5.2 won't work for me on PHP 7.2 (that was my main reason for updating 5.5.2 to 5.5.2.72 as my host forced us to PHP 7.2).

 

I have never heard of the info showing on the front page of the site and not being in the DB. Have you looked thru your DB tables to see if you can find the info? Obviously the data is getting to the site if a submittal email goes to you and the info is present on the front page. Wrong PIREP ID is strange too. What happens with a manual PIREP submittal? Maybe try a fresh install in a separate directory - keep it totally default and then tie it to your present DB to try to debug the issue. Any change this might have anything to do with your recently updated code share module or any others you may be using?

 

I can't comment on your use of PHP 7.1 with phpVMS 5.5.2 - I know that 5.5.2 won't work for me on PHP 7.2 (that was my main reason for updating 5.5.2 to 5.5.2.72 as my host forced us to PHP 7.2). You could also try installing 5.5.2.72 on a test site and then tie your existing DB (or a copy of it) to that test install. There are a few minor DB changes between 5.5.2 and 5.5.2.72 - but those have to do with date and datetime default parameters for MySQL 5.7 and shouldn't cause any issues. But, you may wish to explore those changes as they may apply to MariaDB 10.3 as well.... https://stackoverflow.com/questions/45537777/phpvms-incorrect-date-value-0000-00-00-for-column-lastlogin-at-row-1/

Link to comment
Share on other sites

  • Administrators

Maybe pull the codeshare module out and try it that way. Does your codeshare module have any DATE or DATETIME fields?

 

I have no idea how it could send an email on a new submittal and show it on the front page without there being a DB entry.

Link to comment
Share on other sites

That is what i am confused about. it is getting to most things but when it comes to insert the data into the db it fails. I asked my host could they roll back the version of mariadb, they said they cant. I do have date and time fields that caused some trouble in adding. but work now with adding. codeshares. But come to think of it, the changes i made to the schedules table i made on the 30th of june and i still got pireps on the 1st of July. So something happened between the 1st and 2nd. I am on shared, I wonder has another site caused trouble. I am not thinking of going with a VPS to have more control over what is one the server.

Link to comment
Share on other sites

What is baffling me, is it is trigering the email saying there is a pirep waiting for approval. But it is failing to enter the detauils into the db. I have tried adding an entry in manually but it failed, so my guess is, there is something wrong with the pireps table. I have not touched that table. That table is the only one that seems to have a problem with data entry, all others work fine. I have tried moving databases but to no avail.

Link to comment
Share on other sites

This I think is coming from a problem i had with the schedules table a few days ago. It got corrupted, and i had to migrate to a new table as i couldn't fix that. I wonder could that have damaged the db so much that some code cant see it. As i have edited my codeshare module, so that it doesn't require the removal of a foreign key constraint.

Link to comment
Share on other sites

Have you tried optimizing your tables through the maintenance page? Not sure if it will help but it's worth a try. It's possible that the phpVMS foreign key constraints have been messed up due to the high IDs, if you are continuing to have issue then I would recommend setup a second site, have a fresh install/DB and migrate your data over. If importing it retains the high IDs then you may have to write a script that takes the old data dump and inserts them one at a time from the start.

It's definitely weird that things are working but the data is ending up in some sort of 'pseudo table' and not showing in the DB.

Link to comment
Share on other sites

I have tried all that. I even tried optimising it from the table itself. I am going to be moving to a VPS to have more control over it. it seems the insert function for the pireps is not working the way it should do. I have replaced those files with ones from backups but that did not help.

Link to comment
Share on other sites

  • Administrators

Can you check you PHP configuration and make sure "bcmath" is running and that "allow_url_open" is set to ON ?

 

Maybe install a phpinfo.php file and run it to see exactly the PHP configuration for the directory the phpVMS is installed in. 

Link to comment
Share on other sites

[07-Jul-2020 20:04:15 Europe/Dublin] PHP Warning:  mysqli::__construct(): (HY000/1045): Access denied for user 'malaysi1_icrew_user'@'localhost' (using password: YES) in /core/classes/ezdb/ezdb_mysqli.class.php on line 101
[07-Jul-2020 20:04:15 Europe/Dublin] PHP Fatal error:  Uncaught <blockquote><font face=arial size=2 color=000099><b>Last Error --</b> [<font color=000000><b>Access denied for user 'malaysi1_icrew_user'@'localhost' (using password: YES) (1045)</b></font>]<br />[<font color=000000><b></b></font>]</font><p>
					</blockquote><hr noshade color=dddddd size=1>
  thrown in /core/classes/ezdb/ezdb_mysqli.class.php on line 106

I get that error when i submit a manual pirep can someone shed some light on how to fix that as it is only the pirep form that is causing that error. as all other forms work without error, and submit the data.

Link to comment
Share on other sites

I have resolved this problem. I had to change the pirepdata class to one from the V2 from nabeel's github, and change some columns to allow null values if none for those are submitted. Looks like something got set to strict or something not sure. But am happy this is now fixed.

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...