Ultimate SEO v3 (and v2.200) [Support Thread]

Need help! I have Ultimate URL 2.215 and I have found that everytime I change the page title, it creates a new link. So for one product page, if I edit the title, I could easily have 5 different links all with different keywords, linking to my product. I'm just learning SEO, but this seems like it would hurt my SEO efforts if I decide to use a different target keyword for a product. I could change it, but 5 other links to the same page could be indexed by google with keywords I don't want to use anymore.

I posted a thread about this: https://www.zen-cart.com/showthread....84#post1308084

How do I get rid of the links Ultimate URL has created? I now have 20,000 links to a 5,000 page site...a bit insane and I don't think this is a good thing for our site to have in general.

How can I get Ultimate URL to stop generating new links and just update the original one? Should I turn it off?

Thank you for any help!

I would not worry as long as the template you installed did not remove the built in support for canonicals. If it did, you will want to fix the template ASAP.

Keep in mind Zen Cart and Ultimate URLs (when zen_href_link is used) do not continue generating links to the older URLs. So both customers and SEs will only see the current URL when visiting a page.

One can choose to enable "automatic redirects". This forces a 301 redirect to the newest URL when the page is accessed from older URLs.

If you want to remove Ultimate URLs, make sure you leave behind the .htaccess file - so old URLs go to the new URL. The canonicals will keep SEs informed - or you can modify the .htaccess to issue 301s.

Thank you for the feedback. A few follow up questions:
1. could having all these extra links be slowing website performance?
2. would having the extra links be essentially hurting our indexing since google would be wasting time crawling so many urls for a page when only one is needed?
3. This is also a concern: (per Google) "This indicates the preferred URL to use to access the green dress post, so that the search results will be more likely to show users that URL structure. (Note: We attempt to respect this, but cannot guarantee this in all cases.)" If there is no guarantee one of the URLs we don't like will come up in a search, this could deter our clients. If we make a typo, for example, click update, then go back and fix it, the typo URL still exists and Google can index it, even if its attached to a canonical. How do we go into our root folders and simply remove all URLs we no longer want?

Thank you!

No "extra" URLs exist in your store, so there are no URLs to remove. Only the most recent title is used (when generating a URL) by Zen Cart w/ Ultimate URLs installed. Take a look at the HTML Source of your pages, you (and search engines) will only see one URL generated for each product page.

As such, what you are reporting is not an issue or error with Ultimate URLs.

Hi Larry - where can I download 'Plugin Manager' which you recommend for installing your plugin - it is not coming up in searches in ZC plugins ??

cheers,
Mike

Quote:

---

Originally Posted by shags38

Hi Larry - where can I download 'Plugin Manager' which you recommend for installing your plugin - it is not coming up in searches in ZC plugins ??

cheers,
Mike

---

Ummmm I think lhungil's name is Andrew..

