Database Error, not sure what it is.

[BigJohnny]

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 :

[Steve Machol]

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?

[BigJohnny]

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.

[mikesz]

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

[Steve Machol]

Please follow my instructions nonetheless.

[BigJohnny]

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.