Fix Wordpress Issue Related to MYSQL - Can't Edit or Open Pages List in Wordpress , After Manually Creating via MYSQL Command 11000 pages

Geschlossen Veröffentlicht Jul 21, 2015 Bezahlt bei Lieferung
Geschlossen 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.

MySQL WordPress

Projekt-ID: #8116826

Über das Projekt

18 Vorschläge Remote Projekt Aktiv Oct 5, 2015

18 Freelancer bieten im Durchschnitt $132 für diesen Job

gopalvora

Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joo Mehr

$175 USD in 7 Tagen
(189 Bewertungen)
7.3
KatrinaQ

A proposal has not yet been provided

$40 USD in 0 Tagen
(484 Bewertungen)
7.3
metaexcel

A proposal has not yet been provided

$155 USD in 3 Tagen
(126 Bewertungen)
5.9
techwelfare

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

$174 USD in 9 Tagen
(51 Bewertungen)
5.9
harshatilva

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

$49 USD in 0 Tagen
(19 Bewertungen)
4.3
weblinkbuilding

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

$50 USD in 1 Tag
(8 Bewertungen)
2.9
mohamedgb00714

Aucune proposition n'a encore été fournie.

$155 USD in 3 Tagen
(2 Bewertungen)
1.9
ricks47khan

A proposal has not yet been provided

$155 USD in 3 Tagen
(2 Bewertungen)
1.8
oneskybd

Hi, I am writing in response to your advertisement. After carefully reviewing the experience requirements of the job description it seems to me that my experience is suitable to match for the job. I have experience Mehr

$150 USD in 10 Tagen
(2 Bewertungen)
0.0
Conor0Brien

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!

$66 USD in 1 Tag
(0 Bewertungen)
0.0
krwnet

A proposal has not yet been provided

$250 USD in 1 Tag
(0 Bewertungen)
0.0
Chereeinfomedia1

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

$84 USD in 1 Tag
(0 Bewertungen)
0.0
MatchStickInMoon

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

$111 USD in 3 Tagen
(0 Bewertungen)
0.0
vivekb67

I am ready to take this project. It looks a challenging job. You will have to provide the website URL, admin panel access credentials, FTP access credentials, database access credentials. If possible, provide 3- Mehr

$150 USD in 3 Tagen
(0 Bewertungen)
0.0