Results 1 to 8 of 8

Hybrid View

  1. #1
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: Getting error when installing Auction Product Type plugin

    Evidently your store is configured to use a "prefix" of "zen_" on all tablenames.

    Install scripts for mods only know about official Zen Cart tablenames, without prefixes.

    So, you have two options:
    a) If you're going to use phpMyAdmin to run the SQL script, then you must manually insert your "zen_" prefix in front of EVERY tablename in your SQL scripts before running them there.

    or
    b) Use the Admin->Tools->Install SQL Patch tool in your Zen Cart admin to run the SQL, since it will automatically insert the prefix ... as long as the SQL is written in the correct format that Zen Cart can process and correctly identify the tablenames.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  2. #2
    Join Date
    Aug 2012
    Posts
    45
    Plugin Contributions
    0

    Default Re: Getting error when installing Auction Product Type plugin

    and hence back to my original issue....can I change the sql file to reflect the zen_ and if so where?

    When i run the sql script, I show this....yet same error.

    Click image for larger version. 

Name:	sql3.JPG 
Views:	68 
Size:	41.3 KB 
ID:	12555Click image for larger version. 

Name:	sql4.JPG 
Views:	89 
Size:	31.6 KB 
ID:	12556Click image for larger version. 

Name:	sql5.jpg 
Views:	76 
Size:	28.5 KB 
ID:	12557

  3. #3
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: Getting error when installing Auction Product Type plugin

    To run it via phpMyAdmin, the line saying "FROM product_types" would need to have the prefix added to the tablename, thus making it be "FROM zen_product_types".
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  4. #4
    Join Date
    Aug 2012
    Posts
    45
    Plugin Contributions
    0

    Default Re: Getting error when installing Auction Product Type plugin

    I would prefer to run it though tools section of my site...

    TRY 1:
    I have added the zen_ to all instances "FROM product_types"....auctions.sql file
    Ran the sql file from tools.....install sql patches section of my website...the same error message appears
    checked phpmyadmin and added the zen_ to the following 2 tables running the sql created....zen_products_auctions and zen_product_auction_extra
    Still have the error msg....

    Will try another couple of ways when I have more time etc....for now still using webid and works great

 

 

Similar Threads

  1. Auction Product Type
    By gusuval in forum All Other Contributions/Addons
    Replies: 739
    Last Post: 18 May 2024, 04:02 PM
  2. Auction Product type
    By Andreas1211 in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 14 Aug 2014, 02:13 PM
  3. v1.5.1 Desperately need help installing Auction Product Type
    By tamber56 in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 23 Oct 2012, 10:24 AM
  4. Auction Product Type: Can't add a product of the type.
    By sw0rdz in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 5 Sep 2009, 02:11 AM

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