バグ報告 > 管理機能 > 売上集計でシステムエラー |
管理機能
フラット表示 | 前のトピック | 次のトピック |
投稿者 | スレッド |
---|---|
juli |
投稿日時: 2011/11/22 12:34
対応状況: −−−
|
常連 登録日: 2011/8/3 居住地: 投稿: 34 |
Re: 売上集計でシステムエラー これのことでしょうか?
SERVER_ADDR:203.142.211.114 REMOTE_ADDR:58.183.46.247 USER_AGENT:Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; GTB7.1; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C) SELECT job, count(*) AS order_count, SUM(total) AS total, truncate(AVG(total),0) AS total_average FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE T2.create_date >= '2011/11/1 00:00:00' AND T2.create_date < date('2011/12/01') AND T2.del_flg = 0 and T2.status <> 3 GROUP BY job ORDER BY total DESC DB Error: unknown error SELECT job, count(*) AS order_count, SUM(total) AS total, truncate(AVG(total),0) AS total_average FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE T2.create_date >= '2011/11/1 00:00:00' AND T2.create_date < date('2011/12/01') AND T2.del_flg = 0 and T2.status <> 3 GROUP BY job ORDER BY total DESC [nativecode=ERROR: function truncate(numeric, integer) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts.] /home/kir017128/public_html/daily-shop/admin/total/index.php 33:LC_Page_Admin_Total_Ex->process /home/kir017128/eccube2_data/daily-shop/class_extends/page_extends/admin/total/LC_Page_Admin_Total_Ex.php 56:LC_Page_Admin_Total->process /home/kir017128/eccube2_data/daily-shop/class/pages/admin/total/LC_Page_Admin_Total.php 182:LC_Page_Admin_Total->lfGetOrderJob /home/kir017128/eccube2_data/daily-shop/class/pages/admin/total/LC_Page_Admin_Total.php 715:SC_Query->getall /home/kir017128/eccube2_data/daily-shop/class/SC_Query.php 156:SC_DbConn->getAll /home/kir017128/eccube2_data/daily-shop/class/SC_DbConn.php 166:DB_common->getAll /home/kir017128/eccube2_data/daily-shop/module/DB/common.php 1613:DB_common->query /home/kir017128/eccube2_data/daily-shop/module/DB/common.php 1167:DB_pgsql->simpleQuery /home/kir017128/eccube2_data/daily-shop/module/DB/pgsql.php 338:DB_pgsql->pgsqlRaiseError /home/kir017128/eccube2_data/daily-shop/module/DB/pgsql.php 786:DB_common->raiseError /home/kir017128/eccube2_data/daily-shop/module/DB/common.php 1853:PEAR->raiseError /home/kir017128/eccube2_data/daily-shop/module/PEAR.php 557:DB_Error->DB_Error /home/kir017128/eccube2_data/daily-shop/module/DB.php 893:PEAR_Error->PEAR_Error from 58.183.46.247 2011/11/22 12:28:32 [/admin/login.php] access : user=mizumoto auth=0 sid=1dc9fef4e837cd61d2404bd50f8b6896 from 58.183.46.247 2011/11/22 12:28:32 [/admin/login.php] login : user=mizumoto auth=0 lastlogin=2011-11-22 11:04:13 sid=1dc9fef4e837cd61d2404bd50f8b6896 from 58.183.46.247 2011/11/22 12:28:32 [/admin/home.php] access : user=mizumoto auth=0 sid=1dc9fef4e837cd61d2404bd50f8b6896 from 58.183.46.247 2011/11/22 12:28:34 [/admin/total/index.php] access : user=mizumoto auth=0 sid=1dc9fef4e837cd61d2404bd50f8b6896 from 58.183.46.247 2011/11/22 12:28:37 [/admin/total/index.php] access : user=mizumoto auth=0 sid=1dc9fef4e837cd61d2404bd50f8b6896 from 58.183.46.247 2011/11/22 12:28:39 [/admin/total/index.php] access : user=mizumoto auth=0 sid=1dc9fef4e837cd61d2404bd50f8b6896 from 58.183.46.247 SERVER_ADDR:203.142.211.114 REMOTE_ADDR:58.183.46.247 USER_AGENT:Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; GTB7.1; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C) SELECT COUNT(*) AS order_count, SUM(total) AS total, truncate(AVG(total),0) AS total_average, order_sex FROM dtb_order WHERE create_date >= '2011/11/1 00:00:00' AND create_date < date('2011/12/01') AND customer_id <> 0 AND del_flg = 0 AND status <> 3 GROUP BY order_sex DB Error: unknown error SELECT COUNT(*) AS order_count, SUM(total) AS total, truncate(AVG(total),0) AS total_average, order_sex FROM dtb_order WHERE create_date >= '2011/11/1 00:00:00' AND create_date < date('2011/12/01') AND customer_id <> 0 AND del_flg = 0 AND status <> 3 GROUP BY order_sex [nativecode=ERROR: function truncate(numeric, integer) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts.] /home/kir017128/public_html/daily-shop/admin/total/index.php 33:LC_Page_Admin_Total_Ex->process /home/kir017128/eccube2_data/daily-shop/class_extends/page_extends/admin/total/LC_Page_Admin_Total_Ex.php 56:LC_Page_Admin_Total->process /home/kir017128/eccube2_data/daily-shop/class/pages/admin/total/LC_Page_Admin_Total.php 195:LC_Page_Admin_Total->lfGetOrderMember /home/kir017128/eccube2_data/daily-shop/class/pages/admin/total/LC_Page_Admin_Total.php 647:SC_Query->select /home/kir017128/eccube2_data/daily-shop/class/SC_Query.php 95:SC_DbConn->getAll /home/kir017128/eccube2_data/daily-shop/class/SC_DbConn.php 166:DB_common->getAll /home/kir017128/eccube2_data/daily-shop/module/DB/common.php 1613:DB_common->query /home/kir017128/eccube2_data/daily-shop/module/DB/common.php 1167:DB_pgsql->simpleQuery /home/kir017128/eccube2_data/daily-shop/module/DB/pgsql.php 338:DB_pgsql->pgsqlRaiseError /home/kir017128/eccube2_data/daily-shop/module/DB/pgsql.php 786:DB_common->raiseError /home/kir017128/eccube2_data/daily-shop/module/DB/common.php 1853:PEAR->raiseError /home/kir017128/eccube2_data/daily-shop/module/PEAR.php 557:DB_Error->DB_Error /home/kir017128/eccube2_data/daily-shop/module/DB.php 893:PEAR_Error->PEAR_Error from 58.183.46.247 よろしくお願いします。 |
フラット表示 | 前のトピック | 次のトピック |
題名 | 投稿者 | 日時 |
---|---|---|
売上集計でシステムエラー | juli | 2011/11/22 11:11 |
Re: 売上集計でシステムエラー | seasoft | 2011/11/22 11:32 |
» Re: 売上集計でシステムエラー | juli | 2011/11/22 12:34 |
Re: 売上集計でシステムエラー | seasoft | 2011/11/22 12:43 |
Re: 売上集計でシステムエラー | juli | 2011/11/23 10:21 |
Re: 売上集計でシステムエラー | seasoft | 2011/11/23 23:33 |
Re: 売上集計でシステムエラー | juli | 2011/11/26 11:25 |