evgenyV-2
|
Actually, I did something better (less dangerous for the production). I rebuilt the staging website, all access credentials are exactly as before. The problem manifests itself again, so your colleagues can have a look now. Thanks.
|
Waqas Bin Hasan
Supporter
Languages:
English (English )
Timezone:
Asia/Karachi (GMT+05:00)
|
Thank you for the updates. I can see the problem in the staging.
I've deactivated unnecessary plugins and have requested the team to check in the staging.
I'll update you accordingly.
|
Waqas Bin Hasan
Supporter
Languages:
English (English )
Timezone:
Asia/Karachi (GMT+05:00)
|
Thank you for your patience and cooperation.
Team suggested a solution which I tried on the staging site and it seems to work fine.
Please check and confirm if that's fine and if it hasn't created problems in other areas of the site (i.e. other templates and pages working fine or not).
If that's fine, please let me know and I'll share with you about how to further apply that on the production. Or if it is ok for you, you can share the access to the public site and I can compare, analyze and apply the fix.
Of course, in any case I'll share the details with you beforehand.
I've set your next reply as private to share the access, if needed.
|
evgenyV-2
|
Hi! Good news! The website looks fine so far. What was the solution? I'll try to apply it myself.
|
Waqas Bin Hasan
Supporter
Languages:
English (English )
Timezone:
Asia/Karachi (GMT+05:00)
|
Sure, please follow these step very carefully:
IMPORTANT: Take full backup of your website and database beforehand.
1) Install a database management plugin like https://wordpress.org/plugins/search/phpmyadmin/ or access the database from your hosting control panel.
2) Search for "elementor_pro_theme_builder_conditions" in "option_name" field, in "wp_options" table. The table prefix may be different based on your WordPress settings.
3) Copy the contents of "option_value" field into a text file using a text editor (i.e. notepad or of your choice but not in a Word Processing software to keep the contents unchanged).
4) Then run following query. Please note that since we assume that staging site was cloned from production, it is assumed that post, categories and templates IDs 'll be identical in both sites:
UPDATE `wp_options` SET
`option_value` = 'a:4:{s:7:\"archive\";a:207:{i:31333;a:1:{i:0;s:39:\"include/product_archive/product_cat/403\";}i:31241;a:1:{i:0;s:39:\"include/product_archive/product_cat/401\";}i:31051;a:1:{i:0;s:39:\"include/product_archive/product_cat/398\";}i:30971;a:1:{i:0;s:39:\"include/product_archive/product_cat/396\";}i:30384;a:1:{i:0;s:39:\"include/product_archive/product_cat/391\";}i:30223;a:1:{i:0;s:39:\"include/product_archive/product_cat/389\";}i:30021;a:1:{i:0;s:39:\"include/product_archive/product_cat/387\";}i:29159;a:1:{i:0;s:39:\"include/product_archive/product_cat/372\";}i:29156;a:1:{i:0;s:39:\"include/product_archive/product_cat/371\";}i:29150;a:1:{i:0;s:39:\"include/product_archive/product_cat/385\";}i:29106;a:1:{i:0;s:39:\"include/product_archive/product_cat/382\";}i:29023;a:1:{i:0;s:39:\"include/product_archive/product_cat/380\";}i:28995;a:1:{i:0;s:39:\"include/product_archive/product_cat/378\";}i:28956;a:1:{i:0;s:39:\"include/product_archive/product_cat/376\";}i:28929;a:1:{i:0;s:39:\"include/product_archive/product_cat/373\";}i:28489;a:1:{i:0;s:39:\"include/product_archive/product_cat/369\";}i:28042;a:1:{i:0;s:39:\"include/product_archive/product_cat/366\";}i:27136;a:1:{i:0;s:39:\"include/product_archive/product_cat/363\";}i:27133;a:1:{i:0;s:39:\"include/product_archive/product_cat/362\";}i:26885;a:1:{i:0;s:39:\"include/product_archive/product_cat/358\";}i:24999;a:1:{i:0;s:39:\"include/product_archive/product_cat/294\";}i:24779;a:1:{i:0;s:39:\"include/product_archive/product_cat/291\";}i:24764;a:1:{i:0;s:39:\"include/product_archive/product_cat/292\";}i:24728;a:1:{i:0;s:39:\"include/product_archive/product_cat/290\";}i:24611;a:1:{i:0;s:39:\"include/product_archive/product_cat/289\";}i:24608;a:1:{i:0;s:39:\"include/product_archive/product_cat/289\";}i:24519;a:1:{i:0;s:39:\"include/product_archive/product_cat/287\";}i:24244;a:1:{i:0;s:39:\"include/product_archive/product_cat/273\";}i:23730;a:1:{i:0;s:39:\"include/product_archive/product_cat/247\";}i:23614;a:1:{i:0;s:39:\"include/product_archive/product_cat/246\";}i:23574;a:1:{i:0;s:39:\"include/product_archive/product_cat/245\";}i:23397;a:1:{i:0;s:39:\"include/product_archive/product_cat/243\";}i:23299;a:1:{i:0;s:39:\"include/product_archive/product_cat/241\";}i:23295;a:1:{i:0;s:39:\"include/product_archive/product_cat/242\";}i:23237;a:1:{i:0;s:39:\"include/product_archive/product_cat/240\";}i:23158;a:1:{i:0;s:39:\"include/product_archive/product_cat/239\";}i:22892;a:1:{i:0;s:39:\"include/product_archive/product_cat/238\";}i:22728;a:1:{i:0;s:39:\"include/product_archive/product_cat/237\";}i:22664;a:1:{i:0;s:39:\"include/product_archive/product_cat/236\";}i:22631;a:1:{i:0;s:39:\"include/product_archive/product_cat/235\";}i:22567;a:1:{i:0;s:39:\"include/product_archive/product_cat/259\";}i:22550;a:1:{i:0;s:39:\"include/product_archive/product_cat/234\";}i:21487;a:1:{i:0;s:39:\"include/product_archive/product_cat/233\";}i:21430;a:1:{i:0;s:39:\"include/product_archive/product_cat/232\";}i:21188;a:1:{i:0;s:39:\"include/product_archive/product_cat/231\";}i:21118;a:1:{i:0;s:39:\"include/product_archive/product_cat/230\";}i:16918;a:1:{i:0;s:39:\"include/product_archive/product_cat/224\";}i:16893;a:1:{i:0;s:39:\"include/product_archive/product_cat/223\";}i:16836;a:1:{i:0;s:35:\"include/product_archive/product_cat\";}i:16619;a:1:{i:0;s:39:\"include/product_archive/product_cat/222\";}i:16556;a:1:{i:0;s:39:\"include/product_archive/product_cat/221\";}i:16315;a:1:{i:0;s:39:\"include/product_archive/product_cat/219\";}i:16269;a:1:{i:0;s:39:\"include/product_archive/product_cat/218\";}i:16118;a:1:{i:0;s:39:\"include/product_archive/product_cat/217\";}i:16088;a:1:{i:0;s:39:\"include/product_archive/product_cat/216\";}i:15960;a:1:{i:0;s:39:\"include/product_archive/product_cat/215\";}i:15711;a:1:{i:0;s:39:\"include/product_archive/product_cat/214\";}i:15682;a:1:{i:0;s:39:\"include/product_archive/product_cat/213\";}i:15632;a:1:{i:0;s:39:\"include/product_archive/product_cat/212\";}i:15558;a:1:{i:0;s:39:\"include/product_archive/product_cat/211\";}i:15475;a:1:{i:0;s:39:\"include/product_archive/product_cat/210\";}i:15398;a:1:{i:0;s:39:\"include/product_archive/product_cat/209\";}i:12621;a:1:{i:0;s:39:\"include/product_archive/product_cat/201\";}i:12476;a:1:{i:0;s:39:\"include/product_archive/product_cat/200\";}i:12335;a:1:{i:0;s:39:\"include/product_archive/product_cat/199\";}i:12284;a:1:{i:0;s:39:\"include/product_archive/product_cat/198\";}i:12254;a:1:{i:0;s:39:\"include/product_archive/product_cat/197\";}i:12236;a:1:{i:0;s:39:\"include/product_archive/product_cat/196\";}i:12177;a:1:{i:0;s:39:\"include/product_archive/product_cat/195\";}i:12126;a:1:{i:0;s:39:\"include/product_archive/product_cat/194\";}i:11982;a:1:{i:0;s:39:\"include/product_archive/product_cat/193\";}i:11958;a:1:{i:0;s:39:\"include/product_archive/product_cat/192\";}i:11905;a:1:{i:0;s:39:\"include/product_archive/product_cat/191\";}i:11844;a:1:{i:0;s:39:\"include/product_archive/product_cat/190\";}i:11774;a:1:{i:0;s:39:\"include/product_archive/product_cat/189\";}i:11747;a:1:{i:0;s:39:\"include/product_archive/product_cat/188\";}i:11734;a:1:{i:0;s:39:\"include/product_archive/product_cat/187\";}i:11670;a:1:{i:0;s:39:\"include/product_archive/product_cat/186\";}i:11651;a:1:{i:0;s:39:\"include/product_archive/product_cat/185\";}i:11616;a:1:{i:0;s:39:\"include/product_archive/product_cat/184\";}i:11555;a:1:{i:0;s:39:\"include/product_archive/product_cat/183\";}i:11522;a:1:{i:0;s:39:\"include/product_archive/product_cat/182\";}i:11501;a:1:{i:0;s:39:\"include/product_archive/product_cat/181\";}i:11434;a:1:{i:0;s:39:\"include/product_archive/product_cat/180\";}i:11322;a:1:{i:0;s:39:\"include/product_archive/product_cat/179\";}i:11055;a:1:{i:0;s:39:\"include/product_archive/product_cat/178\";}i:10965;a:1:{i:0;s:39:\"include/product_archive/product_cat/177\";}i:10765;a:1:{i:0;s:39:\"include/product_archive/product_cat/176\";}i:10692;a:1:{i:0;s:39:\"include/product_archive/product_cat/175\";}i:10542;a:1:{i:0;s:39:\"include/product_archive/product_cat/174\";}i:10301;a:1:{i:0;s:39:\"include/product_archive/product_cat/173\";}i:10188;a:1:{i:0;s:39:\"include/product_archive/product_cat/172\";}i:10151;a:1:{i:0;s:39:\"include/product_archive/product_cat/171\";}i:10111;a:1:{i:0;s:39:\"include/product_archive/product_cat/170\";}i:10018;a:1:{i:0;s:39:\"include/product_archive/product_cat/169\";}i:9965;a:1:{i:0;s:39:\"include/product_archive/product_cat/168\";}i:9915;a:1:{i:0;s:39:\"include/product_archive/product_cat/167\";}i:9864;a:1:{i:0;s:39:\"include/product_archive/product_cat/166\";}i:9769;a:1:{i:0;s:39:\"include/product_archive/product_cat/165\";}i:9631;a:1:{i:0;s:39:\"include/product_archive/product_cat/164\";}i:9612;a:1:{i:0;s:39:\"include/product_archive/product_cat/163\";}i:9557;a:1:{i:0;s:39:\"include/product_archive/product_cat/162\";}i:9364;a:1:{i:0;s:39:\"include/product_archive/product_cat/161\";}i:9357;a:1:{i:0;s:39:\"include/product_archive/product_cat/160\";}i:9302;a:1:{i:0;s:39:\"include/product_archive/product_cat/159\";}i:9260;a:1:{i:0;s:39:\"include/product_archive/product_cat/158\";}i:9209;a:1:{i:0;s:39:\"include/product_archive/product_cat/157\";}i:9125;a:1:{i:0;s:39:\"include/product_archive/product_cat/156\";}i:9040;a:1:{i:0;s:39:\"include/product_archive/product_cat/155\";}i:8968;a:1:{i:0;s:39:\"include/product_archive/product_cat/154\";}i:8903;a:1:{i:0;s:39:\"include/product_archive/product_cat/153\";}i:8869;a:1:{i:0;s:39:\"include/product_archive/product_cat/152\";}i:8824;a:1:{i:0;s:39:\"include/product_archive/product_cat/151\";}i:8816;a:1:{i:0;s:39:\"include/product_archive/product_cat/150\";}i:8563;a:1:{i:0;s:39:\"include/product_archive/product_cat/149\";}i:8558;a:1:{i:0;s:39:\"include/product_archive/product_cat/148\";}i:8522;a:1:{i:0;s:39:\"include/product_archive/product_cat/147\";}i:8478;a:1:{i:0;s:39:\"include/product_archive/product_cat/146\";}i:8372;a:1:{i:0;s:39:\"include/product_archive/product_cat/145\";}i:8358;a:1:{i:0;s:39:\"include/product_archive/product_cat/144\";}i:8321;a:1:{i:0;s:39:\"include/product_archive/product_cat/143\";}i:8242;a:1:{i:0;s:39:\"include/product_archive/product_cat/142\";}i:8038;a:1:{i:0;s:39:\"include/product_archive/product_cat/140\";}i:7996;a:1:{i:0;s:39:\"include/product_archive/product_cat/139\";}i:7933;a:1:{i:0;s:39:\"include/product_archive/product_cat/138\";}i:7877;a:1:{i:0;s:39:\"include/product_archive/product_cat/137\";}i:7795;a:1:{i:0;s:39:\"include/product_archive/product_cat/136\";}i:7707;a:1:{i:0;s:39:\"include/product_archive/product_cat/135\";}i:7613;a:1:{i:0;s:39:\"include/product_archive/product_cat/134\";}i:7440;a:1:{i:0;s:39:\"include/product_archive/product_cat/131\";}i:7342;a:1:{i:0;s:39:\"include/product_archive/product_cat/130\";}i:7232;a:1:{i:0;s:39:\"include/product_archive/product_cat/129\";}i:7196;a:1:{i:0;s:39:\"include/product_archive/product_cat/128\";}i:7149;a:1:{i:0;s:39:\"include/product_archive/product_cat/127\";}i:6995;a:1:{i:0;s:39:\"include/product_archive/product_cat/126\";}i:6945;a:1:{i:0;s:39:\"include/product_archive/product_cat/110\";}i:6894;a:1:{i:0;s:39:\"include/product_archive/product_cat/125\";}i:6839;a:1:{i:0;s:39:\"include/product_archive/product_cat/124\";}i:6779;a:1:{i:0;s:39:\"include/product_archive/product_cat/120\";}i:6757;a:1:{i:0;s:39:\"include/product_archive/product_cat/123\";}i:6753;a:1:{i:0;s:39:\"include/product_archive/product_cat/122\";}i:6747;a:1:{i:0;s:39:\"include/product_archive/product_cat/121\";}i:6612;a:1:{i:0;s:39:\"include/product_archive/product_cat/118\";}i:6554;a:1:{i:0;s:39:\"include/product_archive/product_cat/116\";}i:6527;a:1:{i:0;s:39:\"include/product_archive/product_cat/115\";}i:6491;a:1:{i:0;s:39:\"include/product_archive/product_cat/114\";}i:6383;a:1:{i:0;s:39:\"include/product_archive/product_cat/112\";}i:6329;a:1:{i:0;s:39:\"include/product_archive/product_cat/111\";}i:6296;a:1:{i:0;s:39:\"include/product_archive/product_cat/110\";}i:6181;a:1:{i:0;s:39:\"include/product_archive/product_cat/109\";}i:6071;a:1:{i:0;s:39:\"include/product_archive/product_cat/108\";}i:6019;a:1:{i:0;s:39:\"include/product_archive/product_cat/107\";}i:5982;a:1:{i:0;s:39:\"include/product_archive/product_cat/106\";}i:5937;a:1:{i:0;s:39:\"include/product_archive/product_cat/105\";}i:5880;a:1:{i:0;s:39:\"include/product_archive/product_cat/104\";}i:5831;a:1:{i:0;s:39:\"include/product_archive/product_cat/103\";}i:5790;a:1:{i:0;s:39:\"include/product_archive/product_cat/102\";}i:5508;a:1:{i:0;s:39:\"include/product_archive/product_cat/100\";}i:5434;a:1:{i:0;s:38:\"include/product_archive/product_cat/99\";}i:5357;a:1:{i:0;s:38:\"include/product_archive/product_cat/98\";}i:5243;a:1:{i:0;s:38:\"include/product_archive/product_cat/97\";}i:5187;a:1:{i:0;s:38:\"include/product_archive/product_cat/96\";}i:5130;a:1:{i:0;s:38:\"include/product_archive/product_cat/95\";}i:5063;a:1:{i:0;s:38:\"include/product_archive/product_cat/94\";}i:5030;a:1:{i:0;s:38:\"include/product_archive/product_cat/93\";}i:4841;a:1:{i:0;s:38:\"include/product_archive/product_cat/92\";}i:4539;a:1:{i:0;s:38:\"include/product_archive/product_cat/91\";}i:4534;a:1:{i:0;s:38:\"include/product_archive/product_cat/90\";}i:4379;a:1:{i:0;s:38:\"include/product_archive/product_cat/15\";}i:4343;a:1:{i:0;s:38:\"include/product_archive/product_cat/89\";}i:4314;a:1:{i:0;s:38:\"include/product_archive/product_cat/88\";}i:4289;a:1:{i:0;s:38:\"include/product_archive/product_cat/87\";}i:4142;a:1:{i:0;s:38:\"include/product_archive/product_cat/86\";}i:4037;a:1:{i:0;s:38:\"include/product_archive/product_cat/85\";}i:3967;a:1:{i:0;s:38:\"include/product_archive/product_cat/83\";}i:3964;a:1:{i:0;s:38:\"include/product_archive/product_cat/84\";}i:3881;a:1:{i:0;s:38:\"include/product_archive/product_cat/81\";}i:3872;a:1:{i:0;s:38:\"include/product_archive/product_cat/80\";}i:3843;a:1:{i:0;s:38:\"include/product_archive/product_cat/79\";}i:3787;a:1:{i:0;s:38:\"include/product_archive/product_cat/78\";}i:3653;a:1:{i:0;s:38:\"include/product_archive/product_cat/76\";}i:3594;a:1:{i:0;s:38:\"include/product_archive/product_cat/75\";}i:3552;a:1:{i:0;s:38:\"include/product_archive/product_cat/74\";}i:3532;a:1:{i:0;s:38:\"include/product_archive/product_cat/73\";}i:3451;a:1:{i:0;s:38:\"include/product_archive/product_cat/72\";}i:3064;a:1:{i:0;s:38:\"include/product_archive/product_cat/71\";}i:3016;a:1:{i:0;s:38:\"include/product_archive/product_cat/70\";}i:2661;a:1:{i:0;s:38:\"include/product_archive/product_cat/69\";}i:2571;a:1:{i:0;s:38:\"include/product_archive/product_cat/68\";}i:2543;a:1:{i:0;s:38:\"include/product_archive/product_cat/67\";}i:2485;a:1:{i:0;s:38:\"include/product_archive/product_cat/66\";}i:2445;a:1:{i:0;s:38:\"include/product_archive/product_cat/65\";}i:2414;a:1:{i:0;s:38:\"include/product_archive/product_cat/64\";}i:2323;a:1:{i:0;s:38:\"include/product_archive/product_cat/60\";}i:2300;a:1:{i:0;s:38:\"include/product_archive/product_cat/23\";}i:2287;a:1:{i:0;s:38:\"include/product_archive/product_cat/63\";}i:2224;a:1:{i:0;s:38:\"include/product_archive/product_cat/62\";}i:1929;a:1:{i:0;s:38:\"include/product_archive/product_cat/61\";}i:1616;a:1:{i:0;s:38:\"include/product_archive/product_cat/57\";}i:1602;a:1:{i:0;s:38:\"include/product_archive/product_cat/54\";}i:1600;a:1:{i:0;s:38:\"include/product_archive/product_cat/53\";}i:1596;a:1:{i:0;s:38:\"include/product_archive/product_cat/51\";}i:1594;a:1:{i:0;s:38:\"include/product_archive/product_cat/50\";}i:1592;a:1:{i:0;s:38:\"include/product_archive/product_cat/49\";}i:1590;a:1:{i:0;s:38:\"include/product_archive/product_cat/48\";}i:1587;a:1:{i:0;s:38:\"include/product_archive/product_cat/47\";}i:1569;a:1:{i:0;s:23:\"include/product_archive\";}}s:6:\"footer\";a:2:{i:23862;a:1:{i:0;s:15:\"include/general\";}i:1620;a:1:{i:0;s:15:\"include/general\";}}s:6:\"header\";a:2:{i:23852;a:1:{i:0;s:15:\"include/general\";}i:1542;a:1:{i:0;s:15:\"include/general\";}}s:6:\"single\";a:1:{i:1584;a:1:{i:0;s:15:\"include/product\";}}}',
`autoload` = 'yes'
WHERE `option_name` = 'elementor_pro_theme_builder_conditions';
5) Repeat ONLY the step #2 to get the new value.
6) Compare the both values, the one you saved in text (step #3) and the new you got in step #5, probably with hidden link and note down the change for later use (in case it didn't work correctly).
7) Check your site for the original issue, as well as, check other areas of the site to confirm if it hasn't produced any side-effects. In the side-effects case, you can restore either the DB or can simply update the value to the previous one you got in step #2 and saved in step #3.
Please let me know.
|
evgenyV-2
|
Hi. I did everything and, as for now, I don't see any problems. I asked a colleague to go through the site more thoroughly, just to make sure. Any thoughts on how to make sure this doesn't happen again? Anything we can learn from this? What was the problem exactly?
|
Waqas Bin Hasan
Supporter
Languages:
English (English )
Timezone:
Asia/Karachi (GMT+05:00)
|
Glad that it worked and resolved the issue.
Looks like there was some conflicting rules in the option key: elementor_pro_theme_builder_conditions
[29159] => Array
(
[0] => exclude/product_archive
)
[29156] => Array
(
[0] => include/product_archive/product_cat/371
)
This may happen due to a corrupted DB operation, simultaneously editing the same stuff (i.e. different people or in tabs), a broken save/update event or etc.
So it is good to edit in once place, one by one, for each language or pages/posts/templates.
Since issue has been resolved, I'll request to close the ticket. And feel free to open a new one anytime for anything WPML related.
Have a great weekend 🙂
|
evgenyV-2
|
Thank you. Have a great weekend, too.
|
