Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

abz786

Pioneers
  • Posts

    30
  • Joined

  • Last visited

Profile Information

  • Real Name
    Abdul

abz786's Achievements

  1. Hi Chris, Great contibition. I've been looking to add an extra text box field to the to the product.info.php page? Do you think this can be adapted for that?
  2. Hi Jason, Search for the featured products contribution under contributions. There should be a fix there, I remember seeing it last week. I hope it helps Abz
  3. Hi Mark, I've exactly the same problem. What version of MySQL and PHP are you using? I've just encountered this problem after migrating from MySQL 3.23 & PHP 4.3.10 to MySQL 5.0.18 and PHP 5. No problems encountered for over two years until now. The other thing I've noticed, I only get this problem when the amount involved is ?100 or over. It's happened to two of our customers in the last 24 hours and both had order values over ?100. I then tested this on our test server and it happened again. I'm convinced it has something to do with order values and MYSQL 5. If I find out, I'll let you. Abz
  4. Brilliant!!! It worked first time, a great result. Hopefully this will help many others as Hosting Companies migrate to MYSQL 5. Many thanks for the solution. Abz
  5. Thanks for the reply Chris. I'm not technical, so I don't know how you did it but here is the code: $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); } So how does writing joins using INNER/LEFT JOIN statements with corresponding ON clauses, and removing the WHERE predicates, apply here?? Abz
  6. Hi there, We've had the featured products contribution V 1.5 installed on our store since Oct 2004 and it's been running fine. We recently upgraded our test server from MySQL 3.23.58 to MySQL 5 and PHP 5. We now get the following error message when you click on a Category with Sub-Categories: 1054 - Unknown column 'p.products_id' in 'on clause' select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '75' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 9 The above code is from the featured.php file under catalog/includes/modules/featured.php. This is a specific MySQL 5 issue as MySQL 5 introduces Server SQL modes as part of its SQL 2003 standards support, and uses a more stricter approach to executing SQL queries We have already applied the general patches for MySQL 5 compliance as stipulated in the latest oscommerce-2.2ms2-051113 update. Any help would be appreciated. Thanks Abz
  7. Hi, I've installed this fantastic contribution (Categories Box Bullet and Line only) and it looks great . However, ever so often I'm getting the following error in the categories box which disappears once you refresh the page: Warning: in_array(): Wrong datatype for second argument in /home/public_html/includes/boxes/categories.php on line 57 Warning: in_array(): Wrong datatype for second argument. Line 57 refers to the following section of my /boxes/categories.php file if ($foo[$counter]['parent'] == 0) { $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new); $categories_string .= '">' . tep_image(DIR_WS_IMAGES . 'arrow_right_nav.gif', '') . ' '; } else { $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new); $categories_string .= '">' . tep_image(DIR_WS_IMAGES . 'arrow_bullet_square.gif', '') . ' '; } //ACTUAL LINE 57 - SEE BELOW if ( ($id) && (in_array($counter, $id)) ) { $categories_string .= "<b><font color='#CC0000'>"; } Any ideas why this is happening??
  8. Hi, I've just installed this contribution on MS2.2. No problems everything working EXCEPT when you go back into a product admin page the number in the sort order box is missing. I often change quantities and If I don't remember to re-input a value in the sort order box it changes to 0 by default and messes everything up. It's a real pain? Any ideas? Anyone???
  9. Hi, I've just installed this contribution on MS2.2. No problems everything working EXCEPT when you go back into a product admin page the number in the sort order box is missing. I often change quantities and If I don't remember to re-input a value in the sort order box it changes to 0 by default and messes everything up. It's a real pain? Any ideas?
  10. I'm upgrading too and I get exactly the same message! Please advise. Thanks
  11. Quick question Bobby. Installed your Ultimate SEO URLs v1.4 last week, works great!. I also have the configuration cache contribution installed since last Oct (faster page loads less DB queries). No problems with this too. Should I be considering upgrading to your Ultimate SEO URLs v2.0? If yes, do I need to remove the configuration cache contribution. Please advise. Thanks
  12. Hi, I installed the latest version of Configuration Cache 1.32, back in last October. It's been running smoothly. However, I've discovered that when you uninstall say a shipping or a payment module you cannot reinstall it again. When the install button is clicked nothing happens. I've had to replace the modified catalog/admin/module.php file with the orginal to then be able to install a shipping module. I don't know if this is a bug but does anyone have a solution?
  13. OK, I fixed the problem of errors when I select the rewrite method and this in turn fixed the problem of my 'product extra fields' disappearing. My .htaccess file was incorrect. I should have selected the bit of code if your store is in the root directory but I selected the code for the 'folder' option (from the installation instructions). All fixed and working brilliantly. Thanks
  14. Hi Bobby, I've just installed this contribution, worked first time. Excellent work, thanks. I also have 'product extra fields v1.3c' contribution installed on my system and there appears to be a conflict with your Ultimate SEO URLS contribution. Basically, when I enable your contribution via the admin screen, my product extra fields disappear. When I disable it, they're visible again. I'm using the Cname method. This leads me to my second question. When I select the rewrite method, i get an error message 'this URL cannot be found on this server. I'm using apache. Any thoughts?
  15. Thanks for the reply, I really appreciate it. Yes, I am displaying prices with a strike out. Your absolutely right, the strike out line would make the 8 look like a 0 - duh, It didn't even occur to me. I'll change the font to address the problem. Thanks for your help. Abdul
×
×
  • Create New...