Last I knew the plugin manager on which lhungil was working was still in beta status and available through request. In the mean time if you were wanting to identify changes that have been made to a cart by plugins (outside of the plugin manager) there is Mod List that identifies specific differences in the cart as compared to a default install to "some extent". (meaning I haven't looked at what it uses as a comparison to validate the "differences".)

Quote:

---

Originally Posted by DivaVocals

Ummmm I think lhungil's name is Andrew..

---

yes, but he lets me call him Larry

When I install this on a 1.5.5 I got this in the admin area?

Code:

---

Some potential issues were found in your "admin" configure.php. Failure to correct these issues may result in Zen Cart not functioning as intended.
The "admin" configure.php file can be found at /xxxxxx/xxxxxx/public_html/morrisgiftshop.biz/xxxxxxx/includes/configure.php.
The HTTP_CATALOG_SERVER setting cannot end with a slash. Remove the extra / from the end of HTTP_CATALOG_SERVER
The HTTPS_CATALOG_SERVER setting cannot end with a slash. Remove the extra / from the end of HTTPS_CATALOG_SERVER
The value for DIR_WS_CATALOG cannot be blank. If the store installed at the website root (not in a subdirectory), set the value for DIR_WS_CATALOG to /. If the store is in a subdirectory, the name of the subdirectory should be placed in DIR_WS_CATALOG. The subdirectory should be preceded and followed by slashes, e.g. /store/.
The value for DIR_WS_HTTPS_CATALOG cannot be blank. If the store installed at the website root (not in a subdirectory), set the value for DIR_WS_HTTPS_CATALOG to /. If the store is in a subdirectory, the name of the subdirectory should be placed in DIR_WS_HTTPS_CATALOG. The subdirectory should be preceded and followed by slashes, e.g. /store/.

---

Quote:

---

Originally Posted by wmorris

When I install this on a 1.5.5 I got this in the admin area?

---

Read it - it is self explanatory

Quote:

---

Originally Posted by kobra

Read it - it is self explanatory

---

Ok, when I remove the slashes as it says in the Admin. Now I got this:

Code:

---

Some potential issues were found in your "admin" configure.php. Failure to correct these issues may result in Zen Cart not functioning as intended.
The "admin" configure.php file can be found at /xxxxxxx/xxxxxx/public_html/morrisgiftshop.biz/xxxxxxx/includes/configure.php.
The value for DIR_WS_CATALOG cannot be blank. If the store installed at the website root (not in a subdirectory), set the value for DIR_WS_CATALOG to /. If the store is in a subdirectory, the name of the subdirectory should be placed in DIR_WS_CATALOG. The subdirectory should be preceded and followed by slashes, e.g. /store/.
The value for DIR_WS_HTTPS_CATALOG cannot be blank. If the store installed at the website root (not in a subdirectory), set the value for DIR_WS_HTTPS_CATALOG to /. If the store is in a subdirectory, the name of the subdirectory should be placed in DIR_WS_HTTPS_CATALOG. The subdirectory should be preceded and followed by slashes, e.g. /store/.

---

Also, there is no Ultimate SEO in the Configuration menu.

What I uploaded was 3_install files and modified files for v1.5.5.

Quote:

---

Ok, when I remove the slashes as it says in the Admin. Now I got this:

---

You had this before - - Again read it - it is self explanatory

Code:

---

The value for DIR_WS_CATALOG cannot be blank.

---

Quote:

---

Originally Posted by kobra

You had this before - - Again read it - it is self explanatory

Code:

---

The value for DIR_WS_CATALOG cannot be blank.

---

---

Is this in the Admin area? If it is what do I need to put in the blank?

Quote:

---

Originally Posted by wmorris

Is this in the Admin area? If it is what do I need to put in the blank?

---

The message you received started with:

Code:

---

Some potential issues were found in your "admin" configure.php. Failure to correct these issues may result in Zen Cart not functioning as intended.

---

You'll need to edit /YOUR_ADMIN/includes/configure.php and set the value for DIR_WS_CATALOG and DIR_WS_HTTPS_CATALOG to (presumably) '/', e.g.

Code:

---

define ('DIR_WS_CATALOG', '/');

---

Quote:

---

Originally Posted by lat9

The message you received started with:

Code:

---

Some potential issues were found in your "admin" configure.php. Failure to correct these issues may result in Zen Cart not functioning as intended.

---

You'll need to edit /YOUR_ADMIN/includes/configure.php and set the value for DIR_WS_CATALOG and DIR_WS_HTTPS_CATALOG to (presumably) '/', e.g.

Code:

---

define ('DIR_WS_CATALOG', '/');

---

---

Ok, I got it to work. I notice something like p-100 in the link is that normal or can I get rid of that?

it's normal. its known as an anchor.

Quote:

---

Originally Posted by carlwhat

it's normal. its known as an anchor.

---

Ok, on this:
Display categories as directories I have that turned off.

But when I look at a product I see this: flower-top-jar-p-570.html?cPath=2_58 is there a way to get rid of the "?cPath="

you should have a configuration screen in the admin for ultimate SEO. look for the generate cPath parameters. you could turn it off there, although it might mess with your breadcrumbs and some other minor navigation issues when viewing a product. depends if you link 1 product to many categories and some other factors.

Quote:

---

Originally Posted by carlwhat

you should have a configuration screen in the admin for ultimate SEO. look for the generate cPath parameters. you could turn it off there, although it might mess with your breadcrumbs and some other minor navigation issues when viewing a product. depends if you link 1 product to many categories and some other factors.

---

Ok, Thanks. I found it before you replied. Plus I only had 1 product per category not multiple categories.

I installed this on my 1.5.5a and the installation went fine (except I had to do manual install - plugin manager doesn't exist)
Admin area came up with something like "Ultimate URLs installed successfully" in a green box :)

I can see and enter the setup for the module and it's showing as Enable alternate URLs? = true but my urls are still showing as :
http://www.skysports.com.au/index.ph...roducts_id=281

Do I have to do something to kick off the process?

Since you did a "manual" install, did you remember to copy/merge the /.htaccess file? That's where much of the USU "magic" comes from.

Yes, i copied the file to / (same place as DIR_WS_CATALOG).
What permissions on .htaccess? Currently 644

Quote:

---

Originally Posted by Kenton

I installed this on my 1.5.5a and the installation went fine (except I had to do manual install - plugin manager doesn't exist)
Admin area came up with something like "Ultimate URLs installed successfully" in a green box :)

I can see and enter the setup for the module and it's showing as Enable alternate URLs? = true but my urls are still showing as :
http://www.skysports.com.au/index.ph...roducts_id=281

Do I have to do something to kick off the process?

---

It looks like you are missing some of the changes this module makes to core Zen Cart files. The currently version available from this website is compatible with Zen Cart 1.3.9h through Zen Cart 1.5.4. The included installer understands all of those versions and can apply the necessary changes to core Zen Cart files (and may even work with early releases of Zen Cart 1.5.5).

However some changes were introduced in Zen Cart 1.5.5a to the core Zen Cart files modified by the Ultimate URLs installer. There is a good chance when the installer runs it is unable to locate where changes to those files are needed (and just skips them to avoid breaking anything). While one could manually apply the changes required for older versions of Zen Cart, I am hesitant to recommend making any changes to the Zen Cart 1.5.5a core files at this time (an alternative method was introduced in Zen Cart 1.5.5a and some new code in Ultimate URLs to support the changes is still in QA testing).

When is a 155a compatible version likely to be available?

Is this add on anything like ultimate SEO URLs for oscommerce?

Quote:

---

Originally Posted by dspeak35640

Is this add on anything like ultimate SEO URLs for oscommerce?

---

it looks like it is something like it.... probably derived from the same original code.

Quote:

---

Originally Posted by carlwhat

it looks like it is something like it.... probably derived from the same original code.

---

Thank you for the quick response.

The reason I am thinking of installing this add on is because I went from oscommerce to zencart. Now all my links on the search engines are broken and I was thinking that if I had this installed my urls would be like the old urls and the search engine links would work once again.
Also do I need to just leave the core files alone, or do I have to upload the included core files with the package.

In your opinion is a add on like this helpful or not for getting pages indexed by search engines.

Quote:

---

Originally Posted by dspeak35640

Thank you for the quick response.

The reason I am thinking of installing this add on is because I went from oscommerce to zencart. Now all my links on the search engines are broken and I was thinking that if I had this installed my urls would be like the old urls and the search engine links would work once again.
Also do I need to just leave the core files alone, or do I have to upload the included core files with the package.

In your opinion is a add on like this helpful or not for getting pages indexed by search engines.

---

you are best reading the install instructions. i think it touches a few core files, but i think this plug-in is FAR more solid than other plug-ins i have had to wrestle with.

i am NOT the SEO king, and clearly SEO has changed/evolved over the years that opportunists were buying domain names and holding them for ransom. and my opinion is just one data point.

there was an interesting conversation over on github on this very topic. i suggest reading that conversation and you can then make the decision yourself.

best.

https://github.com/zencart/zencart/issues/956

Hello there,

I wondered if somebody might have encountered this issue, it also happens to other SEO modules on zencart. I get many log like below, the file it is looking for does not exist. If I make an empty file of the same name in that location, the log for that particular url does not appear anymore. But there are countless logs that are being created still. Htaccess is configured as in installation for ultimate urls, and files are present and correct, and module works fine. I think this may be server related or old redirections that spiders are looking for, but just throwing this out in the hope somebody maybe was able to find which aspect is causing it. Thanks in advance.

Quote:

---

[03-Jul-2016 09:31:22 America/New_York] PHP Warning: require(includes/templates/template_default/templates/tpl_appletouchiconpng_default.php): failed to open stream: No such file or directory in /home/*****/public_html/includes/templates/*****/common/tpl_main_page.php on line 154
[03-Jul-2016 09:31:22 America/New_York] Request URI: /index.php?main_page=appletouchiconpng, IP address:******
#1 require() called at [/home/*****/public_html/includes/templates/*****/common/tpl_main_page.php:154]
#2 require(/home/****/public_html/includes/templates/*****/common/tpl_main_page.php) called at [/home/****/public_html/index.php:97]

---

Quote:

---

Originally Posted by HeathenMagic

tpl_appletouchiconpng_default.php

---

When Apple-products try to surf around your site, instead of looking for favicon.ico files first, they look for apple-touch-icon.png files.
If you create that file, then this specific issue will go away.

Actually they look for lots of variants of that file, including the following (and probably more):
apple-touch-icon-180x180.png
apple-touch-icon-152x152.png
apple-touch-icon-120x120.png
apple-touch-icon-76x76.png
apple-touch-icon-57x57.png
apple-touch-icon.png
touch-icon-192x192.png


And microsoft devices (windows phones, surface tablets) look for:
ms-tile-image144x144.png

And they all look for favicon.ico too.

So the solution is simple: use an icon-capable graphics program to create appropriate variants of your store logo for the corresponding dimensions and filenames, and put them on your server.
There are hundreds of online articles on how to do this, including dozens of software programs that can do it. Some free. Some with crappy adware. Always use caution when installing new software.

Thanks Dr Byte, I will look into this and hope I can rectify the issue. It does it with file names also, and image names of some items, that reference such as 'tpl_imagesdiamondoiljpg_default.php' in the the templates folder. I am thinking it may be from an old template, as I switched and it seems to have the same behaviour. And files from modules such as'tpl_guestandfullaccountsupported_default.php' and 'tpl_qc_login_default.php'. So far I have nullified these logs by creating blank files for these and more. I will create logo variations as you advised, I think I have some good software somewhere that I can use.

Quote:

---

Originally Posted by HeathenMagic

It does it with file names also, and image names of some items, that reference such as 'tpl_imagesdiamondoiljpg_default.php' in the the templates folder. I am thinking it may be from an old template, as I switched and it seems to have the same behaviour. And files from modules such as'tpl_guestandfullaccountsupported_default.php' and 'tpl_qc_login_default.php'.

---

Probably need to also fix whatever is rewriting things to point to invalid locations. And maybe turn back on the Missing Page Check setting in Admin->Config->My Store.

Hi All,
I installed USU 2.215 on my 1.5.5a and the installation went fine.
Admin area came up with "Ultimate URLs installed successfully".

The links in shop still looks without changes. For ex. link to contact us page is "http://domain/index.php?main_page=contact_us", but when I open this link, in browser address bar is displayed the "http://domain/contact_us.html" link. When I fill the link "http://domain/contact_us.html" in the address bar in new window of my browser, then page is opened ok.
It looks all going fine, but shop displays old untouched links.

Any idea?
Many thanks.
Radek

do you have any sort of caching turned on?

Quote:

---

Originally Posted by Kenton

When is a 155a compatible version likely to be available?

---

Any updates as of then a 1.5.5a compatible version will be available? I upgraded from 1.3.9h to 1.5.5a and now all of my old links are broken, I'd really like to get this installed in order to fix this!

Quote:

---

Originally Posted by carlwhat

do you have any sort of caching turned on?

---

No, all cache features (in USU settings) are OFF. But same behavior is, when I set it ON.

Quote:

---

Originally Posted by Radek

No, all cache features (in USU settings) are OFF. But same behavior is, when I set it ON.

---

I went ahead and attempted to install it, I am having the same results as Radek. If anyone knows of anything we can try, please post!

if your site(s) are available to look at, post the url so that we can get a better sense of the issue.

in addition, have you tried turning on the debug log in admin => configuration => SEO urls. and if so can you post some of the contents of the log?

Quote:

---

Originally Posted by carlwhat

if your site(s) are available to look at, post the url so that we can get a better sense of the issue.

in addition, have you tried turning on the debug log in admin => configuration => SEO urls. and if so can you post some of the contents of the log?

---

Hi Carlwhat,
My site is augiespanoramas(dot)com
I enabled debug log in the Configuration settings.
Here are the logs that I found (doubt they're useful):

index-2016-Jul-17_2.log

Code:

---

============================================================
===== URL Generation Log Started 2016-Jul-17T00:27:51
============================================================
Real URI:      index.php?main_page=index&cPath=10_63
Request URI:  /index.php?main_page=index&cPath=10_63
Canonical URI:

============================================================
===== Generated Alternative URLs
============================================================

---

and:
product_info-2016-Jul-17_0.log

Code:

---

============================================================
===== URL Generation Log Started 2016-Jul-17T00:27:55
============================================================
Real URI:      index.php?main_page=product_info&cPath=10_63&products_id=145
Request URI:  /index.php?main_page=product_info&cPath=10_63&products_id=145
Canonical URI:

============================================================
===== Generated Alternative URLs
============================================================

---

Quote:

---

Originally Posted by augiespanoramas

Here are the logs that I found (doubt they're useful):

---

seth,
i always find logs useful! :)

the problem that i see is in the generation of the links. there is a modified core file:

includes/functions/html_output.php

are you sure you followed the instructions correctly with regards to this file?

similar to radek, your modified URLs will work, ie,

augiespanoramas(dot)com/dodger-stadium-p-136

works, but ZC is NOT generating those modified URLs when outputting your webpage.

the function that generates those links is not using the aforementioned html_output functions. the first function in that script is the zen_href_link function, which checks if you have turned it on, and then generates a link for use in the template. you have to see if you are hitting that function. the beginning of that code is something like this:

Code:

---

/**
 * html_output.php
 * HTML-generating functions used throughout the core
 *
 * @package functions
 * @copyright Copyright 2003-2014 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version GIT: $Id: Author: DrByte  Sat Apr 19 13:30:33 2014 -0400 Modified in v1.5.3 $
 */

/*
 * The HTML href link wrapper function
 */
  function zen_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true, $static = false, $use_dir_ws_catalog = true) {
    global $request_type, $session_started, $http_domain, $https_domain;
    //START alternative URLs patch
    global $altURLs;
        $link = null;
    if(isset($altURLs)) {
      $link = $altURLs->href_link($page, $parameters, $connection, $add_session_id, $static, $use_dir_ws_catalog);
      if($link !== null) return $link;
    }
    // END alternative URLs patch

---

i am not sure if v1.5.5a has overwritten those changes, but i would check that the alternative URL patch above is in that file.

i hope that helps! good luck!

Hi Carlwhat,
thank for your reply.
This inspired me to double check all modified files and I copy it to server again.
I don't know, in what was the reason, but now USU works fine and shop generates the links correctly.

I think, the problem was between chair and keyboard :)
Thanks to all.

Here is my zen_href_link() function from html_output.php:

PHP Code:

---

/*
 * The HTML href link wrapper function
 */
  function zen_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true, $static = false, $use_dir_ws_catalog = true) {
    global $request_type, $session_started, $http_domain, $https_domain, $zco_notifier;
    // START alternative URLs patch
    global $altURLs;
    // END alternative URLs patch
    $link = null;
    $zco_notifier->notify('NOTIFY_SEFU_INTERCEPT', array(), $link, $page, $parameters, $connection, $add_session_id, $static, $use_dir_ws_catalog);
    // START alternative URLs patch
    if(isset($altURLs)) {
      $link = $altURLs->href_link($page, $parameters, $connection, $add_session_id, $static, $use_dir_ws_catalog);
      if($link !== null) return $link;
    }
    // END alternative URLs patch

    if (!zen_not_null($page)) {
      die('</td></tr></table></td></tr></table><br /><br /><strong class="note">Error!<br /><br />Unable to determine the page link!</strong><br /><br /><!--' . $page . '<br />' . $parameters . ' -->');
    }

    if ($connection == 'NONSSL') {
      $link = HTTP_SERVER;
    } elseif ($connection == 'SSL') {
      if (ENABLE_SSL == 'true') {
        $link = HTTPS_SERVER ;
      } else {
        $link = HTTP_SERVER;
      }
    } else {
      die('</td></tr></table></td></tr></table><br /><br /><strong class="note">Error!<br /><br />Unable to determine connection method on a link!<br /><br />Known methods: NONSSL SSL</strong><br /><br />');
    }

    if ($use_dir_ws_catalog) {
      if ($connection == 'SSL' && ENABLE_SSL == 'true') {
        $link .= DIR_WS_HTTPS_CATALOG;
      } else {
        $link .= DIR_WS_CATALOG;
      }
    }

    if (!$static) {
      if (zen_not_null($parameters)) {
        $link .= 'index.php?main_page='. $page . "&" . zen_output_string($parameters);
      } else {
        $link .= 'index.php?main_page=' . $page;
      }
    } else {
      if (zen_not_null($parameters)) {
        $link .= $page . "?" . zen_output_string($parameters);
      } else {
        $link .= $page;
      }
    }

    $separator = '&';

    while ( (substr($link, -1) == '&') || (substr($link, -1) == '?') ) $link = substr($link, 0, -1);
// Add the session ID when moving from different HTTP and HTTPS servers, or when SID is defined
    if ( ($add_session_id == true) && ($session_started == true) && (SESSION_FORCE_COOKIE_USE == 'False') ) {
      if (defined('SID') && zen_not_null(constant('SID'))) {
        $sid = constant('SID');
//      } elseif ( ( ($request_type == 'NONSSL') && ($connection == 'SSL') && (ENABLE_SSL_ADMIN == 'true') ) || ( ($request_type == 'SSL') && ($connection == 'NONSSL') ) ) {
      } elseif ( ( ($request_type == 'NONSSL') && ($connection == 'SSL') && (ENABLE_SSL == 'true') ) || ( ($request_type == 'SSL') && ($connection == 'NONSSL') ) ) {
        if ($http_domain != $https_domain) {
          $sid = zen_session_name() . '=' . zen_session_id();
        }
      }
    }

// clean up the link before processing
    while (strstr($link, '&&')) $link = str_replace('&&', '&', $link);
    while (strstr($link, '&amp;&amp;')) $link = str_replace('&amp;&amp;', '&amp;', $link);

    if ( (SEARCH_ENGINE_FRIENDLY_URLS == 'true') && ($search_engine_safe == true) ) {
      while (strstr($link, '&&')) $link = str_replace('&&', '&', $link);

      $link = str_replace('&amp;', '/', $link);
      $link = str_replace('?', '/', $link);
      $link = str_replace('&', '/', $link);
      $link = str_replace('=', '/', $link);

      $separator = '?';
    }

    if (isset($sid)) {
      $link .= $separator . zen_output_string($sid);
    }

// clean up the link after processing
    while (strstr($link, '&amp;&amp;')) $link = str_replace('&amp;&amp;', '&amp;', $link);

    $link = preg_replace('/&/', '&amp;', $link);
    return $link;
  } 


