0
I have the query below that works well on localhost but when send to the server does not work
What can it be?
SELECT CONCAT( mes, '/ ', ano ) AS data, IFNULL( SUM( total ) , 0 ) AS Total
FROM lc_controle
WHERE tipo_venda ='Atacado' AND tipo ='0'
group by mes, ano Order By ano, mes
Result on localhost:
data
Total
1/ 2017
82950.23
2/ 2017
60386.26
3/ 2017
118314.10
4/ 2017
91309.18
5/ 2017
105705.88
6/ 2017
47475.58
7/ 2017
169589.50
8/ 2017
173758.04
9/ 2017
95056.97
10/ 2017
256681.42
11/ 2017
222838.47
12/ 2017
85775.08
Result on the server:
data
Total
312f2032303137
82950.23
322f2032303137
60386.26
332f2032303137
118314.10
342f2032303137
91309.18
352f2032303137
105705.88
362f2032303137
47475.58
372f2032303137
169589.50
382f2032303137
173758.04
392f2032303137
95056.97
31302f2032303137
256681.42
31312f2032303137
222838.47
31322f2032303137
87318.40
312f2032303138
39141.66
The versions are almost the same
Localhost:
phpMyAdmin Version info: 4.6.6
PHP version: 5.6.30
Server:
Server version: 5.1.68
Apache Database client version: libmysql - 5.1.73
phpMyAdmin Version Info: 4.0.10.15
remembered to configure the connection variables with the database on your system?
– Julio Henrique
Yes, the files are the same, only the result is different
– Robert
I highly recommend upgrading this server, the version of PHP to a minimum 5.6
– NoobSaibot