749 replies to this topic

[Wendy James]

I have exactly the same error now, but it says line 205. lol

How do you guys do it? I would never ever have spotted an extra $. Guess that is why I am just a housewife. lol

[Chemo]

Wendy...I offered a quick bit of code in the previous post. Can you grab it and save it somewhere near the top of googlesitemap/index.php? Let me know if that works for you...

Bobby

[theman]

that tepsession error goes away but then i get the
ERROR: Google Product Sitemap Generation FAILED! ERROR: Google Category Sitemap Generation FAILED! ERROR: Google Sitemap Index Generation FAILED!

[Wendy James]

adding

function tep_session_is_registered( $var ){
return false;
}

worked for me Chemo... atleast I think it did. I get this now


Generated Google Product Sitemap Successfully Generated Google Category Sitemap Successfully Generated Google Sitemap Index Successfully All files generated successfully. If you have not already submitted the sitemap index to Google click the link below. http://www.google.com/webmasters/sitemaps/...itemapindex.xml

oops, except that the link is not clickable and has extra vharacters in it... not sure why it pasted right

says
http%3A%2F%2F<snip on request>%2Fsitemapindex.xml

Edited by mattice, 06 June 2005, 20:26.

[Chemo]

theman, on Jun 5 2005, 02:48 AM, said:

that tepsession error goes away but then i get the
ERROR: Google Product Sitemap Generation FAILED! ERROR: Google Category Sitemap Generation FAILED! ERROR: Google Sitemap Index Generation FAILED!

<{POST_SNAPBACK}>

Great! That is progress!

Now, let's work on those paths for the files. Maybe I didn't make it clear enough in the install file.

The dummy files should be uploaded to the CATALOG directory wherever that may be...whether it is in the root or in a directory.

Are the dummy files in the store root?

wendyjames, on Jun 5 2005, 02:49 AM, said:

adding

function tep_session_is_registered( $var ){
  return false;
}

worked for me Chemo... atleast I think it did. I get this now
Generated Google Product Sitemap Successfully Generated Google Category Sitemap Successfully Generated Google Sitemap Index Successfully All files generated successfully. If you have not already submitted the sitemap index to Google click the link below.

<{POST_SNAPBACK}>

Congratulations! It is installed and ready to view! Take a look at the XML files and make sure the data is good...

Bobby

[theman]

Chemo, on Jun 4 2005, 11:52 PM, said:

Great!  That is progress!

Now, let's work on those paths for the files.  Maybe I didn't make it clear enough in the install file.

The dummy files should be uploaded to the CATALOG directory wherever that may be...whether it is in the root or in a directory.

Are the dummy files in the store root?

yup
dummy files were moved to the store root when u told me too

[Chemo]

wendyjames, on Jun 5 2005, 02:49 AM, said:

oops, except that the link is not clickable and has extra vharacters in it... not sure why it pasted right

says
http%3A%2F%2Fhomeandgardengiftsandcollectibles.com%2Fsitemapindex.xml

<{POST_SNAPBACK}>

The reason it's like that is because it's encoded...being part of the parameter requires this.

BTW, I checked your XML files and everything looks good. Go back to the install directions and pick it back up with the CRON setup...you are almost there!

Bobby

[Wendy James]

Thank you so much Bobby, this is an awesome contribution as always. Really appreciate it.

Going to have to wait on the cron thing. I have to use telnet? and I have no idea how. lol Hubbie does but he is watching Dennis Leary and won't budge. lol =) Will definately let you know how it goes though.

Again, great job and thanks!

[Chemo]

theman, on Jun 5 2005, 02:54 AM, said:

yup
dummy files were moved to the store root when u told me too

<{POST_SNAPBACK}>

OK...so now you have the following structure:

domain.com/catalog/googlesitemap/
domain.com/catalog/sitemapindex.xml
domain.com/catalog/sitemapproducts.xml
domain.com/catalog/sitemapcategories.xml

The 3 dummy files have been CHMOD'd to 777 and verified to be 777.

Can you confirm this? Go back through and actually confirm one time for me...

BTW, thank you for working through this. Once we get this worked out for you I'll incorporate the changes to the code and re-upload another version.

Bobby

[theman]

Chemo, on Jun 5 2005, 12:00 AM, said:

OK...so now you have the following structure:

domain.com/catalog/googlesitemap/
domain.com/catalog/sitemapindex.xml
domain.com/catalog/sitemapproducts.xml
domain.com/catalog/sitemapcategories.xml

The 3 dummy files have been CHMOD'd to 777 and verified to be 777.

Can you confirm this?  Go back through and actually confirm one time for me...

BTW, thank you for working through this.  Once we get this worked out for you I'll incorporate the changes to the code and re-upload another version.

Bobby

<{POST_SNAPBACK}>

yup

you can verify it as well if you want

http://www.soularclothing.com/catalog/googlesitemap/
http://www.soularclothing.com/catalog/sitemapindex.xml
http://www.soularclothing.com/catalog/sitemapproducts.xml
http://www.soularclothing.com/catalog/sitemapcategories.xml

and im happy to help

[Chemo]

The problem HAS to be in file permissions...get with me on instant messenger and we'll go through it real fast.

Bobby

[Wendy James]

Well, hubbie didn't know as much as I thought. I got to the telnet thing, tried setting it up but it keeps telling me

crontab: installing new crontab
"/tmp/crontab.xxxx2cEQpr":0: bad minute
errors in contab file, can't install
so you want to retry the same edit?

It is times like this I wish I had a host with a clicky click controp panel instead of a hands on geeks paradise you have to know what you are doing panel. lol

I am not sure if this error is on my part or not. I know nothing about telnet but i got further than the hubbie.

