PHP v5 Installation ERROR

[AMAviation]

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

[ProAvia]

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?

[AMAviation]

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

[ProAvia]

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.

[AMAviation]

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. 

[ProAvia]

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>');

 

[AMAviation]

Ah yes the config has fixed, a silly mistake from my side. Why is it not defining the map? https://prnt.sc/rewq7r

[ProAvia]

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.

[ProAvia]

Review this thread of other changes you may need to make

 

 

[AMAviation]

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.

[ProAvia]

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.

[AMAviation]

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. 

[AMAviation]

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.

[AMAviation]

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.

[AMAviation]

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

[ProAvia]

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.

[AMAviation]

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? 

[ProAvia]

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.

[AMAviation]

Roger, I shall try this

 

[AMAviation]

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

[AMAviation]

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.

[ProAvia]

From that screen, if you try to log in what happens?

 

 

[AMAviation]

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.

[ProAvia]

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?

[AMAviation]

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.

[shakamonkey88]

Have you properly enabled SSL on your server?

[AMAviation]

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.