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]

(chuckle)! I won't tell a soul

I'm not familiar with the copy and paste technique, though I'm sure it's simple and in trying not to overthink again I'll see if I can figure it out. Gee, it seemed like such an easy way to update the db and it worked well on a previous plugin. Oh well, it IS what it IS.

I came from years of playing with Cartweaver (v2-v4) and CW takes a LOT of thinking, thereby training my brain to think 'til it aches.

[TheGrimReaper]

I'm looking at 2 db plugins right now,
https://www.zen-cart.com/downloads.php?do=file&id=2069 - Easy Populate
and
https://www.zen-cart.com/downloads.php?do=file&id=2091 - dbio

They seem to address the inconvenient - one at a time product and db import/export.....I wonder if they might have some value in this endeavor??

[balihr]

I'm looking at 2 db plugins right now,
https://www.zen-cart.com/downloads.php?do=file&id=2069 - Easy Populate
and
https://www.zen-cart.com/downloads.php?do=file&id=2091 - dbio

They seem to address the inconvenient - one at a time product and db import/export.....I wonder if they might have some value in this endeavor??

Completely off-topic because it has absolutely nothing to do with the original issue... Just to clarify this part: I'm not familiar with the copy and paste technique, - it simply means that IF the plugin comes with an install.sql file (or some similar sql thingy like sql-install.txt), you simply open that file in any text editor, even Notepad is OK, copy the contents and then paste it in the big textarea in your admin->Tools->Install SQL Patches and click Send.

As for EasyPopulate and dbIO - those are plugins that allow you to import and/or export data from your database. For example, adding thousands of products to your catalog by importing a CSV file (spreadsheet) with relevant data. But, both plugins have their own official threads so we shouldn't really be discussing it here.