Results 3,141 to 3,150 of 3673

Threaded View

  1. #11
    Join Date
    Nov 2011
    Location
    Brisbane, Australia
    Posts
    35
    Plugin Contributions
    0

    Default Uploading NEW Product Attributes

    Hi,
    I'm using the Attrib-Basic-EP file to try and get my attributes loaded. I have used the tool to load a number of products and am now using the Attrib-Basics-EP file I exported as a template to populate (it does have some good entries as my store does have some products with attributes already). Before editing and adding more, I thought I would test the update. The upload of the exported file, unchanged, returned the message:

    MySQLi error 1054: Unknown column 'p.products_model' in 'where clause'
    When executing:
    SELECT * FROM products WHERE (
    p.products_model = '1392')

    I see the syntax error in that products was not referenced as 'p', but the upload has created the SQL as p.products_model. Is this a bug?

    Note, I originally tried this with products_id still the primary key. However, I have changed products_model to be the primary key and still get the same error.

    Running ZC 1.5.6c on PHP 7.3
    Last edited by gohealth; 5 Jun 2020 at 03:25 PM. Reason: Incorrect Title

 

 

Similar Threads

  1. Hebrew Support - latest release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 22
    Last Post: 26 Jan 2026, 06:47 AM
  2. BackUp ZC [Support Thread]
    By skipwater in forum All Other Contributions/Addons
    Replies: 285
    Last Post: 23 Dec 2020, 10:40 AM
  3. Wordpress On ZC [Support Thread]
    By hira in forum All Other Contributions/Addons
    Replies: 1858
    Last Post: 17 Jan 2014, 01:24 AM
  4. ZJ Black 2 support thread
    By Liamv in forum Addon Templates
    Replies: 1
    Last Post: 15 Feb 2010, 02:53 PM

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