Error message from: [www.jokesmitacademie.nl] at [28/11/2023 23:28:52]<br>While processing: [/aanmelden]<br>Reported message: <br>----<br>resultFor: executing query failed.Query:[
			SELECT
				question.*,obj.id as obj_id
			FROM
				question INNER JOIN obj ON question.id=obj.source_id
			WHERE
				obj.obj_type_id=17 AND form_id=91940251
			ORDER BY
				question.'rank'
			].mysql responded with:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''rank'' at line 8<br>----<br>Type: [sql statement failure]<br>------------------------------<br>trace starts here:<br /><pre>#0  reportError(resultFor: executing query failed.Query:[
			SELECT
				question.*,obj.id as obj_id
			FROM
				question INNER JOIN obj ON question.id=obj.source_id
			WHERE
				obj.obj_type_id=17 AND form_id=91940251
			ORDER BY
				question.'rank'
			].mysql responded with:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''rank'' at line 8, sql statement failure, 1) called at [/var/www/www.jokesmitacademie.nl/website/code/core/DbConnect_mysql.php:101]
#1  DbConnectDb->resultFor(
			SELECT
				question.*,obj.id as obj_id
			FROM
				question INNER JOIN obj ON question.id=obj.source_id
			WHERE
				obj.obj_type_id=17 AND form_id=91940251
			ORDER BY
				question.rank
			) called at [/var/www/www.jokesmitacademie.nl/website/code/core/ObjForm.php:617]
#2  Form->bPopulateForm() called at [/var/www/www.jokesmitacademie.nl/website/code/core/strmetaparse.php:261]
#3  strMetaParse(
	
		<h3>Aanmelden</h3>		
		<h3>(<span style="text-decoration: underline;">Let op</span>! dit is n&iacute;et voor diploma&#039;s en deelcertificaten VWO, Havo, VMBO-TL, <br /></h3>
<p>ga daarvoor naar het Joke Smit College (Volwassenenonderwijs); klik daarvoor <a href="http://www.jokesmitcollege.nl/" target="_self">hier</a>)</p>
<p>&nbsp;</p>
<p>[form:91940251]</p>
<p>&nbsp;</p>	
	



) called at [/var/www/www.jokesmitacademie.nl/website/code/core/_data.php:587]
#4  strParseTemplate(view_pages, 1) called at [/var/www/www.jokesmitacademie.nl/website/code/core/Entity.php:523]
#5  Entity->viewRecord(view, -1) called at [/var/www/www.jokesmitacademie.nl/website/code/core/_data.php:147]
#6  displayData(428232224, view, -1) called at [/var/www/www.jokesmitacademie.nl/website/code/core/parser_plugs/cms_parser_commands.php:1266]
#7  strDoDisplayData({display_data obj_id="{get obj_id}"})
#8  call_user_func(strDoDisplayData, {display_data obj_id="{get obj_id}"}) called at [/var/www/www.jokesmitacademie.nl/website/code/core/strparse.php:58]
#9  Plugins->fireParserCommand(display_data, {display_data obj_id="{get obj_id}"}) called at [/var/www/www.jokesmitacademie.nl/website/code/core/strparse.php:927]
#10 strParse(
	{display_data obj_id="{get obj_id}"}
) called at [/var/www/www.jokesmitacademie.nl/website/code/core/strparse.php:2946]
#11 strDoIf({if "{request action}"="[element not found]"}, 
	{display_data obj_id="{get obj_id}"}
, , ) called at [/var/www/www.jokesmitacademie.nl/website/code/core/strparse.php:321]
#12 strParse({if "{requestxss zoekwoord}"<>"[element not found]"}
	{set var={zoekwoord} val={{requestxss zoekwoord}}}    
{else}
	{set var={zoekwoord} val={}}
{endif}

<!-- get content -->
{parse {get command_from_main}}

{if "{request action}"="[element not found]"}
	{display_data obj_id="{get obj_id}"}
{endif}) called at [/var/www/www.jokesmitacademie.nl/website/code/core/_data.php:583]
#13 strParseTemplate(get_content) called at [/var/www/www.jokesmitacademie.nl/website/code/core/parser_plugs/cms_parser_commands.php:1247]
#14 strDoDisplayTemplate({display_template get_content})
#15 call_user_func(strDoDisplayTemplate, {display_template get_content}) called at [/var/www/www.jokesmitacademie.nl/website/code/core/strparse.php:58]
#16 Plugins->fireParserCommand(display_template, {display_template get_content}) called at [/var/www/www.jokesmitacademie.nl/website/code/core/strparse.php:927]
#17 strParse({display_template get_content}) called at [/var/www/www.jokesmitacademie.nl/website/code/core/strparse.php:1051]
#18 strGetTerm({set var={content} val={{display_template get_content}}}, val) called at [/var/www/www.jokesmitacademie.nl/website/code/core/strparse.php:1809]
#19 strDoSet({set var={content} val={{display_template get_content}}}) called at [/var/www/www.jokesmitacademie.nl/website/code/core/strparse.php:272]
#20 strParse(<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	{display_template default_settings}
</head>

