Jump to content

iTea

♥Ambassador
  • Content count

    37
  • Joined

  • Last visited

Everything posted by iTea

  1. iTea

    AJAX Attribute Manager support

    Same here, an error is generated when opening a product in admin by this code in requester.js: /* Execute the action which has been associated with the completion of this object */ Requester.prototype.executeAction = function() { // If XMLHR object has finished retrieving the data if (this.commInterface.readyState == 4) { // If the data was retrieved successfully try { if (this.commInterface.status == 200) { this.responseText = this.commInterface.requestXML; this.action(); } // IE returns status = 0 on some occasions, so ignore else if (this.commInterface.status != 0){ alert("There was an error while retrieving the URL: " + this.commInterface.statusText); } } catch (error){} } return true; } Fiddled around with XMLHttpRequest, Access-Control-Allow-Origin header '*' and more, but can't get it right. We're using SSL, exempted the Attribute Manager map from redirect, but that doesn't work either.
  2. iTea

    [Addon] Shopping List

    5.5.21 (Zend: 2.5.0) with MySQL 5.6.23 I don't know the reason for the $products_id thing. The small change at that place in the class solved my problem at least. It doesn't seem to affect anything else, I can add products to the list, delete lists, put them in the cart and so on.
  3. iTea

    [Addon] Shopping List

    And another (probably) small thing, products with special characters like ' don't like to be listed (in our test shop): 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Cut', '1' )' at line 11 insert into shopping_list_products ( shopping_list_id, products_id, products_name, products_quantity ) values ( '4', '5', 'Blade Runner - Director's Cut', '1' )
  4. iTea

    [Addon] Shopping List

    The $products_id in the class is killing me (for some reason): $shopping_list_array[$products_id]['attributes'][] = array ( 'products_options_id' => $attributes['products_options_id'], 'products_options_value_id' => $attributes['products_options_value_id'], 'products_options_name' => $attributes_values['products_options_name'], 'products_options_values_name' => $attributes_values['products_options_values_name'], 'products_options_values_price' => $attributes_values['options_values_price'], 'products_options_price_prefix' => $attributes_values['price_prefix'] When I substitute it for $shopping_list_products_id like in $shopping_list_array[$shopping_list_products_id] = array ( 'products_id' => $shopping_list['products_id'], 'shopping_list_products_id' => $shopping_list_products_id, 'products_image' => $shopping_list['products_image'], 'products_name' => $shopping_list['products_name'], 'products_quantity' => $shopping_list['products_quantity'], 'products_price' => $shopping_list['products_price'], 'specials_new_products_price' => $shopping_list['specials_new_products_price'], 'specials_status' => $shopping_list['specials_status'], 'products_tax_class_id' => $shopping_list['products_tax_class_id'] ); the problem goes away immediately, resulting in one product in the shopping list attributes included.
  5. iTea

    [Addon] Shopping List

    Love the idea of this addon. But we're experiencing some problems on a (modified) regular 2.3.4. store. Products with attributes get two entries in the shopping list: one with a picture, the product name, and everything else and one with an empty picture, the stock check, all attribute(s) and everything else, as if the attributes are a product by themselves, If you add another product with another attribute, there is a new entry for the product but the new attribute is combined with the existing attributes in the attribute entry. Very strange indeed! Also, the shopping_list_attributes_id in the shopping_list_products table remains 0, although I'm not sure it is actually being used.
  6. I'm hesitating to ask, but will do it nevertheless: where can I find Display the products in this category: selection set to Detailed table mode (include Specification columns). I will look into the select to compare code, after I get the basics up and running, sounds promising though!
  7. Thanks for the pointers! The comparison bit in index.php seemed to be too far down, should be inside the if statement where product_listing is included I think, or maybe even in the product_listing module itself? The setting Comparison Row in Table can't do anything now I think, since the product_listing module in the download appears to be identical to the stock product_listing module. Do I undertand correctly that a table is produced that shows the specs for all the products in a specific (sub)category? However, there are no identifiers in my table. Played around with the Spec Combos since I presume they do something with these identifiers so that you produce a sort of enhanced product listing? No success so far. Did you ever consider to make some tick boxes in product listing, to directly compare two or three products on their specs?
  8. Yep, when you found it... it's sometimes difficult to search for problems which are not clearly defined by error messages. What do you search for, "there's something wrong", lots of results, lots to read! We've never been able to get the comparison part up and running, have two products, each with two specs with two values each, within the same category. Specs are showing up, filtering works, but no comparison link in product_listing or product_info to be found. Products are two deep (dvd movies - action). Products Comparison Page Subhead Minimum Spec Comparison 2 Show More True Show Empty Products True Comparison Link in Index True Comparison Row in Table top Show Comparison True Comparison in Index False Comparison Suffix in Header True Comparison Box Style Simple Spec Combo Manufacturer 0 Spec Combo Weight 0 Spec Combo Price 0 Spec Combo Model 1 Spec Combo Image 3 Spec Combo Name 2 Spec Combo Buy Now 4 The product_listing file in PS 1.1.11 is identical to stock osC, there seems to be nothing different. $current_category_id can be echoed. Any suggestions?
  9. Oops, found it: http://forums.oscommerce.com/topic/344692-contribution-products-specifications/page-42#entry1682713. Thanks!
  10. We're experiencing some strange problems with PS 1.1.11 on osC 2.3.4.: The admin PS tabs are not working properly, there is a line with tabs, but the tabs are empty, directly below the line of tabs, the admin page (with graphs) is "reloaded", and below that the content of the tabs is displayed in stock osC layout. The left column admin controls are not working anymore. Is there a problem with two tab-series in one page, one for the admin controls and one for PS? Same thing seems to happen in the front side.
  11. iTea

    Credit Class & Gift Vouchers for 2.3.4

    I'm not sure what you are referring to...
  12. iTea

    Credit Class & Gift Vouchers for 2.3.4

    Did a CCGV drop on a fresh osC 2.3.4 install, seems to be working. Couple of small things though. Does anyone know how we can update the old school <?php echo tep_image_submit('button_back.gif', IMAGE_BUTTON_BACK, 'name=back') . '</a>'; ?> in gv_send.php?action=send referring back to the filled-in form of gv_send.php?action=process to a nice jquery button? Tried tep_draw_button(IMAGE_BUTTON_BACK, 'triangle-1-w', 'javascript:history.back(-1)'), but that doesn't work, like the back button on the browser doesn't work for this purpose.
  13. iTea

    Google XML Sitemap SEO

    When I run the select function GenerateCategorySitemap(){ $quotes = (defined('QUOTES_CATEGORY_NAME') ? " where cd.categories_name NOT LIKE '" . QUOTES_CATEGORY_NAME . "' " : ''); $sql = "SELECT c.categories_id as cID, c.date_added, c.last_modified as last_mod FROM " . TABLE_CATEGORIES . " c left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on c.categories_id = cd.categories_id " . $quotes . " ORDER BY c.parent_id ASC, c.sort_order ASC, c.categories_id ASC"; in phpmyadmin I do get the same repetition, two (languages) for each category. The manufacturers select is language independent: function GenerateManufacturerSitemap(){ $sql = "SELECT manufacturers_id as mID, date_added, last_modified as last_mod, manufacturers_name FROM " . TABLE_MANUFACTURERS . " order by manufacturers_name DESC";
  14. iTea

    Google XML Sitemap SEO

    We've got your url-rewriter up and running. Turned it off, reset the caches, but it didn't seem to make a difference. We've got two languages, our default language had an ID of 2, instead of 1, could that be of significance?
  15. iTea

    Google XML Sitemap SEO

    Dear Jack, Installed your add-on, seems to be working. However, the category links are all doubled, so two identical links to the same category in the default language directly below each other. The product links are all single by the way. Do you have an idea what can cause this?
  16. iTea

    All Products SEO

    We do that now in our product_listing and product_info. Products prices are all zero, attribute has full price. We don't have that many products, maybe two hundred. Will try to edit your contribution. If you could point us in the right direction, it would be greatly appreciated!
  17. iTea

    All Products SEO

    We're considering your add-on for a wholesale shop but were wondering if you have some ideas about including attribute-prices in the pricelist.
  18. iTea

    AJAX Attribute Manager support

    Installed AAM 2.8.2. on an almost fresh osC 2.3.3. Getting lots of warnings like: Strict Standards: Non-static method amDB::query() should not be called statically, assuming $this from incompatible context in ......\attributeManager\classes\attributeManagerConfig.class.php on line 143 Strict Standards: Non-static method amDB::query() should not be called statically, assuming $this from incompatible context in ......\attributeManager\classes\attributeManagerConfig.class.php on line 148 Strict Standards: Non-static method amDB::query() should not be called statically, assuming $this from incompatible context in ......\attributeManager\classes\attributeManagerConfig.class.php on line 167 Strict Standards: Non-static method amDB::fetchArray() should not be called statically, assuming $this from incompatible context in ......\attributeManager\classes\attributeManagerConfig.class.php on line 168 Strict Standards: Non-static method amDB::fetchArray() should not be called statically, assuming $this from incompatible context in ......\attributeManager\classes\attributeManagerConfig.class.php on line 168 Strict Standards: Non-static method amDB::fetchArray() should not be called statically, assuming $this from incompatible context in ......\attributeManager\classes\attributeManagerConfig.class.php on line 168 Strict Standards: Non-static method amDB::fetchArray() should not be called statically, assuming $this from incompatible context in ......\attributeManager\classes\attributeManagerConfig.class.php on line 168 Strict Standards: Non-static method amDB::fetchArray() should not be called statically, assuming $this from incompatible context in ......\attributeManager\classes\attributeManagerConfig.class.php on line 168 Someone got an idea?
  19. iTea

    Official PayPal IPN Support Thread

    Using the recently installed v2.2 we have the problem that osC-order status remains Preparing [PayPal IPN] and (probably) therefore no confirmation emails are send. The Paypal transaction is completed however, since we receive payment in our PayPal-account. No changes in default PayPal-profile settings are made. Does anyone have an idea?
  20. iTea

    More email problems (or not?)

    Sorry, wrong thread!
  21. Is Multi Stores compatible with MySQL 5? I get this error again and again when I run update.sql in phpMyAdmin 2.7.0-pl1. I used a fresh local osC-installation, Multi-Stores 1.7, php 4.4.1. ########################### # //rmh M-S_multi-stores # ########################### CREATE TABLE administrators ( administrators_id int(11) NOT NULL auto_increment, administrators_distributors_id int(11) NOT NULL DEFAULT '0', administrators_username varchar(20) NOT NULL DEFAULT '', administrators_password varchar(40) NOT NULL DEFAULT '', administrators_allowed_pages varchar(255) NOT NULL DEFAULT '', administrators_allowed_stores varchar(255) NOT NULL DEFAULT '', administrators_selected_stores_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (administrators_id), UNIQUE KEY administrators_username (administrators_username) ); INSERT INTO `administrators` VALUES (1, 0, 'admin', '21232f297a57a5a743894a0e4a801fc3', '*', '*', 1); CREATE TABLE categories_to_stores ( categories_id int NOT NULL, stores_id int NOT NULL, PRIMARY KEY (categories_id,stores_id) ); CREATE TABLE distributors ( distributors_id int(11) NOT NULL auto_increment, distributors_name varchar(32) NOT NULL DEFAULT '', distributors_email_address varchar(96) DEFAULT NULL, date_added datetime DEFAULT NULL, last_modified datetime DEFAULT NULL, PRIMARY KEY (distributors_id), KEY IDX_MANUFACTURERS_NAME (distributors_name) ); CREATE TABLE languages_to_stores ( languages_id int NOT NULL, stores_id int NOT NULL, PRIMARY KEY (languages_id,stores_id) ); INSERT INTO languages_to_stores VALUES (1, 1); INSERT INTO languages_to_stores VALUES (2, 1); INSERT INTO languages_to_stores VALUES (3, 1); CREATE TABLE manufacturers_to_stores ( manufacturers_id int NOT NULL, stores_id int NOT NULL, PRIMARY KEY (manufacturers_id,stores_id) ); CREATE TABLE products_to_stores ( products_id int NOT NULL, stores_id int NOT NULL, PRIMARY KEY (products_id,stores_id) ); CREATE TABLE stores ( stores_id int NOT NULL auto_increment, stores_name varchar(64) NOT NULL DEFAULT '', stores_image varchar(64), stores_url varchar(255) DEFAULT NULL, stores_config_table varchar(64) NOT NULL, stores_status tinyint(1) NOT NULL, date_added datetime, last_modified datetime, PRIMARY KEY (stores_id), UNIQUE (stores_config_table) ); INSERT INTO stores (stores_id, stores_name, stores_image, stores_url, stores_config_table, stores_status, date_added) VALUES ('1', 'Default', 'oscommerce.gif', 'http://localhost/catalog/', 'configuration', '1', '2006-01-23'); ALTER TABLE categories ADD distributors_id int DEFAULT '0' NOT NULL; ALTER TABLE customers_basket ADD customers_basket_stores_id int NOT NULL AFTER customers_basket_date_added; ALTER TABLE customers_basket_attributes ADD customers_basket_stores_id int NOT NULL AFTER customers_id; ALTER TABLE customers_info ADD customers_info_stores_id int AFTER customers_info_date_account_last_modified; ALTER TABLE orders ADD orders_stores_id int DEFAULT '1' NOT NULL AFTER orders_date_finished; ALTER TABLE orders_products ADD products_distributors_id int DEFAULT '0' NOT NULL AFTER products_quantity; ALTER TABLE products ADD distributors_id int DEFAULT '0' NOT NULL AFTER manufacturers_id; ALTER TABLE specials ADD stores_id int DEFAULT '0' NOT NULL AFTER status; INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Stores ID', 'STORES_ID', '1', 'The id of my store', '6', '0', '2006-01-23'); INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('16', 'Multi-Stores', 'Multi-Stores Options', '16', '1'); INSERT INTO configuration VALUES ('', 'Store Catalog Website URL', 'HTTP_CATALOG_SERVER', '', 'http://localhost/catalog', 16, 1, '2006-01-23', '2006-01-23', NULL, NULL); INSERT INTO configuration VALUES ('', 'Store Catalog Website SSL URL', 'HTTPS_CATALOG_SERVER', '', '', 16, 2, '2006-01-23', '2006-01-23', NULL, NULL); INSERT INTO configuration VALUES ('', 'Enable SSL Store Catalog', 'ENABLE_SSL_CATALOG', 'false', 'Enable SSL links for Store Catalog', 16, 3, '2006-01-23', '2006-01-23', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES ('', 'Store Catalog Website Path', 'DIR_WS_CATALOG', '', '/catalog', 16, 4, '2006-01-23', '2006-01-23', NULL, NULL); INSERT INTO configuration VALUES ('', 'Store Catalog Filesystem Path', 'DIR_FS_CATALOG', '', 'F:\WWW\catalog', 16, 5, '2006-01-23', '2006-01-23', NULL, NULL); INSERT INTO configuration VALUES ('', 'Store Catalog Website Images Path', 'DIR_WS_CATALOG_IMAGES', '', 'images/)', 16, 6, '2006-01-23', '2006-01-23', NULL, NULL); INSERT INTO configuration VALUES ('', 'Store Catalog Website Languages Path', 'DIR_WS_CATALOG_LANGUAGES', '', 'includes/languages/', 16, 7, '2006-01-23', '2006-01-23', NULL, NULL); INSERT INTO configuration VALUES ('', 'Store Catalog Filesystem Languages Path', 'DIR_FS_CATALOG_LANGUAGES', '', 'F:\WWW\catalog\includes\languages\', 16, 8, '2006-01-23', '2006-01-23', NULL, NULL); INSERT INTO configuration VALUES ('', 'Store Catalog Filesystem Images Path', 'DIR_FS_CATALOG_IMAGES', '', 'F:\WWW\catalog\images\', 16, 9, '2006-01-23', '2006-01-23', NULL, NULL); INSERT INTO configuration VALUES ('', 'Store Catalog Filesystem Modules Path', 'DIR_FS_CATALOG_MODULES', '', 'F:\WWW\catalog\includes\modules\', 16, 10, '2006-01-23', '2006-01-23', NULL, NULL); ########################### # //rmh M-S_pricing # ########################### CREATE TABLE customers_groups ( customers_groups_id int NOT NULL auto_increment, customers_groups_name varchar(32) NOT NULL DEFAULT '', PRIMARY KEY (customers_groups_id) ); INSERT INTO customers_groups (customers_groups_id, customers_groups_name) VALUES ('1', 'Retail'); INSERT INTO customers_groups (customers_groups_id, customers_groups_name) VALUES ('2', 'Wholesale'); CREATE TABLE products_price_schedules ( products_price_schedules_id int NOT NULL auto_increment, products_id int DEFAULT '0' NOT NULL, customers_groups_id int DEFAULT '0' NOT NULL, products_groups_price decimal(15,4) DEFAULT '0.0000' NOT NULL, products_groups_price_qty int(11) DEFAULT '0' NOT NULL, stores_id int DEFAULT '0' NOT NULL, PRIMARY KEY (products_price_schedules_id) ); ALTER TABLE customers ADD customers_groups_id int DEFAULT '1' NOT NULL AFTER customers_id; ALTER TABLE customers ADD customers_tax_exempt char(1) DEFAULT '0' NOT NULL AFTER customers_newsletter; ALTER TABLE orders ADD customers_tax_exempt char(1) DEFAULT '0' NOT NULL AFTER customers_address_format_id; ALTER TABLE products ADD products_qty_blocks int DEFAULT '1' NOT NULL AFTER products_price; INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Default Customer Group', 'DEFAULT_CUSTOMER_GROUP', '1', 'The Customer Group a new member is assigned to', '5', '7', 'tep_cfg_get_customer_group', 'tep_cfg_pull_down_cg_list(', '2006-01-23'); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) VALUES ('Visitor Pricing Group', 'VISITOR_PRICING_GROUP', '0', 'The Customer Group pricing for guests (Hide Prices = Must login to see pricing & default = Default osCommerce)', '5', '8', 'tep_cfg_get_customer_group', 'tep_cfg_pull_down_vg_list(', '2006-01-23'); ########################### # //rmh M-S_fixes # ########################### INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('New Products', 'MIN_DISPLAY_NEWPRODUCTS', '1', 'Minimum number of products to display in the \'New Products\' box', '2', '18', '2006-01-23'); ALTER TABLE whos_online CHANGE last_page_url last_page_url VARCHAR(255) NOT NULL default ''; This is what phpMyAdmin reports: SQL-query: INSERT INTO configuration VALUES ('', 'Store Catalog Website URL', 'HTTP_CATALOG_SERVER', '', 'http://localhost/catalog', 16, 1, '2006-01-23', '2006-01-23', NULL , NULL); MySQL retourneerde: #1264 - Out of range value adjusted for column 'configuration_id' at row 1 Can my MySQL-settings be wrong? It must be something smal I'm not seeing...
×