Server error on Alerts

Discussion in '[bd] Widget Framework' started by anto74, Mar 18, 2014.

  1. anto74

    anto74 Member

    Hi @xfrocks
    when user view alerts this is server error

    error_alerts.jpg

    And in Error Log in AdminCP

    Code:
    XenForo_Exception: Cannot load class using XFCP. Load the class using the correct loader first. - library/XenForo/Autoloader.php:108
    Generato Da: brunetto51, 1 minuto fa
    Analisi dello Stack
    #0 [internal function]: XenForo_Autoloader->autoload('XFCP_WidgetFram...')
    #1 /home/emtvqmnh/public_html/library/WidgetFramework/XenForo/BbCode/Formatter/Text.php(4): spl_autoload_call('XFCP_WidgetFram...')
    #2 /home/emtvqmnh/public_html/library/XenForo/Autoloader.php(119): include('/home/emtvqmnh/...')
    #3 [internal function]: XenForo_Autoloader->autoload('WidgetFramework...')
    #4 [internal function]: spl_autoload_call('WidgetFramework...')
    #5 /home/emtvqmnh/public_html/library/XenForo/AlertHandler/Abstract.php(81): unserialize('a:66:{s:7:"user...')
    #6 /home/emtvqmnh/public_html/library/XenForo/Model/Alert.php(323): XenForo_AlertHandler_Abstract->prepareAlert(Array, Array)
    #7 /home/emtvqmnh/public_html/library/XenForo/Model/Alert.php(289): XenForo_Model_Alert->prepareAlert(Array, 'Nobita_Teams_Al...', Array)
    #8 /home/emtvqmnh/public_html/library/XenForo/Model/Alert.php(80): XenForo_Model_Alert->prepareAlerts(Array, Array)
    #9 /home/emtvqmnh/public_html/library/XenForo/ControllerPublic/Account.php(35): XenForo_Model_Alert->getAlertsForUser(2509, 'fetchRecent', Array)
    #10 /home/emtvqmnh/public_html/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_Account->actionAlerts()
    #11 /home/emtvqmnh/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #12 /home/emtvqmnh/public_html/index.php(13): XenForo_FrontController->run()
    #13 {main}
    Stato Richiesta
    array(3) {
      ["url"] => string(40) "http://www.macroforum.org/account/alerts"
      ["_GET"] => array(0) {
      }
      ["_POST"] => array(0) {
      }
    }
     
  2. xfrocks

    xfrocks XenForo rocks!
    Staff Member

    Please run this query

    Code:
    SELECT * FROM xf_user_alert WHERE user_id = 2509
    You can post the response here or in a conversation.
     
  3. anto74

    anto74 Member

    Code:
    Full texts   
    alert_id
    alerted_user_id
    User being alerted
    user_id
    User who did the action that caused the alert
    username
    Corresponds to user_id
    content_type
    eg: trophy
    content_id
    action
    eg: edit
    event_date
    view_date
    Time when this was viewed by the alerted user
    extra_data
    Serialized. Stores any extra data relevant to the alert
    
    Edit Edit
    Copy Copy
    Delete Delete
    28503
    1961
    2509
    brunetto51
    706f7374
    150887
    696e73657274
    1393749031
    1393944709
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    28521
    3538
    2509
    brunetto51
    706f7374
    150897
    696e73657274
    1393752298
    1393754038
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    28523
    3538
    2509
    brunetto51
    706f7374
    150898
    696e73657274
    1393753420
    1393754038
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    28549
    1961
    2509
    brunetto51
    706f7374
    150910
    696e73657274
    1393767859
    1393944709
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    28566
    1961
    2509
    brunetto51
    706f7374
    150917
    696e73657274
    1393776295
    1393944709
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    28724
    2017
    2509
    brunetto51
    706f7374
    151004
    696e73657274
    1393850412
    1393869891
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    28789
    3538
    2509
    brunetto51
    706f7374
    151029
    696e73657274
    1393872724
    1393922914
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    28790
    5150
    2509
    brunetto51
    706f7374
    151029
    696e73657274
    1393872724
    1393967540
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    29176
    2926
    2509
    brunetto51
    706f7374
    151200
    696e73657274
    1394096672
    1394301211
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    29177
    3538
    2509
    brunetto51
    706f7374
    151200
    696e73657274
    1394096672
    1394124308
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    29178
    1955
    2509
    brunetto51
    706f7374
    151200
    696e73657274
    1394096672
    1394097995
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    29179
    3571
    2509
    brunetto51
    706f7374
    151200
    696e73657274
    1394096672
    1394671754
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    29260
    3538
    2509
    brunetto51
    736f6e6e625f78656e67616c6c6572795f70686f746f
    6668
    6c696b65
    1394146187
    1394177316
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    29428
    5150
    2509
    brunetto51
    706f7374
    151215
    72617465
    1394263763
    1394313392
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    29496
    5389
    2509
    brunetto51
    706f7374
    151296
    72617465
    1394346929
    1394389986
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    29528
    2017
    2509
    brunetto51
    706f7374
    151352
    696e73657274
    1394368587
    1394385187
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    29529
    3307
    2509
    brunetto51
    706f7374
    151352
    696e73657274
    1394368587
    1394443885
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    29530
    3538
    2509
    brunetto51
    706f7374
    151352
    696e73657274
    1394368587
    1394369717
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    30073
    3307
    2509
    brunetto51
    706f7374
    151602
    696e73657274
    1394783673
    0
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    30132
    1955
    2509
    brunetto51
    706f7374
    151631
    696e73657274
    1394807589
    1394809943
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    30135
    2519
    2509
    brunetto51
    736f6e6e625f78656e67616c6c6572795f70686f746f
    7371
    636f6d6d656e74
    1394808774
    1394958948
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    30199
    5245
    2509
    brunetto51
    706f7374
    151297
    72617465
    1394869870
    0
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    30200
    3538
    2509
    brunetto51
    706f7374
    151663
    696e73657274
    1394870263
    1394871286
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    30219
    1961
    2509
    brunetto51
    706f7374
    151671
    696e73657274
    1394902757
    1394961658
    [BLOB - 0 B]
    
    Edit Edit
    Copy Copy
    Delete Delete
    30231
    1961
    2509
    brunetto51
    706f7374
    151677
    696e73657274
    1394906554
    1394961658
    [BLOB - 0 B]
    With selected: Check All With selected: Change Change Delete Delete Export Export
                     |            Number of rows:
    Query results operations
    Print view Print view  Print view (with full texts) Print view (with full texts)  Export Export  Display chart Display chart  Create view Create view
    
    Open new phpMyAdmin window
     
  4. anto74

    anto74 Member

    I have not response message, only this table
     
  5. xfrocks

    xfrocks XenForo rocks!
    Staff Member

    Probably a better idea to export it as SQL and send it as file instead.
     
    anto74 likes this.
  6. anto74

    anto74 Member

    Table attached :)
     

    Attached Files:

  7. xfrocks

    xfrocks XenForo rocks!
    Staff Member

    Ah, my bad, please do it again with this query

    Code:
    SELECT * FROM xf_user_alert WHERE alerted_user_id = 2509
     
  8. anto74

    anto74 Member

    table attached
     

    Attached Files:

  9. xfrocks

    xfrocks XenForo rocks!
    Staff Member

  10. xfrocks

    xfrocks XenForo rocks!
    Staff Member

    What is your username at xenforo.com btw?
     
  11. anto74

    anto74 Member

    Ok, now i contact nobita kun :)
    My username is macroforum :)
    Thanks!
     
  12. xfrocks

    xfrocks XenForo rocks!
    Staff Member

    Ah right, I forgot. Added you to the conversation.
     
    anto74 likes this.
Loading...