で宿泊・プランを検索
で宿泊・プランを検索
SQLSTATE[HY000]: General error: 1041 Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap spaceSELECT MIN(nPlanRate) AS MinPlanRate FROM tPlanRateTbl WHERE nYadoNo = :YadoNo AND nAgentNo = :AgentNo AND nPlanRoomNinzu = :StayNinzu AND dPlanDate = :StayDate AND nStockNo IN ( SELECT nStockNo FROM tPlanSale WHERE nYadoNo = :YadoNo AND nAgentNo = :AgentNo AND bPlanSleep = 0 AND nStockNo IN ( SELECT nStockNo FROM tStockTbl WHERE nYadoNo = :YadoNo AND DATE_FORMAT(dStockDate, '%Y/%m/%d') = :StayDate2 AND (nStockInputNum - nStockResvNum) >= 1 OR nStockInputNum = -9)) AND bPlanExclude != 1 AND nPlanRate > 0 array(5) {
["YadoNo"]=>
string(3) "279"
["AgentNo"]=>
int(5)
["StayNinzu"]=>
string(1) "2"
["StayDate"]=>
string(19) "2025/01/29 00:00:00"
["StayDate2"]=>
string(10) "2025/01/29"
}