Chewy in distress

Hi all,

Oh I do hope somebody can help us :ermm:
My forums were working absolutely fine for a few weeks... and then all of a sudden something happened.
Ok here goes...

For some users... (not all) when they log into my forums they receive this message:

There seems to have been a slight problem with the TalkBroadband Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Now, an email is then dispatched to my webmaster email account that states:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Wednesday 26th of March 2003 08:34:06 PM
Script: http://www.talkbroadband.com/forums/index.php?
Referer:

Wanna hear something strange? If I try and search for users in the admin panel... it will not display any users that have the above problem when logging in.

Additional info:
I've ensured that these users exist on the database.
I've tried comparing the SQL values from one persons account to another and noticed nothing obvious.
I'm using vBulletin Version 2.3.0.
The vbulletin database was upgraded from xmb v1.11d some weeks back (note that it was working fine up until a couple days ago).

OH please help me anyone :cry:


Cheers,

Ch3W.

[g-force2k2]

Ch3W it seems to me that in the index.php the query that counts the actual pms the user has isn't getting the correct userid... anyway you can pm me the file and i'll take a look? the COUNT or SUM query should have $bbuserinfo[userid] i believe... hope that helps some...

regards,
g-force2k2

[Ch3W]

Thanks for replying g-force.

I've pm'd you my index.php

[Xenon]

Wanna hear something strange? If I try and search for users in the admin panel... it will not display any users that have the above problem when logging in.

that looks like your userfield table isn't ok.
maybe your importscript didn't work correctly.
you have to syncronice your user and userfield table, searfch through the board, AFAIK someone has released a script.

[Ch3W]

Thanks for reply.

The import worked fine for a couple of weeks.
Strange. :glasses:

[Ch3W]

Xenon,

Plain and simple.. YOU ROCK.

I've not found a hack that you refer to... but I guess it won't take long to write a script myself.

Cheers for your help .
Thanks also to g-force 2.

[Ch3W]

Ok I've created a script that synchronizes the user and userfield tables in vB v2.3.0.

If anybody else has had this fault... feel free to use this script