Jump to content

Strider

Members
  • Posts

    1816
  • Joined

  • Last visited

  • Days Won

    51

Posts posted by Strider

  1. On 12/15/2021 at 8:58 PM, Boogace said:

    hey Strider thank you for your help i have an issue when importing i keep getting duplicate entry  as you can see here can you please help ?JN818lp.png

    Try dropping the table completely(download it first in case uploading mine doesn't work) Then upload mine and see if that works.

  2. google maps only allows a certain amount of api calls free now, there is a tutorial on how to get leaflet maps on phpvms. If you can find it, I would suggest trying to get them working. First thing to check is, to see if the acars table is being populated as someone is flying, if it isn't then you have a problem with the php files for the acars program you are using. If it is being populated, then the problem lies in the code for the acars map itself. Have you made any other changes to your site that could possibly have broken something? Was it working before you tried getting the google maps api keys?

  3. This is due to strict mode being implemented, I had found a work around by putting INSERT IGNORE for all insert requests. Basically it comes down to the way phpvms stores the date and time of a pirep being filed. Using the INSERT IGNORE will allow the data to be submitted to the db as it ignores any error that is thrown up. It is not the best but for what i can see the only way to work around this problem if you do not have a VPS or dedicated server. As most hosts are reluctant to turn strict mode off.

  4. This error is not to do with the DB. It is to do with php version most likely. Try if possible selecting an older version of php. The switching to an older DB wouldn't solve this error. It could also be that there is something turned off that phpvms requires in the php setup.

  5. This is a known problem, it is to do with strict mode. There is a temporary fix I found to work is for all INSERT you need to put INSERT IGNORE instead that seems to work, but it is not a long term fix. Unfortunately because the version of phpvms you are using is old, the code is coded for older databases and php versions, and would require a pretty much complete rewrite of the code to get it to work with strict mode. You can either ask your host to downgrade to an older version of MariaDB or get a VPS or dedicate where you have control over the db version. But it is going to be harder and harder to find hosts that dont have older DB versions now.

×
×
  • Create New...