FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum Development » Bug Reports » Blank User?
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Blank User? [message #4543] Tue, 30 July 2002 08:55 Go to next message
davew is currently offline  davew   Australia
Messages: 78
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
I seem to have acquired a blank user?

afrafr (login: afrafr)
(login: )
Josh (login: Josh)

Will it just disappear when it doesn't get confirmed?

I can't seem to delete it...

Cheers,
Dave

Report message to a moderator

Re: Blank User? [message #4545 is a reply to message #4543] Tue, 30 July 2002 11:21 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Just run the following query:

UPDATE fud21_users SET alias=login WHERE alias='';

FUDforum Core Developer

Report message to a moderator

Re: Blank User? [message #4547 is a reply to message #4545] Tue, 30 July 2002 13:03 Go to previous messageGo to next message
davew is currently offline  davew   Australia
Messages: 78
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
prottoss wrote on Tue, 30 July 2002 20:51

Just run the following query:

UPDATE fud21_users SET alias=login WHERE alias='';



That didn;t seem to do anything...

so I tried

DELETE from fud21_users wWHERE alias='';

that removed it, but when I tried to add a new test user, it created a blank again...

(sorry)..

Report message to a moderator

Re: Blank User? [message #4549 is a reply to message #4547] Tue, 30 July 2002 13:19 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The query I gave should've correct the problem, I am not certain why it did not...

FUDforum Core Developer

Report message to a moderator

Re: Blank User? [message #4550 is a reply to message #4543] Tue, 30 July 2002 13:23 Go to previous messageGo to next message
davew is currently offline  davew   Australia
Messages: 78
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
I get :

mysql> UPDATE fud21_users SET alias=login WHERE alias='';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0


changed : 0 ???

Report message to a moderator

Re: Blank User? [message #4551 is a reply to message #4550] Tue, 30 July 2002 13:24 Go to previous messageGo to next message
davew is currently offline  davew   Australia
Messages: 78
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
Does this help?

mysql> select * from fud21_users WHERE alias='';
+----+-------+----------------------------------+------+-------+----------+ -----------+------------+---------------+--------+---------------+--------- -----+----------------+--------+------------+-----------------+--------+--- ---+------+-------+------+--------+------------+-----------+--------------+ -----------+-----------+------+------------+----------------+---------+---- --------+----------------------------------+------------+-------+-------+-- ----------------+------------+------------+------------+---------------+--- ---+--------------+--------+----------+-----------+----------------+------- ----+------+-------+-------------+
| id | login | passwd | name | email | location | interests | occupation | display_email | notify | notify_method | ignore_admin | email_messages | avatar | avatar_loc | avatar_approved | gender | icq | aim | yahoo | msnm | jabber | append_sig | show_sigs | show_avatars | posts_ppg | time_zone | bday | join_date | invisible_mode | blocked | email_conf | conf_key | user_image | theme | coppa | posted_msg_count | last_visit | referer_id | last_read | custom_status | sig | default_view | is_mod | level_id | reset_key | u_last_post_id | home_page | bio | alias | pm_messages |
+----+-------+----------------------------------+------+-------+----------+ -----------+------------+---------------+--------+---------------+--------- -----+----------------+--------+------------+-----------------+--------+--- ---+------+-------+------+--------+------------+-----------+--------------+ -----------+-----------+------+------------+----------------+---------+---- --------+----------------------------------+------------+-------+-------+-- ----------------+------------+------------+------------+---------------+--- ---+--------------+--------+----------+-----------+----------------+------- ----+------+-------+-------------+
| 64 | | d41d8cd98f00b204e9800998ecf8427e | | | | NULL | NULL | N | N | | N | N | 0 | NULL | NO | | NULL | NULL | NULL | NULL | NULL | N | N | N | 0 | | 0 | 1028035502 | N | N | N | 0573b7d2710789063b58f2bb490a8a6c | NULL | 0 | N | 0 | 1028035511 | 2 | 1028035502 | NULL | NULL | | N | 0 | 0 | 0 | NULL | NULL | | N |
+----+-------+----------------------------------+------+-------+----------+ -----------+------------+---------------+--------+---------------+--------- -----+----------------+--------+------------+-----------------+--------+--- ---+------+-------+------+--------+------------+-----------+--------------+ -----------+-----------+------+------------+----------------+---------+---- --------+----------------------------------+------------+-------+-------+-- ----------------+------------+------------+------------+---------------+--- ---+--------------+--------+----------+-----------+----------------+------- ----+------+-------+-------------+
1 row in set (0.01 sec)

Report message to a moderator

Re: Blank User? [message #4553 is a reply to message #4551] Tue, 30 July 2002 15:27 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Actually it does, you seem to have somehow aquired a user who's login is ''.
Which is why my query did not fix the problem.

This problem sounds very much like an alias problem present in 2.2.4RC1, are you sure you are not running that version?

FUDforum Core Developer

Report message to a moderator

Re: Blank User? [message #4554 is a reply to message #4553] Tue, 30 July 2002 15:55 Go to previous messageGo to next message
computer_dan is currently offline  computer_dan   Canada
Messages: 58
Registered: July 2002
Location: Toronto
Karma: 0
Member
I had the same problem...my fix was to upgrade to 2.2.4RC2. But I think that recompiling the theme should do the same thing, right?

...or maybe even reinstalling the last upgrade?

**Please note that these are just my thoughts and should not reflect in your decision to make any changes or alterations to your site that may cause any more damage.

Report message to a moderator

Re: Blank User? [message #4555 is a reply to message #4554] Tue, 30 July 2002 15:59 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Recompiling theme would ONLY help if there were modifications made by hand to the source or template files.

FUDforum Core Developer

Report message to a moderator

Re: Blank User? [message #4557 is a reply to message #4553] Wed, 31 July 2002 00:45 Go to previous messageGo to next message
davew is currently offline  davew   Australia
Messages: 78
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
prottoss wrote on Wed, 31 July 2002 00:57

Actually it does, you seem to have somehow aquired a user who's login is ''.
Which is why my query did not fix the problem.

This problem sounds very much like an alias problem present in 2.2.4RC1, are you sure you are not running that version?


It's possible -I'll check when I get home tonight...

Does RC2 fix the problem, if I manually delete the user again?

Report message to a moderator

Re: Blank User? [message #4558 is a reply to message #4557] Wed, 31 July 2002 01:05 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Yes.

FUDforum Core Developer

Report message to a moderator

Re: Blank User? [message #4560 is a reply to message #4558] Wed, 31 July 2002 01:12 Go to previous messageGo to next message
davew is currently offline  davew   Australia
Messages: 78
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
Thanks ... I'll let you know how it goes...

Cheers,
Dave

Report message to a moderator

Re: Blank User? [message #4561 is a reply to message #4560] Wed, 31 July 2002 07:01 Go to previous message
davew is currently offline  davew   Australia
Messages: 78
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
That seems to have done the trick (Latest version - which I THOUGHT I had)...

Thanks a lot - you de man!

Cheers,
Dave

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Problems getting into Forum
Next Topic: WWW Root updated, but old Root still showing
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 21:05:25 GMT 2024

Total time taken to generate the page: 0.02757 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software