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" } } } }