algunillo
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: How to bulk delete users directly from phpMyAdmin/MySQL databases@diondesigns : Thank you! The solution you provided was effective, fast, and easy to implement. Now my problem is solved.
Forum: Fixing WordPress
In reply to: How to bulk delete users directly from phpMyAdmin/MySQL databasesThanks for the advice!
I did not specify that:
– there are only three real users, and
– all unwanted users have the same role, while real users have different rolesTherefore, of is easy to separate real ones from fake ones.
@markrh : Yes, thank you. That was already done, but now I have to get rid of all those fake users.
@vijayhardaha : Thank you. For adding the IDs of the users I want to delete, can it be done using their role? Or I can simply do it for all and leave out the three real users…
I’m not good with MySQL queries, but I’m not so bad at programming in general, so I believe that I can manage. I’ll try to follow the steps you outline.@gappiah : Thank you. The criteria is found, because I want to delete all “subscribers”, or I want to delete all users but three, which I can select manually.
Exactly what I’m looking for is the query that will allow me to delete them.Forum: Fixing WordPress
In reply to: Unable to commentAfter 4 days of managing files, reading all documentation, etc., I finally found which the problem was:
In the permalink section, I selected to put an additional word for a given category (the only one existing up to now).
For some reason, that upset everything: For visitors, posts could only be reached from the category widget, and comments could not be posted nor read.
Erasing that word fixed everything.
- This reply was modified 7 years, 9 months ago by algunillo.
Forum: Fixing WordPress
In reply to: Unable to commentI finally found the active_plugins row in the option_name column. It was set at a:0:{}, as required. I changed the value, then entered that one again, but it did not work.
Forum: Fixing WordPress
In reply to: Unable to commentThanks for your reply, @esmi.
– I deactivated all plugins. This allows me to post comments if I select the post from the “all posts” page, but comments cannot be posted nor read from the post itself (so only admins and editors could post and read comments, I think). If I try to read or post a comment from the post, I get again the “Oops! That page can’t be found.” page.
– Cannot decide which is the default theme. When I started the blog (one week ago) there were three themes to choose from. Now I went to the themes page again, found the same three themes, could not know which one was default.
– Tried PhpMyAdmin, but it says I must look for the active_plugins row in the option_name column, but there is not such a row, even if I activate again some plugins and refresh the PhpMyAdmin page.
– Tried FileZilla, but when adding my domain it shows the following:
Resolving address of mydomain.com
Status: Connecting to 108.167.181.69:21…
Status: Connection established, waiting for welcome message…
Response: 220———- Welcome to Pure-FTPd [privsep] [TLS] ———-
Response: 220-You are user number 3 of 150 allowed.
Response: 220-Local time is now 10:16. Server port: 21.
Response: 220-IPv6 connections are also welcome on this server.
Response: 220 You will be disconnected after 15 minutes of inactivity.
Command: AUTH TLS
Error: Connection timed out after 20 seconds of inactivity
Error: Could not connect to server– How can I access the folders to delete? Should I do that before downloading WordPress again? I am willing to start the blog again from scratch if it will solve the problem, but do not know how to do it.
I have looked at several forums, and nobody seems to have a similar problem. I have been stuck with this for three days by now.