Any suggestions or ideas would be great as I am trying to finish up this site and want to use the sitemap feature.
Here is a how-to about restoring this job:
It's fairly brief but there really isn't much to it. You just need to get access to your database somehow. Most hosting companies offer phpMyAdmin access through whatever website control panel software they use.
I tried the trick of moving the generate_sitemap.xml from concrete/jobs to jobs but throws an error squacking about line 116.
I attached the file below. I have tried to do as you suggested but it doesn't seem to work either.
Thanks for replying. It's driving me round the bend,LOL
I have run the query several times. It keeps squawking stating " You have to choose at least one column to display". Any ideas?
Here's what I did
-- logged in
-- went into the concrete5 database (should only have like a list of a few db's to choose from on the left)
-- Went into the "SQL" tab
-- Pasted both lines of code in there and did "go"
Check out this video, it's better than just describing it. She is doing a completely different sql call than what you are doing, so you probably want to mute it and forward it to around the 45 second mark to see what you are actually looking for.
thanks I will give it a try!!
Didn't use the video but your answer got me back on track. I had one little syntax sql error that I clean up and viola!!
I am the equivelent of a hunt-and-peck typer at this, I expect that I now havehttp://sineofthetime.com/sitemap.xml... to submit to Google Webmaster Tools as I am trying to follow Tony Trupp's article:
But the article linked above (http://www.concrete5.org/documentation/how-tos/developers/restore-the-generate-sitemap-job/) did say "if you accidentally remove your 'generate sitemap' job" which just left me unsure whether is was there, or how to find if it is there now?
I have C5 Version 5.5.1 installed.
Any additional tips are greatly appreciated. Thanks!
Did you get this sorted?
It seems so.
Google Webmaster Tools gracefully accepted my addition of the sitemap.xml extension, after I had indexed my sites with them (and after I added the sitemap code to my Database).
It seems that for my well-honed needle in a haystack (see sineofthetime.com) that my efforts now will be in learning the art of the Keyword (and being patient until the beginning of the next school year).
Tony's article really helped me get back on track, such as I know said track, thus far.
Sorry for the Brevity & Spelling!
Sent from my iPhone