Error message from: [www.spinozahuis.nl] at [22/08/2014 21:37:28]
While processing: [/]
Reported message:
----
resultFor: executing query failed.Query:[ SELECT COUNT(*) AS aantal FROM calendar_item LEFT JOIN ( SELECT obj.* FROM obj INNER JOIN obj_type ON obj.obj_type_id = obj_type.id WHERE obj_type.name = 'calendar_item' ) calendar_item_supertype ON calendar_item.id = calendar_item_supertype.source_id WHERE 1=1 AND calendar_id = 193544216 AND calendar_item.from_date >= '2014-08-22' AND calendar_item.op_startpagina = 1 ].mysql responded with:Got error 28 from storage engine
----
Type: [sql statement failure]
------------------------------
trace starts here:
#0  reportError(resultFor: executing query failed.Query:[
				SELECT COUNT(*) AS aantal
				
				FROM calendar_item
				LEFT JOIN
				(
						SELECT obj.*
						FROM obj
						INNER JOIN obj_type
						ON obj.obj_type_id = obj_type.id
						WHERE obj_type.name = 'calendar_item'
				) calendar_item_supertype
				ON calendar_item.id = calendar_item_supertype.source_id
				WHERE 1=1
				AND calendar_id = 193544216
				AND calendar_item.from_date >= '2014-08-22'  
				AND calendar_item.op_startpagina = 1
	
	].mysql responded with:Got error 28 from storage engine, sql statement failure, 1) called at [/usr/local/www/spinozahuis/website/code/core/DbConnect_mysql.php:101]
#1  DbConnectDb->resultFor(
				SELECT COUNT(*) AS aantal
				
				FROM calendar_item
				LEFT JOIN
				(
						SELECT obj.*
						FROM obj
						INNER JOIN obj_type
						ON obj.obj_type_id = obj_type.id
						WHERE obj_type.name = 'calendar_item'
				) calendar_item_supertype
				ON calendar_item.id = calendar_item_supertype.source_id
				WHERE 1=1
				AND calendar_id = 193544216
				AND calendar_item.from_date >= '2014-08-22'  
				AND calendar_item.op_startpagina = 1
	
	) called at [/usr/local/www/spinozahuis/website/code/client/spinozahuis/inc_spinozahuis.php:138]
#2  valSelectData(aantal, 
				SELECT COUNT(*) AS aantal
				
				FROM calendar_item
				LEFT JOIN
				(
						SELECT obj.*
						FROM obj
						INNER JOIN obj_type
						ON obj.obj_type_id = obj_type.id
						WHERE obj_type.name = 'calendar_item'
				) calendar_item_supertype
				ON calendar_item.id = calendar_item_supertype.source_id
				WHERE 1=1
				AND calendar_id = 193544216
				AND calendar_item.from_date >= '2014-08-22'  
				AND calendar_item.op_startpagina = 1
	
	) called at [/usr/local/www/spinozahuis/website/code/client/spinozahuis/inc_spinozahuis.php:117]
#3  strDoSelectData({select_data fieldname={aantal} ifempty={-1} sql={{get strAgendaCount}}})
#4  call_user_func(strDoSelectData, {select_data fieldname={aantal} ifempty={-1} sql={{get strAgendaCount}}}) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:58]
#5  Plugins->fireParserCommand(select_data, {select_data fieldname={aantal} ifempty={-1} sql={{get strAgendaCount}}}) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:927]
#6  strParse("{select_data fieldname={aantal} ifempty={-1} sql={{get strAgendaCount}}}"="0") called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:1021]
#7  strGetTerm({if "{select_data fieldname={aantal} ifempty={-1} sql={{get strAgendaCount}}}"="0"}, ) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:2890]
#8  strDoIf({if "{select_data fieldname={aantal} ifempty={-1} sql={{get strAgendaCount}}}"="0"}, 
			{inline_help niets_gevonden}
			
{else} {foreach sql={{get strAgendaSQL}} source={agenda}} {set var={link} val={}} {if "{field name={hyperlink} source={agenda}}"<>""} {set var={link} val={{field name={hyperlink} source={agenda}}}} {field name={name} source={agenda}}
{else} {field name={name} source={agenda}}
{endif} {convertdate date={{field name={from_date} source={agenda}}} from={db} to={nl_extended} abbreviator={ } separator={-}} {if "{get strAgendaBlokjeEersteItemDatum}"=""} {set var={strAgendaBlokjeEersteItemDatum} val={{field name={from_date} source={agenda}}}} {endif} {if "{field name={from_time} source={agenda}}"<>""} {field name={from_time} source={agenda}} {inline_help uur} {endif}
{if "{field name={location} source={agenda}}"<>""} {field name={location} source={agenda}}
{endif}
{next} , {inline_help niets_gevonden}
, {foreach sql={{get strAgendaSQL}} source={agenda}} {set var={link} val={}} {if "{field name={hyperlink} source={agenda}}"<>""} {set var={link} val={{field name={hyperlink} source={agenda}}}} {field name={name} source={agenda}}
{else} {field name={name} source={agenda}}
{endif} {convertdate date={{field name={from_date} source={agenda}}} from={db} to={nl_extended} abbreviator={ } separator={-}} {if "{get strAgendaBlokjeEersteItemDatum}"=""} {set var={strAgendaBlokjeEersteItemDatum} val={{field name={from_date} source={agenda}}}} {endif} {if "{field name={from_time} source={agenda}}"<>""} {field name={from_time} source={agenda}} {inline_help uur} {endif}
{if "{field name={location} source={agenda}}"<>""} {field name={location} source={agenda}}
{endif}
{next} ) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:321] #9 strParse(
{debugcomment comment={div_element_height={get div_element_height}.} begintag={
} endtag={
} maxsilent={2} debugcontext={login}}

