string(2133) "Can't find file: './tec/geo_allcountries.MYI' (errno: 2 "No such file or directory") SELECT
*
FROM
(SELECT
`geo_allcountries`.`geonameid`,
`geo_allcountries`.`name`,
`geo_allcountries`.`asciiname`,
`geo_allcountries`.`alternatenames`,
`geo_allcountries`.`latitude`,
`geo_allcountries`.`longitude`,
`geo_allcountries`.`fclass`,
`geo_allcountries`.`fcode`,
`geo_allcountries`.`cc2`,
`geo_allcountries`.`admin2`,
`geo_allcountries`.`admin3`,
`geo_allcountries`.`admin4`,
`geo_allcountries`.`population`,
`geo_allcountries`.`elevation`,
`geo_allcountries`.`gtopo30`,
`geo_allcountries`.`timezone`,
`geo_allcountries`.`moddate`,
geonames_paises.Country AS country,
geonames_admin1.nome AS admin1,
3956 * ACOS(COS(RADIANS(-22.014716)) * COS(RADIANS(`latitude`)) * COS(RADIANS(-44.642809) - RADIANS(`longitude`)) + SIN(RADIANS(-22.014716)) * SIN(RADIANS(`latitude`))) AS `distance`
FROM
tec.geo_allcountries
left join tec.geonames_paises on geonames_paises.ISO = geo_allcountries.country
left join tec.geonames_admin1 on geonames_admin1.cod = concat(geo_allcountries.country, '.', geo_allcountries.admin1)
WHERE
`latitude`
BETWEEN -22.014716 - (10 / 69)
AND -22.014716 + (10 / 69)
AND `longitude`
BETWEEN -44.642809 - (10 / (69 * COS(RADIANS(-22.014716))))
AND -44.642809 + (10 / (69* COS(RADIANS(-44.642809))))
) r
WHERE `distance` < 10
ORDER BY `distance` ASC"
Fatal error: Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, false given in /var/vhosts/trilhaecia.com.br/public/mapadetalhe.php:152
Stack trace:
#0 /var/vhosts/trilhaecia.com.br/public/mapadetalhe.php(152): mysqli_fetch_assoc()
#1 /var/vhosts/trilhaecia.com.br/public/wp-content/themes/twentyfourteen-child/page-templates/mapas-croquis-e-tracklogs.php(60): include('...')
#2 /var/vhosts/trilhaecia.com.br/public/wp-includes/template-loader.php(106): include('...')
#3 /var/vhosts/trilhaecia.com.br/public/wp-blog-header.php(19): require_once('...')
#4 /var/vhosts/trilhaecia.com.br/public/index.php(17): require('...')
#5 {main}
thrown in /var/vhosts/trilhaecia.com.br/public/mapadetalhe.php on line 152
