Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

DawnG

Pioneers
  • Posts

    178
  • Joined

  • Last visited

Posts posted by DawnG

  1. Hi Raiwa

     

    I've got this great contrib up and running for one store, I also have another store with a very large number of categories, I'm getting the following error message:

     

    Parse error: syntax error, unexpected ';' in /home/paganmag/public_html/shop/admin/fm-feed-configs/google-product-search-us-en.php on line 455

     

    Here's the file - I would appreciate any help you can give me.

     

    <?php
    /**
    * @license http://opensource.org/licenses/gpl-license.php GNU Public License
    */
    /*
    Google Product feed configuration for The Feedmachine Solution
    based on google-simple.php by: Lech Madrzyk
    ----------------------------
    This configuration is complient with the Google-Feed specifications from 22nd of september 2011.
    It has to be used together with the modified feedmachine.php file which includes the 'IS_IN_STOCK' Keyword definition.
    */
    $feed_config = array('name' => 'Google Product Search',
    				 'authors' => 'raiwa',
    				 'filename' => 'paganmagic1.txt',
    				 'schema_version' => '2.0',
    				 'fields' => array('id'			   =>   array('output' => 'FM_RS_product_id_us_en',
    																 'type' => 'FUNCTION'
    															    ),
    								   'title'		    =>   array('output' => 'products_name',
    																 'type' => 'DB',
    																 'options' => array('STRIP_HTML', 'STRIP_CRLF')
    															    ),
    								   'price'		    =>   array('output' => 'FINAL_PRICE_WITH_TAX',
    																 'type' => 'KEYWORD',
    															    ),
    								   'brand'					  =>   array('output' => 'manufacturers_name',
    																 'type' => 'DB',
    																 'options' => array('STRIP_HTML', 'HTML_ENTITIES', 'STRIP_CRLF')
    																  ),
    								   'mpn'			  =>   array('output' => 'products_model',
    																 'type' => 'DB'
    															    ),
    					 'Google product category'	    =>   array('output' => 'FM_RS_google_categories_us_en',
    																 'type' => 'FUNCTION'
    															    ),
    								   'product_type'	 =>   array('output' => 'CATEGORY_TREE',
    																 'type' => 'KEYWORD',
    																 'options' => array('STRIP_HTML', 'STRIP_CRLF')
    															    ),
    								   'link'			 =>   array('output' => 'PRODUCTS_URL',
    																 'type' => 'KEYWORD'
    															    ),
    								   'image_link'	   =>   array('output' => 'IMAGE_URL',
    																 'type' => 'KEYWORD'
    															    ),
    								   'condition'	    =>   array('output' => 'New',
    																 'type' => 'VALUE'
    															    ),
    								   'description'	  =>   array('output' => 'products_description',
    																 'type' => 'DB',
    																 'options' => array('STRIP_HTML', 'STRIP_CRLF')
    															    ),
    								   'availability'	    =>   array('output' => 'IS_IN_STOCK',
    																 'type' => 'KEYWORD'
    															    )
    								  ),
    				 'currency_decimal_override' => false,
    				 'currency_thousands_override' => '',
    				 'add_field_names' => true,
    				 'category_tree_seperator' => ' ',
    				 'seperator' => "\t",
    				 'text_qualifier' => '',
    				 'newline' => "\n",
    				 'encoding' => 'false',
    				 'include_record_function' => ''
    			    );
    //FEED FUNCTIONS BEGIN
    function FM_RS_product_id_us_en($product) {
     return 'Retro-Brands_' . $product['products_id'] . '';
    }
    function FM_RS_google_categories_us_en($product) {
     $output_field_category = $product['categories_id'];
     return (($output_field_category == 670) ? 'Office Supplies > Filing & Organization > Calendars, Organizers & Planners' :
       (($output_field_category == 261) ? 'Home & Garden > Decor':
     (($output_field_category == 260) ? 'Home & Garden > Linens > Table Linens > Tablecloths':
      (($output_field_category == 263) ? 'Home & Garden > Decor':
       (($output_field_category == 262) ? 'Home & Garden > Decor':
        (($output_field_category == 264) ? 'Home & Garden > Decor':
    	 (($output_field_category == 602) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
    	  (($output_field_category == 603) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
    	   (($output_field_category == 611) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
      (($output_field_category == 612) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
       (($output_field_category == 613) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
        (($output_field_category == 605) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
    	 (($output_field_category == 608) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
    	  (($output_field_category == 604) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
    	   (($output_field_category == 606) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
    	    (($output_field_category == 607) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
    		 (($output_field_category == 610) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
        (($output_field_category == 609) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
    	 (($output_field_category == 313) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
    	  (($output_field_category == 431) ? 'Arts & Entertainment > Artwork > Prints':
    	  (($output_field_category == 324) ? 'Hardware > Flooring > Stone Flooring > Tile Flooring':
    	  (($output_field_category == 490) ? 'Arts & Entertainment > Artwork > Prints':
    	   (($output_field_category == 390) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
    	   (($output_field_category == 677) ? 'Arts & Entertainment > Artwork > Prints':
    	   (($output_field_category == 318) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
    	   (($output_field_category == 317) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
    	   (($output_field_category == 381) ? 'Arts & Entertainment > Artwork > Prints':
    	   (($output_field_category == 357) ? 'Arts & Entertainment > Artwork > Prints':
    	   (($output_field_category == 316) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
    	   (($output_field_category == 678) ? 'Arts & Entertainment > Artwork > Photographs':
    	   (($output_field_category == 656) ? 'Hardware > Flooring > Stone Flooring > Tile Flooring':
    	   (($output_field_category == 601) ? 'Arts & Entertainment > Artwork > Prints':
    	   (($output_field_category == 314) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
    	   (($output_field_category == 72) ? 'Arts & Entertainment > Collectibles > Collectible Weapons > Collectible Knives':
    	   (($output_field_category == 53) ? 'Apparel & Accessories':
    	   (($output_field_category == 210) ? 'Arts & Entertainment > Crafts & Hobbies > Magnets':
    	   (($output_field_category == 54) ? 'Apparel & Accessories':
    	   (($output_field_category == 623) ? 'Home & Garden > Decor':
    	   (($output_field_category == 84) ? 'Vehicles & Parts > Automotive Care > Automotive Decor > Automotive Decals':
    	   (($output_field_category == 148) ? 'Home & Garden > Decor > Doors & Windows':
    	   (($output_field_category == 268) ? 'Home & Garden > Household Supplies > Storage & Organization':
    	   (($output_field_category == 265) ? 'Home & Garden > Household Supplies > Storage & Organization':
    	   (($output_field_category == 267) ? 'Home & Garden > Household Supplies > Storage & Organization':
    	   (($output_field_category == 266) ? 'Home & Garden > Household Supplies > Storage & Organization':
    	   (($output_field_category == 304) ? 'Home & Garden > Household Supplies > Storage & Organization':
    	   (($output_field_category == 300) ? 'Home & Garden > Decor > Home Fragrances':
    	   (($output_field_category == 302) ? 'Home & Garden > Household Supplies > Storage & Organization':
    	   (($output_field_category == 651) ? 'Apparel & Accessories > Jewelry Accessories > Jewelry Boxes':
    	   (($output_field_category == 301) ? 'Apparel & Accessories > Jewelry Accessories > Jewelry Boxes':
    	   (($output_field_category == 71) ? 'Home & Garden > Household Supplies > Household Cleaning Supplies > Brooms':
    	   (($output_field_category == 240) ? 'Home & Garden > Decor > Candle Holders':
    	   (($output_field_category == 239) ? 'Home & Garden > Decor > Candle Holders':
    	   (($output_field_category == 237) ? 'Home & Garden > Decor > Candle Holders':
    	   (($output_field_category == 238) ? 'Home & Garden > Decor > Candle Holders':
    	   (($output_field_category == 236) ? 'Home & Garden > Decor > Candle Holders':
    	   (($output_field_category == 385) ? 'Home & Garden > Decor > Candles':
    	   (($output_field_category == 365) ? 'Arts & Entertainment > Crafts & Hobbies > Candle & Soap Making':
    	   (($output_field_category == 222) ? 'Home & Garden > Decor > Candles':
    	   (($output_field_category == 495) ? 'Home & Garden > Decor > Candles':
    	   (($output_field_category == 224) ? 'Home & Garden > Decor > Candles':
    	   (($output_field_category == 219) ? 'Home & Garden > Decor > Candles':
    	   (($output_field_category == 223) ? 'Home & Garden > Decor > Candles':
    	   (($output_field_category == 225) ? 'Home & Garden > Decor > Candles':
    	   (($output_field_category == 229) ? 'Home & Garden > Decor > Candles':
    	   (($output_field_category == 492) ? 'Home & Garden > Decor > Candles':
    	   (($output_field_category == 226) ? 'Home & Garden > Decor > Candles':
    	   (($output_field_category == 227) ? 'Home & Garden > Decor > Candles':
    	   (($output_field_category == 228) ? 'Home & Garden > Decor > Candles':
    	   (($output_field_category == 485) ? 'Home & Garden > Decor > Candles':
    	   (($output_field_category == 269) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 509) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 359) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 272) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 273) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 274) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 275) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 271) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 675) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 276) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 278) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 279) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 280) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 277) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 270) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
    	   (($output_field_category == 74) ? 'Home & Garden > Kitchen & Dining > Cookware':
    	   (($output_field_category == 101) ? 'Home & Garden > Kitchen & Dining > Tableware > Dinnerware > Bowls':
    	   (($output_field_category == 102) ? 'Home & Garden > Kitchen & Dining':
    	   (($output_field_category == 149) ? 'Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Candy & Chocolate Molds':
    	   (($output_field_category == 625) ? 'Apparel & Accessories > Handbags':
    	   (($output_field_category == 336) ? 'Apparel & Accessories > Jewelry > Cufflinks':
    	   (($output_field_category == 628) ? 'Apparel & Accessories > Clothing Accessories > Gloves & Mittens':
    	   (($output_field_category == 626) ? 'Apparel & Accessories > Clothing Accessories > Headwear & Kerchiefs':
    	   (($output_field_category == 353) ? 'Apparel & Accessories > Clothing Accessories':
    	   (($output_field_category == 627) ? 'Apparel & Accessories > Clothing Accessories > Scarves & Shawls':
    	   (($output_field_category == 660) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 135) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 488) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 480) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 486) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 481) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 281) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 197) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 331) ? 'Apparel & Accessories > Clothing > Dresses':
    	   (($output_field_category == 616) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 622) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 614) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 619) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 617) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 615) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 620) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 621) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 469) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 618) ? 'Apparel & Accessories > Clothing':
    	   (($output_field_category == 130) ? 'Media > Books > Non-Fiction > Education Books':
    	   (($output_field_category == 469) ? 'Home & Garden > Decor > Baskets':
    	   (($output_field_category == 469) ? 'Arts & Entertainment > Crafts & Hobbies > Jewelry Making > Beads':
    	   (($output_field_category == 437) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 398) ? 'Arts & Entertainment > Crafts & Hobbies > Flower Arranging':
    	   (($output_field_category == 662) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 377) ? 'Home & Garden > Decor':
    	   (($output_field_category == 376) ? 'Home & Garden > Decor':
    	   (($output_field_category == 204) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 31) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 494) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 37) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 146) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 669) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 668) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 349) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 199) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 116) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 167) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 639) ? 'Apparel & Accessories > Jewelry > Bracelets':
    	   (($output_field_category == 641) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
    	   (($output_field_category == 640) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
    	   (($output_field_category == 599) ? 'Apparel & Accessories > Jewelry > Bracelets':
    	   (($output_field_category == 379) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 165) ? 'Home & Garden > Decor':
    	   (($output_field_category == 32) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 156) ? 'Luggage & Bags > Luggage > Luggage Accessories > Keychains':
    	   (($output_field_category == 30) ? 'Health & Beauty > Personal Care > Massagers':
    	   (($output_field_category == 35) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 384) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 367) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 688) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 351) ? 'Home & Garden > Decor':
    	   (($output_field_category == 350) ? 'Home & Garden > Decor':
    	   (($output_field_category == 200) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 145) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 33) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 41) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 209) ? 'Media > DVDs & Videos':
    	   (($output_field_category == 119) ? 'Home & Garden > Decor':
    	   (($output_field_category == 86) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
    	   (($output_field_category == 374) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
    	   (($output_field_category == 659) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
    	   (($output_field_category == 40) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
    	   (($output_field_category == 118) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
    	   (($output_field_category == 201) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
    	   (($output_field_category == 87) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
    	   (($output_field_category == 363) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
    	   (($output_field_category == 667) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
    	   (($output_field_category == 205) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
    	   (($output_field_category == 382) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
    	   (($output_field_category == 157) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
    	   (($output_field_category == 482) ? 'Arts & Entertainment > Party Supplies > Confetti':
    	   (($output_field_category == 469) ? 'Home & Garden > Decor':
    	   (($output_field_category == 443) ? 'Home & Garden > Plants > Flowers':
    	   (($output_field_category == 451) ? 'Apparel & Accessories > Clothing Accessories > Headwear & Kerchiefs > Headdresses':
    	   (($output_field_category == 442) ? 'Home & Garden > Decor > Artificial Plants & Flowers':
    	   (($output_field_category == 326) ? 'Home & Garden > Decor > Clocks':
    	   (($output_field_category == 362) ? 'Home & Garden > Kitchen & Dining > Barware > Coasters':
    	   (($output_field_category == 328) ? 'Home & Garden > Kitchen & Dining':
    	   (($output_field_category == 600) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 439) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping':
    	   (($output_field_category == 330) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping':
    	   (($output_field_category == 438) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping':
    	   (($output_field_category == 85) ? 'Arts & Entertainment > Gift Giving':
    	   (($output_field_category == 144) ? 'Home & Garden > Decor':
    	   (($output_field_category == 387) ? 'Electronics > Computers > Computer Accessories':
    	   (($output_field_category == 325) ? 'Home & Garden > Kitchen & Dining > Tableware > Drinkware > Mugs':
    	   (($output_field_category == 329) ? 'Office Supplies > General Supplies > Paper Products > Notebooks & Notepads':
    	   (($output_field_category == 510) ? 'Home & Garden > Decor > Photo Storage & Display > Photo Albums':
    	   (($output_field_category == 339) ? 'Home & Garden > Household Supplies > Storage & Organization':
    	   (($output_field_category == 211) ? 'Home & Garden > Decor > Plaques':
    	   (($output_field_category == 655) ? 'Arts & Entertainment > Party Supplies > Wedding Ceremony Supplies':
    	   (($output_field_category == 282) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 283) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 489) ? 'Health & Beauty > Personal Care > Cosmetics > Perfume & Cologne':
    	   (($output_field_category == 22) ? 'Health & Beauty > Personal Care > Massagers':
    	   (($output_field_category == 284) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 288) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 21) ? 'Home & Garden > Decor > Home Fragrances':
    	   (($output_field_category == 671) ? 'Home & Garden > Smoking Accessories':
    	   (($output_field_category == 120) ? 'Health & Beauty > Personal Care':
    	   (($output_field_category == 68) ? 'Food, Beverages & Tobacco > Beverages > Tea & Infusions':
    	   (($output_field_category == 78) ? 'Food, Beverages & Tobacco > Food Items > Seasonings & Spices > Herbs & Spices':
    	   (($output_field_category == 285) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 432) ? 'Home & Garden > Decor > Home Fragrances':
    	   (($output_field_category == 386) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 358) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 105) ? 'Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Mortars & Pestles':
    	   (($output_field_category == 287) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 286) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 306) ? 'Home & Garden > Decor > Home Fragrances':
    	   (($output_field_category == 115) ? 'Home & Garden > Decor > Home Fragrances':
    	   (($output_field_category == 307) ? 'Home & Garden > Decor > Home Fragrances':
    	   (($output_field_category == 308) ? 'Home & Garden > Decor > Home Fragrances':
    	   (($output_field_category == 380) ? 'Home & Garden > Decor > Home Fragrances':
    	   (($output_field_category == 23) ? 'Home & Garden > Decor > Home Fragrances':
    	   (($output_field_category == 690) ? 'Home & Garden > Decor > Home Fragrances':
    	   (($output_field_category == 142) ? 'Home & Garden > Decor > Home Fragrances':
    	   (($output_field_category == 215) ? 'Home & Garden > Decor > Home Fragrances > Incense':
    	   (($output_field_category == 216) ? 'Home & Garden > Decor > Home Fragrances > Incense':
    	   (($output_field_category == 508) ? 'Home & Garden > Decor > Home Fragrances > Incense':
    	   (($output_field_category == 218) ? 'Home & Garden > Decor > Home Fragrances > Incense':
    	   (($output_field_category == 487) ? 'Home & Garden > Decor > Home Fragrances > Incense':
    	   (($output_field_category == 217) ? 'Home & Garden > Decor > Home Fragrances > Incense':
    	   (($output_field_category == 312) ? 'Home & Garden > Decor > Home Fragrances > Incense':
    	   (($output_field_category == 214) ? 'Home & Garden > Decor > Home Fragrances > Incense':
    	   (($output_field_category == 79) ? 'Home & Garden > Decor > Home Fragrances > Incense':
    	   (($output_field_category == 473) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
    	   (($output_field_category == 476) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
    	   (($output_field_category == 472) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
    	   (($output_field_category == 474) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
    	   (($output_field_category == 477) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
    	   (($output_field_category == 475) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
    	   (($output_field_category == 299) ? 'Home & Garden > Smoking Accessories > Lighters':
    	   (($output_field_category == 332) ? 'Apparel & Accessories > Clothing Accessories > Hair Accessories':
    	   (($output_field_category == 335) ? 'Apparel & Accessories > Clothing Accessories > Belt Buckles':
    	   (($output_field_category == 344) ? 'Apparel & Accessories > Jewelry > Anklets':
    	   (($output_field_category == 347) ? 'Apparel & Accessories > Jewelry > Bracelets':
    	   (($output_field_category == 340) ? 'Apparel & Accessories > Jewelry > Bracelets':
    	   (($output_field_category == 341) ? 'Apparel & Accessories > Jewelry > Bracelets':
    	   (($output_field_category == 343) ? 'Apparel & Accessories > Jewelry > Bracelets':
    	   (($output_field_category == 346) ? 'Apparel & Accessories > Jewelry > Bracelets':
    	   (($output_field_category == 345) ? 'Apparel & Accessories > Jewelry > Bracelets':
    	   (($output_field_category == 348) ? 'Apparel & Accessories > Jewelry > Bracelets':
    	   (($output_field_category == 342) ? 'Apparel & Accessories > Jewelry > Bracelets':
    	   (($output_field_category == 337) ? 'Apparel & Accessories > Jewelry > Brooches & Lapels':
    	   (($output_field_category == 383) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
    	   (($output_field_category == 334) ? 'Apparel & Accessories > Clothing Accessories > Headwear & Kerchiefs > Headdresses':
    	   (($output_field_category == 258) ? 'Apparel & Accessories > Jewelry > Earrings':
    	   (($output_field_category == 233) ? 'Apparel & Accessories > Jewelry > Earrings':
    	   (($output_field_category == 414) ? 'Apparel & Accessories > Jewelry > Earrings':
    	   (($output_field_category == 415) ? 'Apparel & Accessories > Jewelry > Earrings':
    	   (($output_field_category == 416) ? 'Apparel & Accessories > Jewelry > Earrings':
    	   (($output_field_category == 417) ? 'Apparel & Accessories > Jewelry > Earrings':
    	   (($output_field_category == 413) ? 'Apparel & Accessories > Jewelry > Earrings':
    	   (($output_field_category == 412) ? 'Apparel & Accessories > Jewelry > Earrings':
    	   (($output_field_category == 411) ? 'Apparel & Accessories > Jewelry > Earrings':
    	   (($output_field_category == 111) ? 'Arts & Entertainment > Religious Items > Prayer Beads':
    	   (($output_field_category == 259) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 221) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 256) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 232) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 243) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 422) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 423) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 424) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 664) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 663) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 425) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 426) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 245) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 428) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 427) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 429) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 247) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 254) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 250) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 248) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 242) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 436) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 257) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 249) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 253) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 48) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 147) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 251) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 255) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 55) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 252) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 117) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 393) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 434) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 419) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 360) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 446) ? 'Apparel & Accessories > Jewelry > Rings':
    	   (($output_field_category == 450) ? 'Apparel & Accessories > Jewelry > Rings':
    	   (($output_field_category == 444) ? 'Apparel & Accessories > Jewelry > Rings':
    	   (($output_field_category == 445) ? 'Apparel & Accessories > Jewelry > Rings':
    	   (($output_field_category == 447) ? 'Apparel & Accessories > Jewelry > Rings':
    	   (($output_field_category == 448) ? 'Apparel & Accessories > Jewelry > Rings':
    	   (($output_field_category == 449) ? 'Apparel & Accessories > Jewelry > Rings':
    	   (($output_field_category == 408) ? 'Apparel & Accessories > Jewelry > Necklaces':
    	   (($output_field_category == 338) ? 'Apparel & Accessories > Watches':
    	   (($output_field_category == 213) ? 'Luggage & Bags > Luggage > Luggage Accessories > Keychains':
    	   (($output_field_category == 676) ? 'Food, Beverages & Tobacco > Food Items > Cooking & Baking Supplies':
    	   (($output_field_category == 658) ? 'Media > Magazines & Newspapers':
    	   (($output_field_category == 685) ? 'Media > Music':
    	   (($output_field_category == 682) ? 'Media > Music':
    	   (($output_field_category == 681) ? 'Media > Music':
    	   (($output_field_category == 683) ? 'Media > Music':
    	   (($output_field_category == 686) ? 'Media > Music':
    	   (($output_field_category == 679) ? 'Media > Music':
    	   (($output_field_category == 680) ? 'Media > Music':
    	   (($output_field_category == 687) ? 'Media > Music':
    	   (($output_field_category == 684) ? 'Media > Music':
    	   (($output_field_category == 322) ? 'Arts & Entertainment > Musical Instrument Accessories':
    	   (($output_field_category == 657) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 666) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 654) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 652) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 153) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
    	   (($output_field_category == 170) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
    	   (($output_field_category == 154) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
    	   (($output_field_category == 131) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
    	   (($output_field_category == 418) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
    	   (($output_field_category == 24) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
    	   (($output_field_category == 361) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
    	   (($output_field_category == 323) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
    	   (($output_field_category == 113) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 364) ? 'Media > Books > Fiction > Children\'s Books':
    	   (($output_field_category == 321) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
    	   (($output_field_category == 295) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 294) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 491) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 220) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
    	   (($output_field_category == 73) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 70) ? 'Home & Garden > Decor > Mirrors':
    	   (($output_field_category == 132) ? 'Arts & Entertainment > Musical Instrument Accessories':
    	   (($output_field_category == 399) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 355) ? 'Home & Garden > Linens > Bedding':
    	   (($output_field_category == 352) ? 'Home & Garden > Decor > Rugs':
    	   (($output_field_category == 354) ? 'Home & Garden > Decor':
    	   (($output_field_category == 456) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 455) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 454) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 465) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 464) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 457) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 460) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 463) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 459) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 452) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 493) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 453) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 462) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 458) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 461) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 466) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 99) ? 'Home & Garden > Kitchen & Dining > Food & Beverage Carriers':
    	   (($output_field_category == 107) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 368) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 94) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 129) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 661) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping > Bows & Ribbons':
    	   (($output_field_category == 468) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping > Bows & Ribbons':
    	   (($output_field_category == 97) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 124) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 234) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 372) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 370) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 373) ? 'Arts & Entertainment > Crafts & Hobbies > Drawing & Painting > Art Paper':
    	   (($output_field_category == 369) ? 'Arts & Entertainment > Crafts & Hobbies > Drawing & Painting > Drawing > Art Pens':
    	   (($output_field_category == 371) ? 'Arts & Entertainment > Collectibles > Seal Stamps':
    	   (($output_field_category == 511) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 421) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 76) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 689) ? 'Arts & Entertainment > Collectibles':
    	   (($output_field_category == 378) ? 'Health & Beauty > Health Care > Mobility & Special Needs > Walking Aids':
    	   (($output_field_category == 56) ? 'Arts & Entertainment > Crafts & Hobbies':
    	   (($output_field_category == 672) ? 'Health & Beauty > Personal Care > Sleeping Aids':
    	   (($output_field_category == 674) ? 'Home & Garden > Decor':
    	   (($output_field_category == 673) ? 'Home & Garden > Decor > Wind Chimes':
    		  '')))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))));
     }
    //FEED FUNCTIONS END
    ?>
    

  2. Right, I've restored my site to its original settings, so no need to panic there - but I do need to be able to address this issue.

    I have customers worldwide, and naturally I want to give them the best service, including their choice of shipping company.

     

    This mod looks great http://www.oscommerce.com/community/contributions,1446/category,2/search,enhanced+table but I would like to know how to duplicate so that I can have this for UK, as well as EU and US. Can someone help me with this, or point me in the direction of someone who can help.

  3. I recently became VAT registered, so in order to set up for VAT and deliveries I created 3 Zones:

     

    United Kingdom

    European Union

    Rest of the World

     

    What I want for each zone is an option for Standard Shipping and Tracked Shipping, so

     

    UK Standard

    UK Tracked

    EU Standard

    EU Tracked

    Intl Standard

    Intl Tracked

     

    I copied the table.php (from both includes/modules/shipping and includes/languages/english/modules/shipping)making the appropriate changes i.e. table, table1, table2... ...table6 etc.

     

    Everything looks fine from the Admin side, I installed the new tables, made the changes etc.

    When I went to test it in my store I am able to select Standard/Tracked for both UK and EU destinations, however when I come to a 'Rest of the World' country (they are all listed in the Zone) no option for shipping is displayed at all. I've been staring at this for hours now and I cannot figure out where I went wrong.

  4. Having posted this enquiry on 30th December in the Support thread for X-Sell and having no response, I thought I would try here, any help or a point in the right direction would be greatly appreciated.

     

    I've got this error on my product listing page after installing the latest version of XSell

     

     

    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 'MAX_DISPLAY_XSELL' at line 7

     

    select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, specials_new_products_price from products_xsell xp left join products p on xp.xsell_id = p.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where xp.products_id = '12089' and p.products_status = '1' order by sort_order asc limit MAX_DISPLAY_XSELL

     

    [TEP STOP]

     

    Please please please could someone tell me how to fix it - many thanks

  5. I've got this error on my product listing page:

     

    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 'MAX_DISPLAY_XSELL' at line 7

     

    select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, specials_new_products_price from products_xsell xp left join products p on xp.xsell_id = p.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where xp.products_id = '12089' and p.products_status = '1' order by sort_order asc limit MAX_DISPLAY_XSELL

     

    [TEP STOP]

     

     

    Please could someone tell me how to fix it - many thanks

  6. I don't think you did anything wrong. Someone else mentioned such a problem, as I recall. The failure is saying all of the database entries can't be loaded because the server is running out of memory, which is very unlikely with this contribution under normal conditions. It could be that the entris in your database are corrupted for some reason. You shouldn't have ran into a problem updating the database with this latest version but since you did, I suspect something went wrong. Since you did a fresh install, the database changes need to be cleared too. To do that, re-load the article_manager_V_1.57.sql file and then run the article_manager_update_configure.php file. Those two together will completely reset your database with regards to this contribution.

     

    Thanks Jack, I followed your instructions but the error still exists, should I delete everything an install an earlier version?

  7. Hi I've installed version 1.57_5_1 and when I go to Topics/Articles I get the following error message:

     

    Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 71 bytes) in /admin/includes/functions/articles.php on line 52

     

    Any ideas on where I've gone wrong, I did have a previous version installed, when I followed the upgrade my server had a hissy fit and deleted all of the articles etc. I had in the database. I can't back it up because the file was corrupted (loving my internet connection at the moment!) - so I decided to go for a fresh install.

     

    Many Thanks

    Dawn

  8. Hello all, I've just installed this contrib and was getting the error described earlier:

     

    Quick Fix For this Error:

    The error display twice, under the Starting Price and Highest Bid

    Warning: Missing argument 2 for display_price() in includes/classes/currencies.php on line 72

     

    FIND:

    function display_price($products_price, $products_tax, $quantity = 1) {

    return $this->format($this->calculate_price($products_price, $products_tax, $quantity));

    }

    REPLACE WITH:

    function display_price($products_price, $quantity = 1) {

    return $this->format($this->calculate_price($products_price, $quantity));

    }

     

    Basically this will just remove the code that is asking for the Price+Tax. And at least it will be one less error you get.

     

    I've followed these instructions but now I'm getting this error:

     

    Fatal error: Call to undefined method currencies::calculate_price() in /home/xxxxxx/public_html/shop/includes/classes/currencies.php on line 72

     

    What do I need to do? thank you

  9. I've installed the contrib and it's working fine - thanks btw - but now when I go to duplicate a catalogue product I get the following error message:

     

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/******/public_html/shop/admin/includes/functions/database.php on line 45

    0 -

     

    select products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id

     

    [TEP STOP]

     

    Could someone point me in the right direction please. Any help certainly appreciated.

  10. Currently on my site I give away a free mystery gift with every order over £25 .

     

    On sites such as Amazon and Viking Direct they display a message such as "Spend £x.xx more and get free delivery/gift etc."

    Is there a contrib I could install on my site that will do something similar?

     

    The gifts vary from day to day so I'm not sure the Free Gift contrib would be suitable, any advice would be greatly appreciated.

×
×
  • Create New...