Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

kgt

Archived
  • Posts

    2,878
  • Joined

  • Last visited

  • Days Won

    2

Everything posted by kgt

  1. You almost certainly can, but the installations will certainly step over each other at some points. Generally, when the instructions tell you to add a line, you should add it. When the instructions tell you to change a line, you need to compare your code against the changed code to determine what the line should really be. After you install min order, you will be editing some of the same code to install max order, so you need to be careful that you don't overwrite min order changes.
  2. What about this? http://www.oscommerce.com/community/contributions,716
  3. Is this the contribution? http://www.oscommerce.com/community/contributions,2583 If so, then I suggest you read the page very carefully. It has instructions on the page.
  4. You must have installed another contribution. SPPC doesn't modify products_attributes.php. Post the contenst of admin/products_attributes.php so we can see what it looks like.
  5. The instructions are provided by the people who post contributions. Normally they are included as a text file in the .zip file you download.
  6. Probably not until you post a link to your site. We can't see what you're seeing, so asking someone to debug a layout/format issue without a link to the HTML that is being produced won't get you very many answers.
  7. The drop shadow contribution (I couln't find any others, so I assume I'm looking at the one you used: http://www.oscommerce.com/community/contributions,2564) only replaces the includes/classes/boxes.php file. It sounds like you installed some sort of category contribution that changed the includes/classes/boxes.php file, then wiped out those changes by uploading the drop shadow version. You will need to identify all the contributions you have installed.
  8. That's generally a catch-all error. It tells you that more information may be found in the server logs. This is where you need to look. If your host has CPanel, you can probably find the server error logs there.
  9. Look at the download list. There are 6 versions called simply "2". Which one do you have?
  10. Needs to be UK\'s largest stocks of fabric available to buy online!
  11. This code is unnecessarily running a query for each customer. If you have enough customers, you can indeed use too many connections. Edit customer_export.php as follows: line 46: select c.*, adb.*, co.countries_name from customers as c left join address_book as adb on c.customers_id = adb.customers_id left join countries as co on co.countries_id=adb.entry_country_id line 58-67: /*if ($row[entry_country_id] == 81) { $land="Deutschland"; } else { $country_query = mysql_query("select countries_name from countries where countries_id = '" . $row[entry_country_id] . "';"); $landq = mysql_fetch_array($country_query); $land=$landq[countries_name]; }*/ line 79: $contents.=$row['countries_name'].","; (By the way: MySQL is not crashing. It is giving you a completely normal error based on limits specified by your host.)
  12. For any of these contributions, you should be able to modify them to display only subcategories of the current category: http://www.oscommerce.com/community?contri...wn&category=all See specifically this one: http://www.oscommerce.com/community/contributions,2112
  13. kgt

    payment module error

    1. What payment module? Which exact contribution if it's a contribution? 2. What exactly happens when you try to check out? (What exact PAGE does it fail on?) 3. If there are errors, what are the EXACT errors?
  14. Looks like you missed the step where you add TABLE_FAQ to the includes/database_tables.php file.
  15. Is this the actual code from catalog/advanced_search_result.php? I see nothing wrong with it.
  16. That query will not help you at all...it may be the same error code, but it's not the same error. It's hard to tell what the query should be. I don't use the contribution, so I'm not sure what it's supposed to be, but I see no reason why you'd need to join products_description twice. You'd need to change the code to remove the part in bold: select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%slap%' or p.products_model like '%slap%' or m.manufacturers_name like '%slap%' or p2pef.products_extra_fields_value like '%slap%') ) You would have to do this in your code, so it will of course look different. This is a guess, so perhaps someone else knows for sure.
  17. There's nothing wrong with your tables. There's something wrong with the actual query. Revisit the Products Extra Fields contribution installation and make sure you have followed the directions correctly (this looks like a search query, so look for installation instructions for advanced_search.php).
  18. $suboptions = tep_db_query("SELECT DISTINCT POV.products_options_values_id, POV.products_options_values_name FROM products_options_values POV, products_options_values_to_products_options POVtoPO WHERE language_id = '" . $languages_id . "' AND POVtoPO.products_options_id = '" . $options_values['products_options_id'] . "' AND POVtoPO.products_options_values_id = POV.products_options_values_id ORDER BY POV.POV.products_options_values_id"); should be $suboptions = tep_db_query("SELECT DISTINCT POV.products_options_values_id, POV.products_options_values_name FROM products_options_values POV, products_options_values_to_products_options POVtoPO WHERE language_id = '" . $languages_id . "' AND POVtoPO.products_options_id = '" . $options_values['products_options_id'] . "' AND POVtoPO.products_options_values_id = POV.products_options_values_id ORDER BY POV.products_options_values_id");
  19. http://www.oscommerce.com/community/contributions,282 http://www.oscommerce.com/community/contributions,204
  20. I believe PDFlib is unicode-capable. http://pecl.php.net/package/pdflib
  21. Correct. Please reread the posts. They explain why this is happening.
  22. More information may be found here: http://www.google.com/search?hl=en&q=site%...G=Google+Search
  23. Check again. I've never seen this error happen for any other reason. Double-check the files in the contributions, and make sure the corresponding language files for all are NOT code files.
×
×
  • Create New...