Different results between localhost and on the server

0

I have the following query that works fine on localhost but when I send it to the server it 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

Server result:

    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 Information: 4.6.6

PHP version: 5.6.30

Server:

Server version: 5.1.68

Apache Database Client Version: libmysql - 5.1.73

phpMyAdmin Version Information: 4.0.10.15

    
asked by anonymous 12.01.2018 / 21:04

0 answers