Error message from: [www.jokesmitacademie.nl] at [28/11/2023 23:28:52]
While processing: [/aanmelden]
Reported message:
----
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
----
Type: [sql statement failure]
------------------------------
trace starts here:
#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(
	
		

Aanmelden

(Let op! dit is níet voor diploma's en deelcertificaten VWO, Havo, VMBO-TL,

ga daarvoor naar het Joke Smit College (Volwassenenonderwijs); klik daarvoor hier)

 

[form:91940251]

 

) 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} {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( {display_template default_settings} {set var={content} val={{display_template get_content}}}
  • start


  • {set var={sidebar1_itemcloser} val={}} {foreach type={menu} level={0} source={menu0}} {get sidebar1_itemcloser} {displaymenuitem ignore_not_published={true} source={menu0} template={
  • [naam]

    }} {set var={sidebar1_itemcloser} val={
  • }}
      {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}
    • }} {set var={sidebar2_itemcloser} val={
    • }} {next} {get sidebar2_itemcloser}
    {next} {get sidebar1_itemcloser}


{get content}
{foreach ifempty={ } 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}}
{renderdiv_element encompassing_div={false} type_id={{field name={type_id} source={div_element}}} id={{field name={id} source={div_element}}} }
{next}
{if "{checkperm tname={objectinfobalk} type={edit}}"="true"} {display_template xppane} {endif}
Een ogenblik geduld... de informatie wordt binnengehaald.
) 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]
[trans_to_uk_ipp_cannot open page]