WordPress: Approve all group requests for buddypress from phpmyadmin/backend

10 January 2012  in Applications / CMS / HowTos / Programming / SQL  tagged buddypress / mysql / sql / wordpress by Tux

---

Execute the following SQL snippet on the database

UPDATE wp_bp_groups_members
SET `is_confirmed` = 1
WHERE 1

Share this:

• Share

• Email
• Print
• Facebook
• Reddit
• Twitter

MySQL Workbench: A solution to Error Code 1175

While using MySQL Workbench, we tried to execute an UPDATE command that did not use the Key of the table in the WHERE clause. In our case, it did not matter and it was expected to perform that update without that restriction. When we tried to execute the code though,…

15 June 2016

In "SQL"

Count how many submissions per score

Recently, we had access to a database that contained the scores of a programming competitions system. The database contained several contests, each contest contained several challenges and any competitor could make multiple submissions. We wanted to extract a couple of charts showing how many submissions we had per score and…

2 January 2018

In "SQL"

psftp.exe: The server’s host key is not cached in the registry. You have no guarantee that the server is the computer you think it is.

Recently, we were debugging a scheduled job running on a Microsoft SQL Server Agent. After starting the SQL Server Management Studio, we saw that the specific task was using psftp.exe to upload some data securely to a remote server. When executing the job manually, it would work as expected. On…

1 May 2021

In "Windows"

This post is also available in: Greek

---

---