Jump to content

ecartz

♥Ambassador
  • Content count

    3,312
  • Joined

  • Last visited

  • Days Won

    47

Everything posted by ecartz

  1. It works just fine for me. Are you using a pop up blocker? That could cause problems in some cases. What browser are you using? Hth, Matt
  2. ecartz

    Easy populate and image upload

    Claire, use a graphical FTP program like WS_FTP and you can upload by dragging the images, just like you would drag from folder to folder to copy to a floppy or simply a new folder. Usually the FTP program will need the same login info as the cPanel. Hth, Matt
  3. Dani, It sounds like you are missing some changes to checkout_process.php or includes/classes/order.php. The relevant changes involve using $attr_value Hth, Matt
  4. ecartz

    Virtual Mall 1.2 Support Thread

    I would try checking the query lines. That's where the restriction is. Also check that the store ID is being set by the login process properly. Hth, Matt
  5. Apparently you are using a version intended to be used with the Master Products contribution. Either switch to a different version, edit out the Master Products info, or install Master Products (if you want to use it). Hth, Matt
  6. ecartz

    Master Products - MS2

    To make the search results return the master rather than the slave product, I made the following changes to advanced_search_results.php. Add before line 223: $from_str .= " left join " . TABLE_PRODUCTS . " pm on pm.products_master = p.products_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pdm on pm.products_id = pdm.products_id"; Change line 223 from $where_str = " where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; to $where_str = " where p.products_status = '1' and p.products_listing_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and pdm.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; and around lines 258-9, change $where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'"; if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%'"; to $where_str .= "(pdm.products_name like '%" . tep_db_input($keyword) . "%' or pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'"; if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pdm.products_description like '%" . tep_db_input($keyword) . "%' or pd.products_description like '%" . tep_db_input($keyword) . "%'"; For efficiency, I also added a new index on the products_master column of the products table. Hth, Matt
  7. ecartz

    Orders not showing in admin

    Try enabling Force Cookie Use. If you are not using Force Cookie Use, then you have to make sure that the session ID is passed in some other way. Hth, Matt
  8. That is almost always caused by having a catalog file in the languages directory. Catalog files have require('includes/application_top.php'); in them. Hth, Matt
  9. ecartz

    Paymentech Module error

    http://wiki.oscommerce.com/WarnHeader treecomp.inc.php is the file that probably has the extra spaces (around line 168). Sometimes caused during upload. Make sure that it was uploaded as text or ASCII. Hth, Matt
  10. ecartz

    Checkout Disaster

    If the customer does not accept the cookie, then the site won't work. It will redirect to a cookie usage page. If you want to allow customers to refuse the cookie, then you should either build the return URL with tep_href_link or use tep_hide_session_id() to pass it as a parameter. Those changes would get made in the payment module in the process_button function. I'm not familiar with ViaKlix, so I'm not sure exactly which method to use. It depends on how they pass things. They should have a way of transferring the session ID: if it's as a hidden POST field, then use tep_hide_session_id; if it's part of the return URL (passed separately for each transaction instead of defined for the entire store once like PayPal does), then build the URL with tep_href_link. Hth, Matt
  11. ecartz

    Payflow Link module

    It would probably be in the process_button function of the payment module itself. Hth, Matt
  12. ecartz

    Checkout Disaster

    Try setting admin > Configuration > Sessions > Force Cookie Use to true. If that does it, either leave it that way or make sure that your payment processor uses a return URL that includes the session ID. Hth, Matt
  13. ecartz

    PayPal Insecure

    There is a contribution called the Downloads Controller for this. The problem is that the PayPal IPN does not guarantee that the order will be authorized/declined by the time that it reaches checkout_process.php and checkout_process.php has no way of waiting. Hth, Matt
  14. ecartz

    Check/Money Order module

    includes/languages/english/modules/moneyorder.php (or whatever language). I may have the module name wrong. It's been a while since I have looked at it. Hth, Matt
  15. ecartz

    Master Products - MS2

    I think that this means the product is set to a quantity of 1 in the database. If you change the products_quantity to 20 or more, it should allow people to select more. If that's not how you want it to work, you could also change the behavior directly in includes/modules/master_listing.php. There is discussion about how it was added earlier in the thread (also, you can compare against the original version of the contribution). Hth, Matt
  16. http://forums.oscommerce.com/index.php?showtopic=57259 may help you. There are about 20 pages of discussion of various problems that can occur with the Option Type Feature. Hth, Matt
  17. You should be able to use it as is. You just won't be able to specify the option type in easy populate. If you need to be able to specify the option type, you could add an extra column and adjust the walk function to handle it. Cheers, Matt
  18. ecartz

    Orders not showing in admin

    It should be redirected to checkout_process.php, not checkout_success.php (process will redirect success). Also make sure that if you are not forcing cookie use (admin > Configuration > Sessions > Force Cookie Use), that the link is built with tep_href_link or the session ID is included in some other way. Hth, Matt
  19. There has to be a problem with the product_info changes then. Hth, Matt
  20. ecartz

    Is there a contribution that....

    The simplest way is to put it in a spreadsheet and calculate the price in the spreadsheet. Then remove the cost and markup columns and upload with Easy Populate. Hth, Matt
  21. ecartz

    Offsite Payment module logs out user

    Either set FORCE_COOKIE_USE to true or add the session ID to the return URL. If you use tep_href_link, it will add the session ID for you. Hth, Matt
  22. ecartz

    Easy Populate Model Number too long

    Easy Populate uses the products_model field to tell the difference between products. If you leave it blank, it reads something else as the products_model. This produces odd effects. You should always assign unique products_model values when using Easy Populate. Hth, Matt
  23. You may want to try the following SQL: INSERT INTO `configuration_group` (`configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES ('Import/Export', 'Configuration values for the Import/Export Module', 17, 1); SET @configuration_group_id = LAST_INSERT_ID(); INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', @configuration_group_id, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Text product option type', 'PRODUCTS_OPTIONS_TYPE_TEXT', '1', 'Numeric value of the text product option type', 6, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Radio button product option type', 'PRODUCTS_OPTIONS_TYPE_RADIO', '2', 'Numeric value of the radio button product option type', 6, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Check box product option type', 'PRODUCTS_OPTIONS_TYPE_CHECKBOX', '3', 'Numeric value of the check box product option type', 6, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('File product option type', 'PRODUCTS_OPTIONS_TYPE_FILE', '4', 'Numeric value of the file product option type', 6, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('ID for text and file oroducts options values', 'PRODUCTS_OPTIONS_VALUE_TEXT_ID', '0', 'Numeric value of the products_options_values_id used by the text and file attributes.', 6, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', @configuration_group_id, NULL, now(), now(), NULL, NULL); INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', @configuration_group_id, NULL, now(), now(), NULL, NULL); Hth, Matt
  24. ecartz

    Master Products - MS2

    Browse the table - we are looking for the highest entry for 'configuration_id' - change '16' in the master.sql file to one higher.This problem can be avoided by changing the SQL file to INSERT INTO configuration_group VALUES ('', 'Slave Products', 'Slave Product Listing - configuration options', 16, 1); SET @configuration_group_id = LAST_INSERT_ID(); INSERT INTO configuration VALUES ('', 'Display Slave Product Name', 'MASTER_LIST_NAME', '5', 'Do you wish to display the products name?', @configuration_group_id, 1, '2003-11-17 20:22:53', '2003-11-04 23:28:38', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display Slave Product Price', 'MASTER_LIST_PRICE', '13', 'Do you want to display the Product Price?', @configuration_group_id, 3, '2003-11-16 20:47:55', '2003-11-04 23:28:38', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display Slave Product Manufacturer Name', 'MASTER_LIST_MANUFACTURER', '0', 'Do you want to display the Product Manufacturer Name?', 16, 4, NULL, '2003-11-04 23:28:38', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display Slave Product Image', 'MASTER_LIST_IMAGE', '0', 'Do you want to display the Product Image?', @configuration_group_id, 8, '2003-11-10 21:38:06', '2003-11-04 23:28:38', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display Slave Product Model', 'MASTER_LIST_MODEL', '1', 'Do you want to display the Product Model?', @configuration_group_id, 2, '2003-11-16 22:10:58', '2003-11-04 23:28:38', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display Slave Product Quantity', 'MASTER_LIST_QUANTITY', '0', 'Do you want to display the Product Quantity?', @configuration_group_id, 6, '2003-11-09 22:49:47', '2003-11-04 23:28:38', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display Slave Product Weight', 'MASTER_LIST_WEIGHT', '0', 'Do you want to display the Product Weight?', @configuration_group_id, 5, NULL, '2003-11-04 23:28:38', NULL, NULL); INSERT INTO configuration VALUES ('', 'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'MASTER_PREV_NEXT_BAR_LOCATION', '2', ' Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', @configuration_group_id, 12, '2003-11-10 01:02:58', '2003-11-04 23:28:38', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display the Buy Now Column', 'MASTER_LIST_BUY_NOW', '10', 'Do you want to display the Buy Now column?', @configuration_group_id, 9, '2003-11-12 19:02:59', '2003-11-09 20:38:04', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display Slave Product Description', 'MASTER_LIST_DESCRIPTION', '2', 'Set to 0 to disable, set to 99 to enable.', @configuration_group_id, 10, '2003-11-17 19:02:49', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Length of Truncated Product Description', 'MASTER_LIST_DESCRIPTION_LENGTH', '100', 'How many characters would you like to display?', @configuration_group_id, 11, '2003-11-10 23:36:52', '2003-11-10 18:51:26', NULL, NULL); ALTER TABLE products ADD products_master int(11) NOT NULL default '0'; ALTER TABLE products ADD products_master_status tinyint(2) NOT NULL default '0'; ALTER TABLE products ADD products_listing_status tinyint(2) NOT NULL default '1'; Then one doesn't need to worry about synchronizing the rows in the configuration and configuration_group tables manually. Hth, Matt
  25. ecartz

    SQL error after installing Download Controller

    should be order by *something* limit 0,20. This usually means that there was an error making the edits for the contribution. Look for code that says something like . "' order by " . $something The string would then get passed to the split_listing_class, where the limit is added. Hth, Matt
×