No announcement yet.

Need help with database error

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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 : Referrer : IP Address : Username : Classname : vB_Database_MySQLi MySQL Version : Server : 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.

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


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


      • #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.

        TalkNewsUK - My vBulletin 5.6.3 Demo
        AdminAmmo - My Cloud Demo


        Related Topics