Suche

[GeeLoo]

Hab ein Problem mit Benutzer Neuzugänge hab da bestimmt 200 User drin und wollte die nun Aktivieren.

Einzeln markieren und Account Freischalten geht.

Sobald ich aber mehrere auswähle sagt er mir:

Datenbankfehler: Benutzer konnte nicht zur Datenbank hinzugefügt werden.Insert from temptable into usertable YA-DELETER

hab schon das Forum durchsucht aber bin da nicht schlau draus geworden hat da jemand einen lösungsansatz?

Wäre ich echt dankbar drüber.

MFG
Andre

[Andi]

Hoi

das ist ein Fehler im Zusammenspiel der YA-Erweiterung mit der Option des Aktivierungslinks...

editiere die admin/modules/ya_deleter.php, suche folgende Stelle in der Funktion adminactivateaccount():

Code Auswählen Erweitern

            } elseif ($GLOBALS['vkpUserregoption'] == 4) {
                $user_stat = 0;
            }
            if (isset($uname)) $fields[0] = "uname = '$uname'";
            if (isset($pass)) $fields[1] = "pass = '$pass'";
            if (isset($email)) $fields[2] = "email = '$email'";


die ergänzt/änderst du wie folgt:

Code Auswählen Erweitern

            } elseif ($GLOBALS['vkpUserregoption'] == 4) {
                $user_stat = 0;
            }

            $fields = array();

            if (isset($uname)) $fields[0] = "uname = '$uname'";
            if (isset($pass)) $fields[1] = "pass = '$pass'";
            if (isset($email)) $fields[2] = "email = '$email'";


[GeeLoo]

Bei mir steht da :

Code Auswählen Erweitern

$sqlvars = mxAddSlashesForSQL($row);
            extract($sqlvars);
            if ($GLOBALS['vkpUserregoption'] == 3) {
                $user_stat = 1;
            } elseif ($GLOBALS['vkpUserregoption'] == 4) {
                $user_stat = 0;
            }

            if (isset($uname)) $fields[0] = "uname = '$uname'";
            if (isset($pass)) $fields[1] = "pass = '$pass'";
            if (isset($email)) $fields[2] = "email = '$email'";
            if (isset($name)) $fields[3] = "name = '$name'";
            if (isset($femail)) $fields[4] = "femail = '$femail'";
            if (isset($url)) $fields[5] = "url = '$url'";
            if (isset($user_avatar)) $fields[6] = "user_avatar = '$user_avatar'";
            if (isset($user_regdate)) $fields[7] = "user_regdate = '$user_regdate'";
            if (isset($user_icq)) $fields[8] = "user_icq = '$user_icq'";
            if (isset($user_occ)) $fields[9] = "user_occ = '$user_occ'";
            if (isset($user_from)) $fields[10] = "user_from = '$user_from'";
            if (isset($user_intrest)) $fields[11] = "user_intrest = '$user_intrest'";
            if (isset($user_sig)) $fields[12] = "user_sig = '$user_sig'";
            if (isset($user_aim)) $fields[13] = "user_aim = '$user_aim'";
            if (isset($user_yim)) $fields[14] = "user_yim = '$user_yim'";
            if (isset($user_msnm)) $fields[15] = "user_msnm = '$user_msnm'";
            $fields[16] = "user_level = 1";
            if (isset($newsletter)) $fields[17] = "newsletter = $newsletter ";
            if (isset($user_ingroup)) $fields[18] = "user_ingroup = $user_ingroup";
            if (isset($user_regtime)) $fields[19] = "user_regtime = $user_regtime";
            if (isset($user_stat)) $fields[20] = "user_stat = $user_stat";
            if (isset($user_sexus)) $fields[21] = "user_sexus = $user_sexus";
            if (isset($user_regtime)) $fields[22] = "user_lastvisit = $user_regtime";
            if (isset($userip)) $fields[23] = "user_lastip = '$userip'";
            if (isset($user_bday)) $fields[24] = "user_bday = '$user_bday'"; // ohne anführz.
            if (function_exists("finishNewUser_option")) {
                // / loeschen oder hinzufuegen von Insert-Elementen
                $fields = finishNewUser_option($row, $fields);
                // mxDebugFuncVars($fields); exit;
            }

