Plugin gift_certificate_addon - install.Sql issues ZC 1.57b

[TheGrimReaper]

Good day friendlys,

In an attempt to provide enhanced GV functionality to our developing site, I was intrigued by what the gift_certificate_addon offered and attempted to add the plugin. All went well until the install.sql update attempt(s), twice failed with a message similar to "could not be ran from this location, when the location is within the sites structure, meaning to say it is on the server in an accessible location.

I see there has been 107 downloads, and last updated several years ago, but so far I haven't been able to find any forum information regarding the plugin, but it's a huge forum and I could have easily missed it. Pre-apologies should I be repeating a previous post addressing the issue.

I am inclined to question if the db update is required with 1.57b, and if so has anybody else tried to install it and had the same encounter, which found resolution.

As seen in the site information below, it installed the files just fine, but I'm not sure where to turn with the db error or what/where I should look to find if the database is configured with it.

Any advice from the superior minds in this forum would be tremendously appreciated.



################################################################################ Begin Site Information ########################################___
No live site yet,
ZC version 1.57b
Basic responsive classic template
Server OS: Linux 4.19.150-76.ELK.el6.x86_64
HTTP Server: Apache
PHP Version: 7.3.25 (Zend: 3.3.25)
Database Engine: MySQL 5.6.41-84.1
Plugins:
one_page_checkout-2.3.6
zen_coinpayments
Layaway- Payments accepted Alertpay & PayPal No Cr
zx_point_of_sale_1.3
fedex_web_services.5
ups_v2020_07_01
usps-USPS_2020_09_24_K11
mod_list 1.4
##################################################___Begin mod_list plugin results ########################################__
Mods To This Cart
New Admin Pages
Page Name Menu Key Display Link
Category catalog N Category
Plugin Manager modules Y Plugin Manager
ZX Point of Sale configuration Y ZX Point of Sale
One-Page Checkout Settings configuration Y One-Page Checkout Settings
Gift Certificate Dashboard gv Y Gift Certificate Dashboard
Mod List tools Y Mod List
New Database Tables

zen3i_addon_gv_orders
zen3i_addon_gv_redemptions
zen3i_coinpayments
zen3i_coinpayments_session
zen3i_pos_orders
zen3i_square_payments
zen3i_zen3i_upgrade_exceptions

New Modules

Payment: cointopay.php posinstorepayment.php coinpayments.php layaway.php
Shipping: posinstore.php ups.php fedexwebservices.php usps.php
Order Total: No additional modules

Missing Admin Configuration Pages
This is caused by migrating pre 1.5.0 mods which have entries in Admin->Configuration, without creating admin_pages entries for them.

No missing admin pages found.
######################################################################_End mod_list plugin results##################################################_
######################################################################_End Site Information############################################################_

[balihr]

In an attempt to provide enhanced GV functionality to our developing site, I was intrigued by what the gift_certificate_addon offered

Uhm... Could you provide a link to this addon? Where did you find it?

[TheGrimReaper]

Uhm... Could you provide a link to this addon? Where did you find it?

https://www.zen-cart.com/downloads.php?do=file&id=2174

I see it's last update by the author was 2017, ZC ver. 1.5.5

[balihr]

OK, so... You've done the file modifications and uploaded all the relevant files and you just need to run the SQL query and it fails? How are you running the query, are you using admin->Tools->Install SQL Patches? If so, do you copy/paste the contents of the provided install.sql file or do you try to upload it?
Reason I'm asking is because I just installed it on my test site and it works just fine.

[TheGrimReaper]

OK, so... You've done the file modifications and uploaded all the relevant files and you just need to run the SQL query and it fails? How are you running the query, are you using admin->Tools->Install SQL Patches? If so, do you copy/paste the contents of the provided install.sql file or do you try to upload it?
Reason I'm asking is because I just installed it on my test site and it works just fine.

Awesome. Well, I DID admin->Tools->Install SQL Patches both attempts.
I originally tried the upload from a local drive here (that worked for others)and when that failed I copied it up to the server in the zc_plugins folder and tried the 2nd time. That too failed and I removed it from the folder in the interest of keeping the folder as native as it was whilst doing this research..

[TheGrimReaper]

What I find a bit interesting is according to the mod_list results it looks like there ARE some tables from the plugin, I don't know if they're all there, not knowing which should be, or how to discover their integrity.

[balihr]

