Dhananjaya

What I discovered was that it is all a matter of what you do in what order. I found this problem went away when I copied Multi-Store right on top of OSC default before uploading it to the server and then running the install. Then I added the mysql updates piece by piece testing all the way. But they all are in and that error and lots of others are gone now. Only a few minor quirks to work out. Edward

I've used it a bit. Seems to work okay so far. Nothing special comes to mind as quirkly about it. That's how I migrated my products from my old ms1 store. If only there was a easypopulate for customers.

Yea that's what this contribution does down to the T really. You may have to set up shipping modules for each store in admin but the catalog and customer database are shared.

Hey Dave, Yea it's pretty damn short isn't it? What a pain in the... Usually it would be that you go to admin/includes/functions/sessions.php and look around line 13 for: if (STORE_SESSIONS == 'mysql') { if (!$SESS_LIFE = get_cfg_var('session.gc_maxlifetime')) { $SESS_LIFE = 86400; // was 1440 (24 minutes) As you can see I changed it from 1440 seconds to 86400 which according to my calculations is 24 hours instead of 24 minutes. But alas it had no effect whatsoever. So someone must have it set someplace else instead. I'll let you know if I find it. Edward

I'm pretty sure the solution is to change the name of your default Stores Config Table: to configuration. It's not said anywhere in the instructions that I can find but when I had the same problem as you and started poking around in the code I noticed the name of the configuration table is hard coded into the php as "configuration" and so it is either change a bunch of code or the name of your table. I chose to change the name of the table and Voila! it worked, at least as far as that goes. It seems you can name the other stores tables whatever you like. Please let me know if that works for you. Edward

Following up on what seems is not only my latest two posts but the latest two posts... So naturally I plug along somehow get the store up and running whilst hoping for some assistance soon. I will post my further findings for anyone who is inclined to assist or who has similar problem now or ever. I have narrowed the problem down further by starting with a working plain vanilla login.php and adding the differences in code line by line from the M-S 1.62 L login.php until it breaks and then commented out the offending line and continuing further. I have narrowed it to two lines of code each of which breaks it on its own and neither of which counter acts the other?s malice. I noted that they are related to two modules, B2B and Vendors and so I supposed that they may not work due to a deficiency in my setting up of those sections in the store. So I completely set up those sections. I tried the B2B section out with and without that line of code and found that it works with it and not without it. So since either your store is B2B or it isn?t and it seems you would?nt use the login.php at all if it was, so no harm to leave it commented out for a regular store and comment it in for a B2B store but I think the intention is for the button in admin the have that effect without editing code. Don?t know if it is just me or if it is a code flaw or what but life can go on like this. The actual line of code is in catalog/login.php around line 69, i.e. ?tep_session_register('order_taker'); //rmh M-S_b2b? and causes the following error after entering login and password, if B2B functionality is set to false, otherwise it works like it is supposed and keeps everyone out: Query was empty - Query was empty Query was empty [TEP STOP] Query was empty - Query was empty Query was empty [TEP STOP] Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0 On the other hand the vendors contribution doesn?t work with or without the line of code that breaks the login. I have set up vendors and fully turned it on and I have the zip data table in place but the boxes don?t display and no vendors display although there are buttons to press to search for vendors. Even if I create an account in the same zip code as the vendor, even if the max miles is set to 50 or 5000, still I get no choice of vendors. This is with or without the line of code in question live. However, if the line of code is in place in catalog/login.php around line 82, i.e. ?tep_session_register('vendors_affiliate_id');? (last line of M-S_vendor), it causes the following error after entering login and password. So for now it is commented out: Error! Unable to determine the page link! Query was empty - Query was empty Query was empty [TEP STOP] Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0 So it's working enought for now with some temporary or perhaps permanent patchwork but I would like to use Vendors someday. In the meantime I stumbled on a Froogle error whilst testing about and have to track down that next. Hopefully it just wants to be configured properly. Later on.. Edward

Never mind this part because it's not at all true; just me being confused about which lines to comment out and which ones not to comment out. The main or rest of the problem still persists.

Dear Ryan, I?m using multishop 1.62L or at least I am excited to be using it soon. I installed by first copying it on top of MS2 2 and then uploading the combined files. Then I installed MS2 as usual, then in imported the update.sql, then I imported the zipdata. Then I went into admin and configured. Everything went fine until I enabled SSL. I noticed that the SSL true false setting in admin ? configurations ? multistores does not effect my catalog; only the configure.php does. So I wonder if something is supposed to be commented out on the catalog configure.php like on the admin one so that the shop admin overrides the file. I also noticed that the problem goes away if I change three instances of SSL to NONSSL in login.php or replace it with the vanilla version. There are a lot of settings in this admin and it is likely that I have not set something right although for 12 hours now I have studied it and done my best. Here is the problem specifically. When I set /catalog/includes/configure.php ?define('ENABLE_SSL', true);?, then after entering the login and password on login.php the following shows up (/catalog/login.php/action/process) Query was empty - Query was empty Query was empty [TEP STOP] Query was empty - Query was empty Query was empty [TEP STOP] Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0 If I change SSL to false all is well, except I can?t do business. When I have made the login work by replacing or doctoring the login.php then the problem may come up in account_password.php, and sometimes even account.php. In these cases it usually manifests as: Fatal error: session_start() [function.session-start]: Failed to initialize session module in ...catalog/includes/functions/sessions.php on line 67 ?which as far as I can tell is pretty much the same problem, i.e. my sessions are mucked up. I have another heavily modified site (not multistore), on the same server but a different domain, different SSL certificate and it works fine. Another is on the same domain, same certificate, and is a fresh vanilla MS2 2 install and it works flawlessly. So I know it has to do with some contribution in the 162L pack but who knows what. On another possibly related issue, for some reason admin stops working and gives me the error below if I comment out ?define('DIR_FS_DOCUMENT_ROOT', ''); ? in /admin/configure.php like the instructions instruct me to. Perhaps this is all related somehow to something stupid I did or didn?t do in my set-up.: Warning: main(DIR_WS_LANGUAGESenglish.php): failed to open stream: No such file or directory in /.../multishop/admin/includes/application_top.php on line 192 Fatal error: main(): Failed opening required 'DIR_WS_LANGUAGESenglish.php' (include_path='') in /.../multishop/admin/includes/application_top.php on line 192 Any guidance, leads, clues, are all much appreciated. I searched the multi-shop thread as well as the whole forum for clues and read lots of stuff about people with similar problems and only scraps of suggestions how to solve it. But their problems and solutions were not applicable to my specific problem as far as I could tell through study and testing over 12 hours anyway. Thanks for a great contribution and all your support, Edward

In the installation instructions (INSTALL_ENG.TXT) for osCAffiliate v2.02 the following is given: ADMIN ALTERATIONS In index.php in the admin directory find line 13 approx require('includes/application_top.php'); and on a new line add the following code after it: require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); I'm no expert so it may be that this makes total sense but it just doesn't seem right to me so I thought I would post it and ask: Is this right? Anyway it hasn't caused anything to not work yet as far as I know.

Hello I would like to have the products display in four colums instead of three. How do I do that? Thank you for a great contribution. Dhananjaya

It is included in 1.6.2 loaded on hobzilla.com

I have a completely vanilla install of MS2 2 with 162 MS Loaded on top of it with the sql update and the ziplocator data too and I get the following error. I've started from sratch twice now. It breaks as soon as I add update.sql. Any clues? http://www.mydomain.com/catalog/admin/conf...iguration&gID=1 Warning: call_user_func(tep_get_orders_type_name): First argument is expected to be a valid callback in /home/www/mydomain/catalog/admin/includes/functions/general.php on line 1195

Yep, I did it again and I get the same error. I'm doing a fresh install of MS2 and it works like a charm. Then I just copy over 6 2 loaded on top of it and run the update.sql and its buggered. What's up with that. I know you don't have any bugs in this thing. There must be something I'm doing I'm not supposed to be or not doing that I am supposed to be doing. Any ideas?

Hello, I'm perplexed because I'm sure it works right out of the box and sure I followed the instructions and it doesn't work right out of the box. So I must have mucked up somewhere. I have installed ms2 2 successfully then just copied 62 loaded over that and updated the sql and Voila! I get the following error on the following page. http://www.mydomain.com/catalog/admin/conf...iguration&gID=1 Warning: call_user_func(tep_get_orders_type_name): First argument is expected to be a valid callback in /home/www/mydomain/catalog/admin/includes/functions/general.php on line 1195 Any ideas?

Is there any way to manually remove a sale from an affiliates sales or to manually add a sale to an affiliates sales? What if there is some mistake; how do you correct where sales belong?

What this means is that we need to have the first choice be the one for the lazy people. Something like "I don't remember" and then you can toss that data aside. Then using visitor stats contribution you can look to see if you know and edit the data base accordingly. Easier if we could edit it in account edit. I think for the ref= capture to be really complete it would have translate ref=2 to the name of the affiliate and also capture urls but the reports might get a bit messy with thousands of different urls from a single domain. I just use it as "how did you hear about us" as a back-up and/or confirmation when osc affiliate or visitor web stats doesn't capture the info for some reason. The ultimite will be when there is integration/syncronization of "how did you hear about us", osc affiliate, and visitor web stats so we can have central reporting.

In admin, report, customer order totals, I figure theres a lot of room in there to put a column for how did you hear about us so you can see easily where your money is coming from. So I copied the code from customers.php in there and Voila! Well almost. I didn't get any errors and something is happening. The column is filled with --none-- instead of the referrals. And I was looking forward to making a contribution for a change, albeit a tiny one. Anyway, if anyone would like to take a look at the code and see if you have any suggestions, perhaps I can begin to learn how to be productive around here. <?php /* $Id: stats_customers.php,v 1.31 2003/06/29 22:50:52 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script language="javascript" src="includes/general.js"></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_NUMBER; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td> <!--// referral --> <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_REFERRED_BY; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_PURCHASED; ?> </td> </tr> <?php if (isset($HTTP_GET_VARS['page']) && ($HTTP_GET_VARS['page'] > 1)) $rows = $HTTP_GET_VARS['page'] * MAX_DISPLAY_SEARCH_RESULTS - MAX_DISPLAY_SEARCH_RESULTS; $customers_query_raw = "select c.customers_firstname, c.customers_lastname, sum(op.products_quantity * op.final_price) as ordersum from " . TABLE_CUSTOMERS . " c, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS . " o where c.customers_id = o.customers_id and o.orders_id = op.orders_id group by c.customers_firstname, c.customers_lastname order by ordersum DESC"; $customers_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $customers_query_raw, $customers_query_numrows); // fix counted customers $customers_query_numrows = tep_db_query("select customers_id from " . TABLE_ORDERS . " group by customers_id"); $customers_query_numrows = tep_db_num_rows($customers_query_numrows); $rows = 0; $customers_query = tep_db_query($customers_query_raw); while ($customers = tep_db_fetch_array($customers_query)) { $rows++; if (strlen($rows) < 2) { $rows = '0' . $rows; } // rmh referral 1.3 $source_query = tep_db_query("select customers_info_source_id from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . $customers['customers_id'] . "'"); $source = tep_db_fetch_array($source_query); $entry_referral = tep_get_sources_name($source['customers_info_source_id'], $customers['customers_id']); // end rmh referral 1.3 ?> <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href='<?php echo tep_href_link(FILENAME_CUSTOMERS, 'search=' . $customers['customers_lastname'], 'NONSSL'); ?>'"> <td class="dataTableContent"><?php echo $rows; ?>.</td> <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CUSTOMERS, 'search=' . $customers['customers_lastname'], 'NONSSL') . '">' . $customers['customers_firstname'] . ' ' . $customers['customers_lastname'] . '</a>'; ?></td> <!--//-- rmh referral hack--> <td class="dataTableContent" align="left"><?php echo $entry_referral; ?></td> <!--//-- rmh referral hack--> <td class="dataTableContent" align="right"><?php echo $currencies->format($customers['ordersum']); ?> </td> </tr> <?php } ?> </table></td> </tr> <tr> <td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText" valign="top"><?php echo $customers_split->display_count($customers_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_CUSTOMERS); ?></td> <td class="smallText" align="right"><?php echo $customers_split->display_links($customers_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page']); ?> </td> </tr> </table></td> </tr> </table></td> </tr> </table></td> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Hey Ryan, I'm upgrading from 1.2 I love the display of referrals in customers.php; I didn't even expect it and have been dying for it. I have two questions. 1. How do I turn off the ref ID so the drop down always shows? 2. How do I make the other box only show when they select other, or at least that they can only type in the box when they have chosen other? Thank you Dhananjaya

