Exception Object
(
[message:protected] => Out of resources when opening file './bcseminar/subcategory.MYD' (Errcode: 24 - Too many open files) [
SELECT
rs.SeminarCompanyID as SeminarCompanyID,
rs.SeminarID as SeminarID,
concat(
SUBSTR( rs.ApplicationReceptionStartDate , 1 , 4 ) ,
'/',
SUBSTR( rs.ApplicationReceptionStartDate , 5 , 2 ) ,
'/',
SUBSTR( rs.ApplicationReceptionStartDate , 7 , 2 )
) as ApplicationReceptionStartDate,
concat(
SUBSTR( rs.ApplicationReceptionEndDate , 1 , 4 ) ,
'/',
SUBSTR( rs.ApplicationReceptionEndDate , 5 , 2 ) ,
'/',
SUBSTR( rs.ApplicationReceptionEndDate , 7 , 2 )
) as ApplicationReceptionEndDate,
rs.ApplicationReceptionStartDate as ApplicationReceptionStartDate2,
rs.ApplicationReceptionEndDate as ApplicationReceptionEndDate2,
(select
COUNT(Date)
FROM
recognitionseminarsch
WHERE
(SeminarCompanyID = '102270000') AND
(SeminarID = '000011586')
group by
SeminarCompanyID,SeminarID
) as SemiDate,
rs.PrintStateID as PrintStateID,
rs.SeminarName as SeminarName,
rs.SubTitle as SubTitle,
rs.SeminarOutline as SeminarOutline,
rs.SeminarDetails as SeminarDetails,
rs.Information as Information,
rs.AttendantComment as AttendantComment,
rs.Purpose as Purpose,
rs.TakingLecObject as TakingLecObject,
rs.SpecialFavor as SpecialFavor,
rs.HostCompanyName as HostCompanyName,
rs.ParticipationCost1 as ParticipationCost1,
rs.ParticipationCost2 as ParticipationCost2,
rs.QuotaNum as QuotaNum,
rs.ReceiveNum as ReceiveNum,
rs.ConditionQualifying as ConditionQualifying,
rs.Property as Property,
rs.ParticipationForm1 as ParticipationForm1,
rs.ParticipationForm2 as ParticipationForm2,
rs.LocalID as LocalID,
(SELECT
lc.LocalName
FROM
local lc
WHERE
lc.DelFlag = '0' AND
lc.LocalID = rs.LocalID) as LocalName,
rs.CategoryID as CategoryID,
(SELECT
cg.CategoryName
FROM
category cg
WHERE
cg.DelFlag = '0' AND
cg.CategoryID = rs.CategoryID
) as CategoryName,
rs.SubCategoryID as SubCategoryID,
(SELECT
scg.SubCategoryName
FROM
subcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubCategoryID = rs.SubCategoryID AND
scg.CategoryID = rs.CategoryID
) as SubCategoryName,
rs.SubSubCategoryID as SubSubCategoryID,
(SELECT
scg.SubSubCategoryName
FROM
subsubcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubCategoryID = rs.SubCategoryID AND
scg.CategoryID = rs.CategoryID AND
scg.SubSubCategoryID = rs.SubSubCategoryID
) as SubSubCategoryName,
rs.HallName as HallName,
rs.HallPostal1 as HallPostal1,
rs.HallPostal2 as HallPostal2,
rs.HallAdministrativeDivisionsID as HallAdministrativeDivisionsID,
(SELECT
ad.AdministrativeDivisionsName
FROM
administrativedivisions ad
WHERE
ad.DelFlag = '0' AND
ad.LocalID = rs.LocalID AND
ad.AdministrativeDivisionsID = rs.HallAdministrativeDivisionsID
) as AdministrativeDivisionsName,
rs.HallAddress as HallAddress,
rs.HallBuildingNameEtc as HallBuildingNameEtc,
rs.Icon01Flag as Icon01Flag,
rs.Icon02Flag as Icon02Flag,
rs.Icon03Flag as Icon03Flag,
rs.Icon04Flag as Icon04Flag,
rs.Icon05Flag as Icon05Flag,
case
when sc.MemberTypeID IN ('01','06','16','26')
then rs.Icon06Flag
else '0'
end as Icon06Flag,
rs.Icon07Flag as Icon07Flag,
rs.Icon08Flag as Icon08Flag,
rs.Icon09Flag as Icon09Flag,
rs.Icon10Flag as Icon10Flag,
case
when sc.MemberTypeID IN ('01','06','16','26')
then rs.LectureBeforeMaterial01
else ''
end as LectureBeforeMaterial01,
case
when sc.MemberTypeID IN ('01','06','16','26')
then rs.LectureBeforeMaterial02
else ''
end as LectureBeforeMaterial02,
rs.LectureBeforeAnimation as LectureBeforeAnimation,
rs.LectureAfterMaterial01 as LectureAfterMaterial01,
rs.LectureAfterMaterial02 as LectureAfterMaterial02,
rs.LectureAfterAnimation as LectureAfterAnimation,
rs.LBMSumary01 as LBMSumary01,
rs.LBMSumary02 as LBMSumary02,
rs.LBASumary as LBASumary,
rs.LAMSumary01 as LAMSumary01,
rs.LAMSumary02 as LAMSumary02,
rs.LAASumary as LAASumary,
rs.Map as Map,
rs.ConceptPicture as ConceptPicture ,
rs.AttendantPicture as AttendantPicture ,
rs.HallAccess as HallAccess,
rs.DelFlag as DelFlag,
CASE
WHEN rs.ParticipationCost2 IS NULL
THEN
CASE
WHEN rs.ParticipationCost1 <> 0 AND rs.SMPaidTypeOpt <> '0'
THEN rs.SMPaidTypeValue
WHEN rs.ParticipationCost1 <> 0 AND rs.SMPaidTypeOpt = '0'
THEN
(SELECT
sc.PaidType
FROM
seminarcompany sc
WHERE
sc.SeminarCompanyID = '102270000')
else ''
END
ELSE
CASE
WHEN rs.ParticipationCost2 <> 0 AND rs.SMPaidTypeOpt <> '0'
THEN rs.SMPaidTypeValue
WHEN rs.ParticipationCost2 <> 0 AND rs.SMPaidTypeOpt = '0'
THEN
(SELECT
sc.PaidType
FROM
seminarcompany sc
WHERE
sc.SeminarCompanyID = '102270000')
else ''
END
END as SMPaidTypeValue,
ParticipationCost1,
ParticipationCost2,
rs.SMPaidTypeOpt,
(SELECT
ClickLimitOverFlag
FROM
seminarcompany
WHERE
SeminarCompanyID = '102270000'
) as ClickLimitOverFlag,
coalesce(rs.SmTokutenSemiPointValue , '') as SmTokutenSemiPointValue,
coalesce(rs.SmTokutenSemiCardValue , '') as SmTokutenSemiCardValue,
rs.TargetValue,
(SELECT
s.ApplicationReceptionStartFlag
FROM
seminar as s
WHERE
s.SeminarCompanyID = '102270000' and
s.SeminarID = '000011586'
) as ApplicationReceptionStartFlag,
rs.DeliveruFlg, rs.DeliveruUrl,rs.FrontIndexFlg
FROM
recognitionseminar rs INNER JOIN
seminarcompany sc ON rs.SeminarCompanyID = sc.SeminarCompanyID
WHERE
rs.SeminarCompanyID = '102270000' AND
rs.SeminarID = '000011586' ] time:[0.0050039291381836]
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/module/connect/databese.php
[line:protected] => 106
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/module/procedure/BC_SU050002_01.php
[line] => 244
[function] => query
[args] => Array
(
[0] =>
SELECT
rs.SeminarCompanyID as SeminarCompanyID,
rs.SeminarID as SeminarID,
concat(
SUBSTR( rs.ApplicationReceptionStartDate , 1 , 4 ) ,
'/',
SUBSTR( rs.ApplicationReceptionStartDate , 5 , 2 ) ,
'/',
SUBSTR( rs.ApplicationReceptionStartDate , 7 , 2 )
) as ApplicationReceptionStartDate,
concat(
SUBSTR( rs.ApplicationReceptionEndDate , 1 , 4 ) ,
'/',
SUBSTR( rs.ApplicationReceptionEndDate , 5 , 2 ) ,
'/',
SUBSTR( rs.ApplicationReceptionEndDate , 7 , 2 )
) as ApplicationReceptionEndDate,
rs.ApplicationReceptionStartDate as ApplicationReceptionStartDate2,
rs.ApplicationReceptionEndDate as ApplicationReceptionEndDate2,
(select
COUNT(Date)
FROM
recognitionseminarsch
WHERE
(SeminarCompanyID = '102270000') AND
(SeminarID = '000011586')
group by
SeminarCompanyID,SeminarID
) as SemiDate,
rs.PrintStateID as PrintStateID,
rs.SeminarName as SeminarName,
rs.SubTitle as SubTitle,
rs.SeminarOutline as SeminarOutline,
rs.SeminarDetails as SeminarDetails,
rs.Information as Information,
rs.AttendantComment as AttendantComment,
rs.Purpose as Purpose,
rs.TakingLecObject as TakingLecObject,
rs.SpecialFavor as SpecialFavor,
rs.HostCompanyName as HostCompanyName,
rs.ParticipationCost1 as ParticipationCost1,
rs.ParticipationCost2 as ParticipationCost2,
rs.QuotaNum as QuotaNum,
rs.ReceiveNum as ReceiveNum,
rs.ConditionQualifying as ConditionQualifying,
rs.Property as Property,
rs.ParticipationForm1 as ParticipationForm1,
rs.ParticipationForm2 as ParticipationForm2,
rs.LocalID as LocalID,
(SELECT
lc.LocalName
FROM
local lc
WHERE
lc.DelFlag = '0' AND
lc.LocalID = rs.LocalID) as LocalName,
rs.CategoryID as CategoryID,
(SELECT
cg.CategoryName
FROM
category cg
WHERE
cg.DelFlag = '0' AND
cg.CategoryID = rs.CategoryID
) as CategoryName,
rs.SubCategoryID as SubCategoryID,
(SELECT
scg.SubCategoryName
FROM
subcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubCategoryID = rs.SubCategoryID AND
scg.CategoryID = rs.CategoryID
) as SubCategoryName,
rs.SubSubCategoryID as SubSubCategoryID,
(SELECT
scg.SubSubCategoryName
FROM
subsubcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubCategoryID = rs.SubCategoryID AND
scg.CategoryID = rs.CategoryID AND
scg.SubSubCategoryID = rs.SubSubCategoryID
) as SubSubCategoryName,
rs.HallName as HallName,
rs.HallPostal1 as HallPostal1,
rs.HallPostal2 as HallPostal2,
rs.HallAdministrativeDivisionsID as HallAdministrativeDivisionsID,
(SELECT
ad.AdministrativeDivisionsName
FROM
administrativedivisions ad
WHERE
ad.DelFlag = '0' AND
ad.LocalID = rs.LocalID AND
ad.AdministrativeDivisionsID = rs.HallAdministrativeDivisionsID
) as AdministrativeDivisionsName,
rs.HallAddress as HallAddress,
rs.HallBuildingNameEtc as HallBuildingNameEtc,
rs.Icon01Flag as Icon01Flag,
rs.Icon02Flag as Icon02Flag,
rs.Icon03Flag as Icon03Flag,
rs.Icon04Flag as Icon04Flag,
rs.Icon05Flag as Icon05Flag,
case
when sc.MemberTypeID IN ('01','06','16','26')
then rs.Icon06Flag
else '0'
end as Icon06Flag,
rs.Icon07Flag as Icon07Flag,
rs.Icon08Flag as Icon08Flag,
rs.Icon09Flag as Icon09Flag,
rs.Icon10Flag as Icon10Flag,
case
when sc.MemberTypeID IN ('01','06','16','26')
then rs.LectureBeforeMaterial01
else ''
end as LectureBeforeMaterial01,
case
when sc.MemberTypeID IN ('01','06','16','26')
then rs.LectureBeforeMaterial02
else ''
end as LectureBeforeMaterial02,
rs.LectureBeforeAnimation as LectureBeforeAnimation,
rs.LectureAfterMaterial01 as LectureAfterMaterial01,
rs.LectureAfterMaterial02 as LectureAfterMaterial02,
rs.LectureAfterAnimation as LectureAfterAnimation,
rs.LBMSumary01 as LBMSumary01,
rs.LBMSumary02 as LBMSumary02,
rs.LBASumary as LBASumary,
rs.LAMSumary01 as LAMSumary01,
rs.LAMSumary02 as LAMSumary02,
rs.LAASumary as LAASumary,
rs.Map as Map,
rs.ConceptPicture as ConceptPicture ,
rs.AttendantPicture as AttendantPicture ,
rs.HallAccess as HallAccess,
rs.DelFlag as DelFlag,
CASE
WHEN rs.ParticipationCost2 IS NULL
THEN
CASE
WHEN rs.ParticipationCost1 <> 0 AND rs.SMPaidTypeOpt <> '0'
THEN rs.SMPaidTypeValue
WHEN rs.ParticipationCost1 <> 0 AND rs.SMPaidTypeOpt = '0'
THEN
(SELECT
sc.PaidType
FROM
seminarcompany sc
WHERE
sc.SeminarCompanyID = '102270000')
else ''
END
ELSE
CASE
WHEN rs.ParticipationCost2 <> 0 AND rs.SMPaidTypeOpt <> '0'
THEN rs.SMPaidTypeValue
WHEN rs.ParticipationCost2 <> 0 AND rs.SMPaidTypeOpt = '0'
THEN
(SELECT
sc.PaidType
FROM
seminarcompany sc
WHERE
sc.SeminarCompanyID = '102270000')
else ''
END
END as SMPaidTypeValue,
ParticipationCost1,
ParticipationCost2,
rs.SMPaidTypeOpt,
(SELECT
ClickLimitOverFlag
FROM
seminarcompany
WHERE
SeminarCompanyID = '102270000'
) as ClickLimitOverFlag,
coalesce(rs.SmTokutenSemiPointValue , '') as SmTokutenSemiPointValue,
coalesce(rs.SmTokutenSemiCardValue , '') as SmTokutenSemiCardValue,
rs.TargetValue,
(SELECT
s.ApplicationReceptionStartFlag
FROM
seminar as s
WHERE
s.SeminarCompanyID = '102270000' and
s.SeminarID = '000011586'
) as ApplicationReceptionStartFlag,
rs.DeliveruFlg, rs.DeliveruUrl,rs.FrontIndexFlg
FROM
recognitionseminar rs INNER JOIN
seminarcompany sc ON rs.SeminarCompanyID = sc.SeminarCompanyID
WHERE
rs.SeminarCompanyID = '102270000' AND
rs.SeminarID = '000011586'
)
)
[1] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/controllers/FrontDetailController.php
[line] => 418
[function] => BC_SU050002_01
[args] => Array
(
[0] => 102270000
[1] => 000011586
)
)
[2] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/controllers/FrontOther/question.php
[line] => 17
[function] => getSeminar
[class] => FrontDetailController
[type] => ->
[args] => Array
(
[0] => 102270000
[1] => 000011586
[2] => 0
)
)
[3] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/controllers/FrontOtherController.php
[line] => 193
[args] => Array
(
[0] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/controllers/FrontOther/question.php
)
[function] => include
)
[4] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/core/dispatch.php
[line] => 48
[function] => question
[class] => FrontOtherController
[type] => ->
[args] => Array
(
)
)
[5] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/index.php
[line] => 14
[function] => dispatch
[class] => CDispatch
[type] => ->
[args] => Array
(
)
)
[6] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/index.php
[line] => 4
[args] => Array
(
[0] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/index.php
)
[function] => include
)
)
[previous:Exception:private] =>
)