Honestly (and don't tell anyone I said that), I have no idea why that "upload sql" is even there - it's been nothing but problematic for me since day one. As if it were such a problem to open a file and copy/paste the contents and run it... Anyway, my suggestion is to always just copy/paste the sql patches and run it, don't upload the files.

[TheGrimReaper]

A couple questions regarding Gift Certificates priced by Attributes

Unfortunately I find myself back here bugging you good folks with a couple of what are probably simple-to-solve questions regarding ZC 1.5.7b basic Gift Voucher questions. I've done my due-diligence for 4 hours now searching the forums and crawling thru the docs, finding mostly 14 year old closed threads that almost address them, just not comprehensively and then, understandably for older versions. Hopefully after 14 years somebody smarter than me has realized there needs to be a way around the issues and have a solution.

I have set up Gift Certificates for several amounts, (although I'd like to have the buyer enter their own amounts, that doesn't seem possible) and have them priced by attributes, but as seems to be an ongoing issue for several users, they display with them priced at the lowest denomination of $10 in a couple of places. This is undesirable as it may give a customer the impression we only offer $10 GV's until they actually select a true amount from the drop-down in the cart. Some customers actually may become confused by this if they feel they just paid $25 for a $10 certificate, not understanding it's the denomination they selected and not the denomination displayed on the product image. In the cart is a perfect blurb that states "Starting at $10" I'd be happy if the Display price would include "Starting at" instead of just Display price will include lowest group attributes prices, and happier if the price did not display at all. It's ok if they select Gift Certificates from the sidebar, they get the "Starting At" message.

So far it seems the problem text shows up under the "New Products" sections only, but I really haven't dug much deeper to see if it is also elsewhere, and I thought I came across something somewhere where one could turn off showing the product under new products, (which may be an option) but haven't been able to find those references again to follow up on it.

Next, in the "Product Information" above "Ask A Question" the Model is fine, but I'd like to not display the Qty in stock.

Both of these issue I think I have come across info on before, but now I just can't find it and after burning my brain trying, I thought I'd take the leap and appeal to you folks for help.

Mods To This Cart

Plugin Manager     modules     Y     Plugin Manager
ZX Point of Sale     configuration     Y     ZX Point of Sale
One-Page Checkout Settings     configuration     Y     One-Page Checkout Settings
Gift Certificate Dashboard     gv     Y     Gift Certificate Dashboard
Mod List     tools     Y     Mod List
New Database Tables

    zen3i_addon_gv_orders
    zen3i_addon_gv_redemptions
    zen3i_coinpayments
    zen3i_coinpayments_session
    zen3i_pos_orders
    zen3i_square_payments
    zen3i_zen3i_upgrade_exceptions

New Modules

    Payment: posinstorepayment.php coinpayments.php layaway.php
    Shipping: posinstore.php ups.php fedexwebservices.php usps.php
    Order Total: No additional modules

[balihr]

I have set up Gift Certificates for several amounts, (although I'd like to have the buyer enter their own amounts, that doesn't seem possible) and have them priced by attributes, but as seems to be an ongoing issue for several users, they display with them priced at the lowest denomination of $10 in a couple of places. This is undesirable as it may give a customer the impression we only offer $10 GV's until they actually select a true amount from the drop-down in the cart. Some customers actually may become confused by this if they feel they just paid $25 for a $10 certificate, not understanding it's the denomination they selected and not the denomination displayed on the product image. In the cart is a perfect blurb that states "Starting at $10" I'd be happy if the Display price would include "Starting at" instead of just Display price will include lowest group attributes prices, and happier if the price did not display at all. It's ok if they select Gift Certificates from the sidebar, they get the "Starting At" message.

But, if you setup the Gift Certificate (further GV) to be priced by attributes, it shouldn't be confusing anywhere other than the listing pages (which don't include the "starting at" text). The GV main image should be generic, meaning without the number on the image just to avoid confusion. Once you get to the product page, it will show you the options and will include the selected attribute in the cart page as well as checkout so you know you've selected the $50 option and that's why you're paying $50... So, the only "issue" I'm seeing is that it doesn't say "Starting at..." on the listing pages or sideboxes or centerboxes...

You might consider this plugin if you want to change the main image based on selection and show the value of the GV with a matching image, but I'm not sure if it's worth the hassle.

Next, in the "Product Information" above "Ask A Question" the Model is fine, but I'd like to not display the Qty in stock.

Admin->Catalog->Product Types->Product General->Layout Settings->Show Quantity in Stock->0

[TheGrimReaper]

But, if you setup the Gift Certificate (further GV) to be priced by attributes, it shouldn't be confusing anywhere other than the listing pages (which don't include the "starting at" text). The GV main image should be generic, meaning without the number on the image just to avoid confusion. Once you get to the product page, it will show you the options and will include the selected attribute in the cart page as well as checkout so you know you've selected the $50 option and that's why you're paying $50... So, the only "issue" I'm seeing is that it doesn't say "Starting at..." on the listing pages or sideboxes or centerboxes...

You might consider this plugin if you want to change the main image based on selection and show the value of the GV with a matching image, but I'm not sure if it's worth the hassle.


Admin->Catalog->Product Types->Product General->Layout Settings->Show Quantity in Stock->0

Yes sir! I actually found it and turned it off - then discovered your post when I came to update my post with that very same solution for the masses that follow.