Announcement

Collapse
No announcement yet.

Error when editing users in the Admin CP -

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

  • Error when editing users in the Admin CP -

    I deleted a plugin called COMMBULL that i used to use to send out a weekly newsletter.

    Now whenever I attempt to edit any user in the Admin CP I get the following DB error

    Code:
    Database error in vBulletin 3.8.5:
    
    Invalid SQL:
    UPDATE vb3_user 
    	SET receivebulletin = '0'
    	WHERE userid = '2';
    
    MySQL Error   : Unknown column 'receivebulletin' in 'field list'
    Error Number  : 1054
    Request Date  : Friday, March 19th 2010 @ 08:22:55 PM
    Error Date    : Friday, March 19th 2010 @ 08:22:55 PM
    Script        : http://xlforum.net/xxxxxx/xxxxxx/xxxxxxx/user.php?do=update
    Referrer      : http://xlforum.net/xxxxxx/xxxxx/xxxxxxxxx/user.php?do=edit&u=2
    IP Address    : xxx.xxx.xxx.xxx
    Username      : xxxxxxx
    How do I fix this?

  • #2
    Additionally, on the User Manager page I see the option "Receive Community Bulletin Newsletters" with radio buttons for YES and NO

    I think it is trying to modify a field that is no longer in the database. How do I fix this?

    I think I need to edit the modifyoptions template.

    This is in the modifyoptions template

    Code:
    <td><label for="commbull"><input type="checkbox" name="commbull" value="1" id="commbull" $checked[receivebulletin] />$vbphrase[receive_email_from_commbull]</label><input type="hidden" name="set_options[receivebulletin]" value="1" /></td>
    					</tr>
    					<tr>
    						<td><br />$vbphrase[newsletterformat]<br /><label for="commbull_type"><input type="checkbox" name="commbull_type" value="1" id="commbull_type" $checked[receivebulletin_type] />$vbphrase[type_email_from_commbull]</label><input type="hidden" name="set_options[receivebulletin_type]" value="1" /></td>

    Comment


    • #3
      Anyone have any advise for this?

      Comment


      • #4
        in the user table, colums 'receivevbulletin' is not a default column, therefore you should be able to delete the colum from tha user table safely. Be sure to backup beforehand!
        http://www.vbulletin.com/forum/image...avbit-home.png Eclipse Records - independent record company focused on active rock & alternative metal music
        http://www.vbulletin.com/forum/image...avbit-home.png Streetcult Street Team Marketing - grassroots marketing, promotion, consulting, & digital distribution

        Comment


        • #5
          Did you remove all files and uninstall the product as instructed?
          That's it. If you REALLY can't say ANYTHING nice to me at all on this forum, then I am going to go insanely mad at you. I've had enough of the UNTOLD ABUSE you are all giving me and you should really be CONSIDERATE of other people.

          Comment


          • #6
            I ended up just reinstalling the upgraded CommBull plug-in. It is a good plug-in and maybe I will use it in the future.

            Comment

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