Forums

Restore Maintainance Job Sitemap creation

Permalink
Hi, so I accidentally deleted the sitemap creation job from the jobs page in dashboard... have been squandering around for a way to get it to show as a installable option but I'm not getting so far.

Anyone know what to do?

Also, where does it place the actual sitemap xml? When I had the job there and ran them it said everything was okay and dandy but no sitemap files showed as far as I can tell.

Regards
Philip
philiph
 
Remo replied on at Permalink Reply
Remo
I think you have to enter these rows manually. Table "jobs"

sitemap must be in the root!
philiph replied on at Permalink Reply
philiph
You are seriously overestimating my skill in this area.. :)
I'm a designer, who thinks its fun to fiddle around in concrete settings and accidentally from time to time delete some stuff. (a side note is that it's waaay to easy to do this without much effort, a wrong placed click and it's gone)

So what should I add to the table jobs? I'm presuming it's the database you are talking about?


Regards
Philip
Remo replied on at Permalink Reply
Remo
Didn't know you're not a developer ;-)

But you know how to connect to your mysql database? You also know how to execute an sql stmt?

If so, try to execute this:
INSERT INTO `jobs` (`jID`, `jName`, `jDescription`, `jDateInstalled`, `jDateLastRun`, `pkgID`, `jLastStatusText`, `jLastStatusCode`, `jStatus`, `jHandle`, `jNotUninstallable`) VALUES
   ('1','Index Search Engine','Index the site to allow searching to work quickly and accurately.','2008-11-19 10:37:38','2008-11-20 02:41:32','0','25 page(s) indexed.',0,'ENABLED','index_search',1),
   ('2','Generate Sitemap File','Generate the sitemap.xml file that search engines use to crawl your site.','2008-11-19 10:37:38','2008-11-20 02:41:20','0','Sitemap XML File Saved.',0,'ENABLED','generate_sitemap',0);


It contains data of a page you don't need but I think that shouldn't matter. Please note that this is just a guess, I have never tried that..