Jump to content

webmaster69

Members
  • Content count

    112
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Frank
  1. Surely the whole point of PayPal Express is that YOU DO NOT NEED TO LOGIN to the OsCommerce site- The customer puts items in their basket, then click the PayPal Express icon and it takes you PayPal login, then in turn creates or logs you into OsCommerce?
  2. webmaster69

    Feedmachine

    catalog/admin/feedmachine.php Approx line 270 find the line that starts $master_query = tep_db_query('SELECT s.*, cd.*, c.*, ptc.*, mi. And add before this line // SQL_BIG_SELECTS = 1 - added to solve 1104 MYSQL error message tep_db_query("set sql_big_selects=1"); That’s it! Cheers Frank
  3. webmaster69

    Feedmachine perfect for 2 years, now have error

    catalog/admin/feedmachine.php Approx line 270 find the line that starts $master_query = tep_db_query('SELECT s.*, cd.*, c.*, ptc.*, mi. And add before this line // SQL_BIG_SELECTS = 1 - added to solve 1104 MYSQL error message tep_db_query("set sql_big_selects=1"); That’s it! Cheers Frank
  4. webmaster69

    Feedmachine perfect for 2 years, now have error

    Any help on this from the osCommerce community would be really appreciated. I have also tried all the other feed generating contributions and I can't find any others that generate feeds for the different PPC / Search engines. So it would be a real shame if feedmachine can not be fixed, as I know many of the osCommerce community rely on it. The version I had installed was version 2.13, I have tried using all the other later versions as well but get the exact same error. Thanks Frank
  5. Hi, first of all what a fantastic contribution, it's saved me hours of work and a lot of head scratching and it's so simple to use. I have been sucessfully using feedmachine for at least 2 years with no problems at all. Today I have added some new products to my store and now get an error when generating the feed. So I'm thinking it may have something to do with the amount of products (I now have 930 products). Below is a copy of the error which occurs when the feed is generated languages array built currencies array built taxes array built countries array built categories array built 1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okaySELECT COUNT(*) as count FROM products p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id LEFT JOIN manufacturers_info mi ON m.manufacturers_id = mi.manufacturers_id AND pd.language_id = mi.languages_id LEFT JOIN products_to_categories ptc ON pd.products_id = ptc.products_id LEFT JOIN specials s ON ptc.products_id = s.products_id LEFT JOIN categories c ON ptc.categories_id = c.categories_id LEFT JOIN categories_description cd ON c.categories_id = cd.categories_id AND pd.language_id = cd.language_id WHERE pd.language_id IN(1) AND p.products_status = 1 ORDER BY p.products_id[TEP STOP] Thanks Frank
  6. When a search is performed and there are various product matches, would it be possible to have the products displayed by splitting them into manufacture groups along with manufacture description. Hope this makes sense. Thanks Frank
  7. Sorry, I got this wrong, I meant: When a search is performed and there are various product matches, would it be possible to have the products displayed by splitting them into manufacture groups along with manufacture description. Hope this makes sense. Also just realised posted this in wrong thread it should be in Sam’s other thread Product Listing Enhancements, Thumbnails @ Manufacture Headings I'll post it there instead. Thanks Frank
  8. Hi Sam Would it be possible to add a further mod to this great contribution? When a search is performed and there are various product matches, would it be possible to have the products displayed in their categories. Hope this makes sense. Thanks Frank
  9. Hi Sam That's great news. Frank ps. Don't know if you still use the hosting account that I set up for you on 20-05-08? I can remember offerring a hosting account for a year to anyone who helped with a contribution and you sorted it for the second time. So I know owe you 2 accounts. I have just amended the first account not to expire so it's yours to keep. Let me know what you want to do with the second account or if you want any domain names registering or linking to them.
  10. That's great news, hopefully Marker will post in this thread how he acheived it and which contrbution he used.
  11. Hi First of all what a GREAT contribution. I too would like to replace the 'Buy Now' & 'Details' icons with a Quantity Box and an Add to Cart button at the end of the listing. It would be fantastic if this could be added to the 'Product Listing Style' function in admin so 'Buy Now' & 'Details' icons where replaced with a quantity box see image >> I have spent all today trying to get this to work, there are some conributions that work great on the standard product_listing.php but I can't adapt any to work with this. Regards Frank
  12. Hi Sam I am trying to add your contribution but have a conflict in code as I have Header Tag Controller contribution installed, could you please check to see if you think I have updated my code correctly. this is on manufacturers.php Your code Find near 45 for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $manufacturers_url_array = $HTTP_POST_VARS['manufacturers_url']; $language_id = $languages[$i]['id']; $sql_data_array = array('manufacturers_url' => tep_db_prepare_input($manufacturers_url_array[$language_id])); Replace With: for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $language_id = $languages[$i]['id']; $sql_data_array = array('manufacturers_url' => tep_db_prepare_input($_POST['manufacturers_url'][$language_id]), 'manufacturers_description' => tep_db_prepare_input($_POST['manufacturers_description'][$language_id])); This is my code (I have Header Tags Controller contribution installed) for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $manufacturers_url_array = $HTTP_POST_VARS['manufacturers_url']; //HTC BOC $manufacturers_htc_title_array = $HTTP_POST_VARS['manufacturers_htc_title_tag']; $manufacturers_htc_desc_array = $HTTP_POST_VARS['manufacturers_htc_desc_tag']; $manufacturers_htc_keywords_array = $HTTP_POST_VARS['manufacturers_htc_keywords_tag']; $manufacturers_htc_description_array = $HTTP_POST_VARS['manufacturers_htc_description']; //HTC EOC $language_id = $languages[$i]['id']; //HTC BOC $sql_data_array = array('manufacturers_url' => tep_db_prepare_input($manufacturers_url_array[$language_id]), 'manufacturers_htc_title_tag' => (tep_not_null($manufacturers_htc_title_array[$language_id]) ? tep_db_prepare_input($manufacturers_htc_title_array[$language_id]) : $manufacturers_name), 'manufacturers_htc_desc_tag' => (tep_not_null($manufacturers_htc_desc_array[$language_id]) ? tep_db_prepare_input($manufacturers_htc_desc_array[$language_id]) : $manufacturers_name), 'manufacturers_htc_keywords_tag' => (tep_not_null($manufacturers_htc_keywords_array[$language_id]) ? tep_db_prepare_input($manufacturers_htc_keywords_array[$language_id]) : $manufacturers_name), 'manufacturers_htc_description' => tep_db_prepare_input($manufacturers_htc_description_array[$language_id])); //HTC EOC Replace with this? for ($i=0, $n=sizeof($languages); $i<$n; $i++) { //HTC BOC $manufacturers_htc_title_array = $HTTP_POST_VARS['manufacturers_htc_title_tag']; $manufacturers_htc_desc_array = $HTTP_POST_VARS['manufacturers_htc_desc_tag']; $manufacturers_htc_keywords_array = $HTTP_POST_VARS['manufacturers_htc_keywords_tag']; $manufacturers_htc_description_array = $HTTP_POST_VARS['manufacturers_htc_description']; //HTC EOC $language_id = $languages[$i]['id']; //HTC BOC $sql_data_array = array('manufacturers_url' => tep_db_prepare_input($_POST['manufacturers_url'][$language_id]), 'manufacturers_description' => tep_db_prepare_input($_POST['manufacturers_description'][$language_id])), 'manufacturers_htc_title_tag' => (tep_not_null($manufacturers_htc_title_array[$language_id]) ? tep_db_prepare_input($manufacturers_htc_title_array[$language_id]) : $manufacturers_name), 'manufacturers_htc_desc_tag' => (tep_not_null($manufacturers_htc_desc_array[$language_id]) ? tep_db_prepare_input($manufacturers_htc_desc_array[$language_id]) : $manufacturers_name), 'manufacturers_htc_keywords_tag' => (tep_not_null($manufacturers_htc_keywords_array[$language_id]) ? tep_db_prepare_input($manufacturers_htc_keywords_array[$language_id]) : $manufacturers_name), 'manufacturers_htc_description' => tep_db_prepare_input($manufacturers_htc_description_array[$language_id])); //HTC EOC Thanks Frank p.s Couldn't believe the amount of interest this contribution has attracted in such a small amount of time, looks like it's really in demand - well done
  13. Thanks for this great contribution, it works really well. Would it be possible to add a further mod? On the bottom of the product info page it would be great if it was possible to add a table and list all the categories that that product was in. If these could by hyperlinks to the category it would be amazing. Thanks Frank
  14. Been away for a few weeks, now back and can't wait to have a look at Sam's contribution. I dont have the category description mod, had a look at adding it but code conflicts with SEO contribution I have installed so diidn't add it. also don't have the hide categories contribution installed. Followed the instructions a couple of times and can't get it to work, when I perform a search the following error occurs: Products meeting the search criteria There is no product that matches the search criteria. HEADING_TITLE_3 1054 - Unknown column 'cd.categories_id' in 'field list' select count(distinct cd.categories_id) as total from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where cd.categories_id = c.categories_id and cd.language_id = '1' and ((cd.categories_name like '%dx9000%') ) [TEP STOP]
  15. Is there a way to put the price field in there so the price along with description are automatically generated for each product page in the meta description? Anyone understand this? I'm no techno wizz like the rest of you, I have absolutely no idea what the above means. If anyone could give me the code to enter, I think I could hopefully manage that. Cheers Frank
×