Hotclutch Posted July 17, 2018 Share 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 Quote Link to comment Share on other sites More sharing options...
Hotclutch Posted July 17, 2018 Share 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> PiLLaO 1 Quote Link to comment Share on other sites More sharing options...
Hotclutch Posted July 17, 2018 Share Posted July 17, 2018 ^^ Change the html tag on line 32 for your language. Quote Link to comment Share on other sites More sharing options...
PiLLaO Posted July 17, 2018 Share 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 Quote Link to comment Share on other sites More sharing options...
PiLLaO Posted July 17, 2018 Share 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 Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted July 17, 2018 Share 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? Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
PiLLaO Posted July 18, 2018 Share 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 Quote Link to comment Share on other sites More sharing options...
Hotclutch Posted July 18, 2018 Share 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. PiLLaO 1 Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted July 18, 2018 Share 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', PiLLaO 1 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
DAVID3733 Posted July 18, 2018 Share 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 PiLLaO 1 Quote David Link to comment Share on other sites More sharing options...
DAVID3733 Posted July 18, 2018 Share 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 Quote David Link to comment Share on other sites More sharing options...
Jack_mcs Posted July 18, 2018 Share 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 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
DAVID3733 Posted July 18, 2018 Share 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 Quote David Link to comment Share on other sites More sharing options...
PiLLaO Posted July 18, 2018 Share 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 Quote Link to comment Share on other sites More sharing options...
DAVID3733 Posted July 19, 2018 Share 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 Quote David Link to comment Share on other sites More sharing options...
piernas Posted July 21, 2018 Share 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 radhavallabh and PiLLaO 2 Quote Link to comment Share on other sites More sharing options...
radhavallabh Posted July 23, 2018 Share 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 Quote Link to comment Share on other sites More sharing options...
piernas Posted July 23, 2018 Share Posted July 23, 2018 @radhavallabh yes radhavallabh 1 Quote Link to comment Share on other sites More sharing options...
PiLLaO Posted July 26, 2018 Share 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 :) Quote Link to comment Share on other sites More sharing options...
radhavallabh Posted August 9, 2018 Share Posted August 9, 2018 On 7/23/2018 at 10:30 AM, piernas said: @radhavallabh yes Works fine for me!! Thanks Regds./ radhavallabh Quote Link to comment Share on other sites More sharing options...
phi148 Posted August 14, 2018 Share 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? Quote Link to comment Share on other sites More sharing options...
piernas Posted August 14, 2018 Share 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. Quote Link to comment Share on other sites More sharing options...
clustersolutions Posted August 14, 2018 Share 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? Quote Link to comment Share on other sites More sharing options...
piernas Posted August 15, 2018 Share 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 radhavallabh 1 Quote Link to comment Share on other sites More sharing options...
radhavallabh Posted August 16, 2018 Share Posted August 16, 2018 13 hours ago, piernas said: @phi148 I think I fixed the issue. Can you please test it? Ultimate_Seo_Urls_5_PRO_BS_209_beta_2.zip Hi, Could you please point to the exact changes you made, As mine are modified files I incorporated the beta_1 already, hence I could add the fixes of beta_2.. Warm Regds./ radhavallabh Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.