Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

aragorn108

Pioneers
  • Posts

    5
  • Joined

  • Last visited

Profile Information

  • Real Name
    Ole Hoppe

aragorn108's Achievements

  1. Hi David, are you sure you've loaded mod_rewrite in your Apache config file? This solved the problem for me. My problem is now that osC automatically switches to English language after switching to e.g. German and clicking on another product. Does that work for you? Kindly, Ole
  2. Dear Ryan, while continuing the testing, creating new user account yields error: Column customers_info.customers_info_source_id seems to be from another mod (2159, How Did You Hear About Us?). Is it correct to change /catalog/create_account.php, line 214 from tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_date_of_last_logon, customers_info_number_of_logons, customers_info_date_account_created, customers_info_date_account_last_modified, customers_info_source_id, customers_info_stores_id) values ('" . (int)$customer_id . "', now(), '1', now(), now(), '". (int)$source . "', '" . STORES_ID . "')"); to tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_stores_id) values ('" . (int)$customer_id . "', '0', now(), '" . STORES_ID . "')"); i.e. reverting to original 2.2ms2 source plus new column customers_info_stores_id? Or does M-S depend upon inserting this record with an implicit 1st logon like tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_date_of_last_logon, customers_info_number_of_logons, customers_info_date_account_created, customers_info_date_account_last_modified, customers_info_stores_id) values ('" . (int)$customer_id . "', now(), '1', now(), now(), '" . STORES_ID . "')"); Thanks for your feedback! Kindly, aragorn108
  3. Please see this post for suggested fix to Customer Group problem. Kindly, aragorn108
  4. Dear hobbzilla, thanks a lot for your great contribution! Could install it without problems on an original 2.2ms2 (apart from small MySQL/Apache/PHP/Filesystem configuration problems not originating from you contrib). While testing, seemingly found a small bug regarding M-S_pricing in /catalog/admin/customers.php: Customer's Group is not displayed for a customer and can also not be changed. Suggested Fix: Line 162, change 'customers_newsletter' => $customers_newsletter); to 'customers_newsletter' => $customers_newsletter, and add as new line 163 'customers_groups_id' => $customers_groups_id); // oh M-S_pricing Line 757, change $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by c.customers_lastname, c.customers_firstname"; to $customers_query_raw = "select c.customers_id, cg.customers_groups_name, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from (" . TABLE_CUSTOMERS . " c inner join " . TABLE_CUSTOMERS_GROUPS . " cg on c.customers_groups_id = cg.customers_groups_id) left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by c.customers_lastname, c.customers_firstname"; // oh M-S_pricing Hope this helps. Kind regards, aragorn108
  5. Could successfully install the Multi-Stores contrib (1730) on a fresh original osC 2.2ms2 (not the 051113 update) installation using MySQL 5.0.18, PHP 5.0.3, Apache 2.0.53, phpMyAdmin 2.7.0-pl2. No problems executing the update.sql script. But when clicking a category in the catalog, products would not display with an SQL error. After moving back to MySQL 4.4.10a products display nicely. While testing the MS contrib, seemingly found a bug :o : in Admin, when changing customer info, Customer Group setting is not remembered. Hope to fix the bug soon, though new to PHP, and little knowledgeable about osC, but with background as C++/Java developer. Cheers :rolleyes: , aragorn108
×
×
  • Create New...