Admin Billing, gateway, settings, transactions.PHP4.9.4p1

    • 474 posts
    September 12, 2017 6:56 AM EDT

    Hei folks. I just got an issue on my php admin.
    When I try to view my Gateway, settings, transaction from my admin billings , the pages are not being connected / fetched..??

    I have cleared my error logs (so that I get just fresh error logs ) for each title and carried out the same request but I don't understand what I'm reading.

    all I can gather is either its a fetch issue or a connection issue.

    I'm using the latest php 4.9.4p1.

    Any ideas ?

    mikel.

    • Moderator
    • 6923 posts
    September 12, 2017 7:17 AM EDT

    Hi Mikel,

    Please paste the error message here. Use the button to the right of the smiley button and it will popup a box to input your code. That will keep it safe for posting if any codes are shown. You can sanitize out your site name and info if you need to. 

    • 474 posts
    September 12, 2017 9:34 AM EDT

    Hi Donna
    Here is a copy of the error log.
    I just did a fresh test and copied the latest report. pretty much the same for , gateways, settings and transactions. subjects plans and subscriptions are not affected and working as required.

    Thanks, mikel

    #2 /home/majuunac/public_html/application/libraries/Zend/Db/Table/Abstract.php(1392): Payment_Model_DbTable_Gateways->_fetch(Object(Zend_Db_Table_Select)) #3 /home/majuunac/public_html/application/modules/Payment/Form/Admin/Transaction/Filter.php(52): Zend_Db_Table_Abstract->fetchAll() #4 /home/majuunac/public_html/application/libraries/Zend/Form.php(239): Payment_Form_Admin_Transaction_Filter->init() #5 /home/majuunac/public_html/application/libraries/Engine/Form.php(138): Zend_Form->__construct(NULL) #6 /home/majuunac/public_html/application/modules/Payment/controllers/AdminIndexController.php(50): Engine_Form->__construct() #7 /home/majuunac/public_html/application/libraries/Zend/Controller/Action.php(516): Payment_AdminIndexController->indexAction() #8 /home/majuunac/public_html/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('indexAction') #9 /home/majuunac/public_html/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #10 /home/majuunac/public_html/application/modules/Core/Bootstrap.php(84): Zend_Controller_Front->dispatch() #11 /home/majuunac/public_html/application/libraries/Engine/Application.php(160): Core_Bootstrap->run() #12 /home/majuunac/public_html/application/index.php(223): Engine_Application->run() #13 /home/majuunac/public_html/index.php(25): include('/home/majuunac/...') #14 {main} 2017-09-12T13:28:06+00:00 CRIT (2): Error Code: 00f47d Zend_Json_Exception: Decoding failed in /home/majuunac/public_html/application/libraries/Zend/Json.php:99 Stack trace: #0 /home/majuunac/public_html/application/libraries/Engine/Db/Table.php(213): Zend_Json::decode('\xA9s\xAD\x95\x8A1\x00\xFEWu\xC7K}K\xFD...') #1 /home/majuunac/public_html/application/modules/Payment/Model/DbTable/Gateways.php(89): Engine_Db_Table->_unserializeColumns(Array) #2 /home/majuunac/public_html/application/libraries/Zend/Db/Table/Abstract.php(1392): Payment_Model_DbTable_Gateways->_fetch(Object(Zend_Db_Table_Select)) #3 /home/majuunac/public_html/application/modules/Payment/controllers/AdminSettingsController.php(32): Zend_Db_Table_Abstract->fetchAll() #4 /home/majuunac/public_html/application/libraries/Zend/Controller/Action.php(516): Payment_AdminSettingsController->indexAction() #5 /home/majuunac/public_html/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('indexAction') #6 /home/majuunac/public_html/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #7 /home/majuunac/public_html/application/modules/Core/Bootstrap.php(84): Zend_Controller_Front->dispatch() #8 /home/majuunac/public_html/application/libraries/Engine/Application.php(160): Core_Bootstrap->run() #9 /home/majuunac/public_html/application/index.php(223): Engine_Application->run() #10 /home/majuunac/public_html/index.php(25): include('/home/majuunac/...') #11 {main} 2017-09-12T13:28:11+00:00 CRIT (2): Error Code: 4d5cdb Zend_Json_Exception: Decoding failed in /home/majuunac/public_html/application/libraries/Zend/Json.php:99 Stack trace: #0 /home/majuunac/public_html/application/libraries/Engine/Db/Table.php(213): Zend_Json::decode('\xA9s\xAD\x95\x8A1\x00\xFEWu\xC7K}K\xFD...') #1 /home/majuunac/public_html/application/modules/Payment/Model/DbTable/Gateways.php(89): Engine_Db_Table->_unserializeColumns(Array) #2 /home/majuunac/public_html/application/libraries/Zend/Db/Table/Abstract.php(1392): Payment_Model_DbTable_Gateways->_fetch(Object(Zend_Db_Table_Select)) #3 /home/majuunac/public_html/application/libraries/Zend/Paginator/Adapter/DbTableSelect.php(46): Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select)) #4 /home/majuunac/public_html/application/libraries/Zend/Paginator.php(797): Zend_Paginator_Adapter_DbTableSelect->getItems(0, 10) #5 /home/majuunac/public_html/application/libraries/Zend/Paginator.php(626): Zend_Paginator->getItemsByPage(1) #6 /home/majuunac/public_html/application/libraries/Zend/Paginator.php(1118): Zend_Paginator->getCurrentItems() #7 /home/majuunac/public_html/application/libraries/Zend/Paginator.php(862): Zend_Paginator->_createPages(Object(Zend_Paginator_ScrollingStyle_Sliding)) #8 /home/majuunac/public_html/application/libraries/Zend/View/Helper/PaginationControl.php(119): Zend_Paginator->getPages(NULL) #9 /home/majuunac/public_html/application/libraries/Zend/View/Abstract.php(349): Zend_View_Helper_PaginationControl->paginationControl(Object(Zend_Paginator)) #10 /home/majuunac/public_html/application/modules/Payment/views/scripts/admin-gateway/index.tpl(48): Zend_View_Abstract->__call('paginationContr...', Array) #11 /home/majuunac/public_html/application/libraries/Zend/View.php(157): include('/home/majuunac/...') #12 /home/majuunac/public_html/application/libraries/Zend/View/Abstract.php(888): Zend_View->_run('/home/majuunac/...') #13 /home/majuunac/public_html/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(912): Zend_View_Abstract->render() #14 /home/majuunac/public_html/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(933): Zend_Controller_Action_Helper_ViewRenderer->renderScript('admin-gateway/i...', NULL) #15 /home/majuunac/public_html/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(972): Zend_Controller_Action_Helper_ViewRenderer->render() #16 /home/majuunac/public_html/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch() #17 /home/majuunac/public_html/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch() #18 /home/majuunac/public_html/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('indexAction') #19 /home/majuunac/public_html/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #20 /home/majuunac/public_html/application/modules/Core/Bootstrap.php(84): Zend_Controller_Front->dispatch() #21 /home/majuunac/public_html/application/libraries/Engine/Application.php(160): Core_Bootstrap->run() #22 /home/majuunac/public_html/application/index.php(223): Engine_Application->run() #23 /home/majuunac/public_html/index.php(25): include('/home/majuunac/...') #24 {main}
    • Moderator
    • 6923 posts
    September 12, 2017 10:01 AM EDT

    Thanks for posting that.

    Are you using Paypal?

    Is it in "test mode" which is only set via database?

    Do you have support with us? If not, I can try testing on my own local site.

    • 474 posts
    September 12, 2017 1:04 PM EDT

    Hi Donna.
    answer to your questions:
    Paypal: yes

    Test Mode: paypal is set , live / active
    * To my knowledge the paypal status has not been changed by myself. I will check on my paypal account and check setting there incase paypal has altered a setting on my paypal account.
    * If issue is in the database setting, where would I be looking, ? on my site admin or hosting server DB ?

    Support: I don't have support with you at this time.

    Many thanks
    mikel

     

    • Moderator
    • 6923 posts
    September 13, 2017 5:34 AM EDT

    Hi Mikel,

    The setting I mentioned is only in the db so you didn't set it so we can rule that out.

    What version of PHP is installed on your server? If you aren't sure, you can check in your server information section. 

    • 474 posts
    September 13, 2017 1:28 PM EDT

    Hi donna.

    I have checked paypal account and all is set correctly

    My php version is set at php7 on my server, at tmdhosting.

    Any way ive noticed there is a new 4.9.4p2 upgrade, so I will update and see if that changes things.
    I am going to do fresh error logs on / payment and issues.

    mikel.

    • Moderator
    • 6923 posts
    September 13, 2017 2:09 PM EDT

    You may need our support to check on your site if it's not resolved. Some things are harder to pinpoint from a forum post. 

    • 474 posts
    September 14, 2017 8:16 AM EDT

    Hei.
    Thanks Donna.

    I am going to see if TMD Hosting tech can check the DB settings just in case a external connection or something has closed / turned off.

    Most likely the issue is as you say, just a DB error somewhere.

    Il be in touch soon about support from scripttechs / BryZar.

    mikel.

    • Moderator
    • 6923 posts
    September 14, 2017 8:23 AM EDT

    If it's not a connection issue on the server, please feel free to get SocialEngine support. I do offer services via my BryZar but I was meaning our SocialEngine support for this oneRight now, I can't rule out a bug either. I am not seeing this issue on my testing site though. However, that doesn't mean there couldn't be a bug. We also haven't seen anyone posting this issue other than you but that also doesn't mean it couldn't be a bug still. Hard to say without seeing the issue.

    • 474 posts
    September 15, 2017 8:41 AM EDT

    Hi Donna.

    thanks, il keep you posted.

    mikel.

    • Moderator
    • 6923 posts
    September 15, 2017 9:08 AM EDT

    Thank you Mikel. Sorry for whatever this issue is. It's never fun having issues. I hope it can be resolved for you quickly though.

    • 474 posts
    September 15, 2017 10:14 AM EDT

    Hi Donna.
    Its ok.. its not a major problem as it does not effect the running of the site. I can just have free membership until issue is resolved. its just annoying more than anything.

    just on a Database enquiry. I know I'm a bit of a numpty but I cant seem to find my database on my tmdh CPadmin.
    I know I go into my files but then I get lost as to the exact path to take that will lead me to Database. I know its there somewhere just rolling on floor laughing at me.

    starting at: public_html > ???

     

    thanks
    mikel.

    • Moderator
    • 6923 posts
    September 15, 2017 10:26 AM EDT

    Check in your cpanel for Phpmyadmin or Database link. In most cases it is called phpmyadmin on the tab. It won't be in file manager but don't mess in database unless you really know what you are doing or you can destroy your site completely. Make a backup of it before you touch anything if you do fiddle with it.

    • 474 posts
    September 15, 2017 11:37 AM EDT

    hi Donna.

    Thanks.
    Ive learned not to play with my toys. back in my fox days I broke my site. good job I had backups so was easily repaired.

    Thanks again.

    mikel