Wenn ich deine änderungen einfüge passiert das gleiche wie vorher Fehler

MFG
Andre

[Andi]

Moin

welche pragmaMx Version ist das?

- Debugmodus einschalten
- SQL-Fehler anzeigen lassen

[GeeLoo]

Error sql_query():
qry: INSERT INTO {prefix}_users SET uname = 'niXXXXX', pass = '729db362XXXXX', email = 'nina_XXXXXXX', name = 'nXXX', femail = '', url = '', user_avatar = '', user_regdate = 'Apr 08, 2009', user_icq = '', user_occ = '', user_from = '', user_intrest = '', user_sig = '', user_aim = '', user_yim = '', user_msnm = '', user_level = 1, newsletter = 0 , user_ingroup = 1, user_regtime = XXXXXXX, user_stat = 1, user_sexus = 0, user_lastvisit = 1239184974, user_status = '', user_from1 = '', user_heigh = '', user_gewicht = '', user_piercing = '', user_tatto = '', user_sucht = '', user_beziehung = '', user_haar = '', user_augen = '', user_l1 = '', user_l2 = '', user_l3 = '', user_l4 = '', user_l5 = '', user_l6 = '', user_l7 = '', user_l8 = '', user_positiv = '', user_negativ = '', user_smoke = '', user_alkohol = '', user_partneralter1 = '', user_partneralter2 = '', user_partnerwie = '', user_famstatus = '', user_partnerfigur = '', user_kinder = ''
descr: Duplicate entry 'niXXXXX' for key 2 ( mysql 1062 )

details:

file: /admin/modules/ya_deleter.php # line: 254,  cmd: sql_query(INSERT INTO {prefix}_users SET uname = 'ninaaa',  pass = 'XXXXXXX...),
file: /admin/modules/ya_deleter.php # line: 431,  cmd: adminactivateaccount(INSERT INTO {prefix}_users SET uname = 'ninaaa',  pass = 'XXXXXXX...,  0,  60,  Array[6]),
file: /admin/case/case.ya_deleter.php # line:  25,  cmd: include(INSERT INTO {prefix}_users SET uname = 'niXXXX',  pass = 'XXXXXXX...,  0,  60,  Array[6],  /admin/modules/ya_deleter.php),
file: /admin.php # line: 815,  cmd: include_once(INSERT INTO {prefix}_users SET uname = 'niXXXX',  pass = 'XXXXXXX...,  0,  60,  Array[6],  /admin/modules/ya_deleter.php,  /admin/case/case.ya_deleter.php),


Notice: Undefined variable: nameresult1 in /www/htdocs/w00b57e8/blocks/block-MXS2.php on line 227
Error sql_fetch_row():
descr: mysql_fetch_row(): supplied argument is not a valid MySQL result resource

details:


file: /admin/modules/ya_deleter.php # line: 256,  cmd: mxErrorScreen(null,  /blocks/block-MXS2.php,  /footer.php,  Datenbankfehler: Benutzer konnte nicht zur Datenbank hinzugef&uu...),
file: /admin/modules/ya_deleter.php # line: 431,  cmd: adminactivateaccount(null,  /blocks/block-MXS2.php,  /footer.php,  Datenbankfehler: Benutzer konnte nicht zur Datenbank hinzugef&uu...,  0,  60,  Array[6]),
file: /admin/case/case.ya_deleter.php # line:  25,  cmd: include(null,  /footer.php,  Datenbankfehler: Benutzer konnte nicht zur Datenbank hinzugef&uu...,  0,  60,  Array[6],  /admin/modules/ya_deleter.php),
file: /admin.php # line: 815,  cmd: include_once(null,  /footer.php,  Datenbankfehler: Benutzer konnte nicht zur Datenbank hinzugef&uu...,  0,  60,  Array[6],  /admin/modules/ya_deleter.php,  /admin/case/case.ya_deleter.php),


CMS-Version:         pragmaMx 0.1.11, 1.33.2.12.2.9/2009-05-10     
PHP-Version:            5.2.12-nmm2  (PHP-Info)
MySQL-Version:    5.0.51a-3ubuntu5.7-log