We use cookies

We use cookies to make logging into this Portal easier. Essential cookies are required, but you can opt-out of analytics.

Cookie Settings

Analytics cookies

Helps us improve our service by collecting anonymous usage data.

Essential cookies

Required for secure login and basic site features. Cannot be disabled.

You are in the STAGING environment
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND db652='yes' AND form_cms.db656='forms' AND system_table.condition...' at line 11 (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception

HTTP 500 Internal Server Error

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
AND db652='yes'
AND form_cms.db656='forms'
AND system_table.condition...' at line 11

Exceptions 2

Doctrine\DBAL\Driver\PDO\ Exception

in /var/www/vhosts/heiapply.co.uk/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php (line 18)
  1.  */
  2. final class Exception extends PDOException
  3. {
  4.     public static function new(\PDOException $exception): self
  5.     {
  6.         return new self($exception);
  7.     }
  8. }
in /var/www/vhosts/heiapply.co.uk/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php :: new (line 119)
  1.     public function execute($params = null)
  2.     {
  3.         try {
  4.             return parent::execute($params);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  8.     }
  10.     /**
  11.      * {@inheritdoc}
PDOStatement->execute() in /var/www/vhosts/heiapply.co.uk/httpdocs/engine/admin/inc/lib.inc.php (line 11287)
  1.      ";
  3.     dev_debug("list of required fields sql 1 - " . $required_fields_sql_conditional);
  5.     $sth_conditional = $dbh->prepare($required_fields_sql_conditional);
  6.     $sth_conditional->execute();
  7.     $results_conditional = $sth_conditional->fetchAll(PDO::FETCH_ASSOC);
  9.     $conditional_fields_array = [];
filled_percentage_on_new_forms() in /var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/form_settings.php (line 107)
  2. // Get course level
  3. $course_level = pull_field("core_course_level", "db343", "WHERE id='$core_students_level_of_entry'");
  5. // get percentage of application completed and display
  6. list($required_fields, $required_filled) = filled_percentage_on_new_forms($core_students_id, [],$pages_id );
  7. $filled_percentage = round(100 * $required_filled / $required_fields, 0, PHP_ROUND_HALF_DOWN);
  9. // Fetch application stages
  10. // ----------------------------------------------------------------------------
  11. // Fetch application stages
include('/var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/form_settings.php') in /var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/web_header.php (line 3)
  1. <?php
  2. //pullin the file that holds all the queries 
  3. include("form_settings.php");
  4. ?>
  5. <!DOCTYPE html>
  6. <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-US">
  7. <head>
  8.     <title><?php echo $page_title; ?></title>
include('/var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/web_header.php') in /var/www/vhosts/heiapply.co.uk/httpdocs/web_header_core.php (line 363)
  2. dev_debug("Web Header Core " . front_header_file_location . "/web_header.php");
  3. if (file_exists(front_header_file_location . "/web_header.php")) {
  4.     $front_web_url_file_loc = $front_website_url . '/' . front_header_file_location;
  5.     dev_debug("Core file included 1");
  6.     include(front_header_file_location . "/web_header.php");
  7. } elseif (find_slug(1) == "online-learning" || find_slug(2) == "online-learning" || find_slug(3) == "online-learning" || find_slug(4) == "online-learning" || find_slug(5) == "online-learning") {
  8.     //include("header.php");
  9. } else {
  10.     $front_web_url_file_loc = $front_website_url . '/' . default_theme_files_location;
  11.     dev_debug("Core file included 2");
include('/var/www/vhosts/heiapply.co.uk/httpdocs/web_header_core.php') in /var/www/vhosts/heiapply.co.uk/httpdocs/application_login.php (line 2)
  1. <?php
  2. include("web_header_core.php");
  3. ?>
  5. <div id="mainpage-img"></div>
  6. <div style="clear:both"></div>  

PDOException

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND db652='yes' AND form_cms.db656='forms' AND system_table.condition...' at line 11

in /var/www/vhosts/heiapply.co.uk/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php (line 117)
  1.      */
  2.     #[ReturnTypeWillChange]
  3.     public function execute($params = null)
  4.     {
  5.         try {
  6.             return parent::execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  10.     }
in /var/www/vhosts/heiapply.co.uk/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php -> execute (line 117)
  1.      */
  2.     #[ReturnTypeWillChange]
  3.     public function execute($params = null)
  4.     {
  5.         try {
  6.             return parent::execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  10.     }
PDOStatement->execute() in /var/www/vhosts/heiapply.co.uk/httpdocs/engine/admin/inc/lib.inc.php (line 11287)
  1.      ";
  3.     dev_debug("list of required fields sql 1 - " . $required_fields_sql_conditional);
  5.     $sth_conditional = $dbh->prepare($required_fields_sql_conditional);
  6.     $sth_conditional->execute();
  7.     $results_conditional = $sth_conditional->fetchAll(PDO::FETCH_ASSOC);
  9.     $conditional_fields_array = [];
filled_percentage_on_new_forms() in /var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/form_settings.php (line 107)
  2. // Get course level
  3. $course_level = pull_field("core_course_level", "db343", "WHERE id='$core_students_level_of_entry'");
  5. // get percentage of application completed and display
  6. list($required_fields, $required_filled) = filled_percentage_on_new_forms($core_students_id, [],$pages_id );
  7. $filled_percentage = round(100 * $required_filled / $required_fields, 0, PHP_ROUND_HALF_DOWN);
  9. // Fetch application stages
  10. // ----------------------------------------------------------------------------
  11. // Fetch application stages
include('/var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/form_settings.php') in /var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/web_header.php (line 3)
  1. <?php
  2. //pullin the file that holds all the queries 
  3. include("form_settings.php");
  4. ?>
  5. <!DOCTYPE html>
  6. <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-US">
  7. <head>
  8.     <title><?php echo $page_title; ?></title>
include('/var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/web_header.php') in /var/www/vhosts/heiapply.co.uk/httpdocs/web_header_core.php (line 363)
  2. dev_debug("Web Header Core " . front_header_file_location . "/web_header.php");
  3. if (file_exists(front_header_file_location . "/web_header.php")) {
  4.     $front_web_url_file_loc = $front_website_url . '/' . front_header_file_location;
  5.     dev_debug("Core file included 1");
  6.     include(front_header_file_location . "/web_header.php");
  7. } elseif (find_slug(1) == "online-learning" || find_slug(2) == "online-learning" || find_slug(3) == "online-learning" || find_slug(4) == "online-learning" || find_slug(5) == "online-learning") {
  8.     //include("header.php");
  9. } else {
  10.     $front_web_url_file_loc = $front_website_url . '/' . default_theme_files_location;
  11.     dev_debug("Core file included 2");
include('/var/www/vhosts/heiapply.co.uk/httpdocs/web_header_core.php') in /var/www/vhosts/heiapply.co.uk/httpdocs/application_login.php (line 2)
  1. <?php
  2. include("web_header_core.php");
  3. ?>
  5. <div id="mainpage-img"></div>
  6. <div style="clear:both"></div>  

Stack Traces 2

[2/2] Exception 
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
 	AND db652='yes'
 	AND form_cms.db656='forms'
 	AND system_table.condition...' at line 11

  at /var/www/vhosts/heiapply.co.uk/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (/var/www/vhosts/heiapply.co.uk/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119)
  at Doctrine\DBAL\Driver\PDOStatement->execute()
     (/var/www/vhosts/heiapply.co.uk/httpdocs/engine/admin/inc/lib.inc.php:11287)
  at filled_percentage_on_new_forms()
     (/var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/form_settings.php:107)
  at include('/var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/form_settings.php')
     (/var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/web_header.php:3)
  at include('/var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/web_header.php')
     (/var/www/vhosts/heiapply.co.uk/httpdocs/web_header_core.php:363)
  at include('/var/www/vhosts/heiapply.co.uk/httpdocs/web_header_core.php')
     (/var/www/vhosts/heiapply.co.uk/httpdocs/application_login.php:2)
[1/2] PDOException 
PDOException:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
 	AND db652='yes'
 	AND form_cms.db656='forms'
 	AND system_table.condition...' at line 11

  at /var/www/vhosts/heiapply.co.uk/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
  at PDOStatement->execute()
     (/var/www/vhosts/heiapply.co.uk/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)
  at Doctrine\DBAL\Driver\PDOStatement->execute()
     (/var/www/vhosts/heiapply.co.uk/httpdocs/engine/admin/inc/lib.inc.php:11287)
  at filled_percentage_on_new_forms()
     (/var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/form_settings.php:107)
  at include('/var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/form_settings.php')
     (/var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/web_header.php:3)
  at include('/var/www/vhosts/heiapply.co.uk/httpdocs/static/icca/web_header.php')
     (/var/www/vhosts/heiapply.co.uk/httpdocs/web_header_core.php:363)
  at include('/var/www/vhosts/heiapply.co.uk/httpdocs/web_header_core.php')
     (/var/www/vhosts/heiapply.co.uk/httpdocs/application_login.php:2)