[theman]

Chemo, on Jun 5 2005, 12:09 AM, said:

The problem HAS to be in file permissions...get with me on instant messenger and we'll go through it real fast.

Bobby

<{POST_SNAPBACK}>

my and chemo sorted it out

was a path issue i had wrong

thankks chemo

[Wendy James]

hmmm my window thing said

file:whatever(same as above) and Modified

then said i had email but i dont lol so not sure if it worked or not

[Chemo]

wendyjames, on Jun 5 2005, 03:25 AM, said:

Well, hubbie didn't know as much as I thought. I got to the telnet thing, tried setting it up but it keeps telling me

crontab: installing new crontab
"/tmp/crontab.xxxx2cEQpr":0: bad minute
errors in contab file, can't install
so you want to retry the same edit?

It is times like this I wish I had a host with a clicky click controp panel instead of a hands on geeks paradise you have to know what you are doing panel. lol

I am not sure if this error is on my part or not. I know nothing about telnet but i got further than the hubbie. 

<{POST_SNAPBACK}>

Try this while in terminal:

crontab -e 0 0 * * * php /path/to/googlesitemap/index.php

Of course, change the path to the correct one!

Bobby

Edited by Chemo, 05 June 2005, 07:35.

[misa]

I am getting the following error:

1146 - Table 'bruinenf8.cache' doesn't exist

DELETE FROM cache WHERE cache_expires <= '2005-06-05 09:29:01'

[TEP STOP]

[Tomcat]

Bobby, one quick note.

In order to run the script I had to change this in sitemap.class.php:

function GoogleSitemap($host, $user, $db, $pass){
  $this->DB = new MySQL_Database($host, $user, $db, $pass);
  $this->filename = "sitemap";
  $this->savepath = DIR_FS_CATALOG . DIR_WS_HTTP_CATALOG;
  $this->base_url = HTTP_SERVER . DIR_WS_HTTP_CATALOG;
	} # end class constructor

to this:

function GoogleSitemap($host, $user, $db, $pass){
  $this->DB = new MySQL_Database($host, $user, $db, $pass);
  $this->filename = "sitemap";
  //$this->savepath = DIR_FS_CATALOG . DIR_WS_HTTP_CATALOG;
   $this->savepath = DIR_FS_CATALOG;
  $this->base_url = HTTP_SERVER . DIR_WS_HTTP_CATALOG;
	} # end class constructor

otherwise I had some catalog//catalog string in file path for ../googlesitemap/index.php

Cheers
Franco

[Chemo]

misa, on Jun 5 2005, 03:38 AM, said:

I am getting the following error:

1146 - Table 'bruinenf8.cache' doesn't exist

DELETE FROM cache WHERE cache_expires <= '2005-06-05 09:29:01'

[TEP STOP]

<{POST_SNAPBACK}>

In googlesitemap/index.php find this code:

if ( file_exists(DIR_WS_CLASSES . 'cache.class.php') ){
	include(DIR_WS_CLASSES . 'cache.class.php');
	$cache = new cache($languages_id);
}

if ( file_exists('includes/seo_cache.php') ){
	include('includes/seo_cache.php');
	$cache->get_cache('GLOBAL');
}

and change it to this:

/*
if ( file_exists(DIR_WS_CLASSES . 'cache.class.php') ){
	include(DIR_WS_CLASSES . 'cache.class.php');
	$cache = new cache($languages_id);
}

if ( file_exists('includes/seo_cache.php') ){
	include('includes/seo_cache.php');
	$cache->get_cache('GLOBAL');
}
*/

Tomcat, on Jun 5 2005, 03:38 AM, said:

Bobby, one quick note.

In order to run the script I had to change this in sitemap.class.php:

function GoogleSitemap($host, $user, $db, $pass){
  $this->DB = new MySQL_Database($host, $user, $db, $pass);
  $this->filename = "sitemap";
  $this->savepath = DIR_FS_CATALOG . DIR_WS_HTTP_CATALOG;
  $this->base_url = HTTP_SERVER . DIR_WS_HTTP_CATALOG;
	} # end class constructor

to this:

function GoogleSitemap($host, $user, $db, $pass){
  $this->DB = new MySQL_Database($host, $user, $db, $pass);
  $this->filename = "sitemap";
  //$this->savepath = DIR_FS_CATALOG . DIR_WS_HTTP_CATALOG;
   $this->savepath = DIR_FS_CATALOG;
  $this->base_url = HTTP_SERVER . DIR_WS_HTTP_CATALOG;
	} # end class constructor

otherwise I had some catalog//catalog string in file path for ../googlesitemap/index.php

Cheers
Franco

<{POST_SNAPBACK}>

That makes sense...I'll change it directly.

Bobby

[misa]

Quote

if ( file_exists(DIR_WS_CLASSES . 'cache.class.php') ){
include(DIR_WS_CLASSES . 'cache.class.php');
$cache = new cache($languages_id);
}

if ( file_exists('includes/seo_cache.php') ){
include('includes/seo_cache.php');
$cache->get_cache('GLOBAL');
}

and change it to this:
CODE
/*
if ( file_exists(DIR_WS_CLASSES . 'cache.class.php') ){
include(DIR_WS_CLASSES . 'cache.class.php');
$cache = new cache($languages_id);
}

if ( file_exists('includes/seo_cache.php') ){
include('includes/seo_cache.php');
$cache->get_cache('GLOBAL');
}
*/

Same error

[misa]

Quote

1146 - Table 'cache' doesn't exist

DELETE FROM cache WHERE cache_expires <= '2005-06-05 09:29:01'

[TEP STOP]

This the error message.