質問 > 管理機能 > 期間別集計が表示されません |
管理機能
フラット表示 | 前のトピック | 次のトピック |
投稿者 | スレッド |
---|---|
anchan |
投稿日時: 2009/7/3 12:59
対応状況: −−−
|
新米 登録日: 2009/4/18 居住地: 投稿: 7 |
Re: 期間別集計が表示されません homanさん、遅くなってすみませんでした。
●site.log 2009/07/03 12:33:23 [/hoge/admin/total/index.php] access : user=admin auth=0 sid=6a51d1999faad1589aa827d96210ad60 from {リモートアドレス} 2009/07/03 12:33:23 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/01 00:00:00 1246374000 1246592003 from {リモートアドレス} 2009/07/03 12:33:23 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/02 00:00:00 1246460400 1246592003 from {リモートアドレス} 2009/07/03 12:33:23 [/hoge/admin/total/index.php] LOADING BATCH 2009/07/03 00:00:00 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/04 00:00:00 1246633200 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/05 00:00:00 1246719600 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/06 00:00:00 1246806000 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/07 00:00:00 1246892400 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/08 00:00:00 1246978800 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/09 00:00:00 1247065200 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/10 00:00:00 1247151600 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/11 00:00:00 1247238000 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/12 00:00:00 1247324400 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/13 00:00:00 1247410800 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/14 00:00:00 1247497200 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/15 00:00:00 1247583600 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/16 00:00:00 1247670000 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/17 00:00:00 1247756400 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/18 00:00:00 1247842800 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/19 00:00:00 1247929200 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/20 00:00:00 1248015600 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/21 00:00:00 1248102000 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/22 00:00:00 1248188400 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/23 00:00:00 1248274800 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/24 00:00:00 1248361200 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/25 00:00:00 1248447600 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/26 00:00:00 1248534000 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/27 00:00:00 1248620400 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/28 00:00:00 1248706800 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/29 00:00:00 1248793200 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/30 00:00:00 1248879600 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] EXIT BATCH 2009/07/31 00:00:00 1248966000 1246592005 from {リモートアドレス} 2009/07/03 12:33:25 [/hoge/admin/total/index.php] https://www.hoge.com/hoge/admin/total/index.php SERVER_ADDR:{サーバーアドレス} REMOTE_ADDR:{リモートアドレス} USER_AGENT:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; (R1 1.6); .NET CLR 1.1.4322; .NET CLR 2.0.50727) SELECT job, count(*) AS order_count, SUM(total) AS total, TRUNCATE(AVG(total)) AS total_average FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE T2.create_date >= '2009/7/1 00:00:00' AND T2.create_date < date('2009/08/01') AND T2.del_flg = 0 and T2.status <> 3 GROUP BY job ORDER BY total DESC DB Error: syntax error SELECT job, count(*) AS order_count, SUM(total) AS total, TRUNCATE(AVG(total)) AS total_average FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE T2.create_date >= '2009/7/1 00:00:00' AND T2.create_date < date('2009/08/01') AND T2.del_flg = 0 and T2.status <> 3 GROUP BY job ORDER BY total DESC [nativecode=1064 ** 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 ') AS total_average FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( cus' at line 1] /home/hoge/hoge/html/admin/total/index.php 34:lc_page_admin_total_ex->process /home/hoge/hoge/data/class_extends/page_extends/admin/total/LC_Page_Admin_Total_Ex.php 56:lc_page_admin_total->process /home/hoge/hoge/data/class/pages/admin/total/LC_Page_Admin_Total.php 183:lc_page_admin_total_ex->lfgetorderjob /home/hoge/hoge/data/class/pages/admin/total/LC_Page_Admin_Total.php 714:sc_query->getall /home/hoge/hoge/data/class/SC_Query.php 156:sc_dbconn->getall /home/hoge/hoge/data/class/SC_DbConn.php 162:db_mysql->getall /home/hoge/hoge/data/module/DB/common.php 1613:db_mysql->query /home/hoge/hoge/data/module/DB/common.php 1167:db_mysql->simplequery /home/hoge/hoge/data/module/DB/mysql.php 324:db_mysql->mysqlraiseerror /home/hoge/hoge/data/module/DB/mysql.php 894:db_mysql->raiseerror /home/hoge/hoge/data/module/DB/common.php 1853:pear->raiseerror /home/hoge/hoge/data/module/PEAR.php 557:db_error->db_error /home/hoge/hoge/data/module/DB.php 893:db_error->pear_error from {リモートアドレス} ●サーバーエラー サーバーのログから関係ありそうなものを転記します。 [client アドレス] PHP Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1152001 bytes) in /home/hoge/hoge/data/class/graph/SC_GraphBase.php on line 193, referer: https://hoge/hoge/admin/total/index.php?page=term 以上です。よろしくお願いいたします。 |
フラット表示 | 前のトピック | 次のトピック |
題名 | 投稿者 | 日時 |
---|---|---|
期間別集計が表示されません | anchan | 2009/7/1 18:10 |
Re: 期間別集計が表示されません | homan | 2009/7/1 18:24 |
Re: 期間別集計が表示されません | anchan | 2009/7/1 19:03 |
Re: 期間別集計が表示されません | homan | 2009/7/1 19:31 |
» Re: 期間別集計が表示されません | anchan | 2009/7/3 12:59 |
Re: 期間別集計が表示されません | AMUAMU | 2009/7/3 17:25 |
Re: 期間別集計が表示されません | anchan | 2009/7/3 17:41 |
Re: 期間別集計が表示されません | AMUAMU | 2009/7/3 18:14 |
Re: 期間別集計が表示されません | anchan | 2009/7/3 18:31 |
Re: 期間別集計が表示されません | anchan | 2009/7/6 19:12 |
Re: 期間別集計が表示されません | seasoft | 2009/7/6 19:22 |
Re: 期間別集計が表示されません | AMUAMU | 2009/7/6 20:03 |
Re: 期間別集計が表示されません | seasoft | 2009/7/2 14:31 |
Re: 期間別集計が表示されません | anchan | 2009/7/3 13:01 |