amigaman

Anyone with any ideas?

I have a problem with some 301 rewrites. I have three different products and I want to 301 rewrite two of them to redirect to the third. I am using code that looks a little like this in .htaccess Rewrite 301 /product-name-blah-p-78.html http://www.mysite.com/product-name-blah-p-31.html Whilst the URL appears to be different after implementing this the user if not actually redirected. So clicking on the link to product 40 produces product 40's page and the url: http://www.mysite.com/product-name-blah-p-31.html?products_id=78 I assume it is possible to use a redirect 301 like this when using this mod so can someone tell me the correct syntax to use?

Is it possible to replace the text that reads 'Click here to enlarge' with the name of the product? A case of replacing the aforementioned text with the $product_name tag?

For people continuing to experience the following error message in their admin: Cannot redeclare class ot_discount_coupon in .../includes/modules/order_total/ot_discount_coupon.php The problem in my case came from the automatic installation of the SQL tables failing because they had already been created. I edited out the code under the install function and the installation worked with no errors.

Even if I just select the order number it produces the same result. Obviously some problem connecting to the database. Any idea from anyone or is this contribution dead?

I'm still getting problems with the contribution finding any orders to export within the date ranges I provide. I have altered the batch_print file as instructed in previous posts to no avail. I am running SQL 5.0.27. I would be grateful if anyone could suggest a solution to this problem. Thanks EDIT: It's also occurred to me that I am using the English version of the date format and not the US version. For example my dates are structured as 11/11/2007 and not 2007/11/11. Will this produce this problem?

Eh?

I have a decent knowledge of STS. However I don't really see STS as a luxury but an essential part of making a OsComerce site your own. Thanks though.

To clarify , I am using STS 4.x and I want to image to appear wher the $imagelarge usually does.

Great contribution. However I was wondering whether it is possible to have the additional images replace the main image in the main product window rather than popping up in a separate window? Is it? Thanks

I have fixed it by disabling the minus sign from the the sub-total. This is done the Discount Coupon admin under the Modules/Order Total tab. Anyone know of a fix that will still allow the minus to be displayed?

I have fixed it by disabling the minus sign from the the sub-total. This is done the Discount Coupon admin under the Modules/Order Total tab. Anyone knwo of a fix that will still allow the minus to be displayed?

Can anyone help me out with getting this module working with the Discount Coupon module. When attempting to apply a coupon I receive the following... It looks like a simple syntax problem producing the price as --17.99 instead of 17.99. Can somebody suggest a fix? I have also posted this here.

Here is the rror message I am getting when applying this 'fix' for Google Checkout: Error: Error parsing XML; message from parser is: Invalid value for body of unit-price in checkout-shopping-cart/shopping-cart/items/item: This is not a number Warnings: XML failed to validate against the schema at line: 15, column: 15, with error: cvc-datatype-valid.1.2.1: '--17.99' is not a valid value for 'decimal'. XML failed to validate against the schema at line: 15, column: 15, with error: cvc-complex-type.2.2: Element 'unit-price' must have no element [children], and the value must be valid. And here is the part of the 'XML received' by Google that appears to contain the problem: <item> <item-name>Discount Coupon 3FOR2 applied</item-name> <item-description>Discount Coupon 3FOR2 applied</item-description> <unit-price currency="GBP">--17.99</unit-price> <quantity>1</quantity> </item>

I've managed to install the SQL manual by changing the second table to this: CREATE TABLE IF NOT EXISTS discount_coupons_to_orders ( id INT(11) NOT NULL AUTO_INCREMENT, coupons_id VARCHAR(32) NOT NULL DEFAULT '', orders_id INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (id) ); But I have another problem. When I try and create a code in the admin I get the following error: 1136 - Column count doesn't match value count at row 1 insert into discount_coupons values ( 'GJHVWQ', '3 For 2 Offer', '17', 'fixed', null, null, 10, 34.99, 'price', 10) This problem has been addressed by crash3903 on the 28th of June but there solution amends a admin/coupons.php file that looks nothing like the one with the current download. As I am manual altering the db I don't think the solution is relevant anyway. Any one have any ideas on who to solve this?

When I try and run the database modifications manually via Sql I receive the following error: #1171 - All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead I have noticed that this problem had been touched upon before but I cannot find a revised soultion for manual entering the necessary changes into SQL. Can someone produce and updated version that can let me do it? Many thanks

Hi Ski, Your instructions seemed quite complicated and indepth for something that may not have worked, so instead of doing what you suggested I have simply edited the Zone shipping file that was producing the offending text. I removed the pound sign form being displayed and Google checkout now works fine. It seems that the Pound sign appearing on that particular page was causing the problem. Odd! Many thanks for all the help I've received on this.

I am using Zone Rates for shipping. During checkout the following is stated: Zone Rates, First Item, Plus Additional Items Zone Rates, First Item, Plus Additional Items (£1.99 first item, £0.99 each additional item) If I turn the Zonal Shipping Module off so that this text isn't displayed the checkout process works and the buyer is presented with the first page of the Google checkout. Any ideas how I can keep the Zone Shipping without having the '£' sign displayed? Cheers.

Thanks Ski. However it has had no effect. The same thng happens and the same error is reported. The error log still reads: <?xml version="1.0" encoding="UTF-8"?> <checkout-shopping-cart xmlns="http://checkout.google.com/schema/2"> <shopping-cart> So I'm not sure if the change has had any effect?

I am in the UK. My prices are in '£' or 'Pounds' I'm not sure what you mean by 'GC IPN'. I've made no changes to any of the files in the contribution.

