The Arcive of vBulletin Modifications Site.

pHAZE_1 · #1 05-09-2002, 10:17 PM

Quote:

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 · #2 05-09-2002, 10:48 PM

look in the database to make sure it's changed

Admin · #3 05-10-2002, 10:13 AM

Run this query:

Code:

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

pHAZE_1 · #4 05-10-2002, 03:48 PM

Code:

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 · #5 05-10-2002, 04:16 PM

Code:

Remove the ; at the end and any blank line.

pHAZE_1 · #6 05-10-2002, 04:20 PM

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 · #7 05-11-2002, 01:53 AM

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 · #8 05-11-2002, 04:17 AM

Nothing to do with that.