Announcement

Collapse
No announcement yet.

SQL errors, coming from out of nowhere

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL errors, coming from out of nowhere

    Hey all, last night my board started getting alot of SQL errors for what I thought was no real reason. I was running version 3.5.1, but thinking it would solve the problem, I renewed my liscense and upgraded to 3.6.0. The upgrade went smooth and easy, but I am still getting the same weird SQL errors:

    Code:
    Database error in vBulletin 3.6.0:
    
    Invalid SQL:
    
                SELECT MIN(postid) AS postid
                FROM thadpg_post
                WHERE threadid = 5089
                    AND visible = 1
                    AND dateline > 1156554044
                    AND userid NOT IN (64.110.251.89)
                LIMIT 1;
    
    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 '.251.89)
                LIMIT 1' at line 6
    Error Number : 1064
    Date         : Friday, August 25th 2006 @ 06:58:11 PM
    Script       : http://www.thadpg.com/forums/showthread.php?goto=newpost&t=5089
    Referrer     : http://www.thadpg.com/forums/index.php
    IP Address   : 68.3.73.153
    Username     : Bojangles
    Classname    : vb_database
    I'm not sure what happened.. it is saying that my SQL syntax is invalid. This was the same errors that I was getting on version 3.5.1.. blah.

    Any suggestions? Any help is appreciated.

    Thanks.

  • #2
    SQL Syntax errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem.

    If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

    Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Steve, thanks for the reply. When I upgraded from 3.5.1 to 3.6, I did the "Entire Package" option and uploaded all of the files that came in the .zip file's Upload folder. After reading your post, I disabled all the plugins there were on the forums and created a new style that had default settings, yet I am still getting the same sort of errors that I posted.

      Is there anything else that you can suggest I try?

      Again, thanks for your help.

      Comment


      • #4
        I am 99.9% certain that this is from a modification you've made somewhere. If it's not, then the only other option is that this is a server problem.

        Run 'Suspect File Version' in Diagnostics and report back the results.

        Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

        Do any show as 'File does not contain expected contents'. If so, you need to reupload the original vB non-image files. Make sure you upload these in ASCII format and overwrite the ones on the server.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Steve, I copied the entire upload folder again to my website via ftp using the ASCII format as you said. I then ran the Suspect File Versions and here are the results:

          Diagnostics

          Help
          Suspect File Versions
          Scanned 60 files
          ./
          awards.php File not recognized as part of vBulletin
          config.php File not recognized as part of vBulletin
          request_award.php File not recognized as part of vBulletin
          subscriptions.php File not recognized as part of vBulletin
          userpage.php File not recognized as part of vBulletin
          arcade.php File not recognized as part of vBulletin
          installer_de.php File not recognized as part of vBulletin
          installer_en.php File not recognized as part of vBulletin
          uninstaller.php File not recognized as part of vBulletin
          inferno.php File not recognized as part of vBulletin
          ppverify.php File not recognized as part of vBulletin
          VBGameServer.php File not recognized as part of vBulletin
          gameservers.php File not recognized as part of vBulletin
          donate.php File not recognized as part of vBulletin
          alldonors.php File not recognized as part of vBulletin
          oldindex.php File not recognized as part of vBulletin
          Scanned 91 files
          ./admincp
          award.php File not recognized as part of vBulletin
          award_cat.php File not recognized as part of vBulletin
          awards_install.php File not recognized as part of vBulletin
          inferno_clan_control.php File not recognized as part of vBulletin
          arcade.php File not recognized as part of vBulletin
          inferno_aibot_control.php File not recognized as part of vBulletin
          inferno_battlefield_control.php File not recognized as part of vBulletin
          inferno_battlemusic_control.php File not recognized as part of vBulletin
          inferno_battle_control.php File not recognized as part of vBulletin
          inferno_element_control.php File not recognized as part of vBulletin
          inferno_functions.php File not recognized as part of vBulletin
          inferno_healing_control.php File not recognized as part of vBulletin
          inferno_help.php File not recognized as part of vBulletin
          inferno_help_control.php File not recognized as part of vBulletin
          inferno_itemshop_control.php File not recognized as part of vBulletin
          inferno_job_control.php File not recognized as part of vBulletin
          inferno_main_control.php File not recognized as part of vBulletin
          inferno_rpgavatar_control.php File not recognized as part of vBulletin
          inferno_rpgmember_control.php File not recognized as part of vBulletin
          inferno_section_control.php File not recognized as part of vBulletin
          inferno_spells_control.php File not recognized as part of vBulletin
          inferno_store_control.php File not recognized as part of vBulletin
          inferno_summon_control.php File not recognized as part of vBulletin
          inferno_synthesis_control.php File not recognized as part of vBulletin
          inferno_updatecheck_control.php File not recognized as part of vBulletin
          inferno_upload_control.php File not recognized as part of vBulletin
          inferno_auction_control.php File not recognized as part of vBulletin
          rpginferno_uninstallation.php File not recognized as part of vBulletin
          inferno_donate_control.php File not recognized as part of vBulletin
          inferno_importexport_control.php File not recognized as part of vBulletin
          inferno_lottery_control.php File not recognized as part of vBulletin
          inferno_rpgworld_control.php File not recognized as part of vBulletin
          inferno_tripletriad_control.php File not recognized as part of vBulletin
          inferno_tripletriadbattle_control.php File not recognized as part of vBulletin
          vba_cmps_admin.php File not recognized as part of vBulletin
          inferno_upgrade.php File not recognized as part of vBulletin
          install_inferno.php File not recognized as part of vBulletin
          upgrade_inferno.php File not recognized as part of vBulletin
          phgstats_admin.php File not recognized as part of vBulletin
          rpginferno_installation.php File not recognized as part of vBulletin
          donations_install.php File not recognized as part of vBulletin
          donation_admin.php File not recognized as part of vBulletin
          Scanned 3 files
          ./archive
          Scanned 32 files
          ./clientscript
          vbulletin_editor.js File not recognized as part of vBulletin
          vbulletin_moziwyg.js File not recognized as part of vBulletin
          vbulletin_quickreply.js File not recognized as part of vBulletin
          vbulletin_stdedit.js File not recognized as part of vBulletin
          vbulletin_wysiwyg.js File not recognized as part of vBulletin
          Scanned 2 files
          ./images/regimage/fonts
          Scanned 110 files
          ./includes
          adminfunctions_ranks.php File not recognized as part of vBulletin
          db_mysql.php File not recognized as part of vBulletin
          functions_bbcodeparse.php File not recognized as part of vBulletin
          functions_debug.php File not recognized as part of vBulletin
          functions_image.php File not recognized as part of vBulletin
          functions_register.php File not recognized as part of vBulletin
          functions_showthread.php File not recognized as part of vBulletin
          functions_subscriptions.php File not recognized as part of vBulletin
          functions_upload.php File not recognized as part of vBulletin
          functions_xml.php File not recognized as part of vBulletin
          mail.php File not recognized as part of vBulletin
          sessions.php File not recognized as part of vBulletin
          adminfunctions_vba_cmps.php File not recognized as part of vBulletin
          vba_cmps_include_bottom.php File not recognized as part of vBulletin
          vba_cmps_include_error.php File not recognized as part of vBulletin
          vba_cmps_include_template.php File not recognized as part of vBulletin
          vba_cmps_include_top.php File not recognized as part of vBulletin
          vba_cmps_plugin_newpost.php File not recognized as part of vBulletin
          ppfunc.php File not recognized as part of vBulletin
          pp_image.php File not recognized as part of vBulletin
          Scanned 20 files
          ./includes/cron
          inferno_tasks.php File not recognized as part of vBulletin
          donation_currency_exchange.php File not recognized as part of vBulletin
          Scanned 2 files
          ./includes/datastore
          Scanned 8 files
          ./includes/paymentapi
          Scanned 17 files
          ./includes/xml
          bitfield_userpage.xml File not recognized as part of vBulletin
          rpg_stats_1-2.xml File not recognized as part of vBulletin
          cpnav_arcade.xml File not recognized as part of vBulletin
          product-ibproarcade.xml File not recognized as part of vBulletin
          bitfield_rpginferno.xml File not recognized as part of vBulletin
          cpnav_rpginferno.xml File not recognized as part of vBulletin
          cpnav_vbacmps.xml File not recognized as part of vBulletin
          cpnav_VBphgstats.xml File not recognized as part of vBulletin
          cpnav_paypal_donations.xml File not recognized as part of vBulletin
          cpnav_phgstatsvb.xml File not recognized as part of vBulletin
          Scanned 81 files
          ./install
          upgrade1.php File not recognized as part of vBulletin
          upgrade10.php File not recognized as part of vBulletin
          upgrade11.php File not recognized as part of vBulletin
          upgrade12.php File not recognized as part of vBulletin
          upgrade13.php File not recognized as part of vBulletin
          upgrade14.php File not recognized as part of vBulletin
          upgrade15.php File not recognized as part of vBulletin
          upgrade16.php File not recognized as part of vBulletin
          upgrade17.php File not recognized as part of vBulletin
          upgrade18.php File not recognized as part of vBulletin
          upgrade19.php File not recognized as part of vBulletin
          upgrade2.php File not recognized as part of vBulletin
          upgrade3.php File not recognized as part of vBulletin
          upgrade4.php File not recognized as part of vBulletin
          upgrade5.php File not recognized as part of vBulletin
          upgrade6.php File not recognized as part of vBulletin
          upgrade7.php File not recognized as part of vBulletin
          upgrade8.php File not recognized as part of vBulletin
          upgrade9.php File not recognized as part of vBulletin
          Scanned 10 files
          ./modcp


          I know there's alot of files there.. let me know what I can do based on the results of running that diagnostic. If it takes deleting the /forums/ folder on my website, that's fine.

          Thanks again for your help.

          Comment


          • #6
            You put an ipaddress into the tatchy goes to coventry feild instead of a username.

            Comment


            • #7
              Originally posted by Zachery View Post
              You put an ipaddress into the tatchy goes to coventry feild instead of a username.
              I see what you are saying.. just wondering.. how the heck could this have happened? It happens when opening different pages on my forums, not just a certain page.

              Comment


              • #8
                Because users who are not moderators of the forum are going to get that error message.

                Comment


                • #9
                  Originally posted by Zachery View Post
                  Because users who are not moderators of the forum are going to get that error message.
                  How come I get the error message then? I am an administrator on the forums.

                  Comment


                  • #10
                    Not sure, did you try just removing it, ipaddresses are not a valid entry.

                    Comment


                    • #11
                      Remove what? I didn't add anything to make this happen.. it just started happening a couple days ago, out of nowhere.

                      Comment


                      • #12
                        Remove the IP address from the Tachy setting:

                        Admin CP -> vBulletin Options -> User Banning Options -> Tachy Goes to Coventry
                        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                        Change CKEditor Colors to Match Style (for 4.1.4 and above)

                        Steve Machol Photography


                        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                        Comment


                        • #13
                          Wow.. that was it.. I'm going to kill the admin that put that in there.

                          Thanks a ton guys, I appreciate the help!

                          Comment

                          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                          Working...
                          X