AMAviation Posted March 10, 2020 Report Share Posted March 10, 2020 (edited) I am currently installing PHP v5, and I am recieving the error: Data too long for column 'lastip' at row 1 Here is a screenshot: https://prnt.sc/red7p9 I checked my database and it seemed to be there: https://prnt.sc/redf48 Thanks Edited March 10, 2020 by AMAviation Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 10, 2020 Administrators Report Share Posted March 10, 2020 To start, let's clear up some terminology.... PHP - PHP is a popular general-purpose scripting language that is especially suited to web development. It is NOT the program you show in your screenshot. phpVMS - phpVMS is a free and open source virtual airline administration CMS. You will use this program to set up your VA. Now, on to your issue. We need a bit more info in order to assist you. What version of phpVMS are you using? There is no version 5. There is 2.1.x, 5.5.2, 5.5.2.72 and 7. What versions of PHP are available on your hosting? What version do you intend to use? What version of MySQL or MariaDB are you using? Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 10, 2020 Author Report Share Posted March 10, 2020 (edited) It was a database issue, I have fixed the problem however the CSS is not loading. I persume this is because HTTPS is not enabled. https://prnt.sc/reduj5 Edited March 10, 2020 by AMAviation Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 10, 2020 Administrators Report Share Posted March 10, 2020 If you are using https on your domain, you will need to change phpVMS to use https also. The default phpVMS (prior to v7) uses http. Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 11, 2020 Author Report Share Posted March 11, 2020 Hello, in the SSL, we have HTTPS selected as shown here: https://prnt.sc/reueqk PHP is currently on version:5.6.40 https://prnt.sc/reufem I have tried to re-issue the SSL certificate however onthe main website it works however when I go into the Acars index area to bring up the page to use PHPvms, there is no CSS and the SSL is saying that the site is not secure which is really strange. Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 11, 2020 Administrators Report Share Posted March 11, 2020 I believe your hosting SSL/HTTPS is set up correctly. In your phpVMS files, go to /core/local.config.php and see if the site URL is set to https also. There may be a few other files that need editing - I think there is a post here somewhere about it. I will look to see if I can find it and link it back here. Find this line in local.config and verify it's set to https define('SITE_URL', 'https://<Your_Site_URL)Here>'); Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 11, 2020 Author Report Share Posted March 11, 2020 Ah yes the config has fixed, a silly mistake from my side. Why is it not defining the map? https://prnt.sc/rewq7r Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 11, 2020 Administrators Report Share Posted March 11, 2020 In reviewing your screenshot I see some http URL's that need to be changed to https. You will need to go through your files for phpVMS, search for 'http' and replace with 'https'. This is only required for active calls so no need to do it for URL's in a commented out section. If you don't already use a code editor, I suggest the free Notepad++ to make search/replace easier. In your first 3 errors there are 2 ajax calls and 1 google maps call. Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 11, 2020 Administrators Report Share Posted March 11, 2020 Review this thread of other changes you may need to make Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 11, 2020 Author Report Share Posted March 11, 2020 Yes I find notepad++ very useful, and just as an adittion, when using iframe is there a way that you can get rid of the header with the other links just to display the map itself? Thanks. Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 11, 2020 Administrators Report Share Posted March 11, 2020 Do you have a link to the page in question - the iframe one? And maybe post the code of the page you are calling in the iframe. Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 11, 2020 Author Report Share Posted March 11, 2020 So the URL for the url is: https://veurojet.uk/map.php This is calling the Acars map page. Tomorrow I will fix the SSL issues and the nap will then work. Just wondering weather it is possible to remove the header so I cannot press for example home and the map just shows itself with the relevant data. Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 12, 2020 Author Report Share Posted March 12, 2020 Have re-installed and seem to get this error? https://prnt.sc/rffb10 On php V 5.6.40 It does put the EJA in the airlines however the nothing else does. How can this be fixed? Alex. Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 12, 2020 Author Report Share Posted March 12, 2020 That is fixed, However is it possible to display just the ACARS map or a page without the header? Here is the web url for the ACARS map website where i want just the map and the data below. I have gathered it calls from the index but how does this index function work? Does it set the template up through index or directly from the template folder? URL LINK: https://veurojet.uk/map.php Thanks. Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 12, 2020 Author Report Share Posted March 12, 2020 Now getting an additional error: It is not logging me in. To bypass the error of the lastip error, i had to change the length. After doing this, it has errored on logging in. The details are correct. How can this be fixed? https://prnt.sc/rfgzfh https://prnt.sc/rfh0bd Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 12, 2020 Administrators Report Share Posted March 12, 2020 1 hour ago, AMAviation said: Have re-installed and seem to get this error? https://prnt.sc/rffb10 On php V 5.6.40 It does put the EJA in the airlines however the nothing else does. How can this be fixed? Alex. This has to do with the allowed length of the 'ip' field in the database tavle I think. Since you indicated that you fixed it, how did you do that? Someone may have the same issue in the future and you fix may help them. Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 12, 2020 Author Report Share Posted March 12, 2020 Well what I did was change the VARCHAR length to 40, however. I cannot log in because it says you must be logged in to view use this as shown in the latest print screen. How can that be fixed and is that to do with it? Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 12, 2020 Administrators Report Share Posted March 12, 2020 I see we were typing at the same time. For your lastest issue, maybe try purging your browser cache and deleting all cookies. If that doesn't work, we can look at it further. Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 12, 2020 Author Report Share Posted March 12, 2020 Roger, I shall try this Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 12, 2020 Author Report Share Posted March 12, 2020 I have re-installed the site so I shall just add the HTTPS first. Here is the error tho but nothing in the console: https://prnt.sc/rfh36y Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 12, 2020 Author Report Share Posted March 12, 2020 Okay I have purged the cookies and still the same error: https://prnt.sc/rfh9qq Very strange indead. No issues in the logs and console. Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 12, 2020 Administrators Report Share Posted March 12, 2020 From that screen, if you try to log in what happens? Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 12, 2020 Author Report Share Posted March 12, 2020 It just bounces back with the same error: https://prnt.sc/rfh9qq maybe it’s blocking me because it doesn’t think I’m logged in? Not to sure. Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 13, 2020 Administrators Report Share Posted March 13, 2020 It thinks you aren't logged in. What can you do from that page? Can you register a new account? What browser are you using? Can you try from another browser? What happens if you change back to http in local.config? Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 13, 2020 Author Report Share Posted March 13, 2020 So from that page I can click any thing else, I can register but from the account I register, it gives the sane error. Using google chrome and same thing happens on safari. Quote Link to comment Share on other sites More sharing options...
Moderators shakamonkey88 Posted March 13, 2020 Moderators Report Share Posted March 13, 2020 Have you properly enabled SSL on your server? Quote Link to comment Share on other sites More sharing options...
AMAviation Posted March 13, 2020 Author Report Share Posted March 13, 2020 How can I check that, it is saying it is secure at the top and I have followed the guide to implement SSL step by step. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.