{select_data fieldname={id_name} ifempty={Agenda} sql={SELECT id_name FROM div_element INNER JOIN obj ON div_element.id = obj.source_id INNER JOIN obj_type ON obj.obj_type_id = obj_type.id WHERE obj_type.name = 'div_element' AND obj.id={get div_element_obj_id}}}

{comment} {endcomment} {set var={booEindigenBijEindeMaand} val={1}} {display_template agendaopsomming_init} {debugcomment Agenda-count-SQL:"{get strAgendaCount}".} {debugcomment Deze div_element_agenda voor calendar_id nr.:"{get calendar_id}" betreft de agenda:"{select_data fieldname={name} ifempty={?} sql={SELECT name FROM calendar WHERE id ={get calendar_id}}}".} {debugcomment vanaf-datum:{convertdate date={{get twodigitday}-{get twodigitmonth}-{get fourdigityear}} from={nl} to={nl_extended_with_nonpadded_day}}} {set var={strAgendaBlokjeEersteItemDatum} val={}}
{debugcomment comment={{get strAgendaSQL}} begintag={

} endtag={

} context={login}} {if "{select_data fieldname={aantal} ifempty={-1} sql={{get strAgendaCount}}}"="0"} {inline_help niets_gevonden}
{else} {foreach sql={{get strAgendaSQL}} source={agenda}} {set var={link} val={}} {if "{field name={hyperlink} source={agenda}}"<>""} {set var={link} val={{field name={hyperlink} source={agenda}}}} {field name={name} source={agenda}}
{else} {field name={name} source={agenda}}
{endif} {convertdate date={{field name={from_date} source={agenda}}} from={db} to={nl_extended} abbreviator={ } separator={-}} {if "{get strAgendaBlokjeEersteItemDatum}"=""} {set var={strAgendaBlokjeEersteItemDatum} val={{field name={from_date} source={agenda}}}} {endif} {if "{field name={from_time} source={agenda}}"<>""} {field name={from_time} source={agenda}} {inline_help uur} {endif}
{if "{field name={location} source={agenda}}"<>""} {field name={location} source={agenda}}
{endif}
{next} {endif} {if "{get calendar_hyperlink}"="[element not found]"} {debugcomment hyperlink niet gevonden: calendar_hyperlink="{get calendar_hyperlink}".} {else} {if "{get calendar_hyperlink}"=""} {debugcomment hyperlink leeg: calendar_hyperlink="{get calendar_hyperlink}".} {else} {if "{get strAgendaBlokjeEersteItemDatum}"<>""} {set var={calendar_hyperlink} val={{get calendar_hyperlink}&year={convertdate date={{get strAgendaBlokjeEersteItemDatum}} from={db} to={year}}}} {set var={calendar_hyperlink} val={{get calendar_hyperlink}&month={convertdate date={{get strAgendaBlokjeEersteItemDatum}} from={db} to={month}}}} {endif} » {inline_help meer} {endif} {endif} {comment}
{endcomment}
) called at [/usr/local/www/spinozahuis/website/code/core/_data.php:583] #10 strParseTemplate(div_element_agenda) called at [/usr/local/www/spinozahuis/website/code/core/parser_plugs/cms_parser_commands.php:1242] #11 strDoDisplayTemplate({display_template div_element_agenda}) #12 call_user_func(strDoDisplayTemplate, {display_template div_element_agenda}) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:58] #13 Plugins->fireParserCommand(display_template, {display_template div_element_agenda}) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:927] #14 strParse({display_template div_element_agenda}) called at [/usr/local/www/spinozahuis/website/code/client/spinozahuis/inc_agenda_extras.php:102] #15 clsDivAgenda->strRender() called at [/usr/local/www/spinozahuis/website/code/core/ObjDiv.php:678] #16 ObjDiv->strRenderInMatrixEditorModeElement(normal) called at [/usr/local/www/spinozahuis/website/code/core/ObjDiv.php:546] #17 ObjDiv->strRenderInMatrixEditorMode(1, normal, false) called at [/usr/local/www/spinozahuis/website/code/core/ObjDiv.php:1524] #18 ObjDivMatrix->strRender(1) called at [/usr/local/www/spinozahuis/website/code/core/parser_plugs/cms_parser_commands.php:1414] #19 strDoDivElement({div_element mode={render} encompassing_div={true} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }) #20 call_user_func(strDoDivElement, {div_element mode={render} encompassing_div={true} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:58] #21 Plugins->fireParserCommand(div_element, {div_element mode={render} encompassing_div={true} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:927] #22 strParse({div_element mode={render} encompassing_div={true} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:2950] #23 strDoIf({if "{requestc in_paper_container}"="true"}, {div_element mode={render} encompassing_div={false} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }{else}{div_element mode={render} encompassing_div={true} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }, {div_element mode={render} encompassing_div={false} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }, {div_element mode={render} encompassing_div={true} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:321] #24 strParse( {if "{requestc in_paper_container}"="true"}{div_element mode={render} encompassing_div={false} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }{else}{div_element mode={render} encompassing_div={true} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }{endif} ) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:1893] #25 arrDoForEach({foreach sql={{get sql}} source={div_e}}, Array ([start_position] => 43,[end_position] => 381,[block] => {if "{requestc in_paper_container}"="true"}{div_element mode={render} encompassing_div={false} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }{else}{div_element mode={render} encompassing_div={true} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }{endif} ,[error] => )) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:360] #26 strParse( {foreach sql={{get sql}} source={div_e}} {if "{requestc in_paper_container}"="true"}{div_element mode={render} encompassing_div={false} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }{else}{div_element mode={render} encompassing_div={true} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }{endif} {next} ) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:2946] #27 strDoIf({if "{checkperm tname="div_element" type="read"}"="true"}, {foreach sql={{get sql}} source={div_e}} {if "{requestc in_paper_container}"="true"}{div_element mode={render} encompassing_div={false} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }{else}{div_element mode={render} encompassing_div={true} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }{endif} {next} , , ) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:321] #28 strParse({if "{checkperm tname="div_element" type="read"}"="true"} {foreach sql={{get sql}} source={div_e}} {if "{requestc in_paper_container}"="true"}{div_element mode={render} encompassing_div={false} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }{else}{div_element mode={render} encompassing_div={true} type_id={{field name={type_id} source={div_e}}} id={{field name={id} source={div_e}}} }{endif} {next} {endif} ) called at [/usr/local/www/spinozahuis/website/code/core/_data.php:583] #29 strParseTemplate(view_div_element, 1) called at [/usr/local/www/spinozahuis/website/code/core/Entity.php:565] #30 Entity->viewRecord(view, -1) called at [/usr/local/www/spinozahuis/website/code/core/_data.php:147] #31 displayData(165415537, view, -1) called at [/usr/local/www/spinozahuis/website/code/core/parser_plugs/cms_parser_commands.php:1261] #32 strDoDisplayData({display_data obj_id="{get obj_id}"}) #33 call_user_func(strDoDisplayData, {display_data obj_id="{get obj_id}"}) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:58] #34 Plugins->fireParserCommand(display_data, {display_data obj_id="{get obj_id}"}) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:927] #35 strParse( {display_data obj_id="{get obj_id}"} ) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:2946] #36 strDoIf({if "{request action}"="[element not found]"}, {display_data obj_id="{get obj_id}"} , , ) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:321] #37 strParse({if "{requestxss zoekwoord}"<>"[element not found]"} {set var={zoekwoord} val={{requestxss zoekwoord}}} {else} {set var={zoekwoord} val={}} {endif} {parse {get command_from_main}} {if "{request action}"="[element not found]"} {display_data obj_id="{get obj_id}"} {endif}) called at [/usr/local/www/spinozahuis/website/code/core/_data.php:583] #38 strParseTemplate(get_content) called at [/usr/local/www/spinozahuis/website/code/core/parser_plugs/cms_parser_commands.php:1242] #39 strDoDisplayTemplate({display_template get_content}) #40 call_user_func(strDoDisplayTemplate, {display_template get_content}) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:58] #41 Plugins->fireParserCommand(display_template, {display_template get_content}) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:927] #42 strParse({display_template get_content}) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:1051] #43 strGetTerm({set var={content} val={{display_template get_content}}}, val) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:1809] #44 strDoSet({set var={content} val={{display_template get_content}}}) called at [/usr/local/www/spinozahuis/website/code/core/strparse.php:272] #45 strParse( {display_template default_settings} {set var={content} val={{display_template get_content}}}
{display_template header}
{get content}
{display_template footer} {if "{checkperm tname={objectinfobalk} type={edit}}"="true"}
{display_template xppane}
{endif}
Een ogenblik geduld... de informatie wordt binnengehaald.
) called at [/usr/local/www/spinozahuis/website/code/core/_data.php:583] #46 strParseTemplate(startpagina) called at [/usr/local/www/spinozahuis/website/code/core/_data.php:598] #47 displayTemplate(startpagina) called at [/usr/local/www/spinozahuis/website/code/core/ObjIPPController.php:87] #48 IPPController->strRunAction() called at [/usr/local/www/spinozahuis/website/pub/website/main.php:581]
[trans_to_uk_ipp_cannot open page]