Noel, I meant Noel when I said Steel in the last post. So I installed your contribution to this contribution and it basically works and I think it will really add value to an already essential contribution once it is all tweaked. I have some questions and concerns for you if you would please... (Anyone else feel free to respond - especially Ryan if you are available) 1. I don't understand what to do with this: CODE if ($info['customers_info_source_id'] ==4) { Refers to my Friend / CoWorker select box. And it will not taint your "other" category, it would just be some info the customer put down when signing up. 2. When I add new souces now I get source codes starting at 10000 and I remember reading Ryan's instructions not to go over 999. 3. I want to edit the source and source other in admin/customer.php edit customer mode so that I can tidy up my database by cleaning up their entries and changing their "others" to newly created sources. 4. In the customer listing on customers.php where the referrals are listed I am only getting the info from sources_other and not from sources. Is that the way you intended it or did I muck it up?

Hey Ryan, By the way I did eventually get this contribution to work. The error turned out to be in the cutting and pasting and not putting in a Carriage return where it ought to be. Anyway all is well. Thanks! Steel, You were in the midst of a upgrade that I really really want. I am in the middle of adding in your code and I get the impression that it is unfinished and you had more to do on it. Are you going to do anymore on it? Are you going to tidy it up and post it as a contribution?

I meant "except product_info.php" where of course I want the add to cart button to appear.

