いつも参考にさせて頂いてます。

突然、管理画面にログインできなくなって困っています。
どうもデーターベースの不具合であることまでは突き止めましたが、
どうして良いかわからずに困っています。
以下がエラーログです。
お分かりになる方がいましたら、どうかアドバイスをよろしくお願いします。

22:16:49 [/admin/home.php] https://shop.foottherapy.jp/admin/home.php?transactionid=1cd7b38ccff6f91eca27336ac7f9b5f1be615f7e

SERVER_ADDR:203.183.217.157
REMOTE_ADDR:118.11.10.54
USER_AGENT:Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_6; ja-jp) AppleWebKit/525.27.1 (KHTML, like Gecko) Version/3.2.1 Safari/525.27.1

SELECT
ord.order_id,
ord.customer_id,
ord.order_name01 AS name01,
ord.order_name02 AS name02,
ord.total,
ord.create_date,
(SELECT
det.product_name
FROM
dtb_order_detail AS det
WHERE
ord.order_id = det.order_id LIMIT 1
) AS product_name,
(SELECT
pay.payment_method
FROM
dtb_payment AS pay
WHERE
ord.payment_id = pay.payment_id
) AS payment_method
FROM (
SELECT
order_id,
customer_id,
order_name01,
order_name02,
total,
create_date,
payment_id
FROM
dtb_order AS ord
WHERE
del_flg = 0 AND status <> 3
ORDER BY
create_date DESC LIMIT 10 OFFSET 0
) AS ord
DB Error: unknown error

SELECT
ord.order_id,
ord.customer_id,
ord.order_name01 AS name01,
ord.order_name02 AS name02,
ord.total,
ord.create_date,
(SELECT
det.product_name
FROM
dtb_order_detail AS det
WHERE
ord.order_id = det.order_id LIMIT 1
) AS product_name,
(SELECT
pay.payment_method
FROM
dtb_payment AS pay
WHERE
ord.payment_id = pay.payment_id
) AS payment_method
FROM (
SELECT
order_id,
customer_id,
order_name01,
order_name02,
total,
create_date,
payment_id
FROM
dtb_order AS ord
WHERE
del_flg = 0 AND status <> 3
ORDER BY
create_date DESC LIMIT 10 OFFSET 0
) AS ord [nativecode=ERROR: more than one row returned by a subquery used as an expression]

/home/footthe/.eccubes/eccube1/html/admin/home.php 33:lc_page_admin_home_ex->process
/home/footthe/.eccubes/eccube1/data/class_extends/page_extends/admin/LC_Page_Admin_Home_Ex.php 56:lc_page_admin_home->process
/home/footthe/.eccubes/eccube1/data/class/pages/admin/LC_Page_Admin_Home.php 99:lc_page_admin_home_ex->lfgetneworder
/home/footthe/.eccubes/eccube1/data/class/pages/admin/LC_Page_Admin_Home.php 245:sc_query->getall
/home/footthe/.eccubes/eccube1/data/class/SC_Query.php 156:sc_dbconn->getall
/home/footthe/.eccubes/eccube1/data/class/SC_DbConn.php 161:db_pgsql->getall
/home/footthe/.eccubes/eccube1/data/module/DB/common.php 1613:db_pgsql->query
/home/footthe/.eccubes/eccube1/data/module/DB/common.php 1167:db_pgsql->simplequery
/home/footthe/.eccubes/eccube1/data/module/DB/pgsql.php 338:db_pgsql->pgsqlraiseerror
/home/footthe/.eccubes/eccube1/data/module/DB/pgsql.php 786:db_pgsql->raiseerror
/home/footthe/.eccubes/eccube1/data/module/DB/common.php 1853:pear->raiseerror
/home/footthe/.eccubes/eccube1/data/module/PEAR.php 557:db_error->db_error
/home/footthe/.eccubes/eccube1/data/module/DB.php 893:db_error->pear_error
from 118.11.10.54

dtb_payment がキー重複していそうですね。

----------------
Seasoft
こちらでの投稿は、アイディア程度に留めさせていただいております。
個別案件の作業は有償で承っております。お気軽にご相談ください。

seasoft様

有り難うございます〜！！！
直りました。めっちゃ嬉しいです。

勉強になりました。