tapuahk

Thanks Jack, :thumbsup: The new instructions worked great on test site, will be doing live store now. :rolleyes: ~~~Tapuahk

Received the following error when running admin/headertags_seo_update.php admin/headertags_seo_update.php Warning: mysql_fetch_field(): supplied argument is not a valid MySQL result resource in /international/catalog/admin/includes/functions/database.php on line 125 Administration | Online Catalog | Support Site Logged in as: admin (Logoff) Header Tags Controller Setup Database successfully updated!!! ??? I'm stopping here until I figure what went wrong.

Just saying if I blindly follow instructions I would have two lines saying define('FILENAME_HEADER_TAGS_FILL_TAGS', 'header_tags_fill_tags.php'); as a line saying define('FILENAME_HEADER_TAGS_FILL_TAGS', 'header_tags_fill_tags.php'); exists and you don't say to remove it.

Update instructions for updating Header Tags Controller version 2.6.3 to Header Tags SEO V 3.0 by Jack_mcs says i think you meant catalog/product_info.php ??

USING: Update instructions for updating Header Tags Controller version 2.6.3 to Header Tags SEO V 3.0 by Jack_mcs Step 3 says: But I found this: I don't think I should have to define the same thing twice so I deleted all three lines not just the two. ~~~Tapuahk

Okay. I'm going to use a duplicate I made of my store and database to test this. I really liked the way HTC worked, so I am looking forward to the results this will bring. ~~~Tapuahk

Debug is as follows: <!-- Discount Coupons DEBUG order Object ( [info] => Array ( [order_status] => 4 [currency] => USD [currency_value] => 1.00000000 [payment_method] => PayPal Website Payments Standard [cc_type] => [cc_owner] => [cc_number] => [cc_expires] => [shipping_method] => [shipping_cost] => [subtotal] => 0 [tax] => 0 [tax_groups] => Array ( [MD 5% tax + US Buyer remits taxes] => 0 ) [comments] => [total] => 0 ) [totals] => Array ( ) [products] => Array ( [0] => Array ( [qty] => 1 [name] => How to Get the TRUTH Out of Anyone [model] => PDF [tax] => 5 [tax_description] => MD 5% tax + US Buyer remits taxes [price] => 0.9900 [final_price] => 0.99 [weight] => 0.00 [id] => 112{1}1 [attributes] => Array ( [0] => Array ( [option] => Download [value] => Yes [option_id] => 1 [value_id] => 1 [prefix] => + [price] => 0.0000 ) ) ) ) [customer] => Array ( [firstname] => Melissa [lastname] => Monroe [company] => [street_address] => [suburb] => [city] => Cumberland [postcode] => 21502 [state] => Maryland [zone_id] => 31 [country] => Array ( [id] => 223 [title] => United States [iso_code_2] => US [iso_code_3] => USA ) [format_id] => 2 [telephone] => [email_address] => ) [delivery] => Array ( [firstname] => Melissa [lastname] => Monroe [company] => [street_address] => [suburb] => [city] => Cumberland [postcode] => 21502 [state] => Maryland [zone_id] => 31 [country] => Array ( [id] => 223 [title] => United States [iso_code_2] => US [iso_code_3] => USA ) [country_id] => 223 [format_id] => 2 ) [content_type] => virtual [coupon] => discount_coupon Object ( [messages] => Array ( [debug] => Array ( [0] => INFO: DISPLAY_PRICE_WITH_TAX = false [1] => INFO: MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING = false [2] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS = true [3] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_SORT_ORDER = 0 [4] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_TYPE = true [5] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_SUBTOTAL = true [6] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_TAX = Display discounted tax in separate line [7] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_EXCLUDE_SPECIALS = true [8] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_RANDOM_CODE_LENGTH = 6 [9] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_LINES = false [10] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_ALLOW_NEGATIVE = false [11] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_USE_LANGUAGE_FILE = false [12] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_CONFIG = Discount Coupon [code] applied [13] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DEBUG = true [14] => INFO: Percentage of discount applied to product 112{1}1: 1. [15] => INFO: Fixed discount applied to product 112{1}1: -0.01. [16] => INFO: Fixed adjustment for product 112{1}1: difference: 1 unadjusted applied_discount: -0.01 [17] => INFO: Product 112{1}1 passed exclusion check. Discount 0.99 applied. (fixed) [18] => INFO: Applied tax of 5 to: 0.99 [19] => INFO: Tax not applied to product 112{1}1: 0 [20] => INFO: Discount of 0.99 applied to product 112{1}1 ($0.99). [21] => INFO: Calculating tax on 0. Displayed price 0. ) ) [coupon] => Array ( [coupons_id] => FREEDOWNLOAD [coupons_description] => FREE EBOOK DOWNLOAD [coupons_discount_amount] => 0.990000000000 [coupons_discount_type] => fixed [coupons_date_start] => [coupons_date_end] => [coupons_max_use] => 1 [coupons_min_order] => 0.9900 [coupons_min_order_type] => price [coupons_number_available] => 1 ) [applied_discount] => Array ( [MD 5% tax + US Buyer remits taxes] => 0.99 ) [cart_info] => Array ( [valid_products] => Array ( [count] => 1 [line_items] => 1 [total] => 0.99 ) [total_products] => Array ( [count] => 1 [line_items] => 1 [total] => 0.99 ) [exclusions] => Array ( [categories] => Array ( [0] => 38 [1] => 41 [2] => 42 [3] => 43 [4] => 44 ) [products] => Array ( [0] => 103 [1] => 104 [2] => 106 [3] => 107 [4] => 117 [5] => 118 [6] => 119 [7] => 120 [8] => 121 [9] => 131 [10] => 132 ) [manufacturers] => Array ( ) ) ) [discount_tax] => Array ( [MD 5% tax + US Buyer remits taxes] => 0 ) ) [billing] => Array ( [firstname] => Melissa [lastname] => Monroe [company] => [street_address] => [suburb] => [city] => Cumberland [postcode] => 21502 [state] => Maryland [zone_id] => 31 [country] => Array ( [id] => 223 [title] => United States [iso_code_2] => US [iso_code_3] => USA ) [country_id] => 223 [format_id] => 2 ) ) End Discount Coupons DEBUG--> I don't see any problems, maybe your eyes can catch it... Thanks in advance, ~~~Tapuahk

