17
Apr
2009
Joomla 1.5 Remove Sample Content
milkyway_thumbnail.pngThe sample content in Joomla is handy to have while previewing templates in the early stages of development, but once the site is being spidered by search engines it's good to make sure no sample content is published or it could hurt SEO.

To make things less cluttered the sample content can be moved to the Joomla trash.

* Categories cannot be deleted until all Articles within are emptied from Trash (permanently deleted).

* Sections cannot be deleted until all Categories within are deleted.


When deleting content:

  • delete Articles first
  • then delete Categories
  • delete Sections last
Other sample content to delete:
  • Banner sample content ( Components > Banner > [Banners, Clients, Categories] )
  • News Feeds sample content ( Components > News Feeds )
  • Polls sample content ( Components > Polls )
  • Web Links sample content ( Components > Web Links )

 


SQL statements to remove all Joomla 1.5 sample content in one step

!
Be careful with this. Backup the entire database first.

! Don't use this method if you have added content you want to keep as this will delete that as well. Use the manual method above.


This would be used in phpMyAdmin (in cPanel) or similar database management utility.

DELETE FROM `jos_banner`;
DELETE FROM `jos_bannerclient`;
DELETE FROM `jos_bannertrack`;
DELETE FROM `jos_categories`;
DELETE FROM `jos_content`;
DELETE FROM `jos_content_frontpage`;
DELETE FROM `jos_newsfeeds`;
DELETE FROM `jos_polls`;
DELETE FROM `jos_poll_data`;
DELETE FROM `jos_poll_date`;
DELETE FROM `jos_sections`;
DELETE FROM `jos_weblinks`;

screen capture from phpMyAdmin
Screen capture of the SQL statement to delete all sample content in Joomla 1.5

 

Joomla Announcements

  • Joomla Community Magazine | October 2011
  • Joomla Community Magazine | September 2011
  • Joomla! Explained - Second Joomla Press Book Released
Joomla Web Hosting Canada RSS Feed