---

Quote:

---

Originally Posted by Radek

I think, the problem was between chair and keyboard :)

---

Woah! It worked!! I tried manually editing my html_output.php and it didn't do anything different. So I listened to Radek's advice, and I retried installing all of the files again. First, I uninstalled it, then I copied each of the files again, and when it came to \ultimate_urls-215\modified_files folder, I copied the files from the /1.5.4/ folder (even though I have 1.5.5a) hoping the "closest" one may work. (I dont think I did any of these last time since it didn't list 1.5.5a) Anyway, voila...it worked!!
Thanks Carlwhat and Radek for having the same issue as me...ultimately encouraging me to retrace my steps and confirm that the issue indeed was "was between chair and keyboard :)"

Does anyone know why this plugin is marked as *** USE AT OWN RISK *** in the plugins? There's nothing that I've found that carves the cr@p out of core-files like some other plugins ...

Quote:

---

Originally Posted by lat9

Does anyone know why this plugin is marked as *** USE AT OWN RISK *** in the plugins? There's nothing that I've found that carves the cr@p out of core-files like some other plugins ...

---

I've always assumed it was the author just covering his behind in case something went wrong.

Quote:

---

Originally Posted by lat9

Does anyone know why this plugin is marked as *** USE AT OWN RISK *** in the plugins? There's nothing that I've found that carves the cr@p out of core-files like some other plugins ...

---

I thought it was always because of the use/non-use of a URI rewriter and nothing specific about the mechanism to make it happen, the specific code, nor the specific modifications.

It alters how your site is seen by all things navigating the Internet. Haphazardly switching to (or somewhat more importantly from) it or any such plugin can have a hard impact on the site.

I was asking because this URI rewriter is the only one with that cautionary notice; I've seen the "label" before, but it was on a plugin that tore the :censored: out of many core files (which USU doesn't).

