NOSTOCK_HIDDENをtrueにするとエラーが出ます。
DB接続に失敗しているのかな?という感じなのですが、DB・PHP共によく理解しておらず、状況も原因も全くわかりません。
状況や原因などわかる方がおられましたら教えていただけないでしょうか?
EC-CUBEバージョン 2.11.4
PHPバージョン PHP 5.3.3
DBバージョン MySQL 5.0.77
http://localhost/eccube/html/products/list.php?category_id=34引用:
C:\xampp\htdocs\eccube\html\products\list.php 34:LC_Page_Products_List_Ex->process
C:\xampp\htdocs\eccube\data\class_extends\page_extends\products\LC_Page_Products_List_Ex.php 56:LC_Page_Products_List->process
C:\xampp\htdocs\eccube\data\class\pages\products\LC_Page_Products_List.php 87:LC_Page_Products_List->action
C:\xampp\htdocs\eccube\data\class\pages\products\LC_Page_Products_List.php 124:LC_Page_Products_List->lfGetProductAllNum
C:\xampp\htdocs\eccube\data\class\pages\products\LC_Page_Products_List.php 414:SC_Product->findProductCount
C:\xampp\htdocs\eccube\data\class\SC_Product.php 128:SC_Query->getOne
C:\xampp\htdocs\eccube\data\class\SC_Query.php 601:SC_Query->prepare
C:\xampp\htdocs\eccube\data\class\SC_Query.php 876:trigger_error
▼▼▼ エラーメッセージ ▼▼▼
https://localhost/eccube/html/products/list.php?category_id=34
SERVER_ADDR: 127.0.0.1
REMOTE_ADDR: 127.0.0.1
USER_AGENT: Opera/9.80 (Windows NT 6.1; U; ja) Presto/2.10.229 Version/11.60
SQL: SELECT count(*) FROM ( SELECT alldtl.product_id FROM dtb_products AS alldtl JOIN dtb_product_categories AS T2 ON alldtl.product_id = T2.product_id JOIN dtb_category ON T2.category_id = dtb_category.category_id WHERE alldtl.del_flg = 0 AND alldtl.status = 1 AND (stock >= 1 OR stock_unlimited = 1) AND T2.category_id IN (?) GROUP BY alldtl.product_id ) as t
MDB2 Error: no such field
_doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_12e3040a0646ae05a2e776b9302c24acc33dcf6be2 FROM 'SELECT count(*) FROM ( SELECT alldtl.product_id FROM dtb_products AS alldtl JOIN dtb_product_categories AS T2 ON alldtl.product_id = T2.product_id JOIN dtb_category ON T2.category_id = dtb_category.category_id WHERE alldtl.del_flg = 0 AND alldtl.status = 1 AND (stock >= 1 OR stock_unlimited = 1) AND T2.category_id IN (?) GROUP BY alldtl.product_id ) as t']
[Native code: 1054]
[Native message: Unknown column 'stock' in 'where clause']
C:\xampp\htdocs\eccube\html\products\list.php 34:LC_Page_Products_List_Ex->process
C:\xampp\htdocs\eccube\data\class_extends\page_extends\products\LC_Page_Products_List_Ex.php 56:LC_Page_Products_List->process
C:\xampp\htdocs\eccube\data\class\pages\products\LC_Page_Products_List.php 87:LC_Page_Products_List->action
C:\xampp\htdocs\eccube\data\class\pages\products\LC_Page_Products_List.php 124:LC_Page_Products_List->lfGetProductAllNum
C:\xampp\htdocs\eccube\data\class\pages\products\LC_Page_Products_List.php 414:SC_Product->findProductCount
C:\xampp\htdocs\eccube\data\class\SC_Product.php 128:SC_Query->getOne
C:\xampp\htdocs\eccube\data\class\SC_Query.php 601:SC_Query->prepare
C:\xampp\htdocs\eccube\data\class\SC_Query.php 873:MDB2_Driver_mysql->prepare
C:\xampp\htdocs\eccube\data\module\MDB2\Driver\mysql.php 1123:MDB2_Driver_mysql->_doQuery
C:\xampp\htdocs\eccube\data\module\MDB2\Driver\mysql.php 798:MDB2_Driver_Common->raiseError
C:\xampp\htdocs\eccube\data\module\MDB2.php 1497:PEAR->raiseError
C:\xampp\htdocs\eccube\data\module\PEAR.php 557:MDB2_Error->MDB2_Error
C:\xampp\htdocs\eccube\data\module\MDB2.php 1009:PEAR_Error->PEAR_Error