search

luanpm88 / lawepham-geoip

3 stars 3 forks source link

Unable to prepare statement: 1, no such table: v4 #3

Open sbscan opened 3 years ago

sbscan commented 3 years ago

When I enable Track Clicks it gives this error. When disable everything fine except opens are not tracked.

SqliteGeoIp.php (line 63) is: $result = $this->query("SELECT * FROM {$table} WHERE {$ipno} <= ip_to LIMIT 1");

and parameters like: ('ip' => '0.0.0.0', 'ipno' => 0, 'table' => 'v4')

So really there is no table called v4

louisitvn commented 3 years ago

It is because the GeoIP database is not yet available for querying. You can contact the application support team for help. Thanks.