Clipmarks | nouse4name's 'oscmax' clips

Oscmax: Error: 1054 unknown column shipping tax in field list

Thu, 28 Jun 2007 09:47:36 GMT

clipped by: nouse4name

Clip Source: www.thewebandbeyond.de

Error: 1054 unknown column shipping tax in field list [tab stop]

there were two missing entries in the store SQL for "Edit Orders" as follows:

1) Table 'orders" missing Field "shipping_tax"

2) Table 'configuration' missing entry for "Edit Orders"

Run the following script into your store SQL:

ALTER TABLE orders ADD shipping_tax DECIMAL( 7, 4 ) DEFAULT '0.000' NOT NULL ;


INSERT into configuration (configuration_id, configuration_title,
configuration_key, configuration_value, configuration_description,
configuration_group_id, sort_order, last_modified, date_added,
use_function, set_function) values ('', 'Order Editor- Display Payment
Method dropdown?', 'DISPLAY_PAYMENT_METHOD_DROPDOWN', 'true', 'Display
Payment Method in Order Editor as dropdown menu (true) or as input
field (false)', '1', '21', NULL, '2006-04-02 11:51:01', NULL,
'tep_cfg_select_option(array(\'true\', \'false\'),');

Tags: oscmax, error, 1054, shipping, sql

oscmax / oscommerce: bug: order details missing products

Thu, 28 Jun 2007 09:44:38 GMT

clipped by: nouse4name

Clip Source: www.thewebandbeyond.de

order details missing products

If more than one item is ordered, only one is displayed in the orders admin but the order total ($) is correct

the admin and customer order email also has only 1 item listed but the order total ($)is correct

Two very small edits in checkout_process.php:

1) Around line 162: end bracket is commented -- remove backslashes on beginning of line. from " // } " to " } "

2) Delete end bracket around line 365. ( } )

Tags: oscmax, oscommerce, shop, bug, error, order details, missing, product

oscmax - bread crumb trail - remove top link

Thu, 08 Feb 2007 15:32:04 GMT

clipped by: nouse4name

Clip Source: www.oscmax.com

RE: bread crumb trail

Look in catalog/includes/application_top.php around line 618

find:
// include the breadcrumb class and start the breadcrumb trail
require(DIR_WS_CLASSES . 'breadcrumb.php');

$breadcrumb = new breadcrumb;

$breadcrumb->add(HEADER_TITLE_TOP, HTTP_SERVER);

$breadcrumb->add(HEADER_TITLE_CATALOG, tep_href_link(FILENAME_DEFAULT));

Take out the line (or comment out) -- $breadcrumb->add(HEADER_TITLE_TOP, HTTP_SERVER); -- to remove the "top" link.

To Change -- HEADER_TITLE_CATALOG -- to "Home"

open catalog/includes/languages/english.php

Find the line-- define('HEADER_TITLE_CATALOG', 'catalog'); --

Change 'catalog' to 'Home' or whatever you want.

Hope this helps

Tags: oscmax, bread crumb, remove, top link

OSCMac new_attributes.php does not save in OSC MAX RC3

Wed, 06 Dec 2006 13:02:53 GMT

clipped by: nouse4name

Clip Source: www.thewebandbeyond.de

new_attributes.php does not save in OSC MAX RC3

need it to make change only in admin/new_attributes_include.php
replace lines 4, 5, 6 with
<FORM ACTION="<?=$PHP_SELF?>" METHOD="POST" NAME="SUBMIT_ATTRIBUTES">
<INPUT TYPE="HIDDEN" NAME="current_product_id" VALUE="<?=$current_product_id?>">

To make images work and cancel button click replace line
Line 168 with:
<TD colspan="10" class="main">
<INPUT TYPE="image" xsrc="<?=$adminImages?>button_save.gif"> <?=$backLink?><img xsrc="<?=$adminImages?>button_cancel.gif" border="0"></A></TD>

http://bugtrack.oscmax.com/view.php?id=183

Tags: oscommerce, oscmax, bug, attributes