Uninstalling Product

[stb74]

How do you uninstall the product as I tried and no one could login as I got the following error. I was able to get round it by adding "dbtech_vbactivity_points" back in.

Invalid SQL:

               SELECT
                       post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
                       user.*, userfield.*, usertextfield.*,
                       icon.title as icontitle, icon.iconpath,
                       avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,


                       editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
                       editlog.reason AS edit_reason, editlog.hashistory,
                       postparsed.pagetext_html, postparsed.hasimages,
                       sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
                       sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
                       IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

                       , (user.dbtech_vbactivity_points) AS vbcredits_5, user.dbtech_vbactivity_points AS vbcreditsb_5, (user.credits) AS vbcredits_1, user.credits AS vbcreditsb_1, (user.credits_saved) AS vbcredits_2, user.credits_saved AS vbcreditsb_2
               FROM vb_post AS post
               LEFT JOIN vb_user AS user ON(user.userid = post.userid)
               LEFT JOIN vb_userfield AS userfield ON(userfield.userid = user.userid)
               LEFT JOIN vb_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
               LEFT JOIN vb_icon AS icon ON(icon.iconid = post.iconid)
               LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)


               LEFT JOIN vb_editlog AS editlog ON(editlog.postid = post.postid)
               LEFT JOIN vb_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 18 AND postparsed.languageid = 1)
               LEFT JOIN vb_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 18 AND sigparsed.languageid = 1)
               LEFT JOIN vb_sigpic AS sigpic ON(sigpic.userid = post.userid)

               WHERE post.postid IN (0374074,374084,374140)
               ORDER BY post.dateline;

MySQL Error   : Unknown column 'user.dbtech_vbactivity_points' in 'field list'
Error Number  : 1054
Request Date  : Thursday, November 4th 2010 @ 12:23:12 AM
Error Date    : Thursday, November 4th 2010 @ 12:23:12 AM
Script        : http://www.nifootball.co.uk/forum/bdfl-division-1/10869-b-d-division-1-select-team.html
Referrer      :
IP Address    : 207.46.204.194
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

 

[Fillip H.]

That error appears to be because you have configured vBCredits to read from vBActivity's points column.

If you change those settings, that should prevent this from happening