Jump to content

steve86

Members
  • Content count

    4
  • Joined

  • Last visited

Profile Information

  • Real Name
    Steve
  • Gender
    Male
  1. steve86

    Google XML Sitemap SEO

    I believe the problem of only 1 entry is caused by the following code at around lines: 424, 468, 512, 599 in googlesitemap/sitemap.class.php if ( sizeof($container) > 1 ) Should be changed to: if ( sizeof($container) > 0 ) Thanks Steve
  2. steve86

    Google XML Sitemap SEO

    Jack I have the exact same problem but with the Specials. If one special is present the XML generation fails however with two Specials or more it works fine. Apart from that it's an excellent contribution. Thanks
  3. steve86

    Sitemap SEO

    I did read and I tried a few times to run the uninstall and install scripts and it seems to be working fine right now. I think what caused this malfunction was the fact that I had multiple tabs opened of the Sitemap SEO and I did multiple updates simultaneously which I think might have messed the table values since the check marks were showing randomly, there were no exclusions, and I had double entries. I have another question tough can the Google XML Sitemap SEO (http://addons.oscommerce.com/info/6583) be used together with this contribution? Thanks for your patience & time :D
  4. steve86

    Sitemap SEO

    Jack I have a question for you or whoever can explain this to me. I believe there is a table missing ('sitemap_seo_exclude') In includes/database_tables.php you have: ADD: /***** Begin Sitemap_SEO *****/ define('TABLE_SITEMAP_SEO_BOX_LINKS', 'sitemap_seo_box_links'); define('TABLE_SITEMAP_SEO_BOXES', 'sitemap_seo_boxes'); define('TABLE_SITEMAP_SEO_EXCLUDE', 'sitemap_seo_exclude'); define('TABLE_SITEMAP_SEO_PAGES', 'sitemap_seo_pages'); define('TABLE_SITEMAP_SEO_SETTINGS', 'sitemap_seo_settings'); /***** End Sitemap_SEO *****/ BUT THEN HOWEVER IN sitemap_seo.sql you have: DROP TABLE IF EXISTS sitemap_seo_pages; CREATE TABLE sitemap_seo_pages ( exclude_id INT NOT NULL AUTO_INCREMENT , page_file_name VARCHAR (255) NOT NULL , alternate_page_name VARCHAR (255) NOT NULL DEFAULT '', anchor_text VARCHAR (255) NOT NULL DEFAULT '', excluded_page TINYINT (1) NOT NULL DEFAULT 0, registered_only TINYINT (1) NOT NULL DEFAULT 0, sort_order TINYINT (3) NOT NULL DEFAULT 0, language_id int DEFAULT '1' NOT NULL, PRIMARY KEY ( exclude_id ) ); DROP TABLE IF EXISTS sitemap_seo_boxes; CREATE TABLE sitemap_seo_boxes ( box_file_name VARCHAR (50) NOT NULL DEFAULT '', box_page_name VARCHAR (255) NOT NULL DEFAULT '', pseudo_page_name VARCHAR (255) NOT NULL DEFAULT '', excluded_box TINYINT (1) NOT NULL DEFAULT 0, registered_box TINYINT (1) NOT NULL DEFAULT 0, language_id int DEFAULT '1' NOT NULL, PRIMARY KEY ( box_file_name, language_id ) ); DROP TABLE IF EXISTS sitemap_seo_box_links; CREATE TABLE sitemap_seo_box_links ( box_link_id INT NOT NULL AUTO_INCREMENT, box_file_name VARCHAR (50) NOT NULL DEFAULT '', page_link_name VARCHAR (255) NOT NULL DEFAULT '', pseudo_page_link_name VARCHAR (255) NOT NULL DEFAULT '', anchor_text VARCHAR (255) NOT NULL DEFAULT '', excluded_link TINYINT (1) NOT NULL DEFAULT 0, registered_link TINYINT(1) NOT NULL DEFAULT 0, sort_order TINYINT (3) NOT NULL DEFAULT 0, language_id int DEFAULT '1' NOT NULL, PRIMARY KEY ( box_link_id ) ); DROP TABLE IF EXISTS sitemap_seo_settings; CREATE TABLE sitemap_seo_settings ( enable_articles_manager TINYINT (1) NOT NULL DEFAULT 0, enable_infopages TINYINT (1) NOT NULL DEFAULT 0, enable_page_manager TINYINT (1) NOT NULL DEFAULT 0, heading_title VARCHAR (40) NOT NULL DEFAULT 'Site Map', heading_sub_text TEXT NOT NULL, heading_articles_manager VARCHAR (50) NOT NULL DEFAULT '', heading_categories VARCHAR (50) NOT NULL DEFAULT '', heading_infopages VARCHAR (50) NOT NULL DEFAULT '', heading_manufacturers VARCHAR (50) NOT NULL DEFAULT '', heading_page_manager VARCHAR (50) NOT NULL DEFAULT '', heading_standard_boxes VARCHAR (50) NOT NULL DEFAULT '', heading_standard_pages VARCHAR (50) NOT NULL DEFAULT '', language_id int DEFAULT '1' NOT NULL, PRIMARY KEY ( language_id ) ); .... // INSERT QUERIES So my question is where do you create 'sitemap_seo_exclude' as referred in includes/database_tables.php??? I am not able to exclude any pages therefore I am wondering if this may be the cause please let me know what does table 'sitemap_seo_exclude' suppose to contain. Thanks
×