{set var={content} val={{display_template get_content}}}
<body >	
<div id="outer">
	<div id="container" {if "{checkperm tname={objectinfobalk} type={edit}}"="true"}style="width:1188px;"{endif}>
		<div id="header" style="position: relative;height:100px;">
			{display_template kop}
			<!--
			<div id="top_search" class="top_bar" style="border-bottom: 0px; margin-bottom: 0px; padding-bottom: 0px;">
				<form name="frmSearch" method="post" action="search">
					<div style="position: absolute; left:0px; bottom: 0px; width: 79px; border-bottom: 0px; margin-bottom: 0px; padding-bottom: 0px;  "><input name="zoekwoord" id="id_zoekwoord_invoer" size="21" maxlength="50" type="text" style="height: 15px; font-size: 9px; font-weight: 60%; margin-bottom: 0px; padding-bottom: 0px; border-top: 0px; border-right: 2px solid #ff9900; border-bottom: 0px; border-left: 0px; "  /></div>
					<div id="id_searchbutton" style="text-align: center; background-color: #003469; color: white; position: absolute; bottom: 0px; right: 0px; width: 55px;"><a href="javascript:document.frmSearch.submit();">Search</a></div>
				</form>
				</div>
			-->
		</div>

		<div id="inhoud_main">						
			<div id="block_left">
				<div id="container-left">
					<ul id="sidebar1">
					<li>
						<p class="hoofdmenu">
							<a class="menu" target="_self" href="../main.php" >start</a>
						</p>					
					</li>
					<br/>
					{set var={sidebar1_itemcloser} val={}}
					{foreach type={menu} level={0} source={menu0}}
						{get sidebar1_itemcloser}
						{displaymenuitem ignore_not_published={true} source={menu0} template={
						<li>
							<p class="hoofdmenu">
								<a class="menu" target="[target]" href="[final_url]" >[naam]</a>
							</p>
						}}
						{set var={sidebar1_itemcloser} val={</li>}}
						<ul class="sidebar2"> 
						{set var={sidebar2_itemcloser} val={}}
						{foreach type={menu} parent_id={{field name={id} source={menu0}}} source={menu1}}
							{displaymenuitem ignore_not_published={true} source={menu1} template={
							{get sidebar2_itemcloser}
							<li>
								<p class="submenu">
									<a class="menu" target="[target]" href="[final_url]">[naam]</a>
								</p>
							}}
						{set var={sidebar2_itemcloser} val={</li>}}
						{next}						
							{get sidebar2_itemcloser}
						</ul>
					{next}
					{get sidebar1_itemcloser}
					</ul>
					<br/>
					<ul id="sidebar1">
					{if "{checkperm tname={cursusoverzicht} type={read}}"="true"}
						<li>
							<p class="hoofdmenu">
								<a class="menu" target="_self" href="../archief" >Archief</a>
							</p>					
						</li>
						<li>
							<p class="hoofdmenu">
								<a class="menu" target="_self" href="../main.php?action=log_off" >Uitloggen</a>
							</p>					
						</li>
					{else}
						<li>
							<p class="hoofdmenu">
								<a class="menu" target="_self" href="../inloggen" >Archief</a>
							</p>					
						</li>
					{endif}
					{if "{checkperm tname={login} type={edit}}"="true"}
						<li>
							<p class="hoofdmenu">
								<a class="menu" target="_self" href="../cursisten_beheer" >Cursisten beheer</a>
							</p>					
						</li>
					{endif}
					</ul>
					<br/>
					<ul id="sidebar1">
						<li>
							<p class="hoofdmenu">
								<a class="menu" target="_self" href="../aanmelden" >Aanmelden</a>
							</p>					
						</li>
					</ul>	
				</div> 		
			</div>

			<div id="middendeel">
				<div id="inhoud">
					{get content}
					<div id="block_right" style="float:right;">
						<div id="sidekick_column_1" class="sidekick_column">
							{foreach ifempty={&nbsp;} sql={
								select 
									div_element.type_id, div_element.id 
								from 
									obj_div_element 
										inner join div_element on obj_div_element.div_element_id=div_element.id
								where
									obj_div_element.col=1 and 
									div_element.type_id<>1024 and
									obj_id={get obj_id}
								order by
									rank
								} source={div_element}}
									<div class="sidekick">{renderdiv_element encompassing_div={false} type_id={{field name={type_id} source={div_element}}} id={{field name={id} source={div_element}}} }</div>
							{next}
						</div>		
					</div>		
				</div>
			</div>

				
		</div>

		{if "{checkperm tname={objectinfobalk} type={edit}}"="true"}
			{display_template xppane}
		{endif}
	</div>
</div>

<div id="navSmall"></div>	
<div class="textonly"></div>
<div id="move_obj"></div>
<div id="auto_save"></div>

<div id="een_moment_aub">Een ogenblik geduld... de informatie wordt binnengehaald.</div>

	
</body>
</html>
) called at [/var/www/www.jokesmitacademie.nl/website/code/core/_data.php:583]
#21 strParseTemplate(main) called at [/var/www/www.jokesmitacademie.nl/website/code/core/_data.php:598]
#22 displayTemplate(main) called at [/var/www/www.jokesmitacademie.nl/website/code/core/ObjIPPController.php:87]
#23 IPPController->strRunAction() called at [/var/www/www.jokesmitacademie.nl/website/pub/website/main.php:584]
</pre><div style="float:left;height:300px">		  
	<img src="images/default/icons/warning.gif" />
</div>
	[trans_to_uk_ipp_cannot open page]