Zencart 1.5.5.a

on php 5.3.29, MySQL 5.5.49

mods installed:
Edit Orders 4.1.5
Canada Post Shiping module
Flexible Footer Menu Multilingual
Flexible Language Currency Header Options
Simplified Social Share
Oneall Social Login (not operational)
Newsletter Subscribe
Column Layout Grid
Ultimate Urls 2.15

All the links get rewritten as they should no issues there. However, when I try to add a product to the cart it doesn't work. It goes to store/shopping_cart.html and it stops working from there. I've looked on IE and I get a broken page that loads only part of the footer or I get an oops it's not working. On Firefox and Chrome and get a 404 Page Not Found. Same applies to the store/specials.html , the log in page etc...

In configuration, where I found: Limit alternate URLS to the following pages

all these pages are listed and I took that to mean that they wouldn't get rewritten, am I mistaken and is it relevent to this?

these are the pages listed there: index, product_info, product_music_info, document_general_info, document_product_info, product_free_shipping_info, products_new, products_all, shopping_cart, featured_products, specials, contact_us, conditions, privacy, reviews, shippinginfo, faqs_all, site_map, gv_faq, discount_coupon, page, page_2, page_3, page_4

I checked the logs for errors but no logs gets created. I've also searched this thread and didn't find anything that worked

I went to html validator and got rid of all the html errors and css errors... still each time I set Ultimate Seo Urls to true, I can't add anything to the cart. I then used the Debugger on Firefox and it says that the stylesheet is not loading but I can't find why.

Any help would be greatly appreciated

How to merge the admin\includes\class\plugin.php with that is from another plugin? I have installed "edit orders" which has the same file with different codes. Since it isn't original zen cart file, I have no idea how to merge them. Is anybody can help? Thanks.

Quote:

---

Originally Posted by su35

How to merge the admin\includes\class\plugin.php with that is from another plugin? I have installed "edit orders" which has the same file with different codes. Since it isn't original zen cart file, I have no idea how to merge them. Is anybody can help? Thanks.

---

Please refer to my post in the Edit Orders support-thread regarding a possible solution.

Thanks, lat9. I get it.
Now, another question. I had set enable whole site SSL. if I turn the ultimate urls on, all on page links were set as http://. Is there any way to fix it?

Looking (albeit quickly) at the USU handling, I can't explain your results. Try enabling the plugin's debug mode to see what it is generating for those links.

Umm, how was the whole site enabled to be SSL? If not by modifying the includes/configure.php file to have all urls goto https: then that could be part of the problem...

Quote:

---

Originally Posted by mc12345678

Umm, how was the whole site enabled to be SSL? If not by modifying the includes/configure.php file to have all urls goto https: then that could be part of the problem...

---

includes\configure.php

Code:

---

define('ENABLE_SSL', 'true');

---

admin\includes\configure.php

Code:

---

define('ENABLE_SSL_CATALOG', 'true');

---

includes\functions\html_output.php add on line in function zen_href_link()

Code:

---

if(ENABLE_SSL_CATALOG){$connection = 'SSL';}

---

There's the mistake, do not modify includes\functions\html_output.php

Return that the way is was and only modify the two configure files

Quote:

---

Originally Posted by lat9

Looking (albeit quickly) at the USU handling, I can't explain your results. Try enabling the plugin's debug mode to see what it is generating for those links.

---

original code

Code:

---

<a href="<?php echo zen_href_link(FILENAME_PRODUCTS_ALL); ?>"><?php echo TOP_MENU_ALL_PRODUCTS;?></a>

---

log content

Code:

---

Request sent to href_link('products_all', '', 'NONSSL', true, false, true, true)
Generated URL: http://www.zencart.ca/products_all.html

---

Where is ultimate_urls collects the link parameters?

modify the two configure files couldn't enable the whole site SSL

I found the solution. put the added code on top

Code:

---

