Fix Wordpress Issue Related to MYSQL - Can't Edit or Open Pages List in Wordpress , After Manually Creating via MYSQL Command 11000 pages
$30-250 USD
Bezahlt bei Lieferung
We created 11000 pages with MYSQL command. Our problem is that now when we login Wordpress admin, we can't open the pages List, or edit any page. Anything related to loading pages doesn't work. We get error 502 as it takes too long.
In the Error log, we see a command like this: [Tue Jul 21 12:13:52.469357 2015] [:error] [pid 13243] [client IP:64666] KILLED QUERY (56282 characters long generated): SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (10777,152,422,552,611,753,814,888,967,1004,1039,1199,1321,1420,1555,1591,1593,1609,1778,1816,1892,1936,2055,2072,2074,2184,2338,2349,2412,2495,2519,2538,2595,2649,2677,2897,2922,2923,2932,2974,3025,3046,3070,3093,3094,3138,3168,3202,3335,3497,3824,3925,4067,4164,4285,4307,4332,4435,4445,4583,4604,4683,4719,4794,4817,4841,4854,4863,4900,4918,4961,4970,4979,4994,5011,5093,5132,5216,5289,5313,5352,5362,5399,5533,5653,5680,5700,5762,5790,5853,5938,6010,6221,6367,6537,6593,6625,6682,6902,7295,7335,7531,7718,7728,7766,7914,7982,8094,8137,8219,8287,8342,8343,8670,8790,8981,9093,9282,9331,9466,9609,9642,9965,10054,10094,10159,10288,10525,1
Of course, if it tried to select from 11000 pages every time we need to edit a page or open pages list in Wordpress admin, it won't be able to do it ... but we don't know why it does this. It could be something with the post_meta data.
We need you to 1. fix the problem, 2. explain what the problem was. We will provide MYSQL access and Wordpress admin. FTP if needed. We prefer if you use dbForge, so we give you directly access to the database.
This job is quick. You must start immediately.
Projekt-ID: #8116826
Über das Projekt
18 Freelancer bieten im Durchschnitt $132 für diesen Job
Hello Let's explore the requirement and kindly let us know if you would like us to share our skills & experiences with previous development. thanks & Regards Moumita
Hi, I hope you are doing fine. I am new to freelancing but I have 4 to 5 year experience in designing and developing. I read your project description and would like to work with you. I will provide you 100% sa Mehr
Hello, I am WordPress expert. I would like to start work immediately. If you have any doubt then, please check my profile to know the work activities we have done so far. If you are interested or want to ask any que Mehr
Highly experienced in PHP & MySQL The problem could be to do with the memory allocated to wordpress in the PHP settings I can resolve this fast i am sure . Ready to get working!
Dear Bid Manager, I understand your requirement and its hardly 30 mins work for me i need ftp /cpanel and mysql information from your side solution of this bug is you need to run a query in d Mehr
It's easy, as you said, It must be that you use "SELECT ... IN (,,,)", It has too much IDs so that a too long error occur. So you just need replace it " SELECT ... IN (SELECT id FROM yourPostIdFrom)" ,then there is no Mehr