Announcement

Collapse
No announcement yet.

Edit User errors

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

  • Edit User errors

    Any one have an idea what this problem could be.. We just started getting this error out of the blue when we try to edit a users "User Group".

    Database error in vBulletin Control Panel 2.2.6:
    Invalid SQL: UPDATE user SET birthday='0000-00-00',options='15',usergroupid='8',username='Risewire',email='[email protected]',styleid ='1',parentemail='',coppauser=0,homepage='http://www.risewire.com',icq='',aim='',yahoo='mailbox185
    ',signature='',adminemail=1,receivebulletin=1,receivebulletin_type=0,showemail=1,invisible =0,usertitle='Vortech Inc. Customer',customtitle=0,joindate=UNIX_TIMESTAMP('2002-08-21 05:39:06'),cookieuser=1,nosessionhash=1,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2002-12-19 07:02:40'),lastactivity=UNIX_TIMESTAMP('2002-12-19 17:54:50'),lastpost=UNIX_TIMESTAMP('2002-12-18 01:18:52'),posts='19',timezoneoffset='0',emailnotification=1,receivepm='1'
    ,emailonpm='0',ipaddress='24.116.39.8',pmpopup=IF(pmpopup=2 AND 0=1,pmpopup,'0') WHERE userid=64
    mysql error: Unknown column 'receivebulletin_type' in 'field list'
    mysql error number: 1054
    Date: Friday 20th of December 2002 10:23:40 AM
    Script: http://www.matrixreseller.com/forum/...admin/user.php
    Referer: http://www.matrixreseller.com/forum/...&userid=64
    User Group

  • #2
    Originally posted by Vortech
    Any one have an idea what this problem could be.. We just started getting this error out of the blue when we try to edit a users "User Group".

    Database error in vBulletin Control Panel 2.2.6:
    Invalid SQL: UPDATE user SET birthday='0000-00-00',options='15',usergroupid='8',username='Risewire',email='[email protected]',styleid ='1',parentemail='',coppauser=0,homepage='http://www.risewire.com',icq='',aim='',yahoo='mailbox185
    ',signature='',adminemail=1,receivebulletin=1,receivebulletin_type=0,showemail=1,invisible =0,usertitle='Vortech Inc. Customer',customtitle=0,joindate=UNIX_TIMESTAMP('2002-08-21 05:39:06'),cookieuser=1,nosessionhash=1,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2002-12-19 07:02:40'),lastactivity=UNIX_TIMESTAMP('2002-12-19 17:54:50'),lastpost=UNIX_TIMESTAMP('2002-12-18 01:18:52'),posts='19',timezoneoffset='0',emailnotification=1,receivepm='1'
    ,emailonpm='0',ipaddress='24.116.39.8',pmpopup=IF(pmpopup=2 AND 0=1,pmpopup,'0') WHERE userid=64
    mysql error: Unknown column 'receivebulletin_type' in 'field list'
    mysql error number: 1054
    Date: Friday 20th of December 2002 10:23:40 AM
    Script: http://www.matrixreseller.com/forum/...admin/user.php
    Referer: http://www.matrixreseller.com/forum/...&userid=64
    User Group
    The column 'receivebulletin_type' is from a hack. You'll need to ask for help over in the appropriate hack thread at vbulletin.org.
    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
      Originally posted by Steve Machol
      The column 'receivebulletin_type' is from a hack. You'll need to ask for help over in the appropriate hack thread at vbulletin.org.
      I got that all fixed by upgrading out forum to 2.2.9 now. Not sure what that hack was but oh well..

      Now I seem to have anther problem..

      We added a Custom Profile Fields and made it so it would show up on the left had side like where user name is.

      admin
      Administrator
      Registered: Mar 2002
      Location:
      Posts: 1134
      User Name: "there user name here"



      The user name comes from a Field in there porfile and use to look right. But now it shows up like this below.
      [[(6==6)]] User Name: [[/(6==6)]]

      Any ideas?? All its doing it pulling the info to display it to admins only.

      Comment


      • #4
        This is the code we have in Template name postbit.

        But does not seem to be working any more after the upgrade it just displays the info like above..

        [[($bbuserinfo[usergroupid]==5)]]
        User Name: $post[field5]
        [[/($bbuserinfo[usergroupid]==5)]]

        Comment


        • #5
          I don't belive you can use [[/($bbuserinfo[usergroupid]==5)]] in the postbit template. Assuming everything else is correct, just $post[field5] should be enough to display the name.
          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

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