If you have Apache ModSecurity installed and try to edit your blog, you may
get this error:
“Method Not Implemented  POST to /wp-admin/post.php not
supported.”

Your apache error log, e.g., /var/log/httpd/white_board_ssl_error_log,
may have a line like this:
ModSecurity: Access denied with code 404 (phase 4).

To fix it, open your http virtual host file add this line:

e.g.,

http://en.wikipedia.org/wiki/Comparison_of_shopping_cart_software

1, Make a backup.

cp /var/lib/tomcat5/webapps/ROOT/WEB-INF/web.xml /var/lib/tomcat5/webapps/ROOT/WEB-INF/web.xml_orig

2, Update:

Yum update

3, Make sure Tomcat will start after reboot

chkconfig tomcat5 on

4, Copy web.xml

cp /var/lib/tomcat5/webapps/ROOT/WEB-INF/web.xml_orig /var/lib/tomcat5/webapps/ROOT/WEB-INF/web.xml

5, Restart Tomcat

/etc/rc.d/init.d/tomcat5 restart

To add new column to all product list, for example, 2 new columns: size, application

1, Add new columns to products table.

2, Add columns to select statement: includes/modules/pages/products_all/header_php.php

$products_all_query_raw = "SELECT p.products_type, p.products_id, pd.products_name,
p.products_image, p.products_price, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model,
p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status,
p.master_categories_id, p.application, p.size
FROM " . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_MANUFACTURERS . " m ON(p.manufacturers_id = m.manufacturers_id),
" . TABLE_PRODUCTS_DESCRIPTION . " pd
WHERE p.products_status = 1
AND p.products_id = pd.products_id
AND pd.language_id = :languageID " . $order_by;

3, Find out what configuration_group is PRODUCT_ALL_LIST:

select * from configuration where configuration_key like 'PRODUCT_ALL_LIST%';

4, Add new configuration values:

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description,
configuration_group_id, sort_order, date_added ) values (
'Display Product Size', 'PRODUCT_ALL_LIST_SIZE', '4101', 'Do you want to display the Product Size?', 23, 5, now());
insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description,
configuration_group_id, sort_order, date_added ) values (
'Display Product Application', 'PRODUCT_ALL_LIST_APPLICATION', '3101', 'Do you want to display the Product Application?', 23, 5, now());

5, Edit configuration values:

Admin–>Configuration–>All listing:

6, Add the following lines to includes/languages/english

define('TEXT_PRODUCTS_SIZE','Size: ');
define('TEXT_PRODUCTS_APPLICATION','Application: ');
define('HEADING_TITLE','All Products');

Technorati : Zen Cart
Del.icio.us : Zen Cart

To add new product list columns to Zen Cart, for example, 2 new columns: size, application

1, Add new columns to products table.

2, Add the following lines to include/languages/english/index.php

define('TABLE_HEADING_SIZE', 'Size');
define('TABLE_HEADING_APPLICATION', 'Application');

3, Add the following lines to include/modules/pages/index/main_template_vars.php in the create column list section:

'TABLE_HEADING_APPLICATION' => TABLE_HEADING_APPLICATION,
'PRODUCT_LIST_SIZE' => PRODUCT_LIST_SIZE,

in the switch section:

case 'PRODUCT_LIST_SIZE':
$select_column_list .= 'p.size, ';
break;
case 'PRODUCT_LIST_APPLICATION':
$select_column_list .= 'p.application, ';
break;

4, Add the following lines to includes/modules/excellgen/product_listing.php

switch ($column_list[$col]) {
…

case 'PRODUCT_LIST_SIZE':
$lc_text = TABLE_HEADING_SIZE;
$lc_align = 'left';
$zc_col_count_description++;
break;
case 'PRODUCT_LIST_APPLICATION':
$lc_text = TABLE_HEADING_APPLICATION;
$lc_align = 'left';
$zc_col_count_description++;
break;

...

for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
$lc_align = '';
switch ($column_list[$col]) {

…

case 'PRODUCT_LIST_SIZE':
$lc_align = 'left';
$lc_text = '  '.$listing->fields['size'];
break;
case 'PRODUCT_LIST_APPLICATION':
$lc_align = 'left';
$lc_text = '  '.$listing->fields['application'];
break;

….

5, Remove sorting of these two columns, by editing includes/modules/excellgen/product_listing.php:

if ( ($column_list[$col] != 'PRODUCT_LIST_IMAGE')
&& $column_list[$col] != 'PRODUCT_LIST_SIZE'
&& $column_list[$col] != 'PRODUCT_LIST_APPLICATION')
{
$lc_text = zen_create_sort_heading($_GET['sort'], $col+1, $lc_text);
}

6, Change alignment:

includes/modules/excellgen/product_listing.php:

$lc_align = 'left';

includes/templates/excellgen/css

.productListing-data
{
font-size:12px;
text-align:left;
}


7, Run SQL to add values to configuration table:

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description,
configuration_group_id, sort_order, date_added ) values (
'Display Product Size', 'PRODUCT_LIST_SIZE', '4', 'Do you want to display the Product Size?', 8, 5, now());
insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description,
configuration_group_id, sort_order, date_added ) values (
'Display Product Application', 'PRODUCT_LIST_APPLICATION', '3', 'Do you want to display the Product Application?', 8, 5, now());

8, Check if you can edit these columns:

Admin-->Configuration-->Product Listing

Technorati : Zen Cart, ecommerce
Del.icio.us : Zen Cart, ecommerce