Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

sputnikinternet

Archived
  • Posts

    41
  • Joined

  • Last visited

Everything posted by sputnikinternet

  1. I've searched forums and contributions to see if there is a way to have an option to charge for a personal message to be delivered with the purchase. I can't find it anywhere. does anyone know of one? Cheers Andy
  2. I would be interested to find the latest version as well. I thought i had th latest, but my own switch number is not accepted (it starts 675940). It's strange cos when i look at the code, it look like it should be accepting it. Any suggestions?
  3. Hmmm I seem to have fixed the SELECT blah blah problem. For those that suffer the same gremlin, i took this code in index.php, and removed the bit in red cos it seemed to be putting too many commas in. Hopefully this won't bring up problems elsewhere. for ($col=0, $n=sizeof($column_list); $col<$n; $col++) { if ( ($column_list[$col] == 'PRODUCT_LIST_BUY_NOW') || ($column_list[$col] == 'PRODUCT_LIST_PRICE') ) { continue; } if (tep_not_null($select_column_list)) { $select_column_list .= ', '; } switch ($column_list[$col]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model'; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name'; break; // Products Description Hack begins case 'PRODUCT_LIST_DESCRIPTION': $select_column_list .= 'pd.products_description'; break; // Products Description Hack ends case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name'; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity'; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image'; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight'; break; } } if (tep_not_null($select_column_list)) { $select_column_list .= ', '; }
  4. It seems to be something to do with the if (tep_not_null($select_column_list)) { $select_column_list .= ', '; } bits if i change it to if (tep_not_null($select_column_list)) { $select_column_list .= ', 555'; } i get 1064 - You have an error in your SQL syntax near ' 555pd.products_name, , 555, 555, 555pd.products_description, p.products_id, p.' at line 1 select p.products_image, , 555pd.products_name, , 555, 555, 555pd.products_description, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '2' order by pd.products_name limit 0, 20
  5. I see a few people have had this problem... 1064 - You have an error in your SQL syntax near ' pd.products_name, , , , pd.products_description, p.products_id, p.manufacturer' at line 1 select p.products_image, , pd.products_name, , , , pd.products_description, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '2' order by pd.products_name limit 0, 20 ...but i've replaced my general.php and index.php files and it's not worked. I know I shouldn't have the extra commas, but they're put in dynamically by the code. Does anyone know the fix? Is the bug brought in from one of the other includes? A
  6. I've been fiddling and put all files back the way the mod specifies. The advanced_search works (I know the page appears at the bottom, that's next on the list to fix, i know what the prob is there) - but the simple product_listing doesn't display the description, and is probably responsible for the jagged table display. Any clues will be throughly investigated. A
  7. Hi All WARNING: This site is not for the faint hearted, for others who can help, read on.... My truncated description is not appearing on the page http://www.musthavetoys.com/index.php?cPath=2 I have copied the product_listing.php page directly from the mod. I was having problems with formatting, so i took out // Products Description Hack begins if (PRODUCT_LIST_DESCRIPTION > 0) { $lc_params = 'rowspan="2" '; } // Products Description Hack ends from product_listing.php Don't know if it's related? Any ideas? Cheers Andy
  8. Hi All WARNING: This site os not for the faint hearted, for others who can help, read on.... My truncated description is not appearing in http://www.musthavetoys.com/index.php?cPath=2 I was having problems with formatting, so i took out // Products Description Hack begins if (PRODUCT_LIST_DESCRIPTION > 0) { $lc_params = 'rowspan="2" '; } // Products Description Hack ends Don't know if it's related? Any ideas? Cheers Andy
  9. seeing as it seems to be a problem (and i could be wrong) with the Nogift bit, i notice that in the module for nogift, i don't get the zones drop down like i do in the gift module. instead i get a text box with no description about what it is. is this what other people get?
  10. just noticed that my problem seems to be something to do with $quotes1. at this stage $quotes1_size = sizeof($quotes1); if ($quotes1_size > 1) { $quotes1_size turns out to be 1. It doesn't seem to be reading my "No Gift Wrap" option. Could be wrong, but if this helps someone help me... Andy
  11. damn, i'm a fool! needed to activate it in Modules-->Orders_Total Sorry.
  12. Hi Mark I'm getting the same error now. Seemed to happen for no reason. Aslo, I've lost my radio button to deselect gift wrapping. Did you find a solution? Andy
  13. this is what i get if i add the giftwrap facliity Sub-Total: ?57.00 Flat Rate (Best Way): ?0.01 Total: ?62.01 No idea why it isn't listing. I've had a rummage, but it SEEMS ok. Any suggestions?
×
×
  • Create New...