Error message from: [en.monsantotribunal.org] at [28/03/2024 16:10:31]
While processing: [/registration-pa&mode=pa]
Reported message:
----
resultFor: executing query failed.Query:[SELECT product.id as id, product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 2 AND obj.published = 1 ORDER BY rank].mysql responded with:SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 10
----
Type: [sql statement failure]
------------------------------
trace starts here:
#0  reportError(resultFor: executing query failed.Query:[SELECT
		                product.id as id,
		                product.naam as naam,
		                product.prijs as prijs
		               FROM product
		               JOIN obj ON obj.source_id = product.id
		               WHERE
		                product_type_id = 2
		                AND obj.published = 1
		               ORDER BY rank].mysql responded with:SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 10, sql statement failure, 1) called at [/home/monsanto/www/website/code/core/DbConnect_pdo.php:222]
#1  DbConnectDb->rows(SELECT
		                product.id as id,
		                product.naam as naam,
		                product.prijs as prijs
		               FROM product
		               JOIN obj ON obj.source_id = product.id
		               WHERE
		                product_type_id = 2
		                AND obj.published = 1
		               ORDER BY rank) called at [/home/monsanto/www/website/code/core/strparse.php:1868]
#2  arrDoForEach({foreach sql={SELECT
		                product.id as id,
		                product.naam as naam,
		                product.prijs as prijs
		               FROM product
		               JOIN obj ON obj.source_id = product.id
		               WHERE
		                product_type_id = 2
		                AND obj.published = 1
		               ORDER BY rank} source={options}}, Array ([start_position] => 430,[end_position] => 849,[block] => 
		
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
,[error] => )) called at [/home/monsanto/www/website/code/core/strparse.php:280] #3 strParse(
{inline_help mt-registration-deelname-pa}
{foreach sql={SELECT product.id as id, product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 2 AND obj.published = 1 ORDER BY rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next}
{inline_help mt-registration-deelname-mt}
{inline_help mt-registration-i-do-not-participate}
 
{foreach keep_counter={true} sql={SELECT product.id as id,product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 4 AND obj.published = 1 ORDER BY rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next} ) called at [/home/monsanto/www/website/code/core/strparse.php:3018] #4 strDoIf({if "{get mode}"="pa"},
{inline_help mt-registration-deelname-pa}
{foreach sql={SELECT product.id as id, product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 2 AND obj.published = 1 ORDER BY rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next}
{inline_help mt-registration-deelname-mt}
{inline_help mt-registration-i-do-not-participate}
 
{foreach keep_counter={true} sql={SELECT product.id as id,product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 4 AND obj.published = 1 ORDER BY rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next} , , ) called at [/home/monsanto/www/website/code/core/strparse.php:241] #5 strParse(
{inline_help mt-registration-intro-{get mode}}

{inline_help mt-registration-next-step-button}

{inline_help mt-registration-products-{get mode}} {if "{get mode}"="mt"}
{inline_help mt-registration-deelname-mt}
{foreach keep_counter={true} sql={SELECT product.id as id, product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 1 AND obj.published = 1 order by rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next}
{inline_help mt-registration-deelname-pa}
{inline_help mt-registration-i-do-not-participate}
 
{foreach sql={SELECT product.id as id, product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 3 AND obj.published = 1 ORDER BY rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next} {endif} {if "{get mode}"="pa"}
{inline_help mt-registration-deelname-pa}
{foreach sql={SELECT product.id as id, product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 2 AND obj.published = 1 ORDER BY rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next}
{inline_help mt-registration-deelname-mt}
{inline_help mt-registration-i-do-not-participate}
 
{foreach keep_counter={true} sql={SELECT product.id as id,product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 4 AND obj.published = 1 ORDER BY rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next} {endif}
{inline_help mt-registration-korting}
{edit name="korting" type="text" default="" source="aanmelding"}

{inline_help mt-registration-previous-step-button} {inline_help mt-registration-next-step-button}

{inline_help mt-registration-naw}
{inline_help mt-registration-organisatie}
{inline_help mt-registration-voornaam}
{inline_help mt-registration-tussenvoegsel}
{inline_help mt-registration-achternaam}
{inline_help mt-registration-straat}
{inline_help mt-registration-huisnummer}
{inline_help mt-registration-postcode}
{inline_help mt-registration-woonplaats}
{inline_help mt-registration-country}
{edit name="country_id" type="pulldown_table" class="form-control" options={country|id|country_name} default="-1" source="aanmelding"}
{inline_help email}
{inline_help mt-registration-telefoonnummer}

{inline_help mt-registration-previous-step-button} {inline_help mt-registration-next-step-button}

{inline_help mt-registration-payment}

 {inline_help mt-registration-ideal}
 {inline_help mt-registration-paypal}
 {inline_help mt-registration-creditcard}
 {inline_help mt-registration-bank-transfer}

{inline_help mt-registration-previous-step-button} {edit default={{inline_help mt-registration-betalen}} type={submit} source={aanmelding} class={btn btn-sm btn-primary pull-right}}

) called at [/home/monsanto/www/website/code/core/parser_plugs/cms_parser_commands.php:301] #6 strDoEditForm({editform sql={select * from aanmelding where id = -1} source={aanmelding}}, Array ([start_position] => 255,[end_position] => 11047,[block] =>
{inline_help mt-registration-intro-{get mode}}

{inline_help mt-registration-next-step-button}

{inline_help mt-registration-products-{get mode}} {if "{get mode}"="mt"}
{inline_help mt-registration-deelname-mt}
{foreach keep_counter={true} sql={SELECT product.id as id, product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 1 AND obj.published = 1 order by rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next}
{inline_help mt-registration-deelname-pa}
{inline_help mt-registration-i-do-not-participate}
 
{foreach sql={SELECT product.id as id, product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 3 AND obj.published = 1 ORDER BY rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next} {endif} {if "{get mode}"="pa"}
{inline_help mt-registration-deelname-pa}
{foreach sql={SELECT product.id as id, product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 2 AND obj.published = 1 ORDER BY rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next}
{inline_help mt-registration-deelname-mt}
{inline_help mt-registration-i-do-not-participate}
 
{foreach keep_counter={true} sql={SELECT product.id as id,product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 4 AND obj.published = 1 ORDER BY rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next} {endif}
{inline_help mt-registration-korting}
{edit name="korting" type="text" default="" source="aanmelding"}

{inline_help mt-registration-previous-step-button} {inline_help mt-registration-next-step-button}

{inline_help mt-registration-naw}
{inline_help mt-registration-organisatie}
{inline_help mt-registration-voornaam}
{inline_help mt-registration-tussenvoegsel}
{inline_help mt-registration-achternaam}
{inline_help mt-registration-straat}
{inline_help mt-registration-huisnummer}
{inline_help mt-registration-postcode}
{inline_help mt-registration-woonplaats}
{inline_help mt-registration-country}
{edit name="country_id" type="pulldown_table" class="form-control" options={country|id|country_name} default="-1" source="aanmelding"}
{inline_help email}
{inline_help mt-registration-telefoonnummer}

{inline_help mt-registration-previous-step-button} {inline_help mt-registration-next-step-button}

{inline_help mt-registration-payment}

 {inline_help mt-registration-ideal}
 {inline_help mt-registration-paypal}
 {inline_help mt-registration-creditcard}
 {inline_help mt-registration-bank-transfer}

{inline_help mt-registration-previous-step-button} {edit default={{inline_help mt-registration-betalen}} type={submit} source={aanmelding} class={btn btn-sm btn-primary pull-right}}

,[error] => )) called at [/home/monsanto/www/website/code/core/strparse.php:146] #7 strParse({set var={mode} val={mt}} {if "{requestxss mode}"<>"[element not found]"} {set var={mode} val={{requestxss mode}}} {endif} {check_maintenance_aanmelding}
{editform sql={select * from aanmelding where id = -1} source={aanmelding}}
{inline_help mt-registration-intro-{get mode}}

{inline_help mt-registration-next-step-button}

{inline_help mt-registration-products-{get mode}} {if "{get mode}"="mt"}
{inline_help mt-registration-deelname-mt}
{foreach keep_counter={true} sql={SELECT product.id as id, product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 1 AND obj.published = 1 order by rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next}
{inline_help mt-registration-deelname-pa}
{inline_help mt-registration-i-do-not-participate}
 
{foreach sql={SELECT product.id as id, product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 3 AND obj.published = 1 ORDER BY rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next} {endif} {if "{get mode}"="pa"}
{inline_help mt-registration-deelname-pa}
{foreach sql={SELECT product.id as id, product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 2 AND obj.published = 1 ORDER BY rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next}
{inline_help mt-registration-deelname-mt}
{inline_help mt-registration-i-do-not-participate}
 
{foreach keep_counter={true} sql={SELECT product.id as id,product.naam as naam, product.prijs as prijs FROM product JOIN obj ON obj.source_id = product.id WHERE product_type_id = 4 AND obj.published = 1 ORDER BY rank} source={options}}
{inline_help mt-registration-{field name={naam} source={options}}}
€ {field name={prijs} source={options}}
{next} {endif}
{inline_help mt-registration-korting}
{edit name="korting" type="text" default="" source="aanmelding"}

{inline_help mt-registration-previous-step-button} {inline_help mt-registration-next-step-button}

{inline_help mt-registration-naw}
{inline_help mt-registration-organisatie}
{inline_help mt-registration-voornaam}
{inline_help mt-registration-tussenvoegsel}
{inline_help mt-registration-achternaam}
{inline_help mt-registration-straat}
{inline_help mt-registration-huisnummer}
{inline_help mt-registration-postcode}
{inline_help mt-registration-woonplaats}
{inline_help mt-registration-country}
{edit name="country_id" type="pulldown_table" class="form-control" options={country|id|country_name} default="-1" source="aanmelding"}
{inline_help email}
{inline_help mt-registration-telefoonnummer}

{inline_help mt-registration-previous-step-button} {inline_help mt-registration-next-step-button}

{inline_help mt-registration-payment}

 {inline_help mt-registration-ideal}
 {inline_help mt-registration-paypal}
 {inline_help mt-registration-creditcard}
 {inline_help mt-registration-bank-transfer}

{inline_help mt-registration-previous-step-button} {edit default={{inline_help mt-registration-betalen}} type={submit} source={aanmelding} class={btn btn-sm btn-primary pull-right}}

{endeditform}
) called at [/home/monsanto/www/website/code/core/_data.php:660] #8 strParseTemplate(aanmelding) called at [/home/monsanto/www/website/code/core/parser_plugs/cms_parser_commands.php:1623] #9 strDoDisplayTemplate({display_template aanmelding}) called at [/home/monsanto/www/website/code/core/Plugins.php:70] #10 Plugins->fireParserCommand(display_template, {display_template aanmelding}) called at [/home/monsanto/www/website/code/core/strparse.php:894] #11 strParse({display_template aanmelding}) called at [/home/monsanto/www/website/code/core/ObjDiv.php:1315] #12 ObjDivTemplate->strRender() called at [/home/monsanto/www/website/code/core/ObjDiv.php:250] #13 ObjDivLijst->sRender(
[content]
) called at [/home/monsanto/www/website/code/core/parser_plugs/cms_parser_commands.php:1816] #14 strDoRenderDivElementCol({div_element_col obj_id={{get obj_id}} col={1} template={
[content]
}}) called at [/home/monsanto/www/website/code/core/Plugins.php:70] #15 Plugins->fireParserCommand(div_element_col, {div_element_col obj_id={{get obj_id}} col={1} template={
[content]
}}) called at [/home/monsanto/www/website/code/core/strparse.php:894] #16 strParse(
{div_element_col obj_id={{get obj_id}} col={1} template={
[content]
}}
) called at [/home/monsanto/www/website/code/core/_data.php:660] #17 strParseTemplate(widgets) called at [/home/monsanto/www/website/code/core/parser_plugs/cms_parser_commands.php:1623] #18 strDoDisplayTemplate({display_template widgets}) called at [/home/monsanto/www/website/code/core/Plugins.php:70] #19 Plugins->fireParserCommand(display_template, {display_template widgets}) called at [/home/monsanto/www/website/code/core/strparse.php:894] #20 strParse( {display_template default_settings} {set var={content} val={{display_template get_content}}} {display_template admin_menu} {if "{checkperm tname={div_element} type={edit}}"="true"} {set var={editDivElement_allowed} val={true}} {endif}
{display_template header} {display_template menu}
{get content} {display_template widgets}
{display_template widgets-rechterkant}
{display_template footer}
) called at [/home/monsanto/www/website/code/core/strparse.php:3022] #21 strDoIf({if "{requestxss content_only}"="true"}, {set var={content} val={{display_template get_content}}}{get content}{else} {display_template default_settings} {set var={content} val={{display_template get_content}}} {display_template admin_menu} {if "{checkperm tname={div_element} type={edit}}"="true"} {set var={editDivElement_allowed} val={true}} {endif}
{display_template header} {display_template menu}
{get content} {display_template widgets}
{display_template widgets-rechterkant}
{display_template footer}
, {set var={content} val={{display_template get_content}}}{get content}, {display_template default_settings} {set var={content} val={{display_template get_content}}} {display_template admin_menu} {if "{checkperm tname={div_element} type={edit}}"="true"} {set var={editDivElement_allowed} val={true}} {endif}
{display_template header} {display_template menu}
{get content} {display_template widgets}
{display_template widgets-rechterkant}
{display_template footer}
) called at [/home/monsanto/www/website/code/core/strparse.php:241] #22 strParse({if "{requestxss content_only}"="true"}{set var={content} val={{display_template get_content}}}{get content}{else} {display_template default_settings} {set var={content} val={{display_template get_content}}} {display_template admin_menu} {if "{checkperm tname={div_element} type={edit}}"="true"} {set var={editDivElement_allowed} val={true}} {endif}
{display_template header} {display_template menu}
{get content} {display_template widgets}
{display_template widgets-rechterkant}
{display_template footer}
{endif}) called at [/home/monsanto/www/website/code/core/_data.php:660] #23 strParseTemplate(main, ) called at [/home/monsanto/www/website/code/core/_data.php:675] #24 displayTemplate(main) called at [/home/monsanto/www/website/code/core/ObjIPPController.php:111] #25 IPPController->strRunAction() called at [/home/monsanto/www/website/pub/website/main.php:733]
Sorry, the page you requested cannot be found.