Announcement

Collapse
No announcement yet.

SQL errors, coming from out of nowhere

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

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

    Thanks a ton guys, I appreciate the help!

    Leave a comment:


  • Steve Machol
    replied
    Remove the IP address from the Tachy setting:

    Admin CP -> vBulletin Options -> User Banning Options -> Tachy Goes to Coventry

    Leave a comment:


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

    Leave a comment:


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

    Leave a comment:


  • Bojangles
    replied
    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.

    Leave a comment:


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

    Leave a comment:


  • Bojangles
    replied
    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.

    Leave a comment:


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

    Leave a comment:


  • Bojangles
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    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.

    Leave a comment:


  • Bojangles
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    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?

    Leave a comment:


  • Bojangles
    started a topic SQL errors, coming from out of nowhere

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X