Error message from: [nl.monsantotribunal.org] at [23/04/2024 23:13:13]
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] =>,[error] => )) called at [/home/monsanto/www/website/code/core/strparse.php:280] #3 strParse({inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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}}{next}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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 = 3 AND obj.published = 1 ORDER BY rank} source={options}}{inline_help mt-registration-i-do-not-participate}{next} ) called at [/home/monsanto/www/website/code/core/strparse.php:3018] #4 strDoIf({if "{get mode}"="mt"},{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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}}{next}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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 = 3 AND obj.published = 1 ORDER BY rank} source={options}}{inline_help mt-registration-i-do-not-participate}{next} , , ) called at [/home/monsanto/www/website/code/core/strparse.php:241] #5 strParse({inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{inline_help mt-registration-intro-{get mode}}{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}}{next}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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 = 3 AND obj.published = 1 ORDER BY rank} source={options}}{inline_help mt-registration-i-do-not-participate}{next} {endif} {if "{get mode}"="pa"}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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}}{next}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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 = 4 AND obj.published = 1 ORDER BY rank} source={options}}{inline_help mt-registration-i-do-not-participate}{next} {endif}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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}
) 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-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}}
{inline_help mt-registration-intro-{get mode}}{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}}{next}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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 = 3 AND obj.published = 1 ORDER BY rank} source={options}}{inline_help mt-registration-i-do-not-participate}{next} {endif} {if "{get mode}"="pa"}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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}}{next}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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 = 4 AND obj.published = 1 ORDER BY rank} source={options}}{inline_help mt-registration-i-do-not-participate}{next} {endif}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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}
,[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}{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}}
{editform sql={select * from aanmelding where id = -1} source={aanmelding}}) 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({inline_help mt-registration-intro-{get mode}}{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}}{next}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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 = 3 AND obj.published = 1 ORDER BY rank} source={options}}{inline_help mt-registration-i-do-not-participate}{next} {endif} {if "{get mode}"="pa"}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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}}{next}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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 = 4 AND obj.published = 1 ORDER BY rank} source={options}}{inline_help mt-registration-i-do-not-participate}{next} {endif}{inline_help mt-registration-{field name={naam} source={options}}}€ {field name={prijs} source={options}}{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}
{endeditform}{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}}
[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}) 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]{display_template header} {display_template menu} {get content} {display_template widgets}{display_template widgets-rechterkant}{display_template footer}