function zen_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true, $static = false, $use_dir_ws_catalog = true) {
  global $request_type, $session_started, $http_domain, $https_domain, $zco_notifier;
if(ENABLE_SSL_CATALOG){$connection = 'SSL';}

---

Now, the log content

Code:

---

Request sent to href_link('products_all', '', 'SSL', true, false, true, true)
Generated URL: https://www.zencart.ca/products_all.html

---

If you change HTTP_SERVER define to start with https: like:

Code:

---

define('HTTP_SERVER', 'https://yoursite.com');

---

Then the entire site should be offered as https considering your other changes in includes/configure.php.

Quote:

---

Originally Posted by su35

modify the two configure files couldn't enable the whole site SSL

---

Um, yes it could and yes it does. If you go editing other code, you're going to create problems for yourself, say like the XML Sitemap not working correctly. ;-)

Thanks, everybody. Now, I enable the SSL by configure files defined

Is anybody has used this plugin with jquery moblie? I got 404 error with jquery mobile. But I don't know whether this plugin conflicts with jquery mobile, or there are codeing error when I modified? On address bar, if I input "index.php?main_page=index&cPath=4", page load as nomal. If I input as "name-c-4.html" fomat, 404 was returned.

Quote:

---

Originally Posted by su35

Is anybody has used this plugin with jquery moblie? I got 404 error with jquery mobile. But I don't know whether this plugin conflicts with jquery mobile, or there are codeing error when I modified? On address bar, if I input "index.php?main_page=index&cPath=4", page load as nomal. If I input as "name-c-4.html" fomat, 404 was returned.

---

My codeing error.:D:D

I have Ultimate URL's installed on zen cart v1.5.5a. But my category and subcategory page URLs could be a little cleaner. The product and EZ pages show just perfect. I suspect it has to do with my .htaccess code but I don't know how to clean them up. For example here is one of my sloppy links:

Code:

---

www.myURL.com/stock-wings-c-14_2/?page=StockWings

---

I would like to remove the

Code:

---

?page=StockWings

---

at the end of each of my category URL's to make it look clean like this:

Code:

---

http://www.myURL.com/stock-wings-c-14_2/

---

I tested this URL: http://www.myURL.com/stock-wings-c-14_2/ and the category page shows just fine so I don't get why the additional information bloat is added. This is my .htaccess code:

Code:

---

# Common directives
###############################################################################
# NOTE: Replace /shop/ with the relative web path of your catalog in the "Rewrite

Base" line below:

Options +FollowSymLinks
RewriteEngine on
RewriteBase /

###############################################################################
# Start Ultimate SEO URLs
###############################################################################

# Handles the new URL formats
RewriteRule ^(.*)-c-([0-9_]+)/(.*)-p-([0-9]+)(.*)$ index\.php?

main_page=product_info&products_id=$4&cPath=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-c-([0-9_]+)/(.*)-pi-([0-9]+)(.*)$ index\.php?

main_page=popup_image&pID=$4&cPath=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-c-([0-9_]+)/(.*)-pr-([0-9]+)(.*)$ index\.php?

main_page=product_reviews&products_id=$4&cPath=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-c-([0-9_]+)/(.*)-pri-([0-9]+)(.*)$ index\.php?

main_page=product_reviews_info&products_id=$4&cPath=$2&%{QUERY_STRING} [L]

# Original (unchanged) URL formats
RewriteRule ^(.*)-p-([0-9]+)(.*)$ index\.php?main_page=product_info&products_id=$2&

%{QUERY_STRING} [L]
RewriteRule ^(.*)-m-([0-9]+)(.*)$ index\.php?main_page=index&manufacturers_id=$2&

%{QUERY_STRING} [L]
RewriteRule ^(.*)-pi-([0-9]+)(.*)$ index\.php?main_page=popup_image&pID=$2&

%{QUERY_STRING} [L]
RewriteRule ^(.*)-pr-([0-9]+)(.*)$ index\.php?

main_page=product_reviews&products_id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-pri-([0-9]+)(.*)$ index\.php?

main_page=product_reviews_info&products_id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-ezp-([0-9]+)(.*)$ index\.php?main_page=page&id=$2&%{QUERY_STRING}

[L]
RewriteRule ^(.*)-c-([0-9_]+)(.*)$ index\.php?main_page=index&cPath=$2&

%{QUERY_STRING} [L]

# All other pages
# Don't rewrite real files or directories
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index\.php?main_page=$1&%{QUERY_STRING} [L]

---

Again all other pages have clean URL's its just the category and subcategory pages that look sloppy. Any ideas please?

i do not believe your problem is with your .htaccess file. the problem is with the creation of the category links.

i would look over includes/classes/usu.php. my guess is that is where the problem resides, not in the htaccess file.

if the site is live, a link to it would be more helpful.

good luck.

Quote:

---

Originally Posted by carlwhat

i do not believe your problem is with your .htaccess file. the problem is with the creation of the category links.

i would look over includes/classes/usu.php. my guess is that is where the problem resides, not in the htaccess file.

if the site is live, a link to it would be more helpful.

good luck.

---

OK here is a link to my website http://www.aviationinsignia.com/insi...?page=Insignia. It seems as if only the top menu is making the links this way. Template issue? The lower menu (on this same page) does not seem to add these additional characters. I looked at my template common folder> tpl_drop_menu.php file and did not see where this was adding these characters.

if you are convinced that is the script that is generating those links, i'm "thinking" that you have a couple of files called:

includes/classes/categories_ul_generator.php
includes/classes/categories_ul_generator_menu_style_2.php

in my setup, the culprit seems to be in the second script:

Code:

---


<a href="' . zen_href_link(FILENAME_DEFAULT, 'cPath=' . $category_link . '&page='. $category['name'])

---

i would change it to:

Code:

---


<a href="' . zen_href_link(FILENAME_DEFAULT, 'cPath=' . $category_link)

---

please note, that i did not post the WHOLE line of code, just the problem part...

i "think" that may be your problem.... but it's a wild (educated) guess...

no warranties, guarantees, etc...

best.

carlwhat, I can see the work and effort you put into helping me and thank you for your time, its much appreciated! Your solution worked. In this file: includes>classes> categories_ul_generator_menu_style_2.php around line #83 and 84 I found this code:

Code:

---

'<a href="' . zen_href_link(FILENAME_DEFAULT, 'cPath=' . $category_link .  '&page='. $category['name']) . '">';

---

Per you great instructions I changed to this:

Code:

---

'<a href="' . zen_href_link(FILENAME_DEFAULT, 'cPath=' . $category_link) . '">';

---

Problem solved. It didn't seem like the template override was working for this file but maybe it was cache. So I had to change this code in both the over-ride folder and core folder and make a note in case of future updates. Anyway, works perfectly. Again, thank you very much!

There is no "override" for the /includes/classes folder. Alterations to files in that folder must be made directly.

Thank you, that's good to know.

Where the urls are stored? I mean I need to know where in the database or how can I pull the list of rewritten URLs either from the database or somewhere else talking about product 'landing' pages. THe table usu doesn't have the url ... I just need the url and product id or whatever index is used to reference it, so I can I add each url to a csv matching the corresponding product's id.

Quote:

---

Originally Posted by icecold

Where the urls are stored? I mean I need to know where in the database or how can I pull the list of rewritten URLs either from the database or somewhere else talking about product 'landing' pages. THe table usu doesn't have the url ... I just need the url and product id or whatever index is used to reference it, so I can I add each url to a csv matching the corresponding product's id.

---

They are not stored, they are generated.

One way to obtain the product's url is to use EasyPopulate v4 and export with the product's URL option turned on from the configuration menu. A column will exist with the product's url/uri as generated by your uri rewriter. The other information you are wanting included can be added as a user identified field if it exists in the products table and is already not included in the export or it can be pieced together as necessary.

I don't use EasyPopulate, if they are generated I thought once created there were stored somewhere, any way to avoid installing EasyPopulate4?

Here's a really simple way:

a) visit a product in your store
b) note the URL
c) see the pattern: the segments with slashes etc, and where the product-id number appears

Now you can replicate the same in your spreadsheet.

Also: USU honors default Zen Cart URLs and tells search engines the correct rewritten ("canonical") URL to index, so there's no harm in giving out the non-rewritten URL too

I have thousands of products ... to do this manually is crazy, I tried doing a VLOOKUP, to match exactly what was active, didn't work ... Anyway thanks for the tips I'll try something else ...

Quote:

---

Originally Posted by icecold

I have thousands of products ... to do this manually is crazy, I tried doing a VLOOKUP, to match exactly what was active, didn't work ... Anyway thanks for the tips I'll try something else ...

---

Also any process that will access zen_href_link and is provided the correct ZC information can generate or be used to generate your desired information in the CSV.

Quote:

---

Originally Posted by DrByte

Here's a really simple way:

a) visit a product in your store
b) note the URL
c) see the pattern: the segments with slashes etc, and where the product-id number appears

Now you can replicate the same in your spreadsheet.

Also: USU honors default Zen Cart URLs and tells search engines the correct rewritten ("canonical") URL to index, so there's no harm in giving out the non-rewritten URL too

---

Quote:

---

Originally Posted by icecold

I have thousands of products ... to do this manually is crazy, I tried doing a VLOOKUP, to match exactly what was active, didn't work ... Anyway thanks for the tips I'll try something else ...

---

I think you missed DrByte's point. If you look at the example of a single uri, And you look at the data you have available in your csv, the thought is that you can "reverse engineer" what it takes to get the same type of uri for all products. Then apply that "rule" and tada. Sure, in answering the question of is there another way to get all the URIS, manually one by one is a way, but because this plugin doesn't store/offer manual manipulation of the uri, it is going to be "rule" based and methodical.

i tested to install ultimate_urls-215 for localhost zencart1.5.5b, just follow the steps one by one, finally when i click any link in admin page, it shows error: WARNING: An Error occurred, please refresh the page and try again.

so i checked logs as following:

