Using real estate press theme . site has been hacked and some one created 450,000+ listings . My only questions is that is there anyways to remove all listings from MYSQL database?
Any help and advise will be much appreciated.
Hello W, You can remove listings from Listing Manager or by accessing your database >phpMyAdmin and locate the table wp_posts
as i have mentioned above listing manager only displays up to 30 listings . there are 450,000+ listings to be removed ? wp_posts
doesnt show up these listings . only articles etc.
thanks i have manage to sort this out .
Thanks for updating W 🙂
Ok JOSH, i have soled problem above. Now i have moved the hosting and site showing no image. However images are in upload folder still it showing no image. i have tried every thing changed the permission of folder and files etc. Nothing solving the problem . Its been month struggling to solve the issue. ANY help will be appreciated.
Hello W, Try this plugin >>https://wordpress.org/plugins/velvet-blues-update-urls/
I think within the database there are file references (as opposed to urls) to the public_html folder. When you moved hosts the file path to your public_html may have changed and hence file path to uploads folder
In the database there are file references to images eg. home/username/public_html/wp-content/uploads/image.jpg
You could check your database for references to public_html and uploads to see if this is the problem.
I can’t guarantee this is your problem but worth checking.
Nope nor the plugin above nor the second option. Janak was well aware of that. Moving to new hosting wasn’t a problem as old files and database brings complete website without any issues . Images showing fine, listing opening fine etc. As long as you update the responsive theme to latest version everything else works fine just images on listings stop showing and instead a blank image appears . I have reuploded all the images still, changed the file permission and played with it 755, 744, 644 everything . Nothing works.
Start your new website today!