Page 44 of 44 FirstFirst ... 34424344
Results 431 to 434 of 434
  1. #431
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,637
    Plugin Contributions
    78

    Default Re: product categories - linking

    Quote Originally Posted by strelitzia View Post
    Zen Cart 1.5.7c
    PHP Version 7.4.16
    MySQL 5.7.32

    I'm getting a MySQL error with exports for Manufacturers, ProuctsAttribsbasic, and Products.
    For a manufacturers export the log is as follows:
    Code:
    [06-Aug-2021 20:33:34 Europe/Paris] Request URI: /testadmin/index.php?cmd=dbio_manager&action=export, IP address: ::1
    #1  trigger_error() called at [/Users/steph/Sites/localhost/homebrew/includes/classes/db/mysql/query_factory.php:170]
    #2  queryFactory->show_error() called at [/Users/steph/Sites/localhost/homebrew/includes/classes/db/mysql/query_factory.php:142]
    #3  queryFactory->set_error() called at [/Users/steph/Sites/localhost/homebrew/includes/classes/db/mysql/query_factory.php:269]
    #4  queryFactory->Execute() called at [/Users/steph/Sites/localhost/homebrew/testadmin/includes/classes/dbio/DbIo.php:167]
    #5  DbIo->dbioExport() called at [/Users/steph/Sites/localhost/homebrew/testadmin/dbio_manager.php:156]
    #6  require(/Users/steph/Sites/localhost/homebrew/testadmin/dbio_manager.php) called at [/Users/steph/Sites/localhost/homebrew/testadmin/index.php:11]
    --> PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY m.manufacturers_id ASC' at line 1 :: SELECT m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified FROM zen_manufacturers AS m, zen_manufacturers_info AS mi WHERE m.manufacturers_id = mi.manufacturers_id AND mi.languages_id =  ORDER BY m.manufacturers_id ASC  ==> (as called by) /Users/steph/Sites/localhost/homebrew/testadmin/includes/classes/dbio/DbIo.php on line 167 <== in /Users/steph/Sites/localhost/homebrew/includes/classes/db/mysql/query_factory.php on line 170.
    Note the lack of a languages_id just before the ORDER BY.

    I went to DbioManufacturersHandler.php and set some error_log outputs after
    Code:
    $export_language = ($this->export_language == 'all') ? $this->languages[$this->first_language_code] : $this->languages[$this->export_language];
    
    error_log("export language: ".$this->export_language);
    error_log("first_language_code: ".$this->languages[$this->first_language_code]);
    error_log("this export langueage: ".$this->languages[$this->export_language]);
    error_log("export language var: ".$export_language);
    the results of which are
    Code:
    [06-Aug-2021 20:33:34 Europe/Paris] export language: all
    [06-Aug-2021 20:33:34 Europe/Paris] first_language_code: 
    [06-Aug-2021 20:33:34 Europe/Paris] this export langueage: 
    [06-Aug-2021 20:33:34 Europe/Paris] export language var:
    The error logs for ProuctsAttribsbasic and Products also show a missing language_id in the query.

    Any suggestions on the cause, and a solution to this issue?
    Obviously a multiple-language failure is the cause; the solution will be an update to those handlers. See (https://github.com/lat9/dbio/issues/193) for the tracking of these changes.

  2. #432
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,637
    Plugin Contributions
    78

    Default Re: product categories - linking

    Quote Originally Posted by lat9 View Post
    Obviously a multiple-language failure is the cause; the solution will be an update to those handlers. See (https://github.com/lat9/dbio/issues/193) for the tracking of these changes.
    OK, I'm not able to reproduce this issue on either a single- or dual-language site.

    What languages are present in the site? What version of DbIo? What DB_CHARSET is being used?

  3. #433
    Join Date
    Jul 2017
    Location
    West Midlands, UK
    Posts
    16
    Plugin Contributions
    0

    Default Re: product categories - linking

    Hi,
    I have quite a few linked products originally uploaded using easypopulate CSV.

    With Easypopulate CSV I had created spreadsheets with linked products listed as another row. This means that I would have multiple rows for one linked product.

    All of my Easypopulate spreadsheets need updating to work with DBIO (as the category must be listed in just one column with the ^ delimiter). As DBIO only exports the master category I am unable to easily keep a record of linked categories.

    On import the DBIO manager also requires multiple uploads to achieve the desired result – e.g. one import to add a linked category, then another import to set the master category back to what it was.

    Would it be possible to import/export v_categories_name as a list of linked categories? I believe this has been mentioned by Torvista in post #361. This would make managing the master category and linked categories much easier.

    Alternatively would it be possible to add an additional column such as v_categories_linked to allow linked categories to be clearly defined.

    Any help with this would be much appreciated. We have found this add on to be one of the most useful mods available for Zen Cart. I would be happy to make a donation to help cover the costs of implementing these changes.
    --
    Many thanks
    Richard

  4. #434
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,637
    Plugin Contributions
    78

    Default Re: product categories - linking

    Quote Originally Posted by richard7315 View Post
    Hi,
    I have quite a few linked products originally uploaded using easypopulate CSV.

    With Easypopulate CSV I had created spreadsheets with linked products listed as another row. This means that I would have multiple rows for one linked product.

    All of my Easypopulate spreadsheets need updating to work with DBIO (as the category must be listed in just one column with the ^ delimiter). As DBIO only exports the master category I am unable to easily keep a record of linked categories.

    On import the DBIO manager also requires multiple uploads to achieve the desired result – e.g. one import to add a linked category, then another import to set the master category back to what it was.

    Would it be possible to import/export v_categories_name as a list of linked categories? I believe this has been mentioned by Torvista in post #361. This would make managing the master category and linked categories much easier.

    Alternatively would it be possible to add an additional column such as v_categories_linked to allow linked categories to be clearly defined.

    Any help with this would be much appreciated. We have found this add on to be one of the most useful mods available for Zen Cart. I would be happy to make a donation to help cover the costs of implementing these changes.
    --
    Many thanks
    Richard
    Richard, I like that v_categories_linked column idea. There's already an open issue (https://github.com/lat9/dbio/issues/135) requesting changes to the linked-categories' handling that I'll update to identify that implementation possibility.

 

 
Page 44 of 44 FirstFirst ... 34424344

Similar Threads

  1. Support Thread for CKEditor Plugin
    By DivaVocals in forum Addon Admin Tools
    Replies: 201
    Last Post: 31 Aug 2021, 05:14 PM
  2. Back to Top Plugin [Support Thread]
    By picaflor-azul in forum All Other Contributions/Addons
    Replies: 31
    Last Post: 6 Feb 2016, 10:52 PM
  3. v151 Plug 'n' Pay plugin [Support Thread]
    By KetchRescue in forum Addon Payment Modules
    Replies: 5
    Last Post: 28 Nov 2015, 04:56 AM
  4. Justuno Plugin [Support Thread]
    By JustunoApp in forum All Other Contributions/Addons
    Replies: 8
    Last Post: 24 May 2015, 11:00 PM
  5. VendingBox Plugin Support Thread
    By vb_support in forum All Other Contributions/Addons
    Replies: 31
    Last Post: 10 Feb 2013, 07:24 PM

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