[09-Nov-2016 12:42:59 UTC] Request URI: /new/admin/index.php, IP address: ::1
#1 trigger_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:167]
#2 queryFactory->show_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:139]
#3 queryFactory->set_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:266]
#4 queryFactory->Execute() called at [D:\wamp\www\new\admin\includes\classes\usu_plugin.php:145]
#5 usu_plugin->handleDatabaseChanges() called at [D:\wamp\www\new\admin\includes\classes\plugin.php:336]
#6 plugin->install() called at [D:\wamp\www\new\admin\includes\classes\usu_plugin.php:474]
#7 usu_plugin->install() called at [D:\wamp\www\new\admin\includes\init_includes\init_usu_install.php:7]
#8 require(D:\wamp\www\new\admin\includes\init_includes\init_usu_install.php) called at [D:\wamp\www\new\includes\autoload_func.php:48]
#9 require(D:\wamp\www\new\includes\autoload_func.php) called at [D:\wamp\www\new\admin\includes\application_top.php:171]
#10 require(D:\wamp\www\new\admin\includes\application_top.php) called at [D:\wamp\www\new\admin\index.php:10]


WAMP I used: wampserver3.0.6_x86_apache2.4.23_mysql5.7.14_php5.6.25-7.0.10

Could anyone help me? I have spent several hours and test many times, but still failed to install it. or ultimate_urls-215 does not work for the latest zencart version 1.5.5b???

Any help would be highly appreciated!
Thanks in advance.
Will

Quote:

---

Originally Posted by holawill

i tested to install ultimate_urls-215 for localhost zencart1.5.5b, just follow the steps one by one, finally when i click any link in admin page, it shows error: WARNING: An Error occurred, please refresh the page and try again.

so i checked logs as following:

[09-Nov-2016 12:42:59 UTC] Request URI: /new/admin/index.php, IP address: ::1
#1 trigger_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:167]
#2 queryFactory->show_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:139]
#3 queryFactory->set_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:266]
#4 queryFactory->Execute() called at [D:\wamp\www\new\admin\includes\classes\usu_plugin.php:145]
#5 usu_plugin->handleDatabaseChanges() called at [D:\wamp\www\new\admin\includes\classes\plugin.php:336]
#6 plugin->install() called at [D:\wamp\www\new\admin\includes\classes\usu_plugin.php:474]
#7 usu_plugin->install() called at [D:\wamp\www\new\admin\includes\init_includes\init_usu_install.php:7]
#8 require(D:\wamp\www\new\admin\includes\init_includes\init_usu_install.php) called at [D:\wamp\www\new\includes\autoload_func.php:48]
#9 require(D:\wamp\www\new\includes\autoload_func.php) called at [D:\wamp\www\new\admin\includes\application_top.php:171]
#10 require(D:\wamp\www\new\admin\includes\application_top.php) called at [D:\wamp\www\new\admin\index.php:10]


WAMP I used: wampserver3.0.6_x86_apache2.4.23_mysql5.7.14_php5.6.25-7.0.10

Could anyone help me? I have spent several hours and test many times, but still failed to install it. or ultimate_urls-215 does not work for the latest zencart version 1.5.5b???

Any help would be highly appreciated!
Thanks in advance.
Will

---

Please provide the remainder of the error message. Ie. The error itself... The above information is simply the path of files involved at the time of the error.

@holawill, do you also have the Edit Orders plugin installed?

Quote:

---

Originally Posted by mc12345678

Please provide the remainder of the error message. Ie. The error itself... The above information is simply the path of files involved at the time of the error.

---

Thanks, more from myDEBUG-adm-1478761864-477120.log

[10-Nov-2016 07:11:05 UTC] Request URI: /new/admin/login.php?camefrom=index.php&zenAdminID=36sr2q8t6og8597oikmsh68h77, IP address: ::1

#1 trigger_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:167]
#2 queryFactory->show_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:139]
#3 queryFactory->set_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:266]
......

BTW, I did not install order plugins.

Quote:

---

Originally Posted by lat9

@holawill, do you also have the Edit Orders plugin installed?

---

Thanks, I did not install Edit Orders plugin.

[10-Nov-2016 07:11:05 UTC] Request URI: /new/admin/login.php?camefrom=index.php&zenAdminID=36sr2q8t6og8597oikmsh68h77, IP address: ::1
#1 trigger_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:167]
#2 queryFactory->show_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:139]
#3 queryFactory->set_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:266]
#4 queryFactory->Execute() called at [D:\wamp\www\new\admin\includes\classes\usu_plugin.php:145]
#5 usu_plugin->handleDatabaseChanges() called at [D:\wamp\www\new\admin\includes\classes\plugin.php:336]
#6 plugin->install() called at [D:\wamp\www\new\admin\includes\classes\usu_plugin.php:474]
#7 usu_plugin->install() called at [D:\wamp\www\new\admin\includes\init_includes\init_usu_install.php:7]
#8 require(D:\wamp\www\new\admin\includes\init_includes\init_usu_install.php) called at [D:\wamp\www\new\includes\autoload_func.php:48]
#9 require(D:\wamp\www\new\includes\autoload_func.php) called at [D:\wamp\www\new\admin\includes\application_top.php:171]
#10 require(D:\wamp\www\new\admin\includes\application_top.php) called at [D:\wamp\www\new\admin\login.php:9]

[10-Nov-2016 07:11:05 UTC] PHP Fatal error: 1067:Invalid default value for 'cache_date' :: CREATE TABLE `usu_cache` ( `cache_id` VARCHAR(32) NOT NULL default '', `cache_language_id` TINYINT(1) NOT NULL default '0', `cache_name` VARCHAR(255) NOT NULL default '', `cache_data` MEDIUMBLOB NOT NULL, `cache_global` TINYINT(1) NOT NULL default '1', `cache_gzip` TINYINT(1) NOT NULL default '1', `cache_method` VARCHAR(20) NOT NULL default 'RETURN', `cache_date` DATETIME NOT NULL default '0000-00-00 00:00:00', `cache_expires` DATETIME NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`cache_id`,`cache_language_id`), KEY `cache_id` (`cache_id`), KEY `cache_language_id` (`cache_language_id`), KEY `cache_global` (`cache_global`) ) ==> (as called by) D:\wamp\www\new\admin\includes\classes\usu_plugin.php on line 145 <== in D:\wamp\www\new\includes\classes\db\mysql\query_factory.php on line 167
[10-Nov-2016 07:11:05 UTC] PHP Stack trace:
[10-Nov-2016 07:11:05 UTC] PHP 1. {main}() D:\wamp\www\new\admin\login.php:0
[10-Nov-2016 07:11:05 UTC] PHP 2. require() D:\wamp\www\new\admin\login.php:9
[10-Nov-2016 07:11:05 UTC] PHP 3. require() D:\wamp\www\new\admin\includes\application_top.php:171
[10-Nov-2016 07:11:05 UTC] PHP 4. require() D:\wamp\www\new\includes\autoload_func.php:48
[10-Nov-2016 07:11:05 UTC] PHP 5. usu_plugin->install() D:\wamp\www\new\admin\includes\init_includes\init_usu_install.php:7
[10-Nov-2016 07:11:05 UTC] PHP 6. plugin->install() D:\wamp\www\new\admin\includes\classes\usu_plugin.php:474
[10-Nov-2016 07:11:05 UTC] PHP 7. usu_plugin->handleDatabaseChanges() D:\wamp\www\new\admin\includes\classes\plugin.php:336
[10-Nov-2016 07:11:05 UTC] PHP 8. queryFactory->Execute() D:\wamp\www\new\admin\includes\classes\usu_plugin.php:145
[10-Nov-2016 07:11:05 UTC] PHP 9. queryFactory->set_error() D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:266
[10-Nov-2016 07:11:05 UTC] PHP 10. queryFactory->show_error() D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:139
[10-Nov-2016 07:11:05 UTC] PHP 11. trigger_error() D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:167

It would seem that somewhere between the code/line numbers identified by PHP 5 and PHP 8 that the default value for `cache_date` is set to '0000-00-00 00:00:00' instead of the more recent server preferred '0001-01-01 00:00:00'. Not sure if in following the above path of code if that means right now that your database needs an update or if it could be resolved by changing the install assignment as part of a first time run and it would be resolved.

The update for the field would be:

Code:

---

ALTERTABLE `usu_cache` MODIFY COLUMN `cache_date` DATETIME NOT NULL default '0001-01-01 00:00:00';

