Can't display profiles

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • oxrageous
    New Member
    • Jun 2014
    • 24
    • 5.1.x

    Can't display profiles

    Interesting issue here that's only happening to some of my members, including myself. When you click on someone's profile, you get this error:

    http://tinypic.com/r/2en81nb/8

    As far as I know it's only happening to a small percentage of people, people that are in different user groups.

  • BirdOPrey5
    Senior Member
    • Jul 2008
    • 9613
    • 5.6.3

    #2
    First step is to go to the root config.php file for your site (this is the config.php file NOT in your /core/includes/ directory) and enable debug mode so you get more info about the error. Once you get the real/full error message paste it here and shut off debug mode again.

    To enable debug mode change

    PHP Code:
    $config['debug'] = false

    to

    PHP Code:
    $config['debug'] = true

    Comment

    • oxrageous
      New Member
      • Jun 2014
      • 24
      • 5.1.x

      #3
      An internal error has occurred and the module cannot be displayed. Template: widget_profile => profile_activity => display_contenttype_conversationreply_Text => conversation_posthistory Controller: likessummary Method:getLikesSummary Arguments: Array ( [0] => Array ( [nodeid] => 46746 [routeid] => 62 [contenttypeid] => 22 [publishdate] => 1410303858 [unpublishdate] => [userid] => 62 [groupid] => [authorname] => URGatorBait [description] => :clap: [title] => [htmltitle] => [parentid] => 5946 [urlident] => [displayorder] => [starter] => 5946 [created] => 1410303858 [lastcontent] => 1410303858 [lastcontentid] => 46746 [lastcontentauthor] => URGatorBait [lastauthorid] => 62 [lastprefixid] => [textcount] => 0 [textunpubcount] => 0 [totalcount] => 0 [totalunpubcount] => 0 [ipaddress] => 68.202.84.117 [showpublished] => 1 [oldid] => [oldcontenttypeid] => [nextupdate] => [lastupdate] => 1410303858 [featured] => 0 [CRC32] => 1710857839 [taglist] => [inlist] => 1 [protected] => 0 [setfor] => 0 [votes] => 0 [hasphoto] => 0 [hasvideo] => 0 [deleteuserid] => [deletereason] => [open] => 1 [showopen] => 1 [sticky] => 0 [approved] => 1 [showapproved] => 1 [viewperms] => 2 [commentperms] => 1 [nodeoptions] => 138 [prefixid] => [iconid] => 0 [public_preview] => 0 [dbtech_ajaxthreads_cannotautoupdate] => 0 [dbtech_ajaxthreads_cannotmanualupdate] => 0 [dbtech_ajaxthreads_refreshthread] => 1 [dbtech_ajaxthreads_refreshthread_override] => 0 [dbtech_thanks_disabledbuttons] => 0 [dbtech_thanks_requiredbuttons_content] => 0 [dbtech_thanks_requiredbuttons_attach] => 0 [dbtech_thanks_firstpostonly] => 0 [text_nodeid] => 46746 [previewtext] => [previewimage] => [previewvideo] => [imageheight] => [imagewidth] => [rawtext] =>
      Originally posted by Turk182
      :clap: [moderated] => [pagetextimages] => [pagetext] => [htmlstate] => off [allowsmilie] => 0 [showsignature] => 0 [attach] => Array ( ) [infraction] => 0 [reportnodeid] => 0 [channelroute] => 61 [channeltitle] => The Lounge [channelid] => 16 [starterroute] => 62 [startertitle] => URGatorBait's post padding thread for everyone to enjoy. [starterauthorname] => MJMGator [starterprefixid] => [starteruserid] => 18 [starterlastcontentid] => 46746 [startertotalcount] => 1916 [starterurlident] => urgatorbait-s-post-padding-thread-for-everyone-to-enjoy [deleteusername] => [lastauthorname] => URGatorBait [edit_reason] => [edit_userid] => [edit_username] => [edit_dateline] => [hashistory] => [starternodeoptions] => 138 [channelnodeoptions] => 138 [contenttypeclass] => Text [createpermissions] => Array ( [vbforum_channel] => 1 [vbforum_text] => 1 [vbforum_report] => 1 [vbforum_gallery] => 1 [vbforum_poll] => 1 [vbforum_attach] => 1 [vbforum_photo] => 1 [vbforum_privatemessage] => 1 [vbforum_video] => 1 [vbforum_link] => 1 ) [moderatorperms] => Array ( [caneditposts] => 1 [candeleteposts] => 1 [canopenclose] => 1 [caneditthreads] => 1 [canmanagethreads] => 16 [canannounce] => 32 [canmoderateposts] => 1 [canmoderateattachments] => 128 [canmassmove] => 256 [canmassprune] => 1 [canviewips] => 1024 [canviewprofile] => 1 [canbanusers] => 4096 [canunbanusers] => 1 [newthreademail] => 1 [newpostemail] => 1 [cansetpassword] => 1 [canremoveposts] => 1 [caneditsigs] => 1 [caneditavatar] => 1 [caneditpoll] => 1 [caneditprofilepic] => 1 [caneditreputation] => 1 [cansetfeatured] => 8388608 [canmoderatetags] => 16777216 [canaddowners] => 33554432 [canmove] => 1 [candeletethread] => 0 [candeletepost] => 1 [cansoftdeleteposts] => 1 [canharddeleteposts] => 1 [canundeleteposts] => 2 ) [channeltype] => forum [canedit] => 1 [canview] => 1 [canmove] => 0 [candeleteposts] => 1 [candeletethread] => 0 [canopenclose] => 0 [canremove] => 1 [canundeleteposts] => 2 [showUnpublishedNotice] => 2 [canharddeleteposts] => 1 [moderate] => Array ( [candeleteposts] => 0 [canmoderateposts] => 1 ) [canmoderateposts] => 1 [canmoderate] => 1 [textcount_1] => 1 [totalcount_1] => 1 [allow_post] => 1 [moderate_comments] => 0 [approve_membership] => 1 [invite_only] => 0 [autoparselinks] => 0 [disablesmilies] => 0 [disable_bbcode] => 0 [hide_title] => 0 [hide_author] => 0 [hide_publishdate] => 0 [display_fullincategory] => 0 [display_pageviews] => 0 [hide_comment_count] => 0 [can_flag] => 1 [caninfract] => 1 [canviewnodeinfraction] => 1 [canseewholiked] => 1 [can_comment] => 1 [canreply] => 0 [permissions] => Array ( [canedit] => 1 [canmoderate] => 1 [canvote] => 1 [canuserep] => 1 [canremove] => 1 [can_flag] => 1 [canviewthreads] => 1 [canviewothers] => 1 [caninfract] => 1 [canviewnodeinfraction] => 1 [canseewholiked] => 1 [can_comment] => 1 ) [signature] =>
      GO GATORS [canSign] => 1 [musername] => URGatorBait [online] => online [reputation] => 33 [showreputation] => 0 [reputationlevelid] => 5 [reputationpower] => 3 [reputationimg] => Array ( [type] => pos [level] => reputation5 [bars] => 0 ) [canedittitle] => 0 [userinfo] => Array ( [userid] => 62 [username] => URGatorBait [rank] => [usertitle] => Wobble's Dad [joindate] => 1402607640 [posts] => 2016 [customtitle] => 2 [userfield] => Array ( ) ) [photocount] => 0 [nodeVoted] => 0 [attachments] => Array ( ) [avatar] => Array ( [hascustom] => 1 [avatarpath] => image.php?userid=62&thumb=1&dateline=1404321412 ) [avatar_last_poster] => Array ( [hascustom] => 1 [avatarpath] => image.php?userid=62&thumb=1&dateline=1404321412 ) [isVisitorMessage] => 0 [subscribed] => 0 [joined] => ) ) Errors:
      Array
      (
      [0] => Array
      (
      [0] => exception_trace
      [1] => #0 /home/gatorcha/public_html/core/vb/database/mysqli.php(173): vB_Database->halt()
      #1 /home/gatorcha/public_html/core/vb/database.php(519): vB_Database_MySQLi->execute_query(true, Object(mysqli))
      #2 /home/gatorcha/public_html/core/vb/db/result.php(122): vB_Database->query_read('\n\t\t\t\tSSLECT clo...')
      #3 /home/gatorcha/public_html/core/vb/db/result.php(59): vB_dB_Result->rewind()
      #4 /home/gatorcha/public_html/core/vb/db/query/stored.php(103): vB_dB_Result->__construct(Object(vB_Database_MySQLi), '\n\t\t\t\tSSLECT clo...', false)
      #5 /home/gatorcha/public_html/core/vb/db/assertor.php(282): vB_dB_Query_Stored->execSQL()
      #6 /home/gatorcha/public_html/core/vb/db/assertor.php(624): vB_dB_Assertor->assertQuery('Rellectlikessum...', Array, false)
      #7 /home/gatorcha/public_html/core/packages/rellectlikessummary/api/likessummary.php(76): vB_dB_Assertor->getRows('Rellectlikessum...', Array)
      #8 /home/gatorcha/public_html/core/packages/rellectlikessummary/api/likessummary.php(102): Rellectlikessummary_Api_Likessummary->fetchWhoVoted(Array)
      #9 [internal function]: Rellectlikessummary_Api_Likessummary->getLikesSummary(NULL, Array)
      #10 /home/gatorcha/public_html/core/vb/api/wrapper.php(139): call_user_func_array(Array, Array)
      #11 [internal function]: vB_Api_Wrapper->__call('getLikesSummary', Array)
      #12 [internal function]: vB_Api_Wrapper->getLikesSummary(Array)
      #13 /home/gatorcha/public_html/includes/api/interface/collapsed.php(87): call_user_func_array(Array, Array)
      #14 /home/gatorcha/public_html/includes/vb5/template/runtime.php(491): Api_Interface_Collapsed->callApi('likessummary', 'getLikesSummary', Array, false, true)
      #15 /home/gatorcha/public_html/includes/vb5/template.php(280) : eval()'d code(29): vB5_Template_Runtime:arseData('likessummary', 'getLikesSummary', Array)
      #16 /home/gatorcha/public_html/includes/vb5/template.php(280): eval()
      #17 /home/gatorcha/public_html/includes/vb5/template/cache.php(164): vB5_Template->render(false)
      #18 /home/gatorcha/public_html/includes/vb5/template.php(302): vB5_Template_Cache->replacePlaceholders('\r\n\n\r\r\r\r\r\r\r\r\t\t\n\n....)
      #19 /home/gatorcha/public_html/includes/vb5/template/cache.php(164): vB5_Template->render(false)
      #20 /home/gatorcha/public_html/includes/vb5/template.php(302): vB5_Template_Cache->replacePlaceholders('\r\n\n\n\n\n\n\n\n\n\n\n\n\r\r....)
      #21 /home/gatorcha/public_html/includes/vb5/template/cache.php(164): vB5_Template->render(false)
      #22 /home/gatorcha/public_html/includes/vb5/template.php(302): vB5_Template_Cache->replacePlaceholders('\r\n\n\r\r\r\r\r\r\t\t\n\n\r\r....)
      #23 /home/gatorcha/public_html/includes/vb5/template/cache.php(164): vB5_Template->render(false)
      #24 /home/gatorcha/public_html/includes/vb5/template.php(302): vB5_Template_Cache->replacePlaceholders('<!-- BEGIN: hea...')
      #25 /home/gatorcha/public_html/includes/vb5/frontend/controller/page.php(220): vB5_Template->render()
      #26 [internal function]: vB5_Frontend_Controller_Page->index(62, '$pagenum', '8', 'URGatorBait', 'URGatorBait', true)
      #27 /home/gatorcha/public_html/index.php(72): call_user_func_array(Array, Array)
      #28 {main}
      )

      [1] => Array
      (
      [0] => errormsg
      [1] => Error
      Database error in vBulletin 5.1.3:

      Invalid SQL:

      SELECT closure.child as nodeid, reputation.reputation, user.userid, user.username, user.usergroupid
      FROM vb_closure AS closure
      LEFT JOIN vb_reputation AS reputation ON (reputation.nodeid = closure.child)
      LEFT JOIN vb_user AS user ON (user.userid = reputation.whoadded)
      WHERE closure.parent = 5946
      ORDER BY closure.child ASC, reputation.dateline DESC
      LIMIT -40, 0

      /**fetchwhovoted**/;

      MySQL Error : 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 '-40, 0

      /**fetchwhovoted**/' at line 7
      Error Number : 1064
      Request Date : Wednesday, September 10th 2014 @ 12:36:54 AM
      Error Date : Wednesday, September 10th 2014 @ 12:36:54 AM
      Script : http:///member/62-urgatorbait
      Referrer : http://gatorchatter.com/
      IP Address : 99.127.60.131
      Username : oxrageous
      Classname : vB_Database_MySQLi
      MySQL Version : 5.5.36-cll


      Stack Trace:
      #line vB_Database->halt() called in [path]/vb/database/mysqli.php on line 173
      #line vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 519
      #line vB_Database->query_read() called in [path]/vb/db/result.php on line 122
      #line vB_dB_Result->rewind() called in [path]/vb/db/result.php on line 59
      #line vB_dB_Result->__construct() called in [path]/vb/db/query/stored.php on line 103
      #line vB_dB_Query_Stored->execSQL() called in [path]/vb/db/assertor.php on line 282
      #line vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 624
      #line vB_dB_Assertor->getRows() called in [path]/packages/rellectlikessummary/api/likessummary.php on line 76
      #line Rellectlikessummary_Api_Likessummary->fetchWhoVoted() called in [path]/packages/rellectlikessummary/api/likessummary.php on line 102
      #line Rellectlikessummary_Api_Likessummary->getLikesSummary() called in on line
      #line call_user_func_array() called in [path]/vb/api/wrapper.php on line 139
      #line vB_Api_Wrapper->__call() called in on line
      #line vB_Api_Wrapper->getLikesSummary() called in on line
      #line call_user_func_array() called in /home/gatorcha/public_html/includes/api/interface/collapsed.php on line 87
      #line Api_Interface_Collapsed->callApi() called in /home/gatorcha/public_html/includes/vb5/template/runtime.php on line 491
      #line vB5_Template_Runtime:arseData() called in /home/gatorcha/public_html/includes/vb5/template.php(280) : eval()'d code on line 29
      #line eval() called in /home/gatorcha/public_html/includes/vb5/template.php on line 280
      #line vB5_Template->render() called in /home/gatorcha/public_html/includes/vb5/template/cache.php on line 164
      #line vB5_Template_Cache->replacePlaceholders() called in /home/gatorcha/public_html/includes/vb5/template.php on line 302
      #line vB5_Template->render() called in /home/gatorcha/public_html/includes/vb5/template/cache.php on line 164
      #line vB5_Template_Cache->replacePlaceholders() called in /home/gatorcha/public_html/includes/vb5/template.php on line 302
      #line vB5_Template->render() called in /home/gatorcha/public_html/includes/vb5/template/cache.php on line 164
      #line vB5_Template_Cache->replacePlaceholders() called in /home/gatorcha/public_html/includes/vb5/template.php on line 302
      #line vB5_Template->render() called in /home/gatorcha/public_html/includes/vb5/template/cache.php on line 164
      #line vB5_Template_Cache->replacePlaceholders() called in /home/gatorcha/public_html/includes/vb5/template.php on line 302
      #line vB5_Template->render() called in /home/gatorcha/public_html/includes/vb5/frontend/controller/page.php on line 220
      #line vB5_Frontend_Controller_Page->index() called in on line
      #line call_user_func_array() called in /home/gatorcha/public_html/index.php on line 72

      occurred in file /home/gatorcha/public_html/core/vb/database.php on line 1253
      )

      )

      Comment

      • BirdOPrey5
        Senior Member
        • Jul 2008
        • 9613
        • 5.6.3

        #4
        Have you tried disabling all your add-ons (I see you are usig dbtech's live thread at a minimum) to see if you still get the problem with all mods disabled?

        Comment

        Related Topics

        Collapse

        Working...