Multi-Stores shop system for OSCMAX

[sakwoya]

Hi
No worries - I'm new to oscMax having been heavily involved in osCommerce before - I've just got diverted into trying to get one of the Computer Creation Contributions installed - when I finish that I'll get back onto this one.
graeme

[jpf]

Update posted at:

http://www.oscmax.com/projects/relea...r_oscmax_1_4_1

[simplex]

I haven't been around because of illness and do apologize for my early impatience.

I do very much appreciate all the work that has gone into resolving this glitch and will probably be around more often looking for other resolutions on these forums. I will be starting from scratch with a new install of osCMax v2 sometime this week and using the Multi-Store mod.

Question :

I will also be adding other mods such as a purchased pre-designed template, STS, Auto-stock-notification, etc.

Any suggestions as to which order to install these including Multi-Store?

Thanks

[simplex]

I have once again done a clean install of oscmax2_RC3_0_1 making sure everything worked correctly. I then installed multi-stores_v1_4_1MAX_0 and verified the new tables were edited after importing update.sql.

Everything works correctly except for the link from "Categories" which still gives the following error:

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'

I have no problems accessing the product from "What's New", "Specials" or "New Products for July".

I know very little about php and SQL databases are not really one of my strong suits either so I don't know how to figure out what is wrong.

Can anyone help me, Please?

Link to Demo site

Thanks in advance.

[BlackCap]

Any updates????

I have the same error/problem as simplex

[kris7845]

I had the same problem with the sql error but after doing some research and playing around i was able to fix it. from what i gathered the problem was/is in index.php with the syntax to make it php 5 compatible.

I referenced osCommerce: Error Message - 1054 - Unknown column 'p.products_id' in 'on clause' and did a few searches through the document to find the following code.

final_price from " .

and after verifying the line was not commented out I edited to

final_price from (" .

after making the addition but before moving to the next search i scrolled over till i found

p2c left join " . TABLE_SPECIALS

and changed it to

p2c ) left join " . TABLE_SPECIALS

once all the changes were made my categories loaded up fine. I only had a chance to check this on my xampp server but tomorrow I will upload it to my web server and see if it still works. Also i should note these changes were for php 5 but i only use php 4 so dunno why it was messing up.

Hope this helps any of you and if you need the index.php file i made please send an message or leave a post with instructions on uploading it to oscmax, still pretty new to this site.

[simplex]

Hi Kris7845

Have sent you a PM about your changes.

Thanks,
Simplex

[kris7845]

Just an update, there are more then just the index.php files that need to be edited, in total I found

\includes\classes\shopping_cart.php

And i also found some fixes for the 1045 error coming up in other areas such as articles

\templates\fallback\content\products_new.tpl.php
\templates\fallback\content\articles.tpl.php
\templates\fallback\content\advanced_search_result .tpl.php

I figured out how to start a project so you can download the files from

http://www.oscmax.com/projects/multi_shop_fixes_for_1045_sql_error

-Kris

[ericgtp313]

Hey Kris, when i try to go to the project I'm getting access denied. Am I doing something wrong or is it something on your end? I'd love to get these issues straightened out, looks like your fixes would help...

[kris7845]

Hey Kris, when i try to go to the project I'm getting access denied. Am I doing something wrong or is it something on your end? I'd love to get these issues straightened out, looks like your fixes would help...

Must be some security measure with the site? Maybe a mod can add it to the directory for people to download but until then i uploaded it to my site and you can download it from there.

http://www.consolerepairguides.com/o...hop_fixzip.zip

Mod please let me know if you add the file so i can take it down from my site.

-kris