We are getting , new user error

[TimberFloorAu]

When a new user joins, and we then click on that users name. We are receiving a MySql Error

example: http://www.yobromofo.com/forum/members/mclizzie.html

yet http://www.yobromofo.com/forum/membe...erfloorau.html

works fine.

Any suggestions on a fix please, of have we got some more serious issues.

Error report is:

Database error in vBulletin 3.7.2:

Invalid SQL:

			SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
			FROM yobromofusernote AS usernote
			WHERE userid =;

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 3
Error Number  : 1064

[badboyz]

try repairing ur tables and optimizing them or disable mods n try it n see if it happens.

[Lynne]

Can't see your forum....

As suggested, try disabling your mods.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:

define('DISABLE_HOOKS', true); 


[TimberFloorAu]

Originally Posted by Lynne

Can't see your forum....

As suggested, try disabling your mods.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:

define('DISABLE_HOOKS', true); 


Thanks, will try that now.

I have disabled forums, whilst we upgrade to 3.7.4
That is now complete and will disable plugins.

Ste

--------------- Added [DATE]1226700017[/DATE] at [TIME]1226700017[/TIME] ---------------

Ok that has fixed the issue.

LOL

Now any suggestions as to how and where and what we need to do to fix it.

I have disabled, plugin after plugin, but still having the issue.

Ste

--------------- Added [DATE]1226702177[/DATE] at [TIME]1226702177[/TIME] ---------------

Just added a new user:

This is the error we get:

Database error in vBulletin 3.7.4:

Invalid SQL:
SHOW TABLE STATUS LIKE yobromof'user';

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 'yobromof'user'' at line 1
Error Number : 1064
Request Date : Saturday, November 15th 2008 @ 09:34:40 AM
Error Date : Saturday, November 15th 2008 @ 09:34:40 AM
Script : http://www.xxxxxxxx.com/forum/adminc....php?do=update
Referrer : http://www.xxxxxxxx.com/forum/admincp/user.php?do=add
IP Address : xxx.xxx.xxx.xxx
Username : admin
Classname : vB_Database
MySQL Version : 4.1.22-standard

[Lynne]

If you disabled your plugins and it fixed it, then it is a plugin. Now you need to look for a plugin that adds that code into a query. When you said you've been disabling plugin by plugin, do you mean product by product or really plugin by plugin? You should try disabling the whole product cuz the line could be in a couple of plugins in the product.

[CodingMonkey]

"yobromof'user';"
I think your problem lies within that. It has to be a plugin modifying the table name in all sql queries for the user database.

[TimberFloorAu]

Okies, I have been disabling Products, should i be disabling plugins?

Sorry for appearing Dense. LOL

Ste

--------------- Added [DATE]1226707240[/DATE] at [TIME]1226707240[/TIME] ---------------

The only thing I can think of that would change userid > to username, would be VBSEO ?

Could that be the cause?

[CodingMonkey]

Which version of vBSEO? I currently use vBSEO 3.2.0 on my own board .. no issues that you're stating..

[Lynne]

Originally Posted by TimberFloorAu

Okies, I have been disabling Products, should i be disabling plugins?

Sorry for appearing Dense. LOL

Ste

You should definitely disable products, however there are also some plugins that are not part of products - they are usually listed under the "vbulletin" area in the plugins page. So, when you try disabling things to see what it is, disable both all your products *and* all the plugins.