Google XML Sitemap SEO db entries go missing

[wkdwich]

Running 2.0.25, I recently moved to a new server (end of July it went live).. was this happening on the old box?? I dont think so, but it's possible
I have the cron set for weekly..
Apparently Google XML Sitemap SEO wasn't working properly just after the move to the new server.. I found an email to EJ Aug 11th that I found the same 2 db entires missing, re-added and it was fine.
16 Aug 2011 Success
23 Aug 2011 Failed
30 Aug 2011 Failed
06 Sep 2011 Failed
(apparently I wasn't paying attention to the failed notices.. )
Evening of 9/7 I chatted with EJ while I poked around and found 2 of the 7 db entries gone missing, replaced, manually ran the sitemap, all was well

13 Sep 2011 Success
03:05 AM 9/20/2011 Failed

So tonight I immediately head to the db and sure enough, the same 2 statements are missing:

INSERT INTO configuration_group (configuration_group_id, 
configuration_group_title, configuration_group_description, sort_order, 
visible)
  VALUES ('289', 'Google XML SEO', 'Google XML Sitemap SEO 
Options', '29', '1');

INSERT INTO configuration (configuration_id, 
configuration_title, configuration_key, configuration_value, 
configuration_description, configuration_group_id, sort_order, set_function, 
date_added, use_function)
  VALUES (NULL,'Sitemap file', 
'GOOGLE_XML_SITEMAP_SEO', 'Standard', 'Which file to use for the sitemap 
creation. Use Standard unless it doesn\'t work correctly.<br>(Standard=on 
Alternate=off)', '289', '1', 'tep_cfg_select_option(array(\'Standard\', 
\'Alternate\'), ', now(), NULL);

Added them both and manually ran it, it was fine..
My version has some other modifications in there.. I also maintain 3 other sites with virtually the same setups and they do not lose these entries..

Ideas????

[wkdwich]

Well just for giggles I went and looked this AM.. the 2 entries are gone again.. I could really use some thoughts as to where to move along from here to fix this..
thanks

[pgmarshall]

So the entries are missing from the configuration table in the database? Ie. When you browse this table in phpMyAdmin?

Regards,

[wkdwich]

yes, thats correct, they were missing after the move, I put them in, some time later I noticed they went missing again, I put them in, 2 weeks later they went missing after one successsful run by cron, I put them back in, check this morning and they are gone again.. the click in the admin -> Configuration group is not there now.. thats my big clue now as to they entries are missing again. And yes I check he DB thru phpmyadmin doing a each of configuation_groups and configuration tables for "google" there should be 6 entries in configuration and 1 in configuration_group and when I check there is 5 and 0 there.

ideas??

[pgmarshall]

Sounds like something in the CRON job is removing them. What code are you running in the CRON job?

[wkdwich]

php /home/my_path/shoppe/googlesitemap/index.php

and I respectfully disagree because I added it back Tuesday during the day and the cron would not have run again until next Tuesday, and there has been some successful runs of the cron inbetween the gone missing times.

I checked the cron against one of the other 2 that does not lose the entries, and they are the same except for the time run and of course the path.
I'm going to add them back in now and keep an eye on it..

ok for reference.. added the 2 entries:

 
INSERT INTO configuration_group (configuration_group_id, 
configuration_group_title, configuration_group_description, sort_order, 
visible)
 VALUES ('289', 'Google XML SEO', 'Google XML Sitemap SEO Options', '29', 
'1');
 
INSERT INTO configuration (configuration_id, configuration_title, 
configuration_key, configuration_value, configuration_description, 
configuration_group_id, sort_order, set_function, date_added, use_function)
VALUES (NULL,'Sitemap file', 'GOOGLE_XML_SITEMAP_SEO', 'Standard', 'Which 
file to use for the sitemap creation. Use Standard unless it doesn\'t work 
correctly.<br>(Standard=on Alternate=off)', '289', '1', 
'tep_cfg_select_option(array(\'Standard\', \'Alternate\'), ', now(), NULL);

7 matches inside table configuration (6 for the sitemap, 1 for the map key)
1 match inside table configuration_group

[pgmarshall]

Hmmm. Seems like a very odd one this! I can not think of anything that should be removing things from the configuration table. (The only place this occurs is in the modules install/uninstall process).

Might be just as well to change your dbase password (just to be safe).

Regards,

[wkdwich]

heheh my-my aren't you parinoid but you are right, I will do that, tho I would think a lot more interesting things might be happening on the site and server-wide if that was the case

[wkdwich]

Follow up..
the sitemap ran successfully today and the entries are intact.. very odd...

[pgmarshall]

Did you change the dbase password? (paranoid you say!!!)