1232 replies to this topic

[oner]

Thx Jack_mcs,
could you give me an advice and tell how to loaded reviews_id to this part of code ?

[Jack_mcs]

No, I'm sorry but I don't know it off the top of my head and I don't provide specialized support in the forums due to the number of requests and time it would take.

[oner]

I understand Jack, i just asked. Well i will try do this by myself....

[surrfman]

@Jack_mcs  

Attempting to download from add-ons page, which dated download should I go for. Shows 19 to chose from, some are fixes and changes. have Ultimate Seo 5 installed on 2.3.1 shop.

thanks man,

   Timmy C

[Jack_mcs]

I only see six uploads. You must be looking at the wrong addon.

[yahalimu]

Hi again Jack.

This doesnt seem to work on my site with SEO URL 5 switched on.
Is this correct?
Is there a work around?

iain

[yahalimu]

OK, even with SEU URL switched off I cannot get a product sitemap although categories and index are ok.

Opening   /var/www/vhosts/mysite.co.uk/httpdocs/sitemapproducts.xml
FS_CAT    /var/www/vhosts/mysite.co.uk/httpdocs/
Server    http://109.xxx.xx.x
Save Path /var/www/vhosts/mysite.co.uk/httpdocs/
WS_CAT    /
ERROR: Google Product Sitemap Generation FAILED!

Opening   /var/www/vhosts/mysite.co.uk/httpdocs/sitemapcategories.xml
FS_CAT    /var/www/vhosts/mysite.co.uk/httpdocs/
Server    http://109.xxx.xx.x
Save Path /var/www/vhosts/mysite.co.uk/httpdocs/
WS_CAT    /
Write /var/www/vhosts/mysite.co.uk/httpdocs/sitemapcategories.xml
Generated Google Category Sitemap Successfully

Opening   /var/www/vhosts/mysite.co.uk/httpdocs/sitemapindex.xml
FS_CAT    /var/www/vhosts/mysite.co.uk/httpdocs/
Server    http://109.xxx.xx.x
Save Path /var/www/vhosts/mysite.co.uk/httpdocs/
WS_CAT    /
Write /var/www/vhosts/mysite.co.uk/httpdocs/sitemapindex.xml
Generated Google Sitemap Index Successfully

Array
(
    [QUERY] => Array
        (
            [PRODUCTS] => Array
                (
                    [STATUS] => success
                    [NUM_ROWS] => 125
                )

            [CATEOGRY] => Array
                (
                    [STATUS] => success
                    [NUM_ROWS] => 42
                )

        )

    [SAVE_FILE_XML] => Array
        (
            [0] => Array
                (
                    [file] => /var/www/vhosts/mysite.co.uk/httpdocs/sitemapproducts.xml
                    [status] => failure
                    [file_exists] => true
                )

            [1] => Array
                (
                    [file] => /var/www/vhosts/mysite.co.uk/httpdocs/sitemapcategories.xml
                    [status] => success
                    [file_exists] => true
                )

            [2] => Array
                (
                    [file] => /var/www/vhosts/mysite.co.uk/httpdocs/sitemapindex.xml
                    [status] => success
                    [file_exists] => true
                )

        )

)


After some investigation it seems it should be producing a product sitemap even with that add on installed, especially if its switched off.
I have seen a patch to get it working with SEU URL 5 but first I need the basic version working

[yahalimu]

Apologies for the bandwdth.. All sorted.

[iTea]

Dear Jack,

Installed your add-on, seems to be working. However, the category links are all doubled, so two identical links to the same category in the default language directly below each other. The product links are all single by the way. Do you have an idea what can cause this?

[Jack_mcs]

No, I'm sorry but I've no idea what could cause that. No one has ever mentioned such a problem either, that I can recall. The only thing I can think to suggest is that if you have a url rewriter addon installed, try turning it off and re-creating the sitemaps to see if the problem goes away.

[iTea]

We've got your url-rewriter up and running. Turned it off, reset the caches, but it didn't seem to make a difference. We've got two languages, our default language had an ID of 2, instead of 1, could that be of significance?

[iTea]

When I run the select


function GenerateCategorySitemap(){
        $quotes = (defined('QUOTES_CATEGORY_NAME') ? " where cd.categories_name NOT LIKE '" . QUOTES_CATEGORY_NAME . "' " : '');
$sql = "SELECT c.categories_id as cID, c.date_added, c.last_modified as last_mod
   FROM " . TABLE_CATEGORIES . " c left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on c.categories_id = cd.categories_id  
          " . $quotes . "
ORDER BY c.parent_id ASC, c.sort_order ASC, c.categories_id ASC";

in phpmyadmin I do get the same repetition, two (languages) for each category.

The manufacturers select is language independent:


function GenerateManufacturerSitemap(){
        $sql = "SELECT manufacturers_id as mID, date_added, last_modified as last_mod, manufacturers_name
                FROM " . TABLE_MANUFACTURERS . " order by manufacturers_name DESC";

[Jack_mcs]

It sounds like the problem is due to the two languages but the code should only be loading one. I don't know why it is loading two in your case. If the two urls are identical, then that's a problem. But if they are indicating the language, it may not be. I haven't seen this happen before so I can't say for sure.