Error We are sorry, but an error occurred while generating this page. You should contact the site's administrator.
Error in function call sqlpage.run_sql('shell.sql').
Expected sqlpage.run_sql(sql_file_path, variables)
Backtrace
run_sql: unable to run "shell.sql"
In "shell.sql": The following error occurred while executing an SQL statement:
error returned from database: more than one row returned by a subquery used as an expression
The SQL statement sent by SQLPage was:
SELECT 'shell' AS component, (SELECT COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'title'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'title'))) || COALESCE(' | ' || CAST($2 AS TEXT), '') AS title, (CASE WHEN CAST($1 AS TEXT) IN ('ar', 'he', 'fa', 'ur', 'ps', 'sd', 'ku', 'dv', 'ug') THEN true ELSE false END) AS rtl, 'fluid' AS layout, 'images/logo.svg' AS image, 'style.css' AS css, 'manifest.json' AS manifest, CASE WHEN CAST($1 AS TEXT) = 'en' THEN 'Montserrat' WHEN CAST($1 AS TEXT) = 'pl' THEN 'Montserrat' ELSE NULL END AS font, '16px' AS font_size, 'search' AS search_target, 'favicon.ico' AS favicon, 'images/social_image.webp' AS social_image, '/js/mark.min.js' AS javascript, '/js/mark-me.js' AS javascript, '/js/navigation-buttons.js' AS javascript, '/js/navigation-meta.js' AS javascript, '/js/shareButton.js' AS javascript, '/js/lazyload.js' AS javascript, CAST($3 AS TEXT) AS theme, '/' AS link, json_build_array(json_build_object('title', COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'menu.all_talks'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'menu.all_talks'), 'All Talks'), 'link', '/shri-mataji-talks?tlang=all&lang=' || COALESCE(CAST($1 AS TEXT), 'en')), json_build_object('title', COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'menu.discover'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'menu.discover'), 'Discover'), 'submenu', json_build_array(json_build_object('title', COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'menu.discover_mataji'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'menu.discover_mataji'), 'Discover Shri Mataji') || ' ⧉', 'link', '//shrimataji.org', 'target', '_blank'), json_build_object('title', COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'menu.discover_sahaja'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'menu.discover_sahaja'), 'Discover Sahaja Yoga') || ' ⧉', 'link', '//' || COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'menu.www_sy'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'menu.www_sy'), '//sahajayoga.org'), 'target', '_blank'), json_build_object('title', COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'menu.meditate_online'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'menu.meditate_online'), 'Meditate Online - WeMeditate') || ' ⧉', 'link', '//wemeditate.com', 'target', '_blank'), json_build_object('title', COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'menu.centre_near_you'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'menu.centre_near_you'), 'Centre near you') || ' ⧉', 'link', '//coolbreeze.org/#country_id', 'target', '_blank'))), json_build_object('title', COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'menu.contact'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'menu.contact'), 'Contact'), 'link', 'mailto:[email protected]'), json_build_object('title', COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'menu.donate'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'menu.donate'), 'Donate') || ' ⧉', 'link', '//donate.amruta.org', 'target', '_blank'), json_build_object('icon', 'language', 'submenu', (SELECT json_agg(json_build_object('link', s.link, 'title', s.title, 'image', s.image_link, 'active', (CASE WHEN s.language_code = CAST($1 AS TEXT) THEN true ELSE false END))) FROM (SELECT link, title, image_link, language_code FROM menu_items WHERE parent_id = 3 AND active = true ORDER BY title COLLATE "C") AS s)), json_build_object('title', '☀', 'link', '/toggle')) AS menu_item, COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'shell.description'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'shell.description')) AS description, CAST($1 AS TEXT) AS language, COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'search'), (SELECT translation_value FROM language)) AS search_button, COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'search'), (SELECT translation_value FROM language)) AS search_placeholder, CAST($4 AS TEXT) AS search_value, '[v' || CAST($5 AS TEXT) || '](//sql-page.com/)' || ' | [' || COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'footer.terms'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'footer.terms')) || '](/terms) | [' || COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'footer.privacy'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'footer.privacy')) || '](/privacy-policy) | [oska.dev](//oska.dev) | [' || COALESCE((SELECT translation_value FROM language WHERE language_code = CAST($1 AS TEXT) AND translation_key = 'menu.donate'), (SELECT translation_value FROM language WHERE language_code = 'en' AND translation_key = 'menu.donate')) || ' ♥](//donate.amruta.org)' AS footer;