ketanco
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: Unpublishing postsI understand. But even if appearing in search results, if someone clicks it, its content will not be visible anymore right?
Forum: Fixing WordPress
In reply to: Best way to unnpublishThanks. What do you mean by pointing DNS to somewhere else and where? You mean the website domain name will not work?
Forum: Fixing WordPress
In reply to: Why db size increasedyou are correct
thank you guys !Forum: Fixing WordPress
In reply to: Why db size increasedI tried a plugin wp optimize 3.1.2 as it had highest installation and ratings
it reduced overhead columns, and the size of file by about 10MB
I am now barely at the point of yesterday. Still cannot figure how the db size went up yesterday anyway but so it is goign down nowForum: Fixing WordPress
In reply to: How to delete these rows?Yes you are right, it just started here because it was wordpress site. I am figuring this out separately thanks
Forum: Fixing WordPress
In reply to: How to delete these rows?Ok so I used
DELETE from wp_options where option_name like “%_wp_session_%” and option_id between 5000 and 10000and it works.
the first time i did deletion, i deleted only about 500 rows (my numbers were different than 5000 and 10000) and then i checked the total number of rows of table and it indeed went down by 500
but then i deleted about 2500 rows but the total number of rows of table ent down by only few hundred. although it said 2500 rows affected by my deletion. how can this be?
Forum: Fixing WordPress
In reply to: How to delete these rows?It didnt do anything
Just in case I did a search query with same criteria and it generated the following code:
SELECT * FROM
wp_optionsWHEREoption_idBETWEEN 5000 AND 10000 ANDoption_nameLIKE ‘%_wp_session_%’But when I replaced select with delete it gave syntax error.
But if I try yours, it doesnt do anything. May be the % after wp session should be added to yours?Forum: Fixing WordPress
In reply to: Why db size increasedYes of course, so that physically deletes these right? I just couldnt understand why the db size increased suddenly. Now I started checking the total number of rows in the database, as in phpmyadmin it writes the sum. At least that also decreases, so i am sure that not only the wp options table I am deleting decreases, but the total rows also decrease. So no new rows is opening somewhere mysterical and things get physically deleted. I just couldnt understand why file size had increased. Even when I opened them in notepad and compared number of characters, the number of characters had also increased, although the rows are decreasing. weird
Forum: Fixing WordPress
In reply to: Why db size increasedI open the table, I select the rows I ant to delete and hit delete and it lists all rows I selected such as:
DELETE FROM
wp_optionsWHEREwp_options.option_id= 118444;
…
…And I hit yes….
So this doesnt physically remove these rows? if not where do these rows go?I dont see “drop” anywhere for this. (I saw drop for entire table but I will not delete entire table)
Forum: Fixing WordPress
In reply to: Why db size increasedso here do the deleted rows go? still stay in database?
I cannot follow this now. I dont want to do soething wrong
Where do the deleted rows go? If I know I can physically remove
I thought when we deleted rowss from database it is physically removing
And it still doesnt explain the file size increase
So this generic info dont work for me- This reply was modified 5 years, 11 months ago by ketanco.
Forum: Fixing WordPress
In reply to: why htaccess file was deleted after copying in backupI didn’t use any plugin . I just did it myself by an ftp program (I use winSCP)
Forum: Fixing WordPress
In reply to: How to fix the following fatal errorwow it works thanks a lot
does this method (deleting everything except wp-content and wpconfig file) apply to bigger sites too? or you suggested it because I said my site was very small with one post?If this method applies to all sites (assuming nobody messed with wp admin or wp includes folders, which I do not), then when I am hacked, I do like this, and even if it still doesnt work (i.e. something is wrong in wp-content folder as well), then all there is left for me to check is the wpcontent folder correct? it is much better than also checking wp-admin and wp-includes folders as well
Forum: Fixing WordPress
In reply to: How to fix the following fatal error@macmanx
thanks and I tried all, that you said but nothing worksFor example in the first link you referred me to, for the phpmyadmin option, my setting was already set to a:0:{}
Then I tried the ftp option, but I only have one theme there, which was already default theme, twenty twenty.
So what can I do now?
This was a default wp site with only 1 post in it with only akismet as plugin and apparently even that was not activated I think
- This reply was modified 5 years, 11 months ago by ketanco.
Forum: Fixing WordPress
In reply to: How to fix the following fatal errorI will try and let you know. In the mean time what do you mean by default theme? You mean 2020 or 2019 or something or which theme?
Forum: Fixing WordPress
In reply to: Site still had malware even if I use wordfenceSo in the wordfence options the following four was unchecked (others were checked):
-Scan theme files against repository versions for changes
-Scan plugin files against repository versions for changes
-Scan files outside your WordPress installation
-Scan images, binary, and other files as if they were executableso what you mean is to check all these and scan again correct?