---

Although it does appear that the error is in the generation of the table, so probably looking for the sql that (should be before the location identified by PHP 8 above) provides the CREATE TABLE query. In there change the default date as identified above and "should" work.

Thanks, so i can try to run this sql code on my database through phpmyadmin?
it seems that this code is incorrect?

sorry for my stupid question, i'm not a professional.

3 errors were found during analysis.

Unexpected beginning of statement. (near "ALTERTABLE" at position 0)
Unexpected beginning of statement. (near "`usu_cache`" at position 11)
Unrecognized statement type. (near "MODIFY" at position 23)

SQL query:

ALTERTABLE `usu_cache` MODIFY COLUMN `cache_date` DATETIME NOT NULL default '0001-01-01 00:00:00'

[ QUOTE=mc12345678;1321352]It would seem that somewhere between the code/line numbers identified by PHP 5 and PHP 8 that the default value for `cache_date` is set to '0000-00-00 00:00:00' instead of the more recent server preferred '0001-01-01 00:00:00'. Not sure if in following the above path of code if that means right now that your database needs an update or if it could be resolved by changing the install assignment as part of a first time run and it would be resolved.

The update for the field would be:

Code:

---

ALTERTABLE `usu_cache` MODIFY COLUMN `cache_date` DATETIME NOT NULL default '0001-01-01 00:00:00';

---

Although it does appear that the error is in the generation of the table, so probably looking for the sql that (should be before the location identified by PHP 8 above) provides the CREATE TABLE query. In there change the default date as identified above and "should" work.[/QUOTE]

Quote:

---

Originally Posted by holawill

Thanks, so i can try to run this sql code on my database through phpmyadmin?
it seems that this code is incorrect?

sorry for my stupid question, i'm not a professional.

3 errors were found during analysis.

Unexpected beginning of statement. (near "ALTERTABLE" at position 0)
Unexpected beginning of statement. (near "`usu_cache`" at position 11)
Unrecognized statement type. (near "MODIFY" at position 23)

SQL query:

ALTERTABLE `usu_cache` MODIFY COLUMN `cache_date` DATETIME NOT NULL default '0001-01-01 00:00:00'

[ QUOTE=mc12345678;1321352]It would seem that somewhere between the code/line numbers identified by PHP 5 and PHP 8 that the default value for `cache_date` is set to '0000-00-00 00:00:00' instead of the more recent server preferred '0001-01-01 00:00:00'. Not sure if in following the above path of code if that means right now that your database needs an update or if it could be resolved by changing the install assignment as part of a first time run and it would be resolved.

The update for the field would be:

Code:

---

ALTERTABLE `usu_cache` MODIFY COLUMN `cache_date` DATETIME NOT NULL default '0001-01-01 00:00:00';

---

Although it does appear that the error is in the generation of the table, so probably looking for the sql that (should be before the location identified by PHP 8 above) provides the CREATE TABLE query. In there change the default date as identified above and "should" work.

---

[/QUOTE]
I missed a space somehow in the beginning of the sql query. Two other things. 1) if you use a prefix in your includes/configure.php (DB_PREfIX) and are using phpmyadmin, then usu_cache needs to have that prefix added to it. Otherwise you could run the following query in admin->tools->sql patch install with no changes from the below provided 2) this assumes that the table has been created which appears to not have been done.

Code:

---

ALTER TABLE `usu_cache` MODIFY COLUMN `cache_date` DATETIME NOT NULL default '0001-01-01 00:00:00';

---

Otherwise need to find in the code where the create table statement is and modify the 0000-00-00 portion to the above 0001-01-01.

1) i run the code in phpmyadmin: ALTER TABLE `usu_cache` MODIFY COLUMN `cache_date` DATETIME NOT NULL default '0001-01-01 00:00:00';
it returns error:

SQL query:

ALTER TABLE `usu_cache` MODIFY COLUMN `cache_date` DATETIME NOT NULL default '0001-01-01 00:00:00'

MySQL said: Documentation
#1146 - Table 'new.usu_cache' doesn't exist

i can not find table usu_cache in the database.
--------------
2) i did not use prefix in configure.php.

what can i do now?

Quote:

---

Originally Posted by holawill

1) i run the code in phpmyadmin: ALTER TABLE `usu_cache` MODIFY COLUMN `cache_date` DATETIME NOT NULL default '0001-01-01 00:00:00';
it returns error:

SQL query:

ALTER TABLE `usu_cache` MODIFY COLUMN `cache_date` DATETIME NOT NULL default '0001-01-01 00:00:00'

MySQL said: Documentation
#1146 - Table 'new.usu_cache' doesn't exist

i can not find table usu_cache in the database.
--------------
2) i did not use prefix in configure.php.

what can i do now?

---

I don't have a copy of the code to provide a specific line number to address the modification needed. But I would expect that if you look at the code identified by "PHP 5" through "PHP 8" of the error log, there should be the sql statement to "CREATE TABLE" that has the field cache_date with the problem default. Otherwise, I suspect that someone else may be able to provide the specific file/line number where that change can be made.

You could also use the tools->developers tool kit to search for

Code:

---

`cache_date` = '0000-00-00

---

and the line number of the applicable file should be provided.

Thanks a lot, mc12345678

I changed usu_plugin.php:

'`cache_date` DATETIME NOT NULL default \'0000-00-00 00:00:00\', ' .
'`cache_expires` DATETIME NOT NULL default \'0000-00-00 00:00:00\', ' .

modified to:
'`cache_date` DATETIME NOT NULL default \'0001-01-01 00:00:00\', ' .
'`cache_expires` DATETIME NOT NULL default \'0001-01-01 00:00:00\', ' .

Now I can access to admin page now!!! Thanks a lot! very helpful!

But now I have a new problem:

in frontend, when i move pointer to any links on homepage, for example, when i move pointer to "Hardware" categories, the status Bar URL shows:
localhost/new/index.php?main_page=index&Cpath=1

After i clicked it, it shows:http://localhost/new/hardware-c-1/

How to fix this? any ideas?

I attach my .htacess file below:

--------------------------------------------------------------------------
###############################################################################
# Add custom headers and options
###############################################################################
# Notes:
#
# Examples: Adding IE compatibility / edge flags, language and encoding flags,
# php or suphp directives, configure other Apache modules such as page_speed,
# and enable or disable Apache httpd options.
#
# Do NOT configure anything directly relating to physical or virtual resources
# in this section. These should be addressed later on in this file.
###############################################################################
#Options -Indexes

###############################################################################
# Enable mod_rewrite processing using the rules in this .htaccess file
###############################################################################
# Notes:
#
# <IfModule> should be avoided at all costs. If mod_rewrite is not available
# it is almost always better to return HTTP 500 status. This way we see there
# is an issue as soon as the .htaccess file is uploaded.
#
# For mod_rewrite to work, the Apache server option to allow symbolic links to
# be followed must be enabled. Most providers supporting mod_rewrite will
# already have it enabled for you, but if your rewrite rules are not working
# you can un-comment the first directive below to manually enable the option.
#
# Don't forget, mod_rewrite directives are processed in order until a matching
# RewriteRule with the [L] flag is encountered. So the more specific a rule is
# the closer it should appear to the top of this file.
###############################################################################

Options +FollowSymLinks
RewriteEngine on
RewriteBase /new/

###############################################################################
# Tell mod_rewrite where this file is relative to the server document_root
###############################################################################
# Notes:
#
# This directive should only be enabled if this .htaccess file is not placed
# in the document_root (usually public_html, www, or web) of the (sub)domain.
#
# An easy way to determine the location relative to the server document_root is
# to look at the URL used to access a file in this folder. For example if you
# access a "page" in the same folder as this file by typing in the URL
# "www.mydomain.com/myfolder/index.html" then "myfolder" will be the location
# of this file relative to the server document_root.
#
# Another quick and easy way to determine the correct setting for this is to
# look at the defined value for DIR_WS_CATALOG and DIR_WS_HTTPS_CATALOG in
# Zen Cart's configure.php files. All three values should match.
#
# Don't forget the leading and trailing /. This directive requires both!
###############################################################################



