2 Replies Latest reply on Jun 18, 2018 8:26 AM by Tom with Wiley

    Cannot add OCP: Oracle Certified Professional Java SE 8 Programmer II Study Guide: Exam 1Z0-809 to my profile book list

    Assia Makboul

      Hello,

       

      I have a problem when I try adding a book to my profile book list even if I have a valid registration number, I have this waiting message until my session time out.

       

      I tried tu register the same book with another email adresse and I had my new registration number, but when I try to create sybextestbanks account with that email and registration number I get this message error :

       

      object(ArrayObject)#102 (1) { ["storage":"ArrayObject":private]=> array(3) { ["exception"]=> object(Zend_Db_Statement_Exception)#82 (8) { ["_previous":"Zend_Exception":private]=> NULL ["message":protected]=> string(82) "SQLSTATE[HY000]: General error: 1364 Field 'Username' doesn't have a default value" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(0) ["file":protected]=> string(66) "/home/sybextestbanks/public_html/library/Zend/Db/Statement/Pdo.php" ["line":protected]=> int(234) ["trace":"Exception":private]=> array(13) { [0]=> array(6) { ["file"]=> string(62) "/home/sybextestbanks/public_html/library/Zend/Db/Statement.php" ["line"]=> int(300) ["function"]=> string(8) "_execute" ["class"]=> string(21) "Zend_Db_Statement_Pdo" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(5) { [0]=> string(32) "c914c27878865b814cfb7ed3a71555e1" [1]=> string(4) "user" [2]=> string(19) "MAKBOUL NOUR EDDINE" [3]=> string(20) "MAKBOUL01@HOTMAIL.FR" [4]=> string(12) "anaassia1990" } } } [1]=> array(6) { ["file"]=> string(69) "/home/sybextestbanks/public_html/library/Zend/Db/Adapter/Abstract.php" ["line"]=> int(479) ["function"]=> string(7) "execute" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(5) { [0]=> string(32) "c914c27878865b814cfb7ed3a71555e1" [1]=> string(4) "user" [2]=> string(19) "MAKBOUL NOUR EDDINE" [3]=> string(20) "MAKBOUL01@HOTMAIL.FR" [4]=> string(12) "anaassia1990" } } } [2]=> array(6) { ["file"]=> string(73) "/home/sybextestbanks/public_html/library/Zend/Db/Adapter/Pdo/Abstract.php" ["line"]=> int(238) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &string(94) "INSERT INTO `users` (`Password`, `Role`, `Name`, `Email`, `first_pass`) VALUES (?, ?, ?, ?, ?)" [1]=> &array(5) { [0]=> string(32) "c914c27878865b814cfb7ed3a71555e1" [1]=> string(4) "user" [2]=> string(19) "MAKBOUL NOUR EDDINE" [3]=> string(20) "MAKBOUL01@HOTMAIL.FR" [4]=> string(12) "anaassia1990" } } } [3]=> array(6) { ["file"]=> string(69) "/home/sybextestbanks/public_html/library/Zend/Db/Adapter/Abstract.php" ["line"]=> int(575) ["function"]=> string(5) "query" ["class"]=> string(28) "Zend_Db_Adapter_Pdo_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &string(94) "INSERT INTO `users` (`Password`, `Role`, `Name`, `Email`, `first_pass`) VALUES (?, ?, ?, ?, ?)" [1]=> &array(5) { [0]=> string(32) "c914c27878865b814cfb7ed3a71555e1" [1]=> string(4) "user" [2]=> string(19) "MAKBOUL NOUR EDDINE" [3]=> string(20) "MAKBOUL01@HOTMAIL.FR" [4]=> string(12) "anaassia1990" } } } [4]=> array(6) { ["file"]=> string(67) "/home/sybextestbanks/public_html/library/Zend/Db/Table/Abstract.php" ["line"]=> int(1075) ["function"]=> string(6) "insert" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &string(5) "users" [1]=> &array(5) { ["Password"]=> string(32) "c914c27878865b814cfb7ed3a71555e1" ["Role"]=> string(4) "user" ["Name"]=> string(19) "MAKBOUL NOUR EDDINE" ["Email"]=> string(20) "MAKBOUL01@HOTMAIL.FR" ["first_pass"]=> string(12) "anaassia1990" } } } [5]=> array(6) { ["file"]=> string(69) "/home/sybextestbanks/public_html/application/models/DbTable/Users.php" ["line"]=> int(89) ["function"]=> string(6) "insert" ["class"]=> string(22) "Zend_Db_Table_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(5) { ["Password"]=> string(32) "c914c27878865b814cfb7ed3a71555e1" ["Role"]=> string(4) "user" ["Name"]=> string(19) "MAKBOUL NOUR EDDINE" ["Email"]=> string(20) "MAKBOUL01@HOTMAIL.FR" ["first_pass"]=> string(12) "anaassia1990" } } } [6]=> array(6) { ["file"]=> string(76) "/home/sybextestbanks/public_html/application/controllers/IndexController.php" ["line"]=> int(244) ["function"]=> string(10) "saveRecord" ["class"]=> string(19) "Model_DbTable_Users" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(6) { ["regaccesscode"]=> string(10) "1594847900" ["Email"]=> string(20) "MAKBOUL01@HOTMAIL.FR" ["ReEmail"]=> string(20) "MAKBOUL01@HOTMAIL.FR" ["Name"]=> string(19) "MAKBOUL NOUR EDDINE" ["Password"]=> string(12) "anaassia1990" ["password2"]=> string(12) "anaassia1990" } } } [7]=> array(6) { ["file"]=> string(67) "/home/sybextestbanks/public_html/library/Zend/Controller/Action.php" ["line"]=> int(516) ["function"]=> string(11) "loginAction" ["class"]=> string(15) "IndexController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [8]=> array(6) { ["file"]=> string(80) "/home/sybextestbanks/public_html/library/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(295) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(11) "loginAction" } } [9]=> array(6) { ["file"]=> string(66) "/home/sybextestbanks/public_html/library/Zend/Controller/Front.php" ["line"]=> int(954) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Controller_Request_Http)#39 (15) { ["_paramSources":protected]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri":protected]=> string(33) "/public/index/login?page=register" ["_baseUrl":protected]=> string(7) "/public" ["_basePath":protected]=> NULL ["_pathInfo":protected]=> string(12) "/index/login" ["_params":protected]=> array(4) { ["controller"]=> string(5) "index" ["action"]=> string(5) "login" ["module"]=> string(7) "default" ["error_handler"]=> *RECURSION* } ["_rawBody":protected]=> NULL ["_aliases":protected]=> array(0) { } ["_dispatched":protected]=> bool(true) ["_module":protected]=> string(7) "default" ["_moduleKey":protected]=> string(6) "module" ["_controller":protected]=> string(5) "error" ["_controllerKey":protected]=> string(10) "controller" ["_action":protected]=> string(5) "error" ["_actionKey":protected]=> string(6) "action" } [1]=> object(Zend_Controller_Response_Http)#40 (8) { ["_body":protected]=> array(0) { } ["_exceptions":protected]=> array(1) { [0]=> *RECURSION* } ["_headers":protected]=> array(0) { } ["_headersRaw":protected]=> array(0) { } ["_httpResponseCode":protected]=> int(200) ["_isRedirect":protected]=> bool(false) ["_renderExceptions":protected]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [10]=> array(6) { ["file"]=> string(81) "/home/sybextestbanks/public_html/library/Zend/Application/Bootstrap/Bootstrap.php" ["line"]=> int(97) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [11]=> array(6) { ["file"]=> string(61) "/home/sybextestbanks/public_html/library/Zend/Application.php" ["line"]=> int(366) ["function"]=> string(3) "run" ["class"]=> string(36) "Zend_Application_Bootstrap_Bootstrap" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [12]=> array(6) { ["file"]=> string(49) "/home/sybextestbanks/public_html/public/index.php" ["line"]=> int(46) ["function"]=> string(3) "run" ["class"]=> string(16) "Zend_Application" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> object(PDOException)#84 (8) { ["message":protected]=> string(82) "SQLSTATE[HY000]: General error: 1364 Field 'Username' doesn't have a default value" ["string":"Exception":private]=> string(0) "" ["code":protected]=> string(5) "HY000" ["file":protected]=> string(66) "/home/sybextestbanks/public_html/library/Zend/Db/Statement/Pdo.php" ["line":protected]=> int(228) ["trace":"Exception":private]=> array(14) { [0]=> array(6) { ["file"]=> string(66) "/home/sybextestbanks/public_html/library/Zend/Db/Statement/Pdo.php" ["line"]=> int(228) ["function"]=> string(7) "execute" ["class"]=> string(12) "PDOStatement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> array(5) { [0]=> string(32) "c914c27878865b814cfb7ed3a71555e1" [1]=> string(4) "user" [2]=> string(19) "MAKBOUL NOUR EDDINE" [3]=> string(20) "MAKBOUL01@HOTMAIL.FR" [4]=> string(12) "anaassia1990" } } } [1]=> array(6) { ["file"]=> string(62) "/home/sybextestbanks/public_html/library/Zend/Db/Statement.php" ["line"]=> int(300) ["function"]=> string(8) "_execute" ["class"]=> string(21) "Zend_Db_Statement_Pdo" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(5) { [0]=> string(32) "c914c27878865b814cfb7ed3a71555e1" [1]=> string(4) "user" [2]=> string(19) "MAKBOUL NOUR EDDINE" [3]=> string(20) "MAKBOUL01@HOTMAIL.FR" [4]=> string(12) "anaassia1990" } } } [2]=> array(6) { ["file"]=> string(69) "/home/sybextestbanks/public_html/library/Zend/Db/Adapter/Abstract.php" ["line"]=> int(479) ["function"]=> string(7) "execute" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(5) { [0]=> string(32) "c914c27878865b814cfb7ed3a71555e1" [1]=> string(4) "user" [2]=> string(19) "MAKBOUL NOUR EDDINE" [3]=> string(20) "MAKBOUL01@HOTMAIL.FR" [4]=> string(12) "anaassia1990" } } } [3]=> array(6) { ["file"]=> string(73) "/home/sybextestbanks/public_html/library/Zend/Db/Adapter/Pdo/Abstract.php" ["line"]=> int(238) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &string(94) "INSERT INTO `users` (`Password`, `Role`, `Name`, `Email`, `first_pass`) VALUES (?, ?, ?, ?, ?)" [1]=> &array(5) { [0]=> string(32) "c914c27878865b814cfb7ed3a71555e1" [1]=> string(4) "user" [2]=> string(19) "MAKBOUL NOUR EDDINE" [3]=> string(20) "MAKBOUL01@HOTMAIL.FR" [4]=> string(12) "anaassia1990" } } } [4]=> array(6) { ["file"]=> string(69) "/home/sybextestbanks/public_html/library/Zend/Db/Adapter/Abstract.php" ["line"]=> int(575) ["function"]=> string(5) "query" ["class"]=> string(28) "Zend_Db_Adapter_Pdo_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &string(94) "INSERT INTO `users` (`Password`, `Role`, `Name`, `Email`, `first_pass`) VALUES (?, ?, ?, ?, ?)" [1]=> &array(5) { [0]=> string(32) "c914c27878865b814cfb7ed3a71555e1" [1]=> string(4) "user" [2]=> string(19) "MAKBOUL NOUR EDDINE" [3]=> string(20) "MAKBOUL01@HOTMAIL.FR" [4]=> string(12) "anaassia1990" } } } [5]=> array(6) { ["file"]=> string(67) "/home/sybextestbanks/public_html/library/Zend/Db/Table/Abstract.php" ["line"]=> int(1075) ["function"]=> string(6) "insert" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &string(5) "users" [1]=> &array(5) { ["Password"]=> string(32) "c914c27878865b814cfb7ed3a71555e1" ["Role"]=> string(4) "user" ["Name"]=> string(19) "MAKBOUL NOUR EDDINE" ["Email"]=> string(20) "MAKBOUL01@HOTMAIL.FR" ["first_pass"]=> string(12) "anaassia1990" } } } [6]=> array(6) { ["file"]=> string(69) "/home/sybextestbanks/public_html/application/models/DbTable/Users.php" ["line"]=> int(89) ["function"]=> string(6) "insert" ["class"]=> string(22) "Zend_Db_Table_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(5) { ["Password"]=> string(32) "c914c27878865b814cfb7ed3a71555e1" ["Role"]=> string(4) "user" ["Name"]=> string(19) "MAKBOUL NOUR EDDINE" ["Email"]=> string(20) "MAKBOUL01@HOTMAIL.FR" ["first_pass"]=> string(12) "anaassia1990" } } } [7]=> array(6) { ["file"]=> string(76) "/home/sybextestbanks/public_html/application/controllers/IndexController.php" ["line"]=> int(244) ["function"]=> string(10) "saveRecord" ["class"]=> string(19) "Model_DbTable_Users" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(6) { ["regaccesscode"]=> string(10) "1594847900" ["Email"]=> string(20) "MAKBOUL01@HOTMAIL.FR" ["ReEmail"]=> string(20) "MAKBOUL01@HOTMAIL.FR" ["Name"]=> string(19) "MAKBOUL NOUR EDDINE" ["Password"]=> string(12) "anaassia1990" ["password2"]=> string(12) "anaassia1990" } } } [8]=> array(6) { ["file"]=> string(67) "/home/sybextestbanks/public_html/library/Zend/Controller/Action.php" ["line"]=> int(516) ["function"]=> string(11) "loginAction" ["class"]=> string(15) "IndexController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [9]=> array(6) { ["file"]=> string(80) "/home/sybextestbanks/public_html/library/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(295) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(11) "loginAction" } } [10]=> array(6) { ["file"]=> string(66) "/home/sybextestbanks/public_html/library/Zend/Controller/Front.php" ["line"]=> int(954) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Controller_Request_Http)#39 (15) { ["_paramSources":protected]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri":protected]=> string(33) "/public/index/login?page=register" ["_baseUrl":protected]=> string(7) "/public" ["_basePath":protected]=> NULL ["_pathInfo":protected]=> string(12) "/index/login" ["_params":protected]=> array(4) { ["controller"]=> string(5) "index" ["action"]=> string(5) "login" ["module"]=> string(7) "default" ["error_handler"]=> *RECURSION* } ["_rawBody":protected]=> NULL ["_aliases":protected]=> array(0) { } ["_dispatched":protected]=> bool(true) ["_module":protected]=> string(7) "default" ["_moduleKey":protected]=> string(6) "module" ["_controller":protected]=> string(5) "error" ["_controllerKey":protected]=> string(10) "controller" ["_action":protected]=> string(5) "error" ["_actionKey":protected]=> string(6) "action" } [1]=> object(Zend_Controller_Response_Http)#40 (8) { ["_body":protected]=> array(0) { } ["_exceptions":protected]=> array(1) { [0]=> *RECURSION* } ["_headers":protected]=> array(0) { } ["_headersRaw":protected]=> array(0) { } ["_httpResponseCode":protected]=> int(200) ["_isRedirect":protected]=> bool(false) ["_renderExceptions":protected]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [11]=> array(6) { ["file"]=> string(81) "/home/sybextestbanks/public_html/library/Zend/Application/Bootstrap/Bootstrap.php" ["line"]=> int(97) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [12]=> array(6) { ["file"]=> string(61) "/home/sybextestbanks/public_html/library/Zend/Application.php" ["line"]=> int(366) ["function"]=> string(3) "run" ["class"]=> string(36) "Zend_Application_Bootstrap_Bootstrap" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [13]=> array(6) { ["file"]=> string(49) "/home/sybextestbanks/public_html/public/index.php" ["line"]=> int(46) ["function"]=> string(3) "run" ["class"]=> string(16) "Zend_Application" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> NULL ["errorInfo"]=> array(3) { [0]=> string(5) "HY000" [1]=> int(1364) [2]=> string(45) "Field 'Username' doesn't have a default value" } } } ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#87 (15) { ["_paramSources":protected]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri":protected]=> string(33) "/public/index/login?page=register" ["_baseUrl":protected]=> string(7) "/public" ["_basePath":protected]=> NULL ["_pathInfo":protected]=> string(12) "/index/login" ["_params":protected]=> array(3) { ["controller"]=> string(5) "index" ["action"]=> string(5) "login" ["module"]=> string(7) "default" } ["_rawBody":protected]=> NULL ["_aliases":protected]=> array(0) { } ["_dispatched":protected]=> bool(true) ["_module":protected]=> string(7) "default" ["_moduleKey":protected]=> string(6) "module" ["_controller":protected]=> string(5) "index" ["_controllerKey":protected]=> string(10) "controller" ["_action":protected]=> string(5) "login" ["_actionKey":protected]=> string(6) "action" } } }

      Exception information:

      Message:

      Fatal error: Call to a member function getMessage() on a non-object in /home/sybextestbanks/public_html/application/views/scripts/error/error.phtml on line 9

       

      Any help will be appreciated!

      Thank you.