Piwik_log_link_visit_action going to hit INT(11) max range

General questions
1

Hi all,

We are using piwik since two years and it is working fine and now getting 5.5 M hits daily . Thanks to piwik community . :blush:

We have observed that piwik_log_link_visit_action key idlink_va is going to reach unsigned INT (11) max value i.e 4294967295

In our table the current value is 4239697136 .The solution seems that we change the column type to BIGINT ?

Will this cause any issue to piwik working or not if we do so .We are using piwik 2.10 .
Please suggest .

Many thanks
Saqib

2

Hello

Yes you need to change to BIGINT. See: Integer overflow: how to track more than 2 billion actions with PiwiK? · Issue #3288 · matomo-org/piwik · GitHub

In PIwik 3.0.0 we will implement this change directly.

3

Thanks matthieu .

A big relief for us :slight_smile: