838 replies to this topic

[michael72]

Great package, used it for some time now. Just upgraded to RC2.2 and re-installed latest version of Dynmic Sitemap.
The sitemap is showing up in the store no problem, but get an error posted when opening Sitemap Maintenance:

1146 - Table 'xxxxx_oscx.TABLE_SITEMAP_EXCLUDE' doesn't exist
select exclude_file from TABLE_SITEMAP_EXCLUDE where exclude_type != "0" and is_box="0"
[TEP STOP]

I also notice in the admin screen, things only go as far as "Use the tools below etc" and the Files in Catalog portion is missing.

I have cycled through the install instructions a couple of times, and the phpMyadmin sitemap database table is present. Being a cut & paste guy I'm just wondering if I should back out the install And delete the database table then have another go at things?

Thanks again for a great contribution, any advice greatly appreciated

[petlv]

I installed the "newsdesk" contribution,how can I add the articles into the dynamic site map?
Great thanks

[bhbilbao]

Need help with this error in dynamic_sitemap.php

Quote

1052 - Column 'categories_status' in where clause is ambiguous

select * from categories c, categories_description cd where parent_id = '0' and c.categories_id = cd.categories_id and categories_status = 1 and cd.language_id = '3' order by sort_order, cd.categories_name

[TEP STOP]

The code:

$category_status_check = '';
$check_query = tep_db_query("select * from " . TABLE_CATEGORIES);
$check = tep_db_fetch_array($check_query);
if (isset($check['status_categ'])) { // skip if this is not set to avoid SQL error
  $category_status_check = ' and status_categ = 1';
} elseif (isset($check['categories_status'])) { // [b]skip if this is not set to avoid SQL error[/b]
  $category_status_check = ' and categories_status = 1';
}
 function getFileName($file, $define)        //retrieve the defined filename
 { 
   $fp = file($file);
   for ($idx = 0; $idx < count($fp); ++$idx)
   {
      if (!(strpos($fp[$idx], $define) === FALSE))
      {
          $parts = explode("'", $fp[$idx]);   
          return $parts[3];     
      }
   }    
   return NULL;
 }

[bhbilbao]

Other question:
ref:

Quote

Create a robots.txt file on your web site or add to your existing robots.txt file a line reading like the following:
Sitemap: http://sample.com/catalog/sitemaps.xml

What about http : // www . sample . com / catalog / sitemaps.xml ???

[bhbilbao]

Quote

error in dynamic_sitemap.php

For the moment I can work with other sitemap contribution SITEMAP SEO. Ref: sitemap.php

[FixItPete]

Just installed v4.1.

Is there a fix for the next to the last entry being blank? I just have a bullet, with no entry.
Also, how can I eliminate "Bestsellers" and "List of Manufacturers"?

Thanks,
Cindy

[JSR]

JSR, on 05 October 2009, 07:53, said:

Hi all,

I've installed dynamic sitemap and I'm getting an "openbase restriction is in effect" warning on the catalog side.
Seems the script is trying to access the tmp dir, which is in the root of my store. The warning states however, that it's not within the allowed path (/var/www/vhosts/domain/httpdocs:/tmp).
Has anybody seen this before?

I'm getting the "openbase restriction is in effect" warning too. Strange thing though, the path also reads /var/www/vhosts/domain/httpdocs:/tmp but the : is not supposed to be there, right??
Has anyone else experienced this before?

Edited by JSR, 20 August 2010, 10:28.

[JSR]

Ok ppl, so I contacted my host and the openbase restriction warning is finally solved now!

Change line 178:
if((!is_dir($file) && strtolower(substr($file, -4, 4)) === ".php") && !in_array($file ,$excluded_array))

TO:
if(($file != "..") && (!is_dir($file) && strtolower(substr($file, -4, 4)) === ".php") && !in_array($file ,$excluded_array))

This should stop the code from trying to access the tmp directory that's located outside of the root.

[The ANT man]

Hi All

i just installed this and am getting an error when i try to read the xml file called sitemaps.

Anyone have any idea whats causing this?

my sitemaps.xml

many thanks

[Ausgirl]

Im running V2.2 RC2a

Installed Dynamic Sitemap v4.21 that all seems to be working except the content on the website on the site map page is all
wonky. My site is centered but does not center on the site map page.

Also, when you click on a link made from IPU, the page comes up 404 error. I made the IPU changes in the sitemap.php

http://www.craftybin.com

[misantropo]

Can you help me? I get this error in catalog:

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(..) is not within the allowed path(s): (/var/www/vhosts/midomain.com/httpdocs:/tmp) in /var/www/vhosts/mydomain.com/httpdocs/dynamic_sitemap.php on line 179

thanks

[Zahoor]

First of all, thanks for a great contribution. I have installed this on a customers site and it all works fine. But now the customer wants also to show products that are listed under different categories as customers site doesn't have many products for the time being.

I wanted to know if someone could look into possibility of also displaying products, but that option was up to customer to decide whether to show products or keep them hidden.

Best of luck and can't wait to hear from some the experts here.

[midwesternwholesaler]

I am trying to install this on a fresh, clean install of oscommerece 2.3.1.


However when I get to this installation instruction it does not make sense.

The instruction #3 says to edit -- catalog/includes/boxes/information.php



HOWEVER THERE IS NO SUCH FILE " INFORMATION.PHP " IN OSCOMMERECE 2.3.1.


Additionally... install step 9 calles to edit --- admin/includes/boxes/tools.php

There is also no TOOLS.PHP file

Please advise. Thanks so much

[midwesternwholesaler]

It looks like this only works with version 2.2 . 3.2 does not use information.php

I can't find a sitemap contribution that works with a clean install of 2.3.1.

Wierd!@#$%


guess i will try Sitemap_SEO_V_1.7.zip

[tikidiboo]

Hi,

i have also tried installing this contribution to 2.3.1.

i am almost there.

When you view the site map i get this error.



Parse error: syntax error, unexpected $end in /home/blah/public_html/blah/dynamic_sitemap.php on line 340

I guess this is a missing ; or } i cant spot the culprit allthough there are many missing ones in for/if/else loops etc guessing php 5.3.8 dont like these missing ones.

Any ideas anyone

[maxemus]

Anyone know how to modify this to make an seo url friendly output? On the 2.3.1

[The Munch]

The version for osc 2.3.1 dated 22-Sep-2011:
http://addons.oscommerce.com/info/3306

It installed without any issues on my site...

Edited by The Munch, 09 October 2011, 13:41.

[IWAS]

maxemus, on 03 October 2011, 15:55, said:

Anyone know how to modify this to make an seo url friendly output? On the 2.3.1

I have had this installed for a long time on my sites along with the SEO urls and also use google sitemap. My files from the google sitemap go through the html rewrites & effectively have those displayed with SEO friendly urls.

Is there a way to have this contribution do the same? I tried searching this topic but it keeps sending me to the 1st page.

I am not running 2.3.1 I am running 2.2rc2a

[sexyglamour]

Hi all,
How to show all products in dynamic sitemap?