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

[icecold]

[31-Aug-2014 21:08:31] PHP Fatal error: 1146:Table 'seasonbr_demo.seo_cache' doesn't exist :: DELETE FROM seo_cache WHERE cache_expires <= '2014-08-31 21:08:31' ==> (as called by) /home/seasonbr/public_html/demostore/includes/classes/seo.url.php on line 1245 <== in /home/seasonbr/public_html/demostore/includes/classes/db/mysql/query_factory.php on line 155

Getting this error, not sure why because I don't have a table with that name, any hints? BTW I am using this on a fresh store, with just a template and this plugin, ZC v153 ...

[lhungil]

Fully uninstall (use the included scripts, remove the files, clean any DB entries from older versions) and then install again. The installation creates the seo_cache table.

[icecold]

Fully uninstall (use the included scripts, remove the files, clean any DB entries from older versions) and then install again. The installation creates the seo_cache table.

I will check it with PHPMyAdmin but I don't think there should be any DB entries as this a FRESH demo, with just the template and template modules ... Nothing else, I installed Ultimate SEO on top ... BTW ...

Problems arose when I started to modify the core files that were not intended for ZC v 153 ...
I dropped the TABLE_SEO_URL so I hope it works this time ...

[brist]

I should have mentioned in my prior post about one compatibility issue I had with Ultimate SEO working with the Dynamic Filter plugin. Ultimate SEO didn't handle PHP array GET parameters using '[]' syntax. Dynamic filter uses them to pass variables in the format of "fltOptionName[]". Here's an example:

?main_page=index&
cPath=1234&
fltPrice[]=$0 - $25&
fltPrice[]=$25 - $50&
fltPrice[]=$50 - $75&
fltSize[]=Medium&
fltPrice[]=&
fltSize[]=&
fltColor[]=White&
fltLength[]=&
fltStyle[]=

The flt* parameters are loaded into arrays which don't work with the snippets below:

seo_url.php function parse_parameters()

 342                 default:
 343                     $container[$p2[0]] = $p2[1];
 344                     break; 

and:

 348         if(sizeof($container) > 0) {
 349             if($imploded_params = $this->implode_assoc($container)) {
 350                 $url .= $separator . zen_output_string($imploded_params);
 351                 $separator = '&';
 352             }
 353         } 

Any chance your future release will have compatibility with array GET parameters?

FYI: This is the change I made to make them work together on my site.

  default:
      if (strpos($p2[0], '[]') === strlen($p2[0]) - 2) {
          if (isset($container[$p2[0]])) {
              array_push($container[$p2[0]], $p2[1]);
          } else {
              $container[$p2[0]] = array($p2[1]);
          }
      } else {
          $container[$p2[0]] = $p2[1];
      }
      break; 

  if(sizeof($container) > 0) {
      $imploded_params = '';
      foreach ($container as $key => $val) {
          if (trim($key) == '') {
              continue;
          } else if (is_array($val) && count($val) > 0) {
              foreach ($val as $arr) {
                  if ($imploded_params != '')
                      $imploded_params .= '&';

                  $imploded_params .= $key . '=' . $arr;
              }
          } else {
              if ($imploded_params != '')
                  $imploded_params .= '&';

              $imploded_params .= $key . '=' . $val;
          }
      }
      if ($imploded_params != '') {
          $url .= $separator . zen_output_string($imploded_params);
          $separator = '&';
      }
  } 

[delia]

it's about that Call to undefined function zen_get_ip_address().

It's being caused by the admin/functions/general.php file. There were major changes from 1.5.1 to 1.5.3

The html_output.php in admin was also changed in 1.5.3 but it is a minor change.

I wasted hours last week - and some today. I wasn't sure last week which mod had caused the problem but this time I knew.

The mod still works with the 1.5.3 original files in a upgraded cart - course have no idea if that's true in a new installation.

[dharrison]

Hi I use ultimate SEOs in a 1.5.1 site and it works like a dream.

However I have tried to add it to a new 1.5.3 and it breaks the site even by tweaking the first of the affected files (includes/classes/db/mysql/query_factory.php) even change mysql to mysqli doesn't work.

Please advise is this add-on being upgraded for use on Zencart 1.5.3? I sure hope so.

[lhungil]

You do not need to edit query_factory.php from Zen Cart 1.5.3. (The included changes for 1.5.0 and 1.5.1 were to fix a known bug in the Zen Cart 1.5.0 and 1.5.1 versions of query_factory.php). The bug fix is already included in Zen Cart 1.5.2+.

As for query_cache.php, just need to add the removeFromCache() function. Rest of the affected core files are mostly 1-3 line changes (to allow the internal cache to automatically purge itself when a product / category / etc are changed - or to add the call to href_link from Ultimate URLs).

Have you gotten a chance to look at the Zen Cart 1.5.2 affected_files (attached earlier in this thread) yet? The edits in those will be close to what is needed for Zen Cart 1.5.3.

[joyjoy]

Hello, does anyone have this working with 1.5.3? Also, I was wondering what I need to do if I move the domain name. I moved to a new domain, all my links broke. When I turn off Ultimate SEO it now works again.

[dharrison]

Have you gotten a chance to look at the Zen Cart 1.5.2 affected_files (attached earlier in this thread) yet? The edits in those will be close to what is needed for Zen Cart 1.5.3.

Didn't even know there was one. This thread has got 72 pages

[dharrison]

Actually I have found the 1.5.2 affected files. Post number #555