Page 37 of 37 FirstFirst ... 27353637
Results 361 to 365 of 365
  1. #361
    Join Date
    May 2015
    Location
    USA
    Posts
    5
    Plugin Contributions
    0

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    Installed "creinold_SBA5.1_alpha_version1.5_for_zencart_V1.5.0" on cart version 1.5.5e. The module appears to have installed properly in that it shows the admin section as well as drop-downs in the front end. However, when I try to add in the quantities in "Products with Attributes Stock" in the admin I get the following: WARNING: An Error occurred, please refresh the page and try again.

    Here is what my debug says:

    Code:
    [15-Mar-2017 15:38:32 UTC] 
    Request URI: /PersonalAdmin/products_with_attributes_stock.php?products_id=18&quantity=10&attributes=33&add_edit=add&action=execute, 
    
    #1  trigger_error() called at [/home/REDACTED/public_html/includes/classes/db/mysql/query_factory.php:167]
    #2  queryFactory->show_error() called at [/home/REDACTED/public_html/includes/classes/db/mysql/query_factory.php:139]
    #3  queryFactory->set_error() called at [/home/REDACTED/public_html/includes/classes/db/mysql/query_factory.php:266]
    #4  queryFactory->Execute() called at [/home/REDACTED/public_html/PersonalAdmin/products_with_attributes_stock.php:250]
    
     PHP Fatal error:  1364:Field 'sort' doesn't have a default value :: insert into `products_with_attributes_stock` (`products_id`,`stock_attributes`,`quantity`) values (18,"33",10) ==> (as called by) /home/REDACTED/public_html/PersonalAdmin/products_with_attributes_stock.php on line 250 <== in /home/REDACTED/public_html/includes/classes/db/mysql/query_factory.php on line 167
    Thank you for your help.

  2. #362
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    Hmm. Edit about the below: perhaps I've posted here thinking it was the thread associated with a different version of SBA (I'm on list for several). Sorry for toe stepping. Running out of time to edit. But still able to possibly answer questions related to the solution.

    A lot going on here, 1) using a very old as far as I know no longer maintained version of SBA, 2) looks like you could use at least three options to move forwards, either alter the database, so that every new item has a default value that is a constant (all new items would have the same sort value), you could modify the database field to autonumber such that each would be assigned a new/unique likely unchangeable sort value. You could modify the query to add a value to the table for that field and that value could be a constant (to be changed later) or it could be determined by the last sort number and incremented in a way applicable to the desired outcome. The drastic action would be to delete the field from the table and any other place that the sort field is used/accessed, but that doesn't seem like a worthwhile venture.

    So, it would depend on how you wish to move forward with the issue of that software which doesn't occur with the version that has primarily been discussed, tested, and used on the more recent versions of ZC.
    Last edited by mc12345678; 15 Mar 2017 at 09:05 PM.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  3. #363
    Join Date
    May 2015
    Location
    USA
    Posts
    5
    Plugin Contributions
    0

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    So, it would depend on how you wish to move forward with the issue of that software which doesn't occur with the version that has primarily been discussed, tested, and used on the more recent versions of ZC.


    Hmmm. I guess I missed a module. What is the link to the new version that matches 1.5.5? I did not mean to use a version that was outdated.

    Thanks again for your input!

  4. #364
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    Quote Originally Posted by maxmarketing View Post
    [/B]

    Hmmm. I guess I missed a module. What is the link to the new version that matches 1.5.5? I did not mean to use a version that was outdated.

    Thanks again for your input!
    So, don't be alarmed about the thread title. I suggest going to the end of the thread and reading back even just a couple of pages to get the lay of the land.

    https://www.zen-cart.com/showthread....tock+attribute
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #365
    Join Date
    May 2015
    Location
    USA
    Posts
    5
    Plugin Contributions
    0

    Default Re: Stock by Attributes 5.0 Beta (for v1.5.0)

    Thank you for your rapid response. The title of that thread is why I did not proceed with it when I was looking for a module. Good to have clarification.

 

 
Page 37 of 37 FirstFirst ... 27353637

Similar Threads

  1. v155 BETA feedback for Responsive-Classic in v155-beta
    By picaflor-azul in forum Addon Templates
    Replies: 51
    Last Post: 5 Mar 2016, 09:14 PM
  2. v151 Using Stock By Attributes, In Stock Value Is Sum Of Attributes' Stock
    By y0ul053 in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 29 Aug 2013, 04:23 PM
  3. Replies: 5
    Last Post: 3 Aug 2011, 08:15 AM
  4. Stock by Attributes and displaying next to attributes for Customers 1.3.8
    By tirjasdyn in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 21 May 2009, 10:31 PM
  5. Stock level indicator, for stock by attributes controller
    By vandiermen in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 13 Nov 2008, 09:49 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR