|
StaticStore » StaticStore Manual » Maintenance
8. Maintenance
8.1 How to approve
or reject new product reviews/comments
8.2 How to manage broken products
8.3 Generating HTML files
8.4 Generating Your Front Page
(Index Page)
8.5 Recounting Links
8.6 Removing dead HTML files.
(Clean-up)
8.7 Database Maintenance
8.1 How to approve or reject new product reviews/comments
Each product has the ability to store comments/reviews about it. The reviews/comments
can be added by end-users.
New reviews/comments are placed in a queue when a new review or comment about a
product has been added. The administrator has to approve the reviews/comments before
they will be available for display with their respective links.
To approve or reject a new review, go to the Control Panel. Then click the ‘To Do’
tab. Now click on the ‘Approve/Edit Comments’ link.
5.17 Customizing The Review Templates Plug Ins
7.1.2 Reviews
8.2 How to manage broken product pages
StaticStore comes with the ability, where end users are able to report broken
product pages. To manage the products that has been reported as broken, go to the
Control Panel. Then click on the ‘To Do’ tab. Now click on the ‘View and Manage
Reported Problems With Product Pages’.
Also See:
9.5 The Broken Product Page and URL Checker
8.3 Generating HTML files
You will have to generate HTML files regularly to keep your store updated. When
changes are made to your store, new HTML files need to be generated to update the
changes that has been made to your store.
To generate HTML files, see:
6.1 How to run a static store
8.4 Generating Your Front Page (Index Page)
If you make any changes to the main categories and the sub categories of the
main categories, you will need to update your front page.
Also see:
5.11 How to customize and create your front page
8.5 Recounting Products
To get here: From the admin functions, choose 'generate html files' then 'recount
products' on the window that pops up.
Tip: Only recount products if you are indicating subcategory product numbers (those
in brackets below) on your templates.
There is no need to have it re-counted if you are not indicating the number of products
in categories.
It is recommended that you recount products from telnet/ssh if you have more than
15,000 products. To recount products via telnet/ssh execute recountlnks.cgi in a
telnet session.
8.8 Removing dead HTML files. (Clean-up)
To get there: From the admin functions, choose 'generate html files' then 'clean-up'
on the window that pops up.
Enables you to remove dead product pages (not broken products) and categories
that is not in use anymore.
When you rename categories, the category names change. In such an instance
new categories are created with new files when you generate HTML files. The old
categories that are not used anymore will still be intact.
This clean-up utility looks at what categories you have an removes dead categories
that is not in use, residing in your 'html' directory. (The 'html' directory is
the directory where files and categories are placed when HTML files are generated.)
The clean-up utility also helps you conserve disk space. Run the clean-up utility
every once in a while.
Caution (IMPORTANT!): Do not use the clean-up utility if you are storing
web pages and images, etc. that is not files generated by StaticStore. This means
that you should not put anything in the 'html' directory other than what StaticStore
places in it. The 'html' directory is the directory where StaticStore places generated
HTML files in.
Caution (IMPORTANT!): Never set the StaticStore 'html' directory to be
the root directory of your Public HTML directory. The 'html' directory has to be
in a sub directory of your Public HTML directory. Setting StaticStore to use the
root of your Public HTML directory as it's directory to store generated HTML files
in, can result in data loss when using the clean-up utility. Directories that is
not part of StaticStore can be deleted with it's contents.
8.9 Database Maintenance
From time to time database errors can occur. You can find out more about why
these errors occur
here. Use StaticStore's repair facilities as explained below, to keep your database
in good shape. There are also many alternatives which you can use - Many host providers
will provide you with tools like MyPHP Admin that also has table repair utilities
which you can use to repair your tables. You can also
directly repair
your tables with MySQL.
8.9.1 Database Repairs for Small/Medium sized search engines
If you have less than 15 000 products you can check your tables and have them
repaired by going to the StaticStore control panel. Once in the control panel
click on the 'To Do' tab. Now click on the link that reads 'Generate HTML Files'.
A popup window will appear. Click the link that reads 'Database Repair Kit'.
After you clicked the 'Database Repair Kit' link, checking and repairs (if
needed) will be done on the database tables that is used by StaticStore.
8.9.2 Database Repairs for Large sized search engines
It is highly recommended that you do database repairs from SSH or Telnet if
you have more than 15 000 products present in your database. To check and repair
(if repairs are needed) your database tables from Telnet or SSH, do the following:
Log into your server via Telnet or SSH.
Change to the directory where the StaticStore admin cgi script files reside.
Execute dbrepair.cgi from an SSH or Telnet session as follows:
perl dbrepair.cgi repair
It may take hours for very large Search Engines with tens of thousands or hundreds
of thousands of products. For very large search engines (hundreds of thousands
of products) we recommend that you use MySQL's
myisamchk.
|
