Announcement

Collapse
No announcement yet.

user Vs. userfield

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Michael König
    replied
    Originally posted by snakes1100
    Ok the script works for missing users in the "userfield table", BUT what if you have 6000 members in the userfield and only 3500 members in the "user table"?

    But all of them can still log in and post with no issues.
    Sure, there will be no problem if you have more users in userfield than in the user table...it's only a problem, if you have a less amount of users in the userfield table or if an userid is missing from userfield.

    This script will also remove all unnecessary entries in your userfield table.

    Leave a comment:


  • Steve Machol
    replied
    And their attachments don't show up, even though the attachments are in the database.

    Leave a comment:


  • Freddie Bingham
    replied
    Sure they show up as guest, but he said 'everyone' can login so I take that to indicate that the missing 2500 are not wanted.

    Leave a comment:


  • Steve Machol
    replied
    Originally posted by freddie
    There are no adverse effects to having this if state if everyone can login. I would think this could only happen if you pruned your user table directly via the database.
    Freddie, there are adverse affects. The posts of the missing 2500 show up as 'Guest' and the attachments in their posts do not show up. The problem is that the backup db was made with a very old version of MySQL(he didn't know the exact version) and he's importing it into MySQL 4.0.12.

    Leave a comment:


  • Freddie Bingham
    replied
    There are no adverse effects to having this if state if everyone can login. I would think this could only happen if you pruned your user table directly via the database.

    Leave a comment:


  • snakes1100
    replied
    Ok the script works for missing users in the "userfield table", BUT what if you have 6000 members in the userfield and only 3500 members in the "user table"?

    But all of them can still log in and post with no issues.

    Leave a comment:


  • Steve Machol
    replied
    OmaniMan, please start a new thread with all the relevant details about your specific problem and what exactly you've done.

    Leave a comment:


  • OmaniMan
    replied
    And I foget to say the starnge thing !!..

    amount of user = 840
    amount of userfield = 840 !!!
    Last edited by OmaniMan; Mon 19th May '03, 12:35pm.

    Leave a comment:


  • OmaniMan
    replied
    Hello friends ...
    I have followed all instructions here .... but still same problem ...

    Leave a comment:


  • Stadler
    replied
    Hi,

    try, what I've posted before:
    Originally posted by Stadler
    Well, I think, this wouldn't work for users in forums where fields have been added and/or removed.

    I think you should exchange
    PHP Code:
        $DB_site->query("INSERT INTO userfield (userid,field1,field2,field3,field4) VALUES ('".$getuser[userid]."','','','','')"); 
    with
    PHP Code:
        $DB_site->query("INSERT INTO userfield (userid) VALUES ('$getuser[userid]')"); 
    HTH

    Stadler

    Leave a comment:


  • omniweapon
    replied
    I now seem to get a new error when i try to edit a user via the admin panel.

    <-- Database error in vBulletin Control Panel 2.2.8:
    Invalid SQL: UPDATE userfield SET userid=7,field1='',field2='',field3='',field4='',field7='',field8='',field11='' WHERE userid=7
    mysql error: Unknown column 'field7' in 'field list'
    mysql error number: 1054 -->

    Any help?

    Leave a comment:


  • MalaK_3araby
    replied
    Originally posted by Mystics
    Both tables should contain the same number of users! If a user is missing from userfield he can't be seen in the memberlist and he can't save his Location, Biography and so on in his Profile. To fix this you can use this script:
    For some STRANGE unknown reason one of my admins could no longer login. When she tries to login she gets recognised and she greeted by her name .. but when the page takes her back to .. the forum does not recognize her as being loggedin.

    I ran Mystics script -above- and it recognized that user was not in the Userfiled tableand inserted it .. now All works.

    Many thanks ..

    Leave a comment:


  • Stadler
    replied
    Well, I think, this wouldn't work for users in forums where fields have been added and/or removed.

    I think you should exchange
    PHP Code:
        $DB_site->query("INSERT INTO userfield (userid,field1,field2,field3,field4) VALUES ('".$getuser[userid]."','','','','')"); 
    with
    PHP Code:
        $DB_site->query("INSERT INTO userfield (userid) VALUES ('$getuser[userid]')"); 
    HTH

    Stadler
    Last edited by Stadler; Thu 20th Feb '03, 3:27pm.

    Leave a comment:


  • Mental Stamina
    replied
    this script helped me alot
    i had about 1,000members w/out a userfield
    thanx for the script
    and thanx to smachol for identifying my problem

    Leave a comment:


  • Michael König
    replied
    I don't think that have anything to do with my script because there is nothing in it, that handles with the user's post count...

    To fix it go in your Admin-CP -> Update Counters -> Update User's Post Counts

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X