That's great. There is no information in the google_log.txt file. It is '777' enabled. There are two different errors in the XML log. I tried to checkout a couple of times when testing it. The first error is: Error parsing XML; message from parser is: The entity "pound" was referenced, but not declared. XML We Received: <?xml version="1.0" encoding="UTF-8"?> <checkout-shopping-cart xmlns="http://checkout.google.com/schema/2"> <shopping-cart> <items> <item> <item-name>The Who T-shirt Magic Bus</item-name> <item-description>The Who T-shirt Magic Bus</item-description> <unit-price currency="GBP">17.99</unit-price> <quantity>1</quantity> <tax-table-selector>tax-33{1}23{2}15</tax-table-selector> </item> </items> <merchant-private-data> <osc-orders-id>100</osc-orders-id> </merchant-private-data> </shopping-cart> <checkout-flow-support> <merchant-checkout-flow-support> <continue-shopping-url>http://www.MYSITE.com/checkout_success.php?order_id=100</continue-shopping-url> <tax-tables> <default-tax-table> <tax-rules> <default-tax-rule> <shipping-taxed>false</shipping-taxed> <rate>0.0000</rate> <tax-area> <us-country-area country-area="FULL_50_STATES"/> </tax-area> </default-tax-rule> </tax-rules> </default-tax-table> <alternate-tax-tables> <alternate-tax-table name="tax-33{1}23{2}15" standalone="false"> <alternate-tax-rules> <alternate-tax-rule> <rate>0.0000</rate> <tax-area> <us-country-area country-area="FULL_50_STATES"/> </tax-area> </alternate-tax-rule> </alternate-tax-rules> </alternate-tax-table> </alternate-tax-tables> </tax-tables> <shipping-methods> <flat-rate-shipping name="Zone Rates, First Item, Plus Additional Items ((£1.99 first item, £0.99 each additional item))"> <price currency="GBP">2.98</price> </flat-rate-shipping> </shipping-methods> </merchant-checkout-flow-support> </checkout-flow-support> </checkout-shopping-cart> [/code[ [b]XML We Sent:[/b] [code] <?xml version="1.0" encoding="UTF-8"?> <error xmlns="http://checkout.google.com/schema/2" serial-number="A SERIAL NUMBeR IS WRITTEN HERE"> <error-message>Error parsing XML; message from parser is: The entity "pound" was referenced, but not declared.</error-message> </error> The second error is: The Http Get method is invalid for sending requests. There is no XML received but the 'XML we sent' reads: <?xml version="1.0" encoding="UTF-8"?> <error xmlns="http://checkout.google.com/schema/2" serial-number="SERIAL NUMBER"> <error-message>The Http Get method is invalid to use for sending requests.</error-message> </error>

Thanks but I'm afraid I'm going to have to bother you again! :( A customer can now checkout as normal and select Google checkout as an option (which is great!) but when they leave the site to go to Google an error occurs. At first a processing screen appears with my logo and an instruction to wait. The page then refreshes with the following message: I haven't received an email from Google stating what the problem is. Searching the net it seems that this error may occur by incorrect cart information being sent to Google. Could this have something to do with the way STS processes the information? Sorry to be a pain...

Many thanks, that was the one!

I believe I am using STS v4.1. Module is located here. Thanks again.

Thanks but that code is not present in the file you name. The sts_default contains: <?php /* $Id: sts_default.php,v 1.0.4 2005/12/12 09:36:00 rigadin Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2005 osCommerce Released under the GNU General Public License * * STS v4 module for pages without own module by Rigadin ([email protected]) */ class sts_default { var $template_file; function sts_default (){ $this->code = 'sts_default'; $this->title = MODULE_STS_DEFAULT_TITLE; $this->description = MODULE_STS_DEFAULT_DESCRIPTION.' (v1.0.4)'; $this->sort_order=1; } function find_template (){ // Return an html file to use as template // Check if there is a template for this script $check_file = STS_TEMPLATE_DIR . basename ($_SERVER['PHP_SELF']) . ".html"; if (file_exists($check_file)) return $check_file; // No template for this script, returns the default template return STS_DEFAULT_TEMPLATE; } // End function function capture_fields () { // Returns list of files to include from folder sts_inc in order to build the $template fields return MODULE_STS_DEFAULT_NORMAL; } function replace (&$template) { $template['content']=sts_strip_content_tags($template['content'], 'Default Content'); } //====================================== // Functions needed for admin //====================================== function check() { if (!isset($this->_check)) { $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_STS_DEFAULT_STATUS'"); $this->_check = tep_db_num_rows($check_query); } return $this->_check; } function keys() { return array('MODULE_STS_DEFAULT_STATUS', 'MODULE_STS_DEBUG_CODE' ,'MODULE_STS_DEFAULT_NORMAL', 'MODULE_STS_TEMPLATE_FOLDER','MODULE_STS_TEMPLATE_FILE'); } function install() { tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Use Templates?', 'MODULE_STS_DEFAULT_STATUS', 'false', 'Do you want to use Simple Template System?', '6', '1','tep_cfg_select_option(array(\'true\', \'false\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Code for debug output', 'MODULE_STS_DEBUG_CODE', 'debug', 'Code to enable debug output from URL (ex: index.php?sts_debug=debug', '6', '2', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Files for normal template', 'MODULE_STS_DEFAULT_NORMAL', 'sts_user_code.php', 'Files to include for a normal template, separated by semicolon', '6', '2', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Template folder', 'MODULE_STS_TEMPLATE_FOLDER', 'test', 'Location of templates inside the includes/sts_templates/ folder. Do not start nor end with a slash', '6', '2', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Default template file', 'MODULE_STS_TEMPLATE_FILE', 'sts_template.html', 'Name of the default template file', '6', '2', now())"); } function remove() { tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')"); } }// end class ?>