Jack_mcs 1,116 Posted July 17, 2018 55 minutes ago, PiLLaO said: This 404 page don't have a look like the website, that's why I want to use a custom page instead this notfound_404.php Take a look at the Custom Server Error Pages addon. If you use it, you should remove the 403 and 509 codes. 1 PiLLaO reacted to this Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Need Help? See this thread and provide the information requested. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
Hotclutch 191 Posted July 17, 2018 6 hours ago, PiLLaO said: Hola Rainer, I tried to make it, but I can't show header, footer and categories box... You don't need all this on a 404 page. All you need is a not found notice and a link to somewhere useful. The HTML on that page is very simple and can be replaced, there are many templates online. Here is a bootstrap example from bootsnip: https://bootsnipp.com/snippets/Oel4q Share this post Link to post Share on other sites
Hotclutch 191 Posted July 17, 2018 @PiLLaO Replace your 404 page with this one: You need to do the following things: 1) On line 38 change the base reference to your URL. 2) If you do not use a favicon, delete line 42. That's it, now you have a boostrap 404 page. <?php /** * * ULTIMATE Seo Urls 5 PRO ( version 1.1 ) * * * @package USU5_PRO * @license http://www.opensource.org/licenses/gpl-2.0.php GNU Public License * @link http://www.fwrmedia.co.uk * @copyright Copyright 2008-2009 FWR Media * @copyright Portions Copyright 2005 ( rewrite uri concept ) Bobby Easland * @author Robert Fisher, FWR Media, http://www.fwrmedia.co.uk * @lastdev $Author:: Rob $: Author of last commit * @lastmod $Date:: 2010-12-21 22:45:02 +0000 (Tue, 21 Dec 2010) $: Date of last commit * @version $Rev:: 196 $: Revision of last commit * @Id $Id:: notfound_404.php 196 2010-12-21 22:45:02Z Rob $: Full Details */ /** * Page not found html with 404 header * @package USU5_PRO * * @var array $text - array of text strings to be used in the html */ $text = array( 'title' => 'Page not found', 'text' => 'The page you were looking for could not be found. Please click the below link to return to ' . STORE_NAME . ' <p><a href="' . tep_href_link( 'index.php' ) . '" title="' . STORE_NAME . '">' . STORE_NAME . '</a></p><br />' ); header( "HTTP/1.1 404 Not Found" ); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <title>Page Not Found</title> <base href="https://www.example.com/"> <link href="ext/bootstrap/css/bootstrap.min.css" rel="stylesheet"> <script defer src="https://use.fontawesome.com/releases/v5.1.0/js/all.js"></script> <link rel=icon href=favicon.png sizes="16x16" type="image/png"> <!--[if lt IE 9]> <script src="ext/js/html5shiv.js"></script> <script src="ext/js/respond.min.js"></script> <script src="ext/js/excanvas.min.js"></script> <![endif]--> <script src="ext/jquery/jquery-3.1.1.min.js"></script> <style> .error-404 { margin: 0 auto; text-align: center } .error-404 .error-code { bottom: 60%; color: #4686CC; font-size: 96px; line-height: 100px; font-weight: bold } .error-404 .error-desc { font-size: 12px; color: #647788 } .error-404 .m-b-10 { margin-bottom: 10px!important } .error-404 .m-b-20 { margin-bottom: 20px!important } .error-404 .m-t-20 { margin-top: 20px!important } </style> </head> <body> <div class="error-404"> <div class="error-code m-b-10 m-t-20">404 <i class="fas fa-exclamation-triangle"></i></div> <h2 class="font-bold">Oops 404! That page can’t be found.</h2> <div class="error-desc"> Sorry, but the page you are looking for was either not found or does not exist. <br> Try refreshing the page or click the button below to go back to the Homepage. <div><br> <a href="/" class="btn btn-primary"><span class="fas fa-home" data-fa-transform="up-2" aria-hidden="true"></span> Go back to Homepage</a> </div> </div> </div> <script src="ext/bootstrap/js/bootstrap.min.js"></script> </body> </html> 1 PiLLaO reacted to this Share this post Link to post Share on other sites
Hotclutch 191 Posted July 17, 2018 ^^ Change the html tag on line 32 for your language. Share this post Link to post Share on other sites
PiLLaO 35 Posted July 17, 2018 9 hours ago, Jack_mcs said: Take a look at the Custom Server Error Pages addon. If you use it, you should remove the 403 and 509 codes. With Ultime Seo Urls be FWR, products and categories not found have the same issue, the server_error.php needs to reload application_top, template_top, etc... and get error. Another urls that not found, works correctly Share this post Link to post Share on other sites
PiLLaO 35 Posted July 17, 2018 2 hours ago, Hotclutch said: @PiLLaO Replace your 404 page with this one: You need to do the following things: 1) On line 38 change the base reference to your URL. 2) If you do not use a favicon, delete line 42. That's it, now you have a boostrap 404 page. <?php /** * * ULTIMATE Seo Urls 5 PRO ( version 1.1 ) * * * @package USU5_PRO * @license http://www.opensource.org/licenses/gpl-2.0.php GNU Public License * @link http://www.fwrmedia.co.uk * @copyright Copyright 2008-2009 FWR Media * @copyright Portions Copyright 2005 ( rewrite uri concept ) Bobby Easland * @author Robert Fisher, FWR Media, http://www.fwrmedia.co.uk * @lastdev $Author:: Rob $: Author of last commit * @lastmod $Date:: 2010-12-21 22:45:02 +0000 (Tue, 21 Dec 2010) $: Date of last commit * @version $Rev:: 196 $: Revision of last commit * @Id $Id:: notfound_404.php 196 2010-12-21 22:45:02Z Rob $: Full Details */ /** * Page not found html with 404 header * @package USU5_PRO * * @var array $text - array of text strings to be used in the html */ $text = array( 'title' => 'Page not found', 'text' => 'The page you were looking for could not be found. Please click the below link to return to ' . STORE_NAME . ' <p><a href="' . tep_href_link( 'index.php' ) . '" title="' . STORE_NAME . '">' . STORE_NAME . '</a></p><br />' ); header( "HTTP/1.1 404 Not Found" ); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <title>Page Not Found</title> <base href="https://www.example.com/"> <link href="ext/bootstrap/css/bootstrap.min.css" rel="stylesheet"> <script defer src="https://use.fontawesome.com/releases/v5.1.0/js/all.js"></script> <link rel=icon href=favicon.png sizes="16x16" type="image/png"> <!--[if lt IE 9]> <script src="ext/js/html5shiv.js"></script> <script src="ext/js/respond.min.js"></script> <script src="ext/js/excanvas.min.js"></script> <![endif]--> <script src="ext/jquery/jquery-3.1.1.min.js"></script> <style> .error-404 { margin: 0 auto; text-align: center } .error-404 .error-code { bottom: 60%; color: #4686CC; font-size: 96px; line-height: 100px; font-weight: bold } .error-404 .error-desc { font-size: 12px; color: #647788 } .error-404 .m-b-10 { margin-bottom: 10px!important } .error-404 .m-b-20 { margin-bottom: 20px!important } .error-404 .m-t-20 { margin-top: 20px!important } </style> </head> <body> <div class="error-404"> <div class="error-code m-b-10 m-t-20">404 <i class="fas fa-exclamation-triangle"></i></div> <h2 class="font-bold">Oops 404! That page can’t be found.</h2> <div class="error-desc"> Sorry, but the page you are looking for was either not found or does not exist. <br> Try refreshing the page or click the button below to go back to the Homepage. <div><br> <a href="/" class="btn btn-primary"><span class="fas fa-home" data-fa-transform="up-2" aria-hidden="true"></span> Go back to Homepage</a> </div> </div> </div> <script src="ext/bootstrap/js/bootstrap.min.js"></script> </body> </html> Thanks you so much, but I tried this in this morning, Get the same look that oscommerce not possible, I must to copy the html and If I make any change, the 404 will be obsolete Share this post Link to post Share on other sites
Jack_mcs 1,116 Posted July 17, 2018 1 hour ago, PiLLaO said: Another urls that not found, works correctly I don't know what this means but the addon should work. Did you remove or change the reference to catalog to make the links work for your site? Is there a setting in SEO 5 that turns off the 404 check? Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Need Help? See this thread and provide the information requested. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
PiLLaO 35 Posted July 18, 2018 (edited) 6 hours ago, Jack_mcs said: I don't know what this means but the addon should work. Did you remove or change the reference to catalog to make the links work for your site? Is there a setting in SEO 5 that turns off the 404 check? For example, Quote catalog/hello.php Don't exists and Custom Error Server Pages shows a 404 Not found, in this case USU5 not take part. But, if you try with a non real category or product Quote catalog/no-real-category-c-1958.html catalog/no-real-product-p-2800.html These urls really are: Quote catalog/index.php?cPath=1958 catalog/product_info.php?products_id=2800 These files exists on server and in these cases USU5 take part, so the Custom Error Server Pages don't show a 404 because file exists. USU5 try to find these products or categories and can't find them so uses a php header to put the 404 error and call a file on server, at this time catalog/application_top.php, catalog/template_top.php, catalog/template_bottom.php and catalog/application_bottom.php are loaded and any custom 404 page that I try to use get error because you are load before application_top.php and other. USU5 uses a 404 page that not have the same look that oscommerce <?php /** * * ULTIMATE Seo Urls 5 PRO ( version 1.1 ) * * * @package USU5_PRO * @license http://www.opensource.org/licenses/gpl-2.0.php GNU Public License * @link http://www.fwrmedia.co.uk * @copyright Copyright 2008-2009 FWR Media * @copyright Portions Copyright 2005 ( rewrite uri concept ) Bobby Easland * @author Robert Fisher, FWR Media, http://www.fwrmedia.co.uk * @lastdev $Author:: Rob $: Author of last commit * @lastmod $Date:: 2010-12-21 22:45:02 +0000 (Tue, 21 Dec 2010) $: Date of last commit * @version $Rev:: 196 $: Revision of last commit * @Id $Id:: notfound_404.php 196 2010-12-21 22:45:02Z Rob $: Full Details */ /** * Page not found html with 404 header * @package USU5_PRO * * @var array $text - array of text strings to be used in the html */ $text = array( 'title' => 'Page not found', 'text' => 'The page you were looking for could not be found. Please click the below link to return to ' . STORE_NAME . ' <p><a href="' . tep_href_link( FILENAME_DEFAULT ) . '" title="' . STORE_NAME . '">' . STORE_NAME . '</a></p><br />' ); header( "HTTP/1.0 404 Not Found" ); ?> <title>Page Not Found</title> <div style="padding: 3em; font-family: verdana; margin: 3em; border: 1px solid #e5e5e5;"> <div style="background-color: #2E8FCA; font-size: 12pt; font-weight: bold; padding: 0.5em; color: #00598E;"> <div style="float: right; color: #0073BA; font-weight: bold; font-size: 16pt; margin-top: -0.2em;">FWR MEDIA</div><?php echo $text['title']; ?></div> <div style="padding: 0.5em; font-size: 9pt; font-family: verdana;"><?php echo $text['text']; ?></div></div> </div> And in this file tep_href_link and STORE_NAME works because catalog/application_top.php are previous loaded. Sorry for my poor english, I hope I can explain correctly. Edited July 18, 2018 by PiLLaO Share this post Link to post Share on other sites
Hotclutch 191 Posted July 18, 2018 If it's just the look that's important to you - you could replicate the look with the USU file I am sure. Instead of calling code, copy your boilerplate text from view source. by boilerplate text i mean your nav - left/right columns, footer. 1 PiLLaO reacted to this Share this post Link to post Share on other sites
Jack_mcs 1,116 Posted July 18, 2018 5 hours ago, PiLLaO said: USU5 uses a 404 page that not have the same look that oscommerce I don't use SEO 5 so I can't test it but, I think, if you add the following above the text - array line in that file, it will solve your problem. So the code would look like this: tep_redirect(tep_href_link('server_error.php', 'id=404')); $text = array( 'title' => 'Page not found', 1 PiLLaO reacted to this Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Need Help? See this thread and provide the information requested. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
♥DAVID3733 9 Posted July 18, 2018 Hi Jack_MC Although that does divert to the page it does not seem to take the header info with it so it becomes a 302 found rather than a 404 or 410 Regards David 1 PiLLaO reacted to this David Share this post Link to post Share on other sites
♥DAVID3733 9 Posted July 18, 2018 If I understand the question right in the validator.php there is this function private function pageNotFound() { include_once Usu_Main::i()->getVar( 'includes_path' ) . 'uri_redirects_class.php'; if ( false !== ( $url = Uri_Redirects::i()->needsRedirect() ) ) { $this->redirect( $url ); } session_write_close(); header( "HTTP/1.0 404 Not Found" ); include_once Usu_Main::i()->getVar( 'includes_path' ) . 'notfound_410.php'; exit; the notfound_410.php is within a includes folder within seo_urls5 folder $text = array( 'title' => 'Page not found', 'text' => 'The product or information you\'ve been looking for is no longer available.<br>To see information or available products click the link below: ' . '<p><a href="' . tep_href_link( FILENAME_DEFAULT ) . '" title="' . STORE_NAME . '">' . STORE_NAME . '</a><p><br>' ); header( "HTTP/1.0 410 Gone" ); ?> <!DOCTYPE html> <html <?php echo HTML_PARAMS; ?>> <head> <title>410 Page Not Found</title> <style> img { max-width: 100%; height: auto; width: auto\9; /* ie8 */ } </style> </head> <body> <div id="bodyWrapper" class="container-fluid"> <div class="row"> <div class="modular-header"> <div id="storeLogo" class="col-sm-12"> <?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '"><img src="http://www.mywebsite/logo.png" alt="my website" title="my website" class="img-responsive" /></a>'; ?> </div> </div> <div style="background-color: #000000; font-size: 12pt; font-weight: bold; padding: 0.5em; color: #ffffff;"> <div style="float: right; color: #0073BA; font-weight: bold; font-size: 16pt;"></div><?php echo $text['title']; ?></div><br> <div style="padding: 0.5em; font-size: 9pt; font-family: verdana;"><?php echo $text['text']; ?></div> </div> </div> </div> </body> </html> and that's the page he wants with site wrapped around I could never manage it would be great if it could go to top level 404 page instead of that local one David David Share this post Link to post Share on other sites
Jack_mcs 1,116 Posted July 18, 2018 (edited) 3 hours ago, DAVID3733 said: Although that does divert to the page it does not seem to take the header info with it so it becomes a 302 found rather than a 404 or 410 The basic oscommerce code never returns 404's or 410's and is why I wrote the Header Status Handler. But it sounds like this addon would override that so it may not work either. Edited July 18, 2018 by Jack_mcs Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Need Help? See this thread and provide the information requested. How to Upgrade to the latest version Recommended SEO Addons Share this post Link to post Share on other sites
♥DAVID3733 9 Posted July 18, 2018 Yes I also have that installed, and 404's I do not have a problem with, they go to a 404 page with all the site wrapped around, a copy of the contact page which works well but the seo_url5 pro handles the 410 gone and sends it to its own 410 page, using the function in my previous post, that page has the header info in it so it only handles the 410 David Share this post Link to post Share on other sites
PiLLaO 35 Posted July 18, 2018 In catalog/includes/modules/ultimate_seo_urls5/main/validator.php, if you find this private function validate() { // Get the incoming seo uri minus the session id Usu_Main::i()->setVar( 'request_compare_in', remove_session_id( htmlspecialchars_decode( Usu_Main::i()->getVar( 'original_request_uri' ) ) ) ); // Get a brand new url based on the querystring $new_url = htmlspecialchars_decode( tep_href_link( Usu_Main::i()->getVar( 'filename' ), Usu_Main::i()->getVar( 'request_querystring' ) ) ); // Strip the new url of domain name and session id to arrive at a comparible uri Usu_Main::i()->setVar( 'request_compare_new', remove_session_id( str_replace( array( HTTPS_SERVER, HTTP_SERVER ), '', $new_url ) ) ); /** * If $page_not_found has been set to bool true then the page module returned a result of bool false from the database * this means that the product/category etc does not exist so we need to show 404 headers and page. */ if ( false !== Usu_Main::i()->getVar( 'page_not_found' ) ) { $this->pageNotFound(); } // If the incoming uri and the newly created uri do not match then we need to 301 redirect to the new. if ( Usu_Main::i()->getVar( 'request_compare_in' ) != Usu_Main::i()->getVar( 'request_compare_new' ) ) { $this->redirect( $new_url ); } } // end method And change by this private function validate() { // Get the incoming seo uri minus the session id Usu_Main::i()->setVar( 'request_compare_in', remove_session_id( htmlspecialchars_decode( Usu_Main::i()->getVar( 'original_request_uri' ) ) ) ); // Get a brand new url based on the querystring $new_url = htmlspecialchars_decode( tep_href_link( Usu_Main::i()->getVar( 'filename' ), Usu_Main::i()->getVar( 'request_querystring' ) ) ); // Strip the new url of domain name and session id to arrive at a comparible uri Usu_Main::i()->setVar( 'request_compare_new', remove_session_id( str_replace( array( HTTPS_SERVER, HTTP_SERVER ), '', $new_url ) ) ); /** * If $page_not_found has been set to bool true then the page module returned a result of bool false from the database * this means that the product/category etc does not exist so we need to show 404 headers and page. */ if ( false !== Usu_Main::i()->getVar( 'page_not_found' ) ) { header( "HTTP/1.0 404 Not Found" ); return false; // $this->pageNotFound(); } // If the incoming uri and the newly created uri do not match then we need to 301 redirect to the new. if ( Usu_Main::i()->getVar( 'request_compare_in' ) != Usu_Main::i()->getVar( 'request_compare_new' ) ) { $this->redirect( $new_url ); } } // end method You get the catalog/index.php?cPath=1958 and catalog/product_info.php?products_id=2800 with de standart text of "product/category not found" and a 404 error. Now in product_info.php just after require('application_top') look if you have an 404 error and require your custom 404 page, your_custom_404.php must have require('includes/application_top.php'); commented require('includes/application_top.php'); if (http_response_code() == 404) { require('your_custom_404.php'); return false; } I must to check if on index will work this too. Bests regards Share this post Link to post Share on other sites
♥DAVID3733 9 Posted July 19, 2018 15 hours ago, PiLLaO said: In catalog/includes/modules/ultimate_seo_urls5/main/validator.php, if you find this private function validate() { // Get the incoming seo uri minus the session id Usu_Main::i()->setVar( 'request_compare_in', remove_session_id( htmlspecialchars_decode( Usu_Main::i()->getVar( 'original_request_uri' ) ) ) ); // Get a brand new url based on the querystring $new_url = htmlspecialchars_decode( tep_href_link( Usu_Main::i()->getVar( 'filename' ), Usu_Main::i()->getVar( 'request_querystring' ) ) ); // Strip the new url of domain name and session id to arrive at a comparible uri Usu_Main::i()->setVar( 'request_compare_new', remove_session_id( str_replace( array( HTTPS_SERVER, HTTP_SERVER ), '', $new_url ) ) ); /** * If $page_not_found has been set to bool true then the page module returned a result of bool false from the database * this means that the product/category etc does not exist so we need to show 404 headers and page. */ if ( false !== Usu_Main::i()->getVar( 'page_not_found' ) ) { $this->pageNotFound(); } // If the incoming uri and the newly created uri do not match then we need to 301 redirect to the new. if ( Usu_Main::i()->getVar( 'request_compare_in' ) != Usu_Main::i()->getVar( 'request_compare_new' ) ) { $this->redirect( $new_url ); } } // end method And change by this private function validate() { // Get the incoming seo uri minus the session id Usu_Main::i()->setVar( 'request_compare_in', remove_session_id( htmlspecialchars_decode( Usu_Main::i()->getVar( 'original_request_uri' ) ) ) ); // Get a brand new url based on the querystring $new_url = htmlspecialchars_decode( tep_href_link( Usu_Main::i()->getVar( 'filename' ), Usu_Main::i()->getVar( 'request_querystring' ) ) ); // Strip the new url of domain name and session id to arrive at a comparible uri Usu_Main::i()->setVar( 'request_compare_new', remove_session_id( str_replace( array( HTTPS_SERVER, HTTP_SERVER ), '', $new_url ) ) ); /** * If $page_not_found has been set to bool true then the page module returned a result of bool false from the database * this means that the product/category etc does not exist so we need to show 404 headers and page. */ if ( false !== Usu_Main::i()->getVar( 'page_not_found' ) ) { header( "HTTP/1.0 404 Not Found" ); return false; // $this->pageNotFound(); } // If the incoming uri and the newly created uri do not match then we need to 301 redirect to the new. if ( Usu_Main::i()->getVar( 'request_compare_in' ) != Usu_Main::i()->getVar( 'request_compare_new' ) ) { $this->redirect( $new_url ); } } // end method You get the catalog/index.php?cPath=1958 and catalog/product_info.php?products_id=2800 with de standart text of "product/category not found" and a 404 error. Now in product_info.php just after require('application_top') look if you have an 404 error and require your custom 404 page, your_custom_404.php must have require('includes/application_top.php'); commented require('includes/application_top.php'); if (http_response_code() == 404) { require('your_custom_404.php'); return false; } I must to check if on index will work this too. Bests regards Hi Gustavo Yes this works, bypass's the requirement for the local 404 / 410 not found file (within the SEO URL 5), I use Jack MC's Header status contrib. and also use a contact me page for all the 404's and 410's Thank you for sharing David David Share this post Link to post Share on other sites
piernas 152 Posted July 21, 2018 I've been working on this addon to fix some issues and improve some things like multilanguage support. Anyone here would like to test the code before submitting to the addons section? Here is a short list of changes: Latest responsive oscommerce compatible. Moved usu_base_filename function from application_top to its own file to simplify core edits. Fix for sitemaps not showing manufacturer rewritten URLs Fix for hreflang tags module - now categories shows correct language Corrected location of character conversion packs Allow to processs links outside root folder (ie. ext/directory). This is useful for addons like Twitter typeahead. Fixed (some) cache problems. For now the only issue I still find is with mysql cache: Looks like the table is being truncated on every page load. Any help with locating the problem will be welcome. Ultimate_Seo_Urls_5_PRO_BS_209 beta1.zip 2 PiLLaO and radhavallabh reacted to this Share this post Link to post Share on other sites
radhavallabh 41 Posted July 23, 2018 On 7/21/2018 at 7:54 PM, piernas said: I've been working on this addon to fix some issues and improve some things like multilanguage support. Anyone here would like to test the code before submitting to the addons section? Here is a short list of changes: Latest responsive oscommerce compatible. Moved usu_base_filename function from application_top to its own file to simplify core edits. Fix for sitemaps not showing manufacturer rewritten URLs Fix for hreflang tags module - now categories shows correct language Corrected location of character conversion packs Allow to processs links outside root folder (ie. ext/directory). This is useful for addons like Twitter typeahead. Fixed (some) cache problems. For now the only issue I still find is with mysql cache: Looks like the table is being truncated on every page load. Any help with locating the problem will be welcome. Ultimate_Seo_Urls_5_PRO_BS_209 beta1.zip Is it compatible with php 7- frozen CE version? Warm regds./ radhavallabh Share this post Link to post Share on other sites
piernas 152 Posted July 23, 2018 @radhavallabh yes 1 radhavallabh reacted to this Share this post Link to post Share on other sites
PiLLaO 35 Posted July 26, 2018 Better replace this: require('includes/application_top.php'); if (http_response_code() == 404) { require('your_custom_404.php'); return false; } With this: require('includes/application_top.php'); if (http_response_code() == 404) { require('your_custom_404.php'); exit; } Best regards :) Share this post Link to post Share on other sites
radhavallabh 41 Posted August 9, 2018 On 7/23/2018 at 10:30 AM, piernas said: @radhavallabh yes Works fine for me!! Thanks Regds./ radhavallabh Share this post Link to post Share on other sites
phi148 11 Posted August 14, 2018 | Id | User | Host | db | Command | Time | State | Info | +------+------------------+-----------+------------------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+ | 1330 | xxx | localhost | xxx | Query | 1 | Waiting for table metadata lock | TRUNCATE `usu_cache` | | 1331 | xxx | localhost | xxx | Query | 1 | checking permissions | TRUNCATE `usu_cache` | | 1332 | xxx | localhost | xx | Query | 1 | Waiting for table metadata lock | TRUNCATE `usu_cache` Hey all I'm running into alot of metadata locks with my SQL database (you can see above what I'm talking about). I went and looked and the "usu_cache" table is empty. Is this even used? Share this post Link to post Share on other sites
piernas 152 Posted August 14, 2018 On 7/21/2018 at 4:24 PM, piernas said: For now the only issue I still find is with mysql cache: Looks like the table is being truncated on every page load. Any help with locating the problem will be welcome. @phi148 as mentioned in my previous post there's an issue with mysql code I still couldn't fix. Share this post Link to post Share on other sites
♥clustersolutions 104 Posted August 14, 2018 Don't think MySQL cache works at this time, but u did not say much about the version of your OSC and environment. Anyway, just use file cache, I was gonna rewrite the DB cache part but had decided to wait after hearing the 2.4 release announcement at that time... 16 hours ago, phi148 said: | Id | User | Host | db | Command | Time | State | Info | +------+------------------+-----------+------------------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+ | 1330 | xxx | localhost | xxx | Query | 1 | Waiting for table metadata lock | TRUNCATE `usu_cache` | | 1331 | xxx | localhost | xxx | Query | 1 | checking permissions | TRUNCATE `usu_cache` | | 1332 | xxx | localhost | xx | Query | 1 | Waiting for table metadata lock | TRUNCATE `usu_cache` Hey all I'm running into alot of metadata locks with my SQL database (you can see above what I'm talking about). I went and looked and the "usu_cache" table is empty. Is this even used? Share this post Link to post Share on other sites
piernas 152 Posted August 15, 2018 @phi148 I think I fixed the issue. Can you please test it? Ultimate_Seo_Urls_5_PRO_BS_209_beta_2.zip 1 radhavallabh reacted to this Share this post Link to post Share on other sites