I can see by using this thing that it is quite a beast and a lot has gone into it and it is a great boon to OS2. Bravo Matti and everyone else who has brought it this far! Having said that I have some suggestions/requests for you Matti and everyone else capable for you to consider in your plans. 1. The usual instructions would be nice. This is a very difficult mod to install to an existing cart with certain other mods installed. Yikes! It isn't nearly as user friendly has other mods. One can't simple find the code to add to or replace cause there are no instructions and it is hard to find what to change because the files don't contain the all the original code anymore so you can find your way. The usual install instructions would be nice. 2. It doesn't play well with Quantity Price Breaks nor Easy Populate modified for quantity price breaks, at least not in my experience. It would be great if these were already integrated since they are both so important and popular and occupy the same code neighborhood and are thus very challenging to get to play nice with each other, unless you eat and drink php. 3. Here's a good one. Once you integrate Quantity Price Breaks, each slave can only be purchased according to its quantity block right. That's all I use it for anyway. I don't even use the price breaks. I just need to force buying in certain lot sizes. Anyway, now wouldn't it be sweet if those pull down quantity lists were according to those lots so that if your product came in lots of 6 for example it would give you a choice of 6, 12, 18, 24, etc. And while we are at it. It would be nice to be able to turn off the drop down for the master and just force it to one or at least default it to one. 3. Now the big wish. Wouldn't it be great if the master could be like a buyer's choice assortment that had a price and maybe included some certain free slaves such as a display for the assortment and also included so many slave products or so many dollars worth of the slaves to go into this free display and you could go in and pick what you wanted and it checked your math and forced you to get it right? Wouldn't it be great? That's what my customer wanted and it seems quite reasonable to him. Oh well. 4. This one you already know about, multiple masters for each slave so you don't have to put your products in two and three times under different model numbers. Ugh! Thanks for all you're doing! Cheers!

Does anyone know how to hide the add to cart button along with the price in the product listing on index and all other pages except product_listing.php for masters with zero prices? Much obliged for all assistance!

I managed to get it to work by using the easy populate 2.74 to put the data in and some other mod of this mod to get the price tiers to show up but then the thing doesn't work how i want anyway.

I'm having the same problem only I installed 1.11.1 I don't see where to add the price and quantity info and my store still looks the same. Did you ever figure it out?