title: Upgraded MySQL from 5.1 to 5.5, running into PDOException: SQLSTATE[42000]: Syntax error or access violation
body: <p>I have my website database running on another machine (MySQL DB) where v5.5 is installed. The current machine (with PhP / Drupal) is on 5.1. </p>
  
  <p>Upgraded MySQL on my current machine from v5.1 to v5.5 so I could have both Drupal and MySQL on the same box (done all the hygiene steps - mysql_upgrade, my.cnf configured correctly).</p>
  
  <p>MySQL grant privileges is also given to the resp DB users. There are no errors in MySQL log (eliminated all of them).</p>
  
  <p>The particular function worked perfectly fine with the earlier setup (DB on another machine with 5.5), however I am running into few problems in the current setup. See below.</p>
  
  <pre><code>    PDOException: SQLSTATE[42000]: Syntax error or access violation: 
      1305 FUNCTION xxx_system.gen_stat_as_due_ors does not exist: 
      SELECT gen_stat_as_due_ors(:xx_number, :assigned_date); Array ( [:xx_number] =&gt; 5229 
      [:assigned_date] =&gt; 2013-04-08 00:00:00 ) in xxx_utils_get_report_rep4a1() 
      (line 403 of /home/xxx/public_html/sites/all/modules/custom/xxx_utils/xxx_utils.reports.inc).
  </code></pre>
  
  <p>Linux 2.6.32-042stab076.8 x86_64</p>
  
  <p>Have been searching desperately on my machine and over the internet for a solution (2 days now!!!) no luck!</p>
  
  <p>Any help would be highly appreciated.</p>