osCmax v2.5 User Manual
Page 1 of 13 12311 ... LastLast
Results 1 to 10 of 122

Multi-Stores shop system for OSCMAX

This is a discussion on Multi-Stores shop system for OSCMAX within the osCmax Projects Discussion forums, part of the osCmax v2.0 Forums category; A new project_project entry has been added: [drupal=173]Multi-Stores shop system for OSCMAX[/drupal] Version 1.4 ============= These modifications allow you to ...

      
  1. #1
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,699
    Rep Power
    22


    Default Multi-Stores shop system for OSCMAX

    A new project_project entry has been added:

    [drupal=173]Multi-Stores shop system for OSCMAX[/drupal]

    Version 1.4
    =============
    These modifications allow you to assign specific products and categories to multiple stores that you define in the administration panel. The products and categories
    JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
    Try out our osCMax at: Live Catalog Demo
    Limited access Admin: Live Admin Demo
    Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!

  2. #2
    New Member
    Join Date
    Feb 2007
    Posts
    25
    Rep Power
    0


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

    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.

  3. #3
    New Member
    Join Date
    Jun 2007
    Posts
    7
    Rep Power
    0


    Default Re: 1054 - Unknown column 's.specials_id' in 'on clause'

    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.

  4. #4
    New Member
    Join Date
    Feb 2007
    Posts
    25
    Rep Power
    0


    Default Re: 1054 - Unknown column 's.specials_id' in 'on clause'

    That's what I thought might be the problem however, the last update that was made to the mod was after Ver 2.0 and I believe reference was made to the changes that would be compatible with it.

    BTW, thanks for the reply. This message and others that I have posted, including a "contact us" email concerning templates, have gone basically un-answered. This kind of help reminds me of another nightmare called MIVA which you also couldn't get help with nor did they have a great tutorial on how to edit the store. Oh, well, I guess newbies to this software just have to waste ridiculous time or simply move onto a more editable shopping cart.

  5. #5
    osCMax Testing Team
    Join Date
    Sep 2004
    Posts
    362
    Rep Power
    10


    Default Re: 1054 - Unknown column 's.specials_id' in 'on clause'

    Please be patient with this board. It is a growing community and the more people we get involved the better this and oscmax will get. Out of all the carts I worked with this one is very versatile. You do need some patience and have to do alot of googling and research on some problems but I have learned much from that.

    I can not answer your problem as I have not added that contribution yet but plan to. I believe jpf ported that to work with oscmax and has it working. Maybe he might have an answer and I am sure he will respond if he does.

  6. #6
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: 1054 - Unknown column 's.specials_id' in 'on clause'

    First, you should probably post any problems with the multi-store mod in the dedicated thread that actually deals with that mod:

    http://www.oscmax.com/forums/oscmax-...em-oscmax.html

    Oh, and one last thing, you are not allowed to start complaining about us until you have at least 25 posts, and have become one of us, but then you can really let it rip.

    As for your actual problem, I have never tried to install that mod.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  7. #7
    New Member
    Join Date
    Jun 2007
    Posts
    7
    Rep Power
    0


    Default Re: 1054 - Unknown column 's.specials_id' in 'on clause'

    In osCommerce (or I guess OSCmax) it is usually fairly easy to add a bug free individual contribution to the base module by following installation instructions. The complications usually start to arise when there are multiple contributions added which start cutting across or interfering with each other. Even then contributions which involve mainly small changes to a small number of existing modules are not to difficult to adapt.

    Adding big contributions like Multi-Store to an existing heavily modified version of osCommerce (like OSCmax 1.4 or OSCmax 2.0) is quite a daunting task as it involves new tables, additional fields on tables, lots of code changes to lots of modules. I assume that the OSCmax 1.4 multi store contribution worked well with OSCmax 1.4 and I am sure the contributor could probably make it work for 2.0 if he has the time and inclination, just the same as I could make it work if I had the time (....which I dont!).

    An alternative would be to offer new OSCmax users the opportunity to download previous versions of OSCmax like 1.4. It is possible that OSCmax 1.4 (which I assume was a stable version) plus an easy upgrade to a working multi-store might be closer to what I need than OSCmax 2.0 plus a headache!

    In an ideal world we will be able to select base osCommerce plus just the contributions we actually need though we are a way off that Utopia just yet.

  8. #8
    New Member
    Join Date
    Jun 2007
    Posts
    7
    Rep Power
    0


    Default Re: Multi-Stores shop system for OSCMAX

    Hi, just to advise that a I have had a problem installing this contribution with osCMax v2_RC3_0_1. Same problem also encountered by another user (see link further below).

    We both tried this as we noticed your contribution was posted after OSCmax 2.0 became the base version.

    I assume your multi-store add on was for a OSCmax 1.4 installation. Do you intend to provide an OSCmax 2.0 version?

    We got 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'


    http://www.oscmax.com/forums/oscmax-...html#post27962

  9. #9
    osCMax Testing Team
    Join Date
    Sep 2004
    Posts
    362
    Rep Power
    10


    Default Re: 1054 - Unknown column 's.specials_id' in 'on clause'

    I believe that the Multi Store Contribution version is 1.4 not OsCMAX . The Contribution was ported for the current version of oscmax however since not installing it I am not sure what is causing this error other than it says unknown column so the first place I would look at is the DB to see if it is there.

  10. #10
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: 1054 - Unknown column 's.specials_id' in 'on clause'

    I am merging this thread with the official thread to keep everything together.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

Page 1 of 13 12311 ... LastLast

Similar Threads

  1. Multi-Stores multiple shop system
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 02-03-2007, 10:10 AM
  2. Multi shop store module for oscmax
    By clauska in forum osCmax v2 Customization/Mods
    Replies: 1
    Last Post: 10-12-2006, 06:52 PM
  3. Multi Stores contrib in OsC Max-Is it possible?
    By InaFlap in forum osCmax v2 Customization/Mods
    Replies: 0
    Last Post: 08-05-2006, 03:11 PM
  4. multi-stores
    By okatoma in forum osCMax v1.7 General Mods Discussion
    Replies: 3
    Last Post: 02-25-2004, 07:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •