FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Blank User?
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Blank User? [message #4543] Tue, 30 July 2002 04:55 Go to next message
davew is currently offline  davew   Australia
Messages: 77
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
add to buddy list
ignore all messages by this user

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
Re: Blank User? [message #4545 is a reply to message #4543] Tue, 30 July 2002 07: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
add to buddy list
ignore all messages by this user
Just run the following query:

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


FUDforum Core Developer
Re: Blank User? [message #4547 is a reply to message #4545] Tue, 30 July 2002 09:03 Go to previous messageGo to next message
davew is currently offline  davew   Australia
Messages: 77
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
add to buddy list
ignore all messages by this user

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)..
Re: Blank User? [message #4549 is a reply to message #4547] Tue, 30 July 2002 09: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
add to buddy list
ignore all messages by this user
The query I gave should've correct the problem, I am not certain why it did not...

FUDforum Core Developer
Re: Blank User? [message #4550 is a reply to message #4543] Tue, 30 July 2002 09:23 Go to previous messageGo to next message
davew is currently offline  davew   Australia
Messages: 77
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
add to buddy list
ignore all messages by this user

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 ???

Re: Blank User? [message #4551 is a reply to message #4550] Tue, 30 July 2002 09:24 Go to previous messageGo to next message
davew is currently offline  davew   Australia
Messages: 77
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
add to buddy list
ignore all messages by this user

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)
Re: Blank User? [message #4553 is a reply to message #4551] Tue, 30 July 2002 11: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
add to buddy list
ignore all messages by this user
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
Re: Blank User? [message #4554 is a reply to message #4553] Tue, 30 July 2002 11: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
add to buddy list
ignore all messages by this user

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.
Re: Blank User? [message #4555 is a reply to message #4554] Tue, 30 July 2002 11: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
add to buddy list
ignore all messages by this user
Recompiling theme would ONLY help if there were modifications made by hand to the source or template files.

FUDforum Core Developer
Re: Blank User? [message #4557 is a reply to message #4553] Tue, 30 July 2002 20:45 Go to previous messageGo to next message
davew is currently offline  davew   Australia
Messages: 77
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
add to buddy list
ignore all messages by this user

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?

Re: Blank User? [message #4558 is a reply to message #4557] Tue, 30 July 2002 21: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
add to buddy list
ignore all messages by this user
Yes.

FUDforum Core Developer
Re: Blank User? [message #4560 is a reply to message #4558] Tue, 30 July 2002 21:12 Go to previous messageGo to next message
davew is currently offline  davew   Australia
Messages: 77
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
add to buddy list
ignore all messages by this user

Thanks ... I'll let you know how it goes...

Cheers,
Dave
Re: Blank User? [message #4561 is a reply to message #4560] Wed, 31 July 2002 03:01 Go to previous message
davew is currently offline  davew   Australia
Messages: 77
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
Member
add to buddy list
ignore all messages by this user

That seems to have done the trick (Latest version - which I THOUGHT I had)...

Thanks a lot - you de man!

Cheers,
Dave
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Mon Dec 10 19:51:39 EST 2018

Total time taken to generate the page: 0.00782 seconds