Plugin gift_certificate_addon - install.Sql issues ZC 1.57b

[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.

[TheGrimReaper]

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.

My apologies. I knew there was some risk in the question, I didn't meant to step on any toes.

[balihr]

LOL, no, you didn't step on anyone's toes, I just said it so you don't expect much "support" or discussion in this thread. Both plugins are great and I love using both, but if you want to discuss any of it's features or capabilities, you'll get the best replies in their respective support threads - both lat9 and mc# provide fantastic support for their plugins.

[TheGrimReaper]

Renewed greetings,
Regarding this issue, and not knowing if the database is correct, I sent myself a test gift cert for $100 USD and everything seemed to go ok, but not knowing what to really expect these are the events:

I received the email with the redemption code. Prior to redemption, I methodically viewed all fields under the "Discounts" (the forums Image upload doesn't seem to work, but I have a pic of the Discount panel, - another problem to be addressed probably somewhere else) and within this panel the only place it shows up is in "Gift Certificates Sent", not in the Dashboard and not in Queue or anywhere.

I then redeemed it for $75, expecting it to apply the $75 toward my test purchase and leave $25 in the bank- instead I receive an "Invalid Gift Certificate Redemption Code", available balance did not change and none of the fields in the menu changed. I then tried to redeem it for full value and received "Coupon code "f76f621b04" is not a valid code" but I do have a $100 balance that I can't apply. Now I'm in danger of invoking my "over thinking" curse. I tried it as a coupon code with the same result.

In short, I have a code, a balance and a pending purchase I can't apply the balance to and nothing in the menu reflects the certificate except in "Sent".

Still wondering if I have a partial or corrupt db function somewhere.... Any thoughs anyone?

Thank you.

[TheGrimReaper]

Ok, I copied the code from install.sql, pasted into the "Query to be executed"block, hit "send" and get this message:

WARNING: An Error occurred, please refresh the page and try again.If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.