Umsatz > heute

[Roger Rehnelt]

Bei Auswahl der o.g. Option wird eine leere Seite (keine weiße, WordPress Navi ist da). Mit Debug gibt es folgende Fehlermeldung:

Query: SELECT 
COUNT(*) AS orders,
SUM( `price_gesamt` ) AS total,
AVG( `price_gesamt` ) AS avg_total,
HOUR( `cdate` ) AS hour, 
DAY ( `cdate` ) AS day, 
MONTH( `cdate` ) AS month, 
YEAR( `cdate` ) AS year
HOUR( `cdate` ) AS tstamp,
FROM 
`wp_wpsg_order`
WHERE  
`cdate` != '0000-00-00 00:00:00' AND 
`type_payment` != '' AND 
`type_payment` IS NOT NULL AND 
`status` IN(100,110) AND 
YEAR( `cdate` ) = '2014' AND 
MONTH ( `cdate` ) = '06' AND 
DAY (`cdate`) = '11'
GROUP BY 
year, month, day, hour
ORDER BY 
hour ASC
													 
Fehler: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOUR( `cdate` ) AS tstamp,
 FROM 
`wp_wpsg_order' at line 9

[d.schmitzer]

Behoben