###############################################################################
# Redirect if request was for index.php (no query)
###############################################################################
# Notes:
#
# This is only required if the site generates references to index.php with no
# parameters. This rule will force a 301 redirect to the site root when a
# request is made for "/index.php" with no query terms (?key=value).
###############################################################################
#RewriteCond %{QUERY_STRING} ^$
#RewriteRule ^index\.php$ / [R=301,L]


###############################################################################
# Add any custom 301 redirects
###############################################################################
# Notes:
#
# In general these should be few and far between. If you use a RewriteRule
# be sure to add the L flag to let Apache mod_rewrite know to stop processing
# and skip any RewriteRules defined later in the .htaccess file.
###############################################################################


###############################################################################
# Redirect if request was for index.php (with or without query)
###############################################################################
# Notes:
#
# This is a performance optimization. If the request is for index.php simply
# pass the request on and do not process any other mod_rewrite directives in
# this file.
#
# Basically this avoids the overhead of checking if index.php is a real file
# or directory (used in subsequent mod_rewrite rules) before sending the
# request to index.php.
###############################################################################
RewriteRule ^index\.php$ - [L]


###############################################################################
# Start Ultimate (SEO) URLs
###############################################################################
# Notes:
#
# You should not make any changes in this section unless you really understand
# how it will impact your web site. Mistakes can break things.
###############################################################################

# Handles the new URL formats
RewriteRule ^(.*)-c-([0-9_]+)/(.*)-p-([0-9]+)(.*)$ index\.php?main_page=product_info&products_id=$4&cPath=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-c-([0-9_]+)/(.*)-pi-([0-9]+)(.*)$ index\.php?main_page=popup_image&pID=$4&cPath=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-c-([0-9_]+)/(.*)-pr-([0-9]+)(.*)$ index\.php?main_page=product_reviews&products_id=$4&cPath=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-c-([0-9_]+)/(.*)-pri-([0-9]+)(.*)$ index\.php?main_page=product_reviews_info&products_id=$4&cPath=$2&%{QUERY_STRING } [L]

# Original (unchanged) URL formats
RewriteRule ^(.*)-p-([0-9]+)(.*)$ index\.php?main_page=product_info&products_id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-m-([0-9]+)(.*)$ index\.php?main_page=index&manufacturers_id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-pi-([0-9]+)(.*)$ index\.php?main_page=popup_image&pID=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-pr-([0-9]+)(.*)$ index\.php?main_page=product_reviews&products_id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-pri-([0-9]+)(.*)$ index\.php?main_page=product_reviews_info&products_id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-ezp-([0-9]+)(.*)$ index\.php?main_page=page&id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-c-([0-9_]+)(.*)$ index\.php?main_page=index&cPath=$2&%{QUERY_STRING} [L]

# Rewrite all other requests (if the file / directory does not exist)
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index\.php?main_page=$1&%{QUERY_STRING} [L]

###############################################################################
# Add any other directives relating to the handling of physical files
###############################################################################
# Notes:
#
# If processing makes it this far, the request was for a real file or folder.
# Example: Adding further processing related to browser caching or security.
###############################################################################

in backend, i update "Reset URL Cache", but still the same:(

hola will!

you have a couple of choices. you are installing this plugin into a WAMP environment. i know nothing about WAMP.

that said, you have STRICT mode turned on in your mysql environment. as you can control that environment, you can turn strict mode off. perhaps someone more familiar your WAMP environmant can tell you where that mysql variable is. (or perhaps you know how to do that already... or a google search should help as well https://goo.gl/pTE2fh)

it may also be due to a deprecated variable called no zero date in your mysql implementation. it would depend on your version and your configuration.

barring that you could change the code for the plugin. it looks like you would need to go to:

admin/includes/classes/usu_plugin.php

there are 2 instances where you would need to change (my line numbers look different from the ones reported in the log, and i have a fresh download):

0000-00-00

to

0001-01-01

personally i would recommend the first option. but your choice....

good luck!

Attachment 16779

This is my settings.

Quote:

---

Originally Posted by carlwhat

hola will!

you have a couple of choices. you are installing this plugin into a WAMP environment. i know nothing about WAMP.

that said, you have STRICT mode turned on in your mysql environment. as you can control that environment, you can turn strict mode off. perhaps someone more familiar your WAMP environmant can tell you where that mysql variable is. (or perhaps you know how to do that already... or a google search should help as well https://goo.gl/pTE2fh)

it may also be due to a deprecated variable called no zero date in your mysql implementation. it would depend on your version and your configuration.

barring that you could change the code for the plugin. it looks like you would need to go to:

admin/includes/classes/usu_plugin.php

there are 2 instances where you would need to change (my line numbers look different from the ones reported in the log, and i have a fresh download):

0000-00-00

to

0001-01-01

personally i would recommend the first option. but your choice....

good luck!

---

Thanks carlwhat, i have already fixed the first issue, now I can access to admin page now. i just posted another problem on post #1089, any ideas?

ideas? sure... i would still turn strict mode off...

with regards to your new problem, what template are you using?

your problem is NOT related to your .htaccess file.

some script is creating those links; and that script is ignoring the setting for your URLs.

good luck.

i just use the default Responsive Classic Template.
Attachment 16780

i also tried Classic Contemporary Green, still the same

that is a breadcrumb. it is constructed here:

includes/init_includes/init_add_crumbs.php

you can then see where the category part is constructed. my code looks like:

Code:

---

      $breadcrumb->add($categories->fields['categories_name'], zen_href_link(FILENAME_DEFAULT, 'cPath=' . implode('_', array_slice($cPath_array, 0, ($i+1)))));

---

you then would need to find zen_href_link which i see here:

includes/functions/html_output.php

mine modified looks something like this:

Code:

---

  function zen_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true, $static = false, $use_dir_ws_catalog = true) {
    global $seo_urls;

    $href_link = null;
          if(isset($seo_urls)) {
      $href_link = $seo_urls->href_link($page, $parameters, $connection, $add_session_id, $static, $use_dir_ws_catalog);
    }

    if($href_link === null) {
            $href_link = original_zen_href_link($page, $parameters, $connection, $add_session_id, $search_engine_safe, $static, $use_dir_ws_catalog);
    }

    return $href_link;
  }

---

good luck!

Thanks carlwhat.

For includes/init_includes/init_add_crumbs.php, my code is the same as yours.

For includes/functions/html_output.php, mine is different:

PHP Code:

---

function zen_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true, $static = false, $use_dir_ws_catalog = true) {
    global $request_type, $session_started, $http_domain, $https_domain, $zco_notifier;
    $link = null;
    $zco_notifier->notify('NOTIFY_SEFU_INTERCEPT', array(), $link, $page, $parameters, $connection, $add_session_id, $static, $use_dir_ws_catalog);
    if($link !== null) return $link;

    if (!zen_not_null($page)) {
      die('</td></tr></table></td></tr></table><br /><br /><strong class="note">Error!<br /><br />Unable to determine the page link!</strong><br /><br /><!--' . $page . '<br />' . $parameters . ' -->');
    } 


---

you need to look at the README in the install.

my version is slightly older.

look under modified files. you have not done that part.

PHP Code:

---

  function zen_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true, $static = false, $use_dir_ws_catalog = true) {
    global $request_type, $session_started, $http_domain, $https_domain;
    // START alternative URLs patch
    global $altURLs;
    $link = null;
    if(isset($altURLs)) {
      $link = $altURLs->href_link($page, $parameters, $connection, $add_session_id, $static, $use_dir_ws_catalog);
      if($link !== null) return $link;
    }
    // END alternative URLs patch 


---

Thanks again carlwhat.

I replaced the code with yours, now the site works well now. Currently all my problems solved, i really appreciate your help, have a nice day.