user.php

[Boofo]

I am still running vbulletin 2.2.5 but I did do the 3 file fix for 2.2.6 until I do the full upgrade. With a little help, that fixed the templates not all showing problem and I thought it fixed the editing users problem, but for some reason, I have a user that I can eidt just fine in the admin cp but the rest, I get the following error. Can anyone please tell me what this it and maybe how to fix it?

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT userid
					FROM user
					WHERE username='MarTinX'
						AND userid <> 
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064

Date: Saturday 29th of June 2002 06:33:47 PM
Script: http://www.bearfacts2.com/forum/forum/admin/user.php
Referer: http://bearfacts2.com/forum/admin/us...edit&userid=11

[FWC]

See if you have this:

PHP Code:

SELECT *,FROM_UNIXTIME(joindate) 


If you do, change it to this:

PHP Code:

SELECT user.*,FROM_UNIXTIME(joindate) 


That fixed a similar problem on a board I tried it on. I'm not sure if you have the same problem, though.

[Boofo]

Well, once again you have proven to be the MASTER! That fixed my problem. The only thing is... now it won't let me view IPs for the users. When I try to view them in the View IPs, it doesn't return any IP addresses. Other than that, it works great! Thank you very much (again )

[FWC]

Could you view IP's before you changed that query?

[Boofo]

No, that query didn't make a difference there. But it did help the other part.

[tonytheboss]

desoler jai aucune idée comment t'aidé