Database Error for members registration...

[Hall of Famer]

Well I've successfully upgraded to vb4.08, the site does look a lot more beautiful now. However, the total members registered on the forum has been unchanged since then. Just very recently a member on another forum reported to me that he received database error whenever he tried to register, so I tested it myself and it did happen. WTF is going on with this? Why database error? So are VB4.08 forum runners supposed to gain no new member from now on?

[Wayne Luke]

Moved to the appropriate support forum. The Licensed Feedback forum shouldn't be used for support.

What is the database error? Without knowing what that is, no one can answer your question or help get your site working again.

[Hall of Famer]

umm you are asking me? How am I supposed to know what database error it is? It says the same thing all the time, here you can have a look:

[Hall of Famer]

Well the same problem also occurs when I edit a users profile in admincp:

Database error in vBulletin 4.0.8:

Invalid SQL:
SELECT userid, username FROM user WHERE userid = 2060);

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 : Friday, October 22nd 2010 @ 04:19:21 PM
Error Date : Friday, October 22nd 2010 @ 04:19:21 PM
Script : http://www.pokemonmysidia.com/forum/...er.php?do=kill
Referrer : http://www.pokemonmysidia.com/forum/...=remove&u=2061
IP Address : 128.180.221.27
Username : Hall of Famer
Classname : vB_Database
MySQL Version : 5.1.47-community-log

[Hall of Famer]

Any idea what was wrong?

[Wayne Luke]

Well the database error is because of the parenthesis in the query. It isn't a wide scale error though. Your site is the first that I have heard of this I don't get the error on this site. I recommend disabling all plugins except the CMS and Blog and seeing if the error continues. If it does let us know.

[Hall of Famer]

umm any idea what script file caused this issue? I may be able to edit the php file myself if I at least know where the error is...

[Steve Machol]

Possibly a bad file or add-on. 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 products (except vB Blog and vB CMS if you are running the Suite.)

Admin CP -> Plugins & Products -> Manage Products -> Disable

Then manually uncheck all plugins that are not for 'vBulletin Blog' and vBulletin CMS' here:

Admin CP -> Plugins & Products -> Plugin Manager

You must do BOTH of those steps in order to disable all non vBulletin Modifications.

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. 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?

[Hall of Famer]

This is ridiculous. Disabling all the addons I use on my forum? Then it will die...

Are there any other ways to fix this? I am sure you coders can at least look up the codes to see what script file(s) is/are causing this error. I believe there's a malfunction in sql query, and I can even correct this myself.

[Hall of Famer]

Just sent a support ticket, looks like coders of Vbulletin need to see this...

[Hall of Famer]

Umm I tried your suggestion eventually by globally disabling plugins/products on my forum, but it wont solve this database error, any ideas please?

[Wayne Luke]

Well it isn't a coding issue. Why? Because the query is so simple that it isn't one constructed via code. In the default code or everyone that upgraded would see it. Did you follow all the steps that Steve outlined?

[vbPassion]

probably could be some code errors...due to add-ons....