Error: (1406) - Data too long for column 'lat' at row 1 (SOLVED)

phpVMS Legacy Support
1

phpVMS version : Simpilot 5.5.2
PHP version: php5.6
MySQL or Maria DB version: MariaDB 10.4.17
Skin used: Crystal

 

 

Hi,

using kACARS or CCFTracker i see this error:

 

Error: (1406) - Data too long for column ‘lat’ at row 1

 

In phpmyadmin i have a table phpvms_acarsdata and in column lat and lng VARCHAR(15).

 

I change to VARCHAR(7) but error remain.

 

In log.txt for see error i find coordinates like this one; ‘39.8207508932871’,‘-8.88761192976597’

 

How to fix this, anyone know’s?

 

Thanks guys.

Regards.

Miguel

 

 

2

As stated in Discord, we need additional info…

 

phpVMS version

PHP version

MySQL or MariaDB version

Skin used

Addon modules used

 

This is most probably a StrictMode issue.

3

I see you edited your post above with some of the info.

 

What MySQL version?

Are you using the default crystal skin or another?

Any addon modules?

4

27 minutes ago, ProAvia said:

I see you edited your post above with some of the info.

 

What MySQL version?

Are you using the default crystal skin or another?

Any addon modules?

Im testing with Crystal.

And MySQL or Maria DB version: MariaDB 10.4.17

 

And modules below:

 

IMG20201201172239.jpg.93f4843d1d6bbe3f37e82d70198b2357.jpg

5

Ok guys,

with some tests i find a solution.

 

In phpvms_acarsdata and in column lat and lng VARCHAR(15), i change to LONG TEXT and acarsmap works fine.

 

Thanks for your time reading my post.

Regards,

Miguel

6

The real issue is probably MariaDB 10.4 and Strict Mode.

 

We know that phpVMS  5.5.2 will work under MariaDB 10.1 . Some users have reported issues with MariaDB 10.2 and above. Some of these issues were related to Strict Mode. Search here for “strict mode”.

 

Your work-around may work. There may be other DB tables that may need the same adjustments. Only time will tell. Keep us advised in this thread if you notice other similar issues.

1 Like