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}}}
{display_template kop}{if "{checkperm tname={objectinfobalk} type={edit}}"="true"} {display_template xppane} {endif}
{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}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]