| Re: Problem with Registration Date and Negative Posts |
| by mpowell on 2006/9/17 12:43:46 I remember that button from 2.0.x but can't find it in 2.2.x. Thanks for the info however. |
| Re: Problem with Registration Date and Negative Posts |
| by allnewtome on 2006/9/17 8:49:00 I'm using 2.0.15 now so don't have this problem any more. But I notice that now in main preferences - edit user, at the bottom, there is: <code> User Posts Comments 20 Push the button below to synchronize data if you think the above user posts info does not seem to indicate the actual status </code> Forum posts and smartsection articles all count towards this total. Perhaps you could look at the 'syncronization' code and try to amend it for 2.2.3? This would fix at least part of the problem. |
| Re: Problem with Registration Date and Negative Posts |
| by mpowell on 2006/9/17 3:49:42 I think I have been able to fix this problem. I found several errors by using phpmyadmin that I repaired and things seem to be working now and new members can register. I still have no solution to the -1 number problem but it is not a new problem with new members joining but I had a bunch join before I tackled this issue. I am sure there must be some kind of a MySQL query to update the posts for each user but I don't know what it is. I will try to let you all know if these efforts did indeed fix this problem. |
| Re: Problem with Registration Date and Negative Posts |
| by mmesa on 2006/8/29 12:13:18 I have the same problem since five months. I put this code in /modules/profiles/register.php: $profile_handler =& xoops_gethandler('profile'); // Get fields $mensaje="uname: ".$newuser->getVar('uname')."\n"; $mensaje.="loginname: ".$newuser->getVar('loginname')."\n"; $mensaje.="email: ".$newuser->getVar('email')."\n"; $mensaje.="pass: ".$newuser->getVar('pass')."\n"; $mensaje.="actkey: ".$newuser->getVar('actkey')."\n"; $mensaje.="user_regdate: ".$newuser->getVar('user_regdate')."\n"; $fields = $profile_handler->loadFields(); if (count($fields) > 0) { foreach (array_keys($fields) as $i) { $fieldname = $fields[$i]->getVar('field_name'); if ($fields[$i]->getVar('field_register') && isset($_POST[$fieldname])) { $newuser->setVar($fieldname, $_POST[$fieldname]); $mensaje.=$fieldname.": ".$newuser->getVar($fieldname).";\n"; } } } $para = 'admin@dealmonte.com'; $asunto = 'Intento de registro'; mail($para, $asunto, $mensaje); if (!$member_handler->insertUser($newuser)) { $para = 'admin@dealmonte.com'; $asunto = 'Registro fallido en usuario'; $mensaje.="mysql_error: ".mysql_error().";\n"; mail($para, $asunto, $mensaje); echo _PROFILE_MA_REGISTERNG; echo implode('<br />', $newuser->getErrors()); break; } $newid = $newuser->getVar('uid'); if (!$member_handler->addUserToGroup(XOOPS_GROUP_USERS, $newid)) { $para = 'admin@dealmonte.com'; $asunto = 'Registro fallido en grupo'; $mensaje.="mysql_error: ".mysql_error().";\n"; mail($para, $asunto, $mensaje); echo _PROFILE_MA_REGISTERNG; break; } But not always the e-mails are dispatched. I received this message for last registering: uname: españa loginname: pruebaxx email: espaol2@dealmonte.com pass: c893bad68927b457dbed39460e6afd62 actkey: 07c959f7 user_regdate: 1156849533 notify_method: 0; attachsig: 1; user_mailok: 1; user_from: Almonte; user_sig: ; bio: ; user_occ: ; mysql_error: Duplicate entry '405' for key 1; The row in xoops_users was ok, but in xoops_user_profile was wrong. The register date was 0, and other fields were with default value. And, there wasn't new records in xoops_group_users_links. After, I deleted the new records for uid=405, I updated the autoincrement value to 405, and then I can register the new user with the same values. As sometimes I don't receive the e-mails with the regisering data, I think is a problem of PHP. When this occurs, a new row is inserted in xoops_user_profile, with default values, but in tables xoops_users and xoops_group_users_links there aren't new rows. Versions: XOOPS 2.2.4, PHP 4.4.2, MySQL 4.1.21-standard, Apache 1.3.37 (Unix) |
| Re: Problem with Registration Date and Negative Posts |
| by fosterm on 2006/8/28 21:45:01 Hi Dave. I have still not solved this issue. It is hard to figure out what percentage of users have this issue. A guess is 10-20% on my site running 2.2.3 final. Typically if I delete the entry in both tables for these registrations and when I ask the person to register again, it works. I hate not knowing though really how many people may be having a issue that I know nothing about. Also, it seems that only a few are posting with this issue. So i infer that most are not having this issue? or are they not aware that they have an issue? As Dave says any help or ideas would be appreciated. Foz |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|