Announcement

Collapse
No announcement yet.

after converting from mybb to vbulletin

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

  • after converting from mybb to vbulletin

    if im going to some user profile which have been imported from the last forum, the page looks like this :
    http://math-pl.co.il/forums/member.php?u=27


    and i get this message :

    Warning: mktime() expects parameter 4 to be long, string given in [path]/includes/class_userprofile.php on line 260

    rows about 245-270 :

    PHP Code:
     
        
    if ($year $bday[2] AND $bday[2] > 1901 AND $bday[2] != '0000' AND $userinfo['showbirthday'] == 2)
        {
         require_once(
    DIR '/includes/functions_misc.php');
         
    $this->registry->options['calformat1'] = mktimefix($this->registry->options['calformat1'], $bday[2]);
         if (
    $bday[2] >= 1970)
         {
          
    $yearpass $bday[2];
         }
         else
         {
          
    // day of the week patterns repeat every 28 years, so
          // find the first year >= 1970 that has this pattern
          
    $yearpass $bday[2] + 28 ceil((1970 $bday[2]) / 28);
         }
         
    $this->prepared['birthday'] = vbdate($this->registry->options['calformat1'], mktime(000$bday[0], $bday[1], $yearpass), falsetruefalse);
        }
        else
        {
         
    // lets send a valid year as some PHP3 don't like year to be 0
         
    $this->prepared['birthday'] = vbdate($this->registry->options['calformat2'], mktime(000$bday[0], $bday[1], 1992), falsetruefalse);
        }
        if (
    $this->prepared['birthday'] == '')
        {
         if (
    $bday[2] == '0000')
         {
          
    $this->prepared['birthday'] = "$bday[0]-$bday[1]";
         }
         else
         {
          
    $this->prepared['birthday'] = "$bday[0]-$bday[1]-$bday[2]";
         }
        }
       }
      }
     } 
    didnt touch anything..
    בגרות במתמטיקה | פתרונות לספרי לימוד

  • #2
    This generally means that they did not have a birth year. You need to manually edit his account and add a birth year.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      In your vBulletin database what does this return :

      Code:
      SELECT birthday_search, birthday FROM user WHERE userid=27;
      I wrote ImpEx.

      Blog | Me

      Comment


      • #4
        jerry :

        error number: 1146
        error description: Table 'imiviortalvb.user' doesn't exist

        steve, that happends for all users...
        בגרות במתמטיקה | פתרונות לספרי לימוד

        Comment


        • #5
          You need to use the appropriate table prefix in front of 'user'.
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment


          • #6
            how can i do that?
            בגרות במתמטיקה | פתרונות לספרי לימוד

            Comment


            • #7
              Find out what the table prefix is by looking at your config.php file, then adding it to that query.
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment


              • #8
                i.e.

                Code:
                SELECT birthday_search, birthday FROM [b]vb_[/b]user WHERE userid=27;
                I wrote ImpEx.

                Blog | Me

                Comment


                • #9
                  well that brings me :
                  0000-00-00--
                  בגרות במתמטיקה | פתרונות לספרי לימוד

                  Comment


                  • #10
                    and i cant edit 1400 users profile...
                    so how can i fix that?
                    בגרות במתמטיקה | פתרונות לספרי לימוד

                    Comment


                    • #11
                      Code:
                      UPDATE vb_user SET birthday='00-00-0000' WHERE birthday='--';
                      I wrote ImpEx.

                      Blog | Me

                      Comment


                      • #12
                        thanks man it worked..
                        בגרות במתמטיקה | פתרונות לספרי לימוד

                        Comment


                        • #13
                          Originally posted by imiviortal View Post
                          thanks man it worked..
                          Importing the net, one site at a time
                          I wrote ImpEx.

                          Blog | Me

                          Comment


                          • #14
                            Eh, life saving post. My thanks as well.

                            Comment

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