this is a little strange

[pHAZE_1]

Top Poster: X Squared(403) | Top Thread Starter: EF-X(38)

on my site that is the same guy.. he was EF-X then i changed his name to X Squared, but that was a while ago, then the other day he became top thread started, but with his old name..
*scratches head*

[scsa20]

look in the database to make sure it's changed

[Admin]

Run this query:

UPDATE thread SET postusername="X Squared" WHERE postusername="EF-X";

[pHAZE_1]

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: UPDATE thread SET postusername="X Squared" WHERE postusername="EF-X";

mysql error: You have an error in your SQL syntax near ';
' at line 1

mysql error number: 1064

Date: Friday 10th of May 2002 01:41:13 PM
Script: http://hiphoptechnicz.com/forums/forums/admin/query.php
Referer: http://www.hiphoptechnicz.com/forums/admin/query.php

[Admin]

Remove the ; at the end and any blank line.

[pHAZE_1]

thanks FireFly, but i have another question.. ive had the same problems with other queries, is it possible to do the same thing[remove the ;] and work?

[pHAZE_1]

lol it works now, but the 'most users online in a day' got reverted to 0.. so did 'most active users' [at a time]

[Admin]

Nothing to do with that.