Announcement

Collapse
No announcement yet.

Database Error, not sure what it is.

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

  • Database Error, not sure what it is.

    Ive used vbulletin a fair bit before, and encountered database errors that I've managed to fix, but im no pro and I keep getting this database error on the registration page, thats got me stumped.... im not sure what it is or how to fix it.

    I think it only happens when trying to use image magick in the image settings, and im also currently having issues with my host and image magick not working properly.

    Anyway this is the error im getting, if anyone knows anything about it, or could at least explain it to me a bit better so i understand it, I would greatly appreciate that.

    Invalid SQL:

    SELECT text, languageid, special
    FROM phrase AS phrase
    LEFT JOIN phrasetype USING (fieldname)
    WHERE phrase.fieldname = 'error'
    AND varname = 'php_error_exec_disabled' AND languageid IN (-1, 0, 0);

    MySQL Error :
    Error Number :
    Request Date : Wednesday, October 29th 2008 @ 05:53:46 PM
    Error Date : Wednesday, October 29th 2008 @ 05:53:46 PM
    Script : http://www.96cougar.com/Forum/image....e2cd83df6b43bf
    Referrer : http://www.96cougar.com/Forum/register.php?do=register
    IP Address : 99.254.68.135
    Username :
    Classname : vB_Database
    MySQL Version :

  • #2
    Invalid SQL errors are almost always related to modified code. To troubleshoot this, first 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. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

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

    [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

    Next, disable all plugins.

    Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

    define('DISABLE_HOOKS', true);

    Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Next make this the default style.

    Admin Control Panel -> vBulletin Options -> Style & Language Settings -> Default Style

    Now try registering a new account. 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
      Sorry i should have mentioned, this is a fresh install, with only 3 minor modifications installed.
      Advanced product management, vBDebug mode, and microstats.... they are all currently disabled.... other than that, the board is plain, and brand new.

      i just read somewhere that it might be because my host has php exec() disabled.

      Comment


      • #4
        Do you mean they just disabled it? You should run phpinfo.php to see if that's true maybe?

        Comment


        • #5
          Please follow my instructions nonetheless.
          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


          • #6
            just so this thread doesn't end with nothingness, the problem was that my host sucked and didn't use imagemagick, nor did they allow phpexec() or run any kind of program like PHPsuexec.

            I switched hosts, imagemagick works great.

            Comment

            Loading...
            Working...
            X