Deleted the automated job, sitemap.xml
I have no idea how to bring that back and I've just launched a site. Does anyone know how to help?
I hope this does the trick.
In phpmyadmin, it might be simpler to click the "SQL" box at the top. This will give you a large box. If there is any text in there just clear it out. Then copy that query into the box
INSERT INTO `Jobs` (`jName`, `jDescription`, `jDateInstalled`, `jDateLastRun`, `pkgID`, `jLastStatusText`, `jLastStatusCode`, `jStatus`, `jHandle`, `jNotUninstallable`) VALUES ('Generate Sitemap File', 'Generate the sitemap.xml file that search engines use to crawl your site.', '', NULL, 0, NULL, 0, 'ENABLED', 'generate_sitemap' ,0 );
Then Click "Go" and you should see a confirmation message that it ran.
From there close phpmyadmin and check the Jobs section of your site to see if the job is back.
Don't worry, there isn't too much that can go wrong with the query above. If something gets input wrong it will probably just throw and error and not run at all. The only thing to check is to make sure you are in the correct database.
# 1142 - INSERT command denied to user xxxxx for table 'Jobs'
I went back and double-checked to make sure my user setup had the privileges to INSERT, which was set up with the original installation. Yes.
Double-checked to make sure username was correct. Yes.
Double-checked to make sure I was trying to insert into the right database. Yes.
A bit stymied. Any help from anyone who has run across this and solved it would be appreciated.
does this job also run with 126.96.36.199 ?
The concept in your sql it´s ok, in my case the table structure for Jobs it´s quite different. Was necesary add jID, in structure and values. It works with the correct table structure (Concrete 188.8.131.52)
I accidentally pushed the trash can button on the "create sitemap.xml" job.
INSERT INTO `Jobs` (`jID`, `jName`, `jDescription`, `jDateInstalled`, `jDateLastRun`, `pkgID`, `jLastStatusText`, `jLastStatusCode`, `jStatus`, `jHandle`, `jNotUninstallable`, `isScheduled`, `scheduledInterval`, `scheduledValue`) VALUES (4, 'Generate the sitemap.xml file', 'Generate the sitemap.xml file that search engines use to crawl your site.', '2015-09-21 15:27:25', NULL, 0, NULL, 0, 'ENABLED', 'generate_sitemap', 0, 0, 'days', 0);
Thanks everyone for the quick replies.
How did I ever manage to do such a ditzy thing in the first place? It's a comfort though, to know that I'm not alone.