Jump to content
FWR Media

ULTIMATE Seo Urls 5 - by FWR Media

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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

@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>

 

Share this post


Link to post
Share on other sites
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
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
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?

Share this post


Link to post
Share on other sites
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 by PiLLaO

Share this post


Link to post
Share on other sites

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.  

Share this post


Link to post
Share on other sites
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',

 

Share this post


Link to post
Share on other sites

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


David

Share this post


Link to post
Share on other sites

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
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 by Jack_mcs

Share this post


Link to post
Share on other sites

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

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
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

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

Share this post


Link to post
Share on other sites
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

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
| 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
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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×