Error message from: [monsantotribunal.org] at [24/05/2024 00:06:32]
While processing: [/registration-mt]
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 = 1 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 = 1
		                                     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 = 1
		                                     AND obj.published = 1
		                                    order by rank) called at [/home/monsanto/www/website/code/core/strparse.php:1868]
#2  arrDoForEach({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}}, Array ([start_position] => 633,[end_position] => 1052,[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-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} ) called at [/home/monsanto/www/website/code/core/strparse.php:3018] #4 strDoIf({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} , , ) 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/strmetaparse.php:454] #9 strMetaParse(

[template:aanmelding]

) called at [/home/monsanto/www/website/code/core/_data.php:664] #10 strParseTemplate(view_pages, 1) called at [/home/monsanto/www/website/code/core/Entity.php:926] #11 Entity->viewRecord(view, -1) called at [/home/monsanto/www/website/code/core/_data.php:152] #12 displayData(137087607, view, -1) called at [/home/monsanto/www/website/code/core/parser_plugs/cms_parser_commands.php:1642] #13 strDoDisplayData({display_data obj_id="{get obj_id}"}) called at [/home/monsanto/www/website/code/core/Plugins.php:70] #14 Plugins->fireParserCommand(display_data, {display_data obj_id="{get obj_id}"}) called at [/home/monsanto/www/website/code/core/strparse.php:894] #15 strParse({display_data obj_id="{get obj_id}"}) called at [/home/monsanto/www/website/code/core/strparse.php:3018] #16 strDoIf({if "{request action}"="[element not found]"}, {display_data obj_id="{get obj_id}"}, , ) called at [/home/monsanto/www/website/code/core/strparse.php:241] #17 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 [/home/monsanto/www/website/code/core/_data.php:660] #18 strParseTemplate(get_content) called at [/home/monsanto/www/website/code/core/parser_plugs/cms_parser_commands.php:1623] #19 strDoDisplayTemplate({display_template get_content}) called at [/home/monsanto/www/website/code/core/Plugins.php:70] #20 Plugins->fireParserCommand(display_template, {display_template get_content}) called at [/home/monsanto/www/website/code/core/strparse.php:894] #21 strParse({display_template get_content}) called at [/home/monsanto/www/website/code/core/strparse.php:1018] #22 strGetTerm({set var={content} val={{display_template get_content}}}, val) called at [/home/monsanto/www/website/code/core/strparse.php:1804] #23 strDoSet({set var={content} val={{display_template get_content}}}) called at [/home/monsanto/www/website/code/core/strparse.php:192] #24 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] #25 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] #26 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] #27 strParseTemplate(main, ) called at [/home/monsanto/www/website/code/core/_data.php:675] #28 displayTemplate(main) called at [/home/monsanto/www/website/code/core/ObjIPPController.php:111] #29 IPPController->strRunAction() called at [/home/monsanto/www/website/pub/website/main.php:733]
Sorry, the page you requested cannot be found.