Multi-Stores shop system for OSCMAX

[jpf]

Not sure what you mean -BEFORE OSCMax 2.0???

Changes.txt file:

Changelog
---------
v1.4 BTS - 04/24/07
Converted to BTS and for OSCMAX V2 RC3

Sounds like you did not follow the instructions in INSTALL.TXT.

In the temporary unzipped directory you will find an .sql file. This contains the
mysql configuration data for having the ability to have multiple stores. Please update
your database accordingly via however method you are most comfortable: phpmyadmin, etc.

I did not "write" the instruction - but the basics are correct.

[jpf]

I got the same problem, but I think the problem is caused by the Multi Store package (which I assume was coded for OSCMAX 1.4) is not compatible with OSCMAX 2.0.

Basically someone needs to work out the changes needed to add multistore to OSCMAX 2.0.

Please read the package docs.

In Changes.txt

Changelog
---------
v1.4 BTS - 04/24/07
Converted to BTS and for OSCMAX V2 RC3

[jpf]

I just installed osCMax v2_RC3_0_1 which seemed to work just fine. I did not make any changes to the install except to change the template from aabox to CSS-Fluid-1.

I then downloaded & installed multi-stores_v1_4MAX exactly as instructed in the 'install.txt' file included. I now get the following error when I choose from the category list on the opening page:

1054 - Unknown column 's.specials_id' in 'on clause'

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials_retail_prices s on p.products_id = s.products_id, products_to_categories p2c LEFT JOIN specials_to_stores s2s ON s.specials_id = s2s.specials_id INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '1' and p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1'

This only appears to happen when I attempt to go to the category products list from the menu. If I go directly to the product from the "What's New" listing everything works out just fine.

Since I am new to osCMax I assume I have not done something that would be taken for granted by others more familar with it. Please help.

Thanks in advance.

Did you follow the instructions? Like the part about loading the SQL file?

[mlloyd]

Yes I missed the part in the installation text refereing to OSCMAX2. Other than that I have followed the installation instructions which is fairly straightforward as I see it:

(1) Install Vanilla OSCMAX2_RC3_0_1
(2) Copy Multi-Store 1.4 files onto the server replacing any existing files
(3) Run the supplied Multi-Store 1.4 SQL to add new tables and alter existing ones.

I have now set up 3 test stores from scratch with separate databases.
londondeskshop.co.uk -----> Vanilla OSCMAX2_RC3_0_1
liverpooldeskhop.co.uk -----> OSCMAX2_RC3_0_1 with Multi Store and SQL updates
glasgowdeskhop.co.uk -----> OSCMAX2_RC3_0_1 with Multi Store but without SQL updates
(For future reference - you may not be able to see these test domains from July 2007 onwards)

The vanilla version (londondeskshop.co.uk) seems to work fine.
The multi-store version (liverpooldeskshop.co.uk) fails as described.
The multi-store version (glasgowdeskshop.co.uk) without SQL fails even to get started.

Now looking at the SQL that is failing in the "correctly" installed multi-store, the problem table specials_retail_prices (s) does not contain field categories_to_stores (clearly a multi-store related field). The update SQL provided does not alter the specials_retail_prices and its not a field included in vanilla OSCMAX2_RC3_0_1 so obviously that is never going to work.

The easy fix would be to use phpmyadmin to add the missing field but it does not give me much confidence that these changes have been tested. Adding the field will clearly stop this particular SQL problem, but my worry would be there may be more SQL problems downstream or the code might not be working as intended.

Now if you think I have installed it wrong please feel free to let me know where I have gone wrong.

[mlloyd]

Now looking at the SQL that is failing in the "correctly" installed multi-store, the problem table specials_retail_prices (s) does not contain field categories_to_stores (clearly a multi-store related field).

Sorry, getting my versions mixed up, this should read......

Now looking at the SQL that is failing in the "correctly" installed multi-store, the problem table specials_retail_prices (s) does not contain field specials_id.

[mlloyd]

Out of curiosity I added the missing specials_id field (on yet another instance of OSCMAX2 with Multi-Stores) and sure enough I got another SQL error, however this time the actual syntax of the failing SQL is invalid, not just out of sync with the table changes.

If jpf has actually got multi-stores working with OSCMAX2, I can only conclude that what has been included in the contribution is not what was working ....... unless I have really screwed up somewhere and I am missing something obvious.

Next Failure

