Correct. I never summarized how I got it to work. It is a frustrating problem some of us are facing.
However if you do a search on this thread and break out all the "gogolf" posts and follow the steps I took and frustrating comments I posted .. that is how it got to work for me.
In summary, thinking out loud:
A) there "maybe" a problem in the sql patch such that there is a pre-existing field in the tables that the mod is trying to install and it can't; at least that is my understanding from reading the error report (comments welcome from guru's). There maybe a problem with syntax and there may not be for some installers.
What I may not have posted was that after running the sql patch with the mod I did get tables and fields appear, they did get updated. So I went into my database, through mysql, and deleted the changes the mod sql patch created and located one field or table which for some reason the mod sql patch reported (in simple terms) "was already there guy, sorry can't do anything". I then cut and pasted the mod sql patch into myphp and it ran.
B) after "A" above the referral was still not being posted to the database so I moved a file (see post 157 in this thread) and that solved my problem.
That is how it got ITSELF to work. Is the problem in the sql patch? I don't know but I'm leaning toward that. Is the problem in the version of MySql or php is on your or my server, I don't know.
C) In my opinion, as well as suggested in Zen, when a file is modded it should be noted in the top of the file or commented where the changes are line by line. Some of these files in the mod do not have any notes so you have to use a "compare" program often.
D) The mod instructions could be more clear or concise. No offense to any mod authors however the best instructions are simple, concise and in laymens terms.
I'm sure if you sift through various mod's for Zen you'll find some that anticipate that you know what you are doing and how things work, and then there those that go into detail for expert and newbie.
Thanks Gogolf for the reply. I believe one of my problems is that I have never been able to get the override system to work for me. So, I have no idea where to go from here.
I have never been able to figure it out, however somehow mine works.
If you read my threads again you'll find a post discussing over-ride system of which confuses me ; depending upon which FAQ or Help article you read.
Here it is again.
https://www.zen-cart.com/tutorials/index.php?article=36
Read it and search the FAQ's and Help sections of Zen to other articles.
Thanks again Gogolf for the reply. I don't know how many articles I've read on this subject. I thought I had all the folders/directories in their proper place, etc. but still can't get it to work. I'll check out the link you have here and give it another try.
Thanks,
Robyn