Need help with database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Elyk
    Senior Member
    • Sep 2003
    • 292
    • 4.2.x

    Need help with database error

    Usually I can figure out most database errors but not this time. This has just started to pop up, been restoring database and files on site as another admin did a bunch of stupid moves as he said he knew what he was doing.

    Database error in vBulletin 4.2.5: Invalid SQL: SELECT dateline, userid FROM customavatar WHERE userid =; 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 '' at line 1
    Error Number : 1064 Request Date : Wednesday, September 12th 2018 @ 11:05:35 AM Error Date : Wednesday, September 12th 2018 @ 11:05:35 AM

    Script : http://xxxxxx.com/forum/list.php/author/1225-mrkromer Referrer : IP Address : 136.243.37.219 Username : Classname : vB_Database_MySQLi MySQL Version : Server : 204.197.251.164 User Agent :

    Stack Trace: #0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395
    #1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 505
    #2 vB_Database->query_first() called in [path]/includes/class_bootstrap.php(433) : eval()'d code on line 106
    #3 eval() called in [path]/includes/class_bootstrap.php on line 433
    #4 vB_Bootstrap->process_templates() called in [path]/includes/class_core.php on line 4391
    #5 vB_Template->__construct() called in [path]/includes/class_core.php on line 4349
    #6 vB_Template::create() called in [path]/includes/functions_navigation.php on line 842
    #7 render_navigation() called in [path]/includes/functions_navigation.php on line 864
    #8 render_navbar_template() called in [path]/includes/functions.php on line 3707
    #9 standard_error() called in [path]/includes/functions.php on line 2161
    #10 vbsetcookie() called in [path]/includes/class_core.php on line 3942
    #11 vB_Session->fetch_session() called in [path]/includes/class_core.php on line 3734
    #12 vB_Session->__construct() called in [path]/includes/init.php on line 659
    #13 require_once([path]/includes/init.php) called in [path]/includes/class_bootstrap.php on line 101
    #14 vB_Bootstrap->init() called in [path]/includes/class_bootstrap.php on line 72
    #15 vB_Bootstrap->bootstrap() called in [path]/vb/bootstrap.php on line 33
    #16 require_once([path]/vb/bootstrap.php) called in [path]/list.php on line 30
    Last edited by Elyk; Wed 12 Sep '18, 3:21am.
  • Elyk
    Senior Member
    • Sep 2003
    • 292
    • 4.2.x

    #2
    Figured it out, was config.php file.

    Comment

    • MentorBR
      New Member
      • Jul 2019
      • 9
      • 4.2.x

      #3
      Originally posted by Elyk
      Figured it out, was config.php file.
      Hello, I have the same problem, what did you do to solve?

      Comment

      • Mark.B
        vBulletin Support
        • Feb 2004
        • 24288
        • 6.0.X

        #4
        It is unlikely your error is 100% identical.

        Please start your own topic with the full detailed error.

        Using someone else’s fix can easily break your site.
        MARK.B
        vBulletin Support
        ------------
        My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
        My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

        Comment

        Related Topics

        Collapse

        Working...