Still having problems with DCC recording usage... Will work on multiple coupon fix over weekend, maybe the solution to lack of usage recording will present itself when I walk through code. Sigh :( ~~~Tapuahk KGT, I think I should have the multiple coupon modification done in a week, but I'm slow at documenting what I do so I may not have it posted here in the same time frame.

I got this fix, to sell free items simply change checkout_confirmation.php as follows: find: <?php if (isset($$payment->form_action_url)) { $form_action_url = $$payment->form_action_url; } else { $form_action_url = tep_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL'); } replace with: <?php // if order total is equal to zero redirect to checkout_process if ($order->info['total']<0.005) { // Too little to process payment for $0.0049 $form_action_url = tep_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL'); } else { // They will have to pay if (isset($$payment->form_action_url)) { $form_action_url = $$payment->form_action_url; } else { $form_action_url = tep_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL'); } }

KG, I have installed your contribution, modified it to work with virtual products, but I need a slightly greater modification. I was wondering how long would it take you to make an update to allow the use of multiple coupons on the same cart. I imagine it would be adding the use of a delimiter in the coupon entry, reading that into an array, then running a loop for the count in the array. I would also like to ad a coupon exclusion, so that certain coupons could not be combined while still allowing use of multiple coupons on a single cart. I have many single use coupons that are fixed $ discounts on a single item. But I also have % discounts on real products that may be bought at the same time. These coupons are not being recorded as being used, even after a coupon has been recorded in a completed sale. ORDER shows this: Products Model Tax Price (ex) Price (inc) Total (ex) Total (inc) 1 x 470 Crock Pot Recipes - Download: Yes Zipped PDF 5.00% $0.99 $1.04 $0.99 $1.04 Tax not applied: -$0.00 Discount Coupon FREEDOWNLOAD applied: -$0.98 Sub-Total: $0.01 MD 5% tax + US Buyer remits taxes: $0.00 Total: $0.01 But REPORT show this: Code Discount Amount Global Number Available Number Used Global Number Available Remaining 2. FREEDOWNLOAD $0.98 1 0 1 I am still working on allowing skipping of payment method if total == $0. Any help at all will be greatly appreciated. ~~~Tapuahk

HERE is the solution to above error: I got it working, The cart had been crashing on virtual only products with a 1064 SQL Syntax that many others were also getting change the following: In checkout_shipping find: // if the order contains only virtual products, forward the customer to the billing page as // a shipping address is not needed if ($order->content_type == 'virtual') { if (!tep_session_is_registered('shipping')) tep_session_register('shipping'); $shipping = false; $sendto = $customer_default_address_id; // not $sendto=false to work with shop using Discount Coupon Codes tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL')); } Allows use of discount coupons with virtual products.

Okay, weird as it may sound, it appears you have a browser cookie problem... In your configure.php make sure your cookie domain(s) (especially the SSL one) matches your actual domain(s). If the cookie get stored the wrong place your users will get treated like a crawler and dump the cart if you try to checkout. ~~~Tapuahk

PSS, I tested it to make sure: I put two items in cart one digital and one physical. Got to checkout_shipping shipping address was blank. Chose 'Change Address' click radio button next to billing address, choose shipping method for physical item, chose 'continue' and Got to payment enter coupon code hit continue, COUPON worked and Displayed on Confirmation screen So I need to change the behavior of digital products to not skip shipping info. Any ideas.???

Okay, duh, could I be that stupid... The problem may be that the $delivery array does not get filled if they choose digital products. So of course you have nulls being output. How do I get it to pass billing address as delivery address??? Again I just need someone to show me how to get it to pass the shipping info normally sent when the user visits checkout_shipping.php Any ideas??

Okay narrowed it down to includes/classes/order.php to this piece of code: //shipping zone exclusions $check_user_query = tep_db_query($sql = 'SELECT dc2z.geo_zone_id FROM ' . TABLE_DISCOUNT_COUPONS_TO_ZONES . ' dc2z LEFT JOIN ' . TABLE_ZONES_TO_GEO_ZONES . ' z2g USING( geo_zone_id ) WHERE ( z2g.zone_id=' . $delivery['zone_id'] . ' or z2g.zone_id = 0 or z2g.zone_id IS NULL ) AND ( z2g.zone_country_id=' . $delivery['country_id'] . ' or z2g.zone_country_id = 0 ) AND dc2z.coupons_id="' . tep_db_input( $code ) . '"' ); Now I need to find where $delivery is defined as an array having zone_id, country_id of the customer... Okay... I'll find it...myself...

Okay its not the tables the geo_zone_id is not getting passed to the query??? Now I just need to find which query that is??? Any help will be appreciated.. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'or z2g.zone_id = 0 or z2g.zone_id IS NULL ) ' at line 5 SELECT dc2z.geo_zone_id FROM discount_coupons_to_zones dc2z LEFT JOIN zones_to_geo_zones z2g USING( geo_zone_id ) WHERE ( z2g.zone_id= or z2g.zone_id = 0 or z2g.zone_id IS NULL ) AND ( z2g.zone_country_id= or z2g.zone_country_id = 0 ) AND dc2z.coupons_id="CouponCode" [TEP STOP]

Okay, Server Information Server Host: () Database Host: MYSQLHOST (66.244.251.60) Server OS: Database: MySQL 5.0.24a-log Server Date: 03/30/2008 05:06:38 Datebase Date: 03/30/2008 05:06:38 Server Up Time: HTTP Server: Apache/1.3.34 (Unix) mod_fastcgi/2.4.2 mod_perl/1.26 PHP Version: 4.4.7 (Zend: 1.3.0) [osCommerce Online Merchant v2.2 RC2a] osCommerce Online Merchant v2.2 RC2a PHP Logo PHP Version 4.4.7 System FreeBSD cgi25 6.2-RELEASE-p7 FreeBSD 6.2-RELEASE-p7 #4: Wed Sep 19 10:18:56 EDT 2007 root@admn6:/usr/obj/usr/src/sys/NF_GENERIC_MDROOT amd64 Build Date Mar 16 2008 15:56:54 It looks like the 1064 error is a problem with the DATABASE tables. Because I have 2 tax zones already setup. So what I don't see if which field is causing the error in the previous post. Anyone who could suggest a possibility?

I am using OSC 2.2 RC2a, PHP4, MYSQL. I am getting the following error when someone enters a coupon code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'or z2g.zone_id = 0 or z2g.zone_id IS NULL ) ' at line 5 SELECT dc2z.geo_zone_id FROM discount_coupons_to_zones dc2z LEFT JOIN zones_to_geo_zones z2g USING( geo_zone_id ) WHERE ( z2g.zone_id= or z2g.zone_id = 0 or z2g.zone_id IS NULL ) AND ( z2g.zone_country_id= or z2g.zone_country_id = 0 ) AND dc2z.coupons_id="CouponCode" [TEP STOP] The coupon code displayed here I edited so nothing bad happens once I get this fixed. Any ideas ??

Another solution would be to allow the creation of sub-zones, based on zipcode for each county. And a tax rate assigned to it. Right now 2.2 RC2 does not allow for this so the code would need to be modified. Could borrow from a mod known as ZipShip to set up the zip_zones, then need to create extra table for zip_tax_rates_to_zip_zones. Then modify the tax calculations in the PHP files. I can send you a rough (very rough) proto-mod as I am strapped for time. I'll post it here in a day or two... okay , it might take a week :-" ~~~Tapuahk

Product, category images are all stored in your catalog/images folder. Other images can be stored there or anywhere you please. You can name your images anything except what images you are currently using. NOTE: There is no overwrote notification if you upload a second image named "books.jpg" it will just overwrite the existing "books.jpg" ~~~Tapuahk

The catalog/admin/includes/configure.php is either calling the wrong database (Very UNLIKELY) or you are missing a table in your database... Is your store still functional? ~~~ Tapuahk

Nothing wrong in the code I can see... You should see text in the middle that says "Put here your about us information!" ???

Contribution is available at http://addons.oscommerce.com/info/4652 .. For support started this thread... ~~~tapuahk

Try http://www.oscommerce.com/community/contributions,1333 setting shipping by product