1109 - Unknown table 'p2s' in where clause

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = p2s.products_id and p2s.stores_id = '1' and s2s.stores_id = '1' and s.specials_id = s2s.specials_id and pd.language_id = '1' and s.status = '1' and s.customers_group_id = '0' order by s.specials_date_added desc limit 10

[bkpie]

mlloyd

Did you resolve your problem? I am about to tackle this one and would like to side step any errors if possible.

[mlloyd]

bkpie

I didnt receive any further response from JPF, either to acknowledge the problem exists or to confirm that he is looking into it.

I have abandoned oscMAX for the moment - if you get anywhere with multi-store or JPF fixes it let me know. Maybe a fresh pair of eyes might help.

[sakwoya]

Hi all
with the unknown tables problems - there is an error in includes/boxes/specials.php the following is missed out twice:

, " . TABLE_PRODUCTS_TO_STORES . " p2s, " . TABLE_SPECIALS_TO_STORES . " s2s

so around line 32 the code should read:

// Line Edited: MOD - Multi-Stores V1.4
$random_product = tep_random_select("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s, " . TABLE_PRODUCTS_TO_STORES . " p2s, " . TABLE_SPECIALS_TO_STORES . " s2s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = p2s.products_id and p2s.stores_id = '" . STORES_ID . "' and s2s.stores_id = '" . STORES_ID . "' and s.specials_id = s2s.specials_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' and s.customers_group_id = '0' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS);
} else { // $sppc_customer_group_id is in the session variables, so must be set
// Line Edited: MOD - Multi-Stores V1.4
$random_product = tep_random_select("select p.products_id, pd.products_name, IF(pg.customers_group_price IS NOT NULL,pg.customers_group_price, p.products_price) as products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s LEFT JOIN " . TABLE_PRODUCTS_GROUPS . " pg, " . TABLE_PRODUCTS_TO_STORES . " p2s, " . TABLE_SPECIALS_TO_STORES . " s2s using (products_id, customers_group_id) where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = p2s.products_id and p2s.stores_id = '" . STORES_ID . "' and s2s.stores_id = '" . STORES_ID . "' and s.specials_id = s2s.specials_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' and s.customers_group_id= '".$customer_group_id."' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS);
}
if (tep_not_null($random_product)) {
// EOF Separate Price per Customer

Graeme

[jpf]

I will add this into the contribution when I get a chance. Some how I missed it and could not see the error.

Reposted for readablitiy

 // Line Edited: MOD - Multi-Stores V1.4
      $random_product = tep_random_select("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s, " . TABLE_PRODUCTS_TO_STORES . " p2s, " . TABLE_SPECIALS_TO_STORES . " s2s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = p2s.products_id and p2s.stores_id = '" . STORES_ID . "' and s2s.stores_id = '" . STORES_ID . "' and s.specials_id = s2s.specials_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' and s.customers_group_id = '0' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS);
  } else { // $sppc_customer_group_id is in the session variables, so must be set
// Line Edited: MOD - Multi-Stores V1.4
      $random_product = tep_random_select("select p.products_id, pd.products_name, IF(pg.customers_group_price IS NOT NULL,pg.customers_group_price, p.products_price) as products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s LEFT JOIN " . TABLE_PRODUCTS_GROUPS . " pg, " . TABLE_PRODUCTS_TO_STORES . " p2s, " . TABLE_SPECIALS_TO_STORES . " s2s using (products_id, customers_group_id) where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = p2s.products_id and p2s.stores_id = '" . STORES_ID . "' and s2s.stores_id = '" . STORES_ID . "' and s.specials_id = s2s.specials_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' and s.customers_group_id= '".$customer_group_id."' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS);
    }
 
  if (tep_not_null($random_product)) {
// EOF Separate Price per Customer 
  

If your posing php code use the [ php ] put code her [ /php ] (without spaces in the [] )


I have been swamped with other stuff lately - and on top of that just recently been without my main PC for 3 weeks , got that fixed then my DSL modem went for a vacation for a week...*%#@&!... Still have not had time to re-setup everything and to catch up.

I am not the original author - I just converted it to BTS and Max - I had it all setup and working on my main DEMO site just fine - but when I packaged it up and removed my customization (my lockdowns) I goofed up here. I restored my Demo site back prior to adding this after a few weeks. (Thus lost the working copy.)

I could not see where the problem was at first -- then I got way to busy about a month ago - then the PC/DSL problems.....

Still have not transfered my old project files to my new computer (I have been working on an old PC that was at least 6 to 7 years old - finally died)