2024-07-26 23:16:51
array(4) {
  ["error"]=>
  string(13) "PDO-SQL-ERROR"
  ["PDO_error"]=>
  string(239) "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 'and c.islive=1 order by c.certificate' at line 1"
  ["SQL"]=>
  array(2) {
    ["query"]=>
    string(166) "select p.profid,p.certid,p.credits,p.price,c.certificate from prof2cert as p,certificates as c where c.Id=p.certid and p.profid= and c.islive=1 order by c.certificate"
    ["input"]=>
    array(0) {
    }
  }
  ["debug_backtrace"]=>
  array(6) {
    [0]=>
    array(7) {
      ["file"]=>
      string(55) "/home/powers/public_html/classLibs/class.pdoWrapper.inc"
      ["line"]=>
      int(107)
      ["function"]=>
      string(12) "pdoException"
      ["class"]=>
      string(10) "PdoWrapper"
      ["object"]=>
      object(PdoWrapper)#15 (4) {
        ["pdoHandle":"PdoWrapper":private]=>
        object(PDO)#16 (0) {
        }
        ["useTablecols"]=>
        int(0)
        ["useDatadumper"]=>
        int(0)
        ["sql"]=>
        array(2) {
          ["query"]=>
          string(166) "select p.profid,p.certid,p.credits,p.price,c.certificate from prof2cert as p,certificates as c where c.Id=p.certid and p.profid= and c.islive=1 order by c.certificate"
          ["input"]=>
          array(0) {
          }
        }
      }
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        string(239) "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 'and c.islive=1 order by c.certificate' at line 1"
      }
    }
    [1]=>
    array(7) {
      ["file"]=>
      string(55) "/home/powers/public_html/classLibs/class.pdoWrapper.inc"
      ["line"]=>
      int(126)
      ["function"]=>
      string(10) "pdoExecute"
      ["class"]=>
      string(10) "PdoWrapper"
      ["object"]=>
      object(PdoWrapper)#15 (4) {
        ["pdoHandle":"PdoWrapper":private]=>
        object(PDO)#16 (0) {
        }
        ["useTablecols"]=>
        int(0)
        ["useDatadumper"]=>
        int(0)
        ["sql"]=>
        array(2) {
          ["query"]=>
          string(166) "select p.profid,p.certid,p.credits,p.price,c.certificate from prof2cert as p,certificates as c where c.Id=p.certid and p.profid= and c.islive=1 order by c.certificate"
          ["input"]=>
          array(0) {
          }
        }
      }
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(2) {
        [0]=>
        string(166) "select p.profid,p.certid,p.credits,p.price,c.certificate from prof2cert as p,certificates as c where c.Id=p.certid and p.profid= and c.islive=1 order by c.certificate"
        [1]=>
        array(0) {
        }
      }
    }
    [2]=>
    array(7) {
      ["file"]=>
      string(50) "/home/powers/public_html/classLibs/class.MyPdo.inc"
      ["line"]=>
      int(11)
      ["function"]=>
      string(9) "pdoGetAll"
      ["class"]=>
      string(10) "PdoWrapper"
      ["object"]=>
      object(PdoWrapper)#15 (4) {
        ["pdoHandle":"PdoWrapper":private]=>
        object(PDO)#16 (0) {
        }
        ["useTablecols"]=>
        int(0)
        ["useDatadumper"]=>
        int(0)
        ["sql"]=>
        array(2) {
          ["query"]=>
          string(166) "select p.profid,p.certid,p.credits,p.price,c.certificate from prof2cert as p,certificates as c where c.Id=p.certid and p.profid= and c.islive=1 order by c.certificate"
          ["input"]=>
          array(0) {
          }
        }
      }
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(2) {
        [0]=>
        string(166) "select p.profid,p.certid,p.credits,p.price,c.certificate from prof2cert as p,certificates as c where c.Id=p.certid and p.profid= and c.islive=1 order by c.certificate"
        [1]=>
        array(0) {
        }
      }
    }
    [3]=>
    array(7) {
      ["file"]=>
      string(54) "/home/powers/public_html/classLibs/class.certNotes.inc"
      ["line"]=>
      int(94)
      ["function"]=>
      string(4) "rows"
      ["class"]=>
      string(5) "MyPdo"
      ["object"]=>
      object(MyPdo)#14 (4) {
        ["pdo"]=>
        object(PdoWrapper)#15 (4) {
          ["pdoHandle":"PdoWrapper":private]=>
          object(PDO)#16 (0) {
          }
          ["useTablecols"]=>
          int(0)
          ["useDatadumper"]=>
          int(0)
          ["sql"]=>
          array(2) {
            ["query"]=>
            string(166) "select p.profid,p.certid,p.credits,p.price,c.certificate from prof2cert as p,certificates as c where c.Id=p.certid and p.profid= and c.islive=1 order by c.certificate"
            ["input"]=>
            array(0) {
            }
          }
        }
        ["pdoHandle":"PdoWrapper":private]=>
        NULL
        ["useTablecols"]=>
        int(0)
        ["useDatadumper"]=>
        int(0)
      }
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        string(166) "select p.profid,p.certid,p.credits,p.price,c.certificate from prof2cert as p,certificates as c where c.Id=p.certid and p.profid= and c.islive=1 order by c.certificate"
      }
    }
    [4]=>
    array(7) {
      ["file"]=>
      string(54) "/home/powers/public_html/classLibs/class.certNotes.inc"
      ["line"]=>
      int(32)
      ["function"]=>
      string(22) "selectCertificateNotes"
      ["class"]=>
      string(24) "CountryApprovedCertNotes"
      ["object"]=>
      object(CountryApprovedCertNotes)#13 (8) {
        ["pdo":"CountryApprovedCertNotes":private]=>
        object(MyPdo)#14 (4) {
          ["pdo"]=>
          object(PdoWrapper)#15 (4) {
            ["pdoHandle":"PdoWrapper":private]=>
            object(PDO)#16 (0) {
            }
            ["useTablecols"]=>
            int(0)
            ["useDatadumper"]=>
            int(0)
            ["sql"]=>
            array(2) {
              ["query"]=>
              string(166) "select p.profid,p.certid,p.credits,p.price,c.certificate from prof2cert as p,certificates as c where c.Id=p.certid and p.profid= and c.islive=1 order by c.certificate"
              ["input"]=>
              array(0) {
              }
            }
          }
          ["pdoHandle":"PdoWrapper":private]=>
          NULL
          ["useTablecols"]=>
          int(0)
          ["useDatadumper"]=>
          int(0)
        }
        ["pid":"CountryApprovedCertNotes":private]=>
        NULL
        ["country":"CountryApprovedCertNotes":private]=>
        string(2) "US"
        ["countryName":"CountryApprovedCertNotes":private]=>
        string(24) "UNITED STATES OF AMERICA"
        ["stateName":"CountryApprovedCertNotes":private]=>
        string(5) "Maine"
        ["state":"CountryApprovedCertNotes":private]=>
        string(2) "ME"
        ["professionName":"CountryApprovedCertNotes":private]=>
        NULL
        ["approvedCerts":"CountryApprovedCertNotes":private]=>
        array(0) {
        }
      }
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(2) {
        [0]=>
        NULL
        [1]=>
        string(2) "US"
      }
    }
    [5]=>
    array(7) {
      ["file"]=>
      string(62) "/home/powers/public_html/stateApprovals/requirements/index.php"
      ["line"]=>
      int(125)
      ["function"]=>
      string(11) "__construct"
      ["class"]=>
      string(24) "CountryApprovedCertNotes"
      ["object"]=>
      object(CountryApprovedCertNotes)#13 (8) {
        ["pdo":"CountryApprovedCertNotes":private]=>
        object(MyPdo)#14 (4) {
          ["pdo"]=>
          object(PdoWrapper)#15 (4) {
            ["pdoHandle":"PdoWrapper":private]=>
            object(PDO)#16 (0) {
            }
            ["useTablecols"]=>
            int(0)
            ["useDatadumper"]=>
            int(0)
            ["sql"]=>
            array(2) {
              ["query"]=>
              string(166) "select p.profid,p.certid,p.credits,p.price,c.certificate from prof2cert as p,certificates as c where c.Id=p.certid and p.profid= and c.islive=1 order by c.certificate"
              ["input"]=>
              array(0) {
              }
            }
          }
          ["pdoHandle":"PdoWrapper":private]=>
          NULL
          ["useTablecols"]=>
          int(0)
          ["useDatadumper"]=>
          int(0)
        }
        ["pid":"CountryApprovedCertNotes":private]=>
        NULL
        ["country":"CountryApprovedCertNotes":private]=>
        string(2) "US"
        ["countryName":"CountryApprovedCertNotes":private]=>
        string(24) "UNITED STATES OF AMERICA"
        ["stateName":"CountryApprovedCertNotes":private]=>
        string(5) "Maine"
        ["state":"CountryApprovedCertNotes":private]=>
        string(2) "ME"
        ["professionName":"CountryApprovedCertNotes":private]=>
        NULL
        ["approvedCerts":"CountryApprovedCertNotes":private]=>
        array(0) {
        }
      }
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(3) {
        [0]=>
        NULL
        [1]=>
        string(2) "US"
        [2]=>
        string(2) "ME"
      }
    }
  }
}