plazman65 Posted July 17, 2014 Share Posted July 17, 2014 Hi! I have been upgrading my database to 2.3 and one thing I noticed is that the product attributes was hiding for customers if they werent logged in.. I narrowed it down to the product_attributes table One column (attributes_hide_from_group) all have the value of 0 right now. I need them to have a value of @ How do I change all the values of the existing attributes_hide_from_groups from 0 to @ when I went in and manually changed a few showed correctly. Im a little scared to write the mysql myself and do it correctly :) Thanks! Link to comment Share on other sites More sharing options...
Jack_mcs Posted July 17, 2014 Share Posted July 17, 2014 That's not a stock option. You will need to determine which addon it is from and then ask in its support thread. Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
plazman65 Posted July 17, 2014 Author Share Posted July 17, 2014 Ok . I just needed help with a mysql statement though not the add on.. I must have posted it in the wrong spot. Off to google and hope I dont screw it up Link to comment Share on other sites More sharing options...
♥bruyndoncx Posted July 17, 2014 Share Posted July 17, 2014 update product_attributes set attributes_hide_from_group = "@" where attributes_hide_from_group = "0"; changes all 0 to @ KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt Link to comment Share on other sites More sharing options...
plazman65 Posted July 17, 2014 Author Share Posted July 17, 2014 update product_attributes set attributes_hide_from_group = "@" where attributes_hide_from_group = "0"; changes all 0 to @ Thank you so much!! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.