Printable View
UH OH!! You are WAY BAD for still being on 1.2.6 - you need to hack at your HEAD with that graphite shaft! giggle
Upgrading is not that bad.... just make sure you back up the site and database first - make sure your design files and modified files are all in a "custom" directory - and follow the instructions... you will do just fine! :flex:
Quote:
Originally Posted by gogolf
Hello,
Fished around the forums and could not figure this out, and have noticed others with the same problem:
1) On Admin>Customers page, there is a "referred by" title, but nothing is showing up for all the customers, just --none--... is this just a '1st Discount coupon' issue, because if it is, this ain't workin for me either.
2) Admin>Extras>Referral Sources: Only item is "Other", and no matter what customer enters in the "How did you hear about us" field, the number will keep adding to this "Other" total, despite having several entries under Admin>Extras>Referrals
Here is my configuration:
Admin>Config>My Store>Display "Other" Referral option=true
Admin>Config>Customer Details>Require Referral=true
Admin>Config>Customer Details>Customers Referral Status=2
Admin>Extras>Referrals>AOL, Google, Magazine, Etc...
Admin>Extras>Referral Sources>Sources:'Other', Referred:4
-When I click on 'Other' it just says Displaying 0 to 0 (of 0 referral sources)" although I don't recall entering anything during test customer registration in the "Other" field, but my main issue is that there is no way to see totals of the "AOL, Google, Magazine etc" referrals.
Help??!!? :wacko:
I guess I have the same problem other users of the mod have run into:
I'm not seeing the referral posted when I view the Admin-Customer's screen, and the referral does not appear in the Reports-Customers Referral.
Inspecting my database in PHP I can see a field customers_referral in the customers table however there is nothing in the field for a record I created for a new customer.
Any suggestions?
A newbie trying to get this to work:
I was looking at my tables in the database and noted a message in MyPHP (server is running version 4.4.4) that stated
UNIQUE and INDEX keys should not both be set for column `configuration_key
Looks like the attached picture:
Does this indicate something that needs to be changed in the tables to make the mod work?
I've just installed using Stellarweb's code above... first to work for me! All seems well, apart from the fact that there is no mention of Referral within Admin... I know it'll be down to user error... but don't know where to begin, any ideas?Quote:
Originally Posted by stellarweb
As I said... User error!!!
Re-uploaded all Admin files and all is now well!
You've gotta love thinking for yourself!
Tried that.Quote:
Originally Posted by zilla
Nothing appears below the Admin-Customers "TABLE_HEADING_REFERRED_BY"
after creating a new customer.
And, after the new customer placed an order I'm getting the following error
when trying to view the order through Admin-Customers-Orders:
Fatal error: Cannot redeclare class order in ........./admin/includes/classes/order.php on line 23
have you double checked that you've uploaded all the files to all the right places? Are you using the same SQL that I did because the one supplied with the mod didn't work for me.
Quote:
Originally Posted by zilla
I have tried several variations of the SQL mod regarding the "true" statements,
the "/" as well as the ',' issues. Evertime I run the SQL mod the message is the same as everyone else got ... the tables were already updated and can't do it again, unless that means that some of the SQL patch did not take place.
I'm using:
v1.3.7.1 [2007-07-11 19:10:46] (Fresh Installation)
Server OS: Linux 2.6.9-34.ELsmp
PHP Version: 4.4.4 (Zend: 1.3.0)
Database: MySQL 4.1.21-standard
PHP Version 4.4.4
Getting this mod to work for me is very important, you get to know where your customers are coming from. If there is another way to capture the same information other than this mod I'd give that a shot too.
Update on trying to get the mod to work (refer to previous posts).
Last night deleted the new store and reinstalled it.
Installed the mod per its instructions.
Went into mysql
Went into myphpadm
Cut and pasted the sql patch and ran it.
Got the following error:
SQL query:
ALTER TABLE customers_info ADD customers_info_source_id int NOT NULL AFTER customers_info_date_account_last_modified;
MySQL said: Documentation
#1060 - Duplicate column name 'customers_info_source_id'
Does this mean the table was already there and it should not have been?
Or, does this mean there is a problem with the install_referrals.sql ?
Again I have the same problem as before, if a new customer signs up to the store the referral does not appear under under TABLE_HEADING_REFERRED_BY when viewed from Admin/Customers, and nothing shows up when you run a referrals reports.
And if I look at the field in the database for the new customer, though all the other customer data is there, there is nothing in the referral... blank, zip, nada.
It seems like the referral is not being posted to the table or its field.
Another what will appear to be a long thread of updates from this newbie trying to figure out why the customer's referral is not appearing in the Admin/Customers or the Admin/Reports/Customers Referral Report.
I went into the database table for customers_info and looked at the field name
customers_info_source_id and saw that for the five test customers I setup each had a value of "0".
I then edited four of the five test customers to have a value other than 0, such as "1". I then went back to the admin/customers and saw that the four customers now had a referral appearing (finally) under the TABLE_HEADING_REFERRED_BY and the one customer I did not edit had "none" which appears to be what "0" will do.
When I ran the Admin/Reports/Customer's Referral the report showed nothing.
However when I explored Admin/Extra's/Referral Sources what appeared was a count of each of the referral names. So at least now I know that the database will report something on the admin side but for some reason the referral is not being posted in the database when the customer account is created.
We are having the same exact problem. The database is not storing the referral information when creating test customers... but if I go into the database and manually change the values, then the associated referral sources show up in the admin reports.
So, as far as I can tell, the main problem here is - why is the database not getting passed the referral info in the create_account page? HELP - if anyone knows how to troubleshoot this, it'll solve both mine and gogolf's problems.
In case anyone can eyeball this code and see what the problem is, I believe the problem lies somewhere in this code from tpl_module_create_account.php
All the other fields on tpl_module_create_account.php pass info to the Customers table while this data is supposed to be stored in Customers_Info. Could this be the problem?PHP Code:<!-- //rmh referral start -->
<fieldset>
<legend><?php echo TABLE_HEADING_REFERRAL_DETAILS; ?></legend>
<!--<?php echo zen_draw_separator('pixel_trans.gif', '100%', '10'); ?> -->
<!-- <?php echo CATEGORY_SOURCE; ?> -->
<?php echo zen_get_source_list('sources', (DISPLAY_REFERRAL_OTHER == 'true' ? true : false)) . ' ' . (zen_not_null(ENTRY_SOURCE_TEXT) ? '<span class="inputRequirement">' . ENTRY_SOURCE_TEXT . '</span>': ''); ?><?php echo ENTRY_SOURCE; ?>
<br class="clearBoth" />
<?php
if (DISPLAY_REFERRAL_OTHER == 'true') {
?>
<?php echo zen_draw_input_field('source_other', '', 'id="sources_other_name" size="26"') . (zen_not_null(ENTRY_SOURCE_OTHER_TEXT) ? '<span class="inputRequirement">' . ENTRY_SOURCE_OTHER_TEXT . '</span>': ''); ?> <?php echo ENTRY_SOURCE_OTHER; ?>
<br class="clearBoth" />
</fieldset>
<?php
}
?>
<!-- //rmh referral end -->
BTW, AFAICT, Admin/Reports/Customer's Referral is for a totally different report unrelated to this mod.
I dug into the Module code for this, and wondering if the problem is here. Note, my customers_info table is receiving the other data (ID, 0, Now) but not the source ( (int)$source ).
From the mod:Code:values ('" . (int)$_SESSION['customer_id'] . "', '0', now(), '" . (int)$source . "')";
PHP Code://rmh referral start
$query_insert= "insert into " . TABLE_CUSTOMERS_INFO . "
(customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id)
values ('" . (int)$_SESSION['customer_id'] . "', '0', now(), '" . (int)$source . "')";
$db->Execute($query_insert);
$db->Execute($sql);
if ($source == '9999') {
zen_db_perform(TABLE_SOURCES_OTHER, array('customers_id' => $_SESSION['customer_id'], 'sources_other_name' => $source_other));
}
// $sql = "insert into " . TABLE_CUSTOMERS_INFO . "
// (customers_info_id, customers_info_number_of_logons,
// customers_info_date_account_created)
// values ('" . (int)$_SESSION['customer_id'] . "', '0', now())";
//
// $db->Execute($sql);
//rmh referral end
MyGreyGoose,
Yeah. I'm starting to wonder where the problem is with this great mod. And its a shame not to solve the riddle because tracking where your customers come from is common sense. I'm super- prized that this mod was not in 1.3.7 !
What is most puzzling is that there seems to be an array of users here who all have the same problem yet some have solved it with different approaches.
....... yet I'll have to assume some have probably quit too early and gave up.
So where are the experts when we need them?
I think its worth a cup of coffee!
Just as an FYI - after a PM from MyGreyGoose this afternoon .... I did an install of this mod onto a working 1.3.7 zencart.... and the results were again the same as when I have installed it on other websites for my clients - works perfectly.
I created a new account after installing the mod.... used google as the referral source and the report under Extras > Referral Sources now shows:
Referral Sources
Sources Referred
Google 1
Other 9
(the ones in the "other column" are existing customer accounts - it automatically throws them there)
Again... all I did was take the files from the zip file..... put them all in the corresponding directories.... went into my zencart admin and copied and pasted the install_referrals.sql info under tools.... install sql patches..... and everything works peachy keen. :blink:
A couple of things that MAY help to double check yourself on ......
1. Make sure you install the patch via your zencart admin
2. Make sure that the file under the Templates folder is put into your specific CUSTOM directory folder... per the installation instructions (\includes\templates\YOUR-TEMPLATE\templates\tpl_modules_create_account.php)
3. Remember that the definition of insanity is... "doing the same thing over and over again and expecting different results!" :smile:
I know that probably doesnt help.... but I just wanted to put in my $.05 cents worth (inflation.....) :)
Quote:
Originally Posted by gogolf
Hello again,
I'm getting worried as I'll be going live very soon and the referrals helps me pay out a commission to my sales rep as well as bonuses for magazine referrals...
I've merged the files, reinstalled them, rechecked.....etc. At this point can someone take a look at my orders, customers, create account files if you have a couple minutes. I've merged them but something tells me it might lie within another mod conflict. Out of all the mods I've used, this one has got me stumped
TIA,
Tatiana
Judy,
I guess I can now qualify for the Insanity Award because I've read all your comments several times, tried all the suggestions posted in this thread several times. Now I want to go for the Neurotic Award because its all grey to me know
My store is a fresh install. The only mods are creating a custom template, yes I tried putting all the files mentioned its directory, and I added the Ask A Question About This Product mod.
A few questions for you:
1) Do KNOW if the Ask a Question About This Product mod is the problem?
2) Have you ever had a problem with the Referral mod?
3) What are the specific scripts or php's that direct the referral into the tables field (what is the path or flow)?
I look forward to you help.
And just to make sure I'm insane I installed another new Zen Cart, followed the instructions and got following error running the SQL patch:
1064,,,,, yada yada yada,. (you know the rest).
So. Did some say they have a cast call for a remake of One Flew Over the CucKoo's Nest?
And HERES Johnny!
Did you copy-and-paste the SQL contents into the SQL Patch window, or did you Browse to the file and click Send?Quote:
Originally Posted by gogolf
Sometimes the copy/paste works better.
Hi Dr. Byte,
Thanks for your help on this. Gogolf and I have been in touch and are having the same problem, although he can answer your q specifically. I think Tatiana is having the same prob.
For me, when I first did the sql patch, I tried uploading it. I got an error. I investigated, and all the first statements seemed to take hold. Not the last two (related to the configuration table). I copied and pasted those in. AFAICT, the table modifications and row inserts took hold as desired.
To me, it seems like everything in the mod was set up correctly, it looks great in my shop, but that when you click submit to create an account, everything gets submitted to the tables EXCEPT for the customers_info_source_id. I wonder if it has anything to do with the fact that all the other fields on create_account go into the customers table instead of customers_info.
I tried pinpointing the problem. I substituted an integer for the code that produces the customers_info_source_id value, but that did not go into customers_info either. So, I wonder if it's even deeper in the code?
I copy pasted the SQL in admin, like all other SQL patches and it didn't work.
My cart is pretty much ready to go live, except for this feature...
Tatiana
Just installed this mod, and it appeared to be working fine. However, when I tried to go into Admin-->Customers-->Orders to pull up an order to ship, I get this error:
Parse error: syntax error, unexpected T_CASE in /home/.budmeisterwasher/elana/threddies.com/store/admin/orders.php on line 196
Does anyone have any ideas as to what the problem could be? I'm stumped. I checked out the offending line, but don't see a problem or a difference with what was there pre-mod. Any help would be greatly appreciated!
Should have read the rest of the thread before asking - whoops!
After going back and reviewing the first couple of pages, I saw that others were having the same problem. Someone suggested downloading a new, clean orders.php and popping it in there, which I did, and now it's working fine. Just wanted to post in case anyone else is having the same problem!
don't know if you figured it out yet. but Ihad the same problem. instead of browsing for hte file and uploading.. copy and paste into the box and install
that's what i did. and it works just fine now! good luck
I got the same thing. I have a copy of my zen on my hard drive so I just ftp'd the order.php to my zen website .. that did the trick. It's working fine again. somehow some lines got deleted. don't know what happened. but when I reloaded the order.php it's back to normal and working great!
Well... in answer to your questions...
1. I just installed the Ask a Question about this product mod at http://zencart-ecommerce-website-design.com which also has the Referred by mod on it.... and no problems with either mod.... So.... long story short - answer is NO... the Ask a Question mod is not the problem
2. No, I have never had a problem with the Referrals mod as I revised it to work for the 1.3.7 version. It installs every time perfectly.
3. I have no clue.... you will need a developer / guru to answer this question I guess. :shocking:
Quote:
Originally Posted by gogolf
I uploaded the sql patch (browse) method and ran it.Quote:
Originally Posted by DrByte
Judy,
Considering all the problems we are all having maybe "we" have to come up with a set of instructions that works the first time?
Quote:
Originally Posted by stellarweb
I seem to be having the same issue: Referred by in Admin Customers continue to display --None-- although the customer has chosen "Other" and "Friend", Unable to display "Other" Referral Sources in Admin. Only shows count. I've also tried registering and using a dummy registration. This time I used Google as a Referral but it still shows up as --None-- in Customer Admin. The only time this changes is if I manipulate the customers_info database.
Any solutions to this?
www.foxxydiva.com/fashions
I have tried installing the mod several times and tried various ways of updating the SQL. However the issues seems to be the same for many of us and that is simply the table is not being written to; it will display whatever you manually post to it however the script or whatever is not doing it normally.
Assuming:
1) Both group of user's, those who were successful and those of us who were not are all using the same mod..... . I'm starting to wonder if the issue, mentioned in this thread before, may have to do with the version of MYSQL that either group is using.
I'm running on a server that uses the following:
Database: MySQL 4.1.21-standard
PHP Version: 4.4.4 (Zend: 1.3.0)
Zen Cart 1.3.7.1
Database Patch Level: 1.3.7.1
It would be interesting to here from those who have gotten the mod to work vs. those who have not as what their server is running.
How about class, what are we all riding in?
Quote:
Originally Posted by Robbyn7
Here's my setup:
Database: MySQL 4.0.27-standard-log
PHP Version: 4.4.7
Zen Cart: 1.3.7
Database Patch Level: 1.3.7
I'm still scratching my head as to why this mod doesn't work either.
Tatiana
My setup is similar:
Database: MySQL 4.1.22-standard-log
PHP Version: 4.4.6
Zen Cart: 1.3.7
Hopefully a pro will chime in with a resolution.
Server OS: Linux 2.6.9-42.ELsmp
Database: MySQL 4.1.22-standard
PHP Version: 4.4.7 (Zend: 1.3.0)
Zen Cart 1.3.7
Database Patch Level: 1.3.7
I believe I posted this info earlier in this thread - but just moved all my web clients over to an upgraded dedicated server. Most clients have zencart websites as that is what I specialize in building. All sites worked fine on the "old" server and continue to work fine on the one with the specs outlined above.
Quote:
Originally Posted by gogolf
The instructions in the zip file are pretty clear I would think - and are exactly what I do when installing the mod ..... they are as follows...
2. Unpack the zip file to a temporary directory on your hard drive. All of the
files are stored in separate directory structures and all files are based on
ZenCart Release 1.3.7 (e.g. admin and includes).
3. Copy the contents of the `how_did_you_hear_about_us_1.3.7` directory to your
Zen Cart installation except for the `install_referrals.sql` file and this
installation file. If you are using any overrides in ZenCart that include the
files in the this contribution, use an application such as Beyond Compare or
WinDiff to compare your files and resolve any differences.
There is one file:
(\includes\templates\template_default\templates\tpl_modules_create_account.php)
which should be put in your template override folder i.e.
(\includes\templates\YOUR-TEMPLATE\templates\tpl_modules_create_account.php)
4. Run the SQL file install_referrals.sql on your database. You can use the
Install SQL Patches in the ZenCart Admin Panel under Tools -> Install SQL
Patches or you can use phpmyadmin for this purpose.
Server Information
Server OS: Linux 2.6.9-42.ELsmp
Database: MySQL 4.1.22-standard-log PHP Version: 4.4.7 (Zend: 1.3.0)
HTTP Server: Apache
Zen Cart 1.3.7
Database Patch Level: 1.3.7
the only thing different on my server than yours (that I did not post above) is:Quote:
Originally Posted by cowboyfred
HTTP Server: WebServerX
I'm running on (or however you would describe it loll)
HTTP Server: Apache/1.3.33 (Unix)
Would this make any difference?
Stellarweb, there are file over rights, and perhaps if a conflicting mod is causing this problem, it would be easier to just implement the code rather than completely replacing it? I always use winmerge to compare the files, but as I'm not a coding expert, sometimes I'll overlook something. Would the issue be customers.php, orders.php or any other similar file?
Thanks,
Tatiana
I, too, use Winmerge - and yes, one needs to be very careful when merging the files together if they are using other mods that also modify the same files.
It is also important to note that usually you will see notations that show the start and the end of the mod code and should copy those notations over as well - AND that just because you see the code once at the top of the file.... doesn't mean there is not MORE code for that mod further into the file. Using the create_account.php file for this mod - there are 3 different instances where there is code that might need to be transferred over if integrating with other mods.
Quote:
Originally Posted by tatiana77
Did anyone get this mod to work properly?
I'm still waiting to see what the concensus is with respect to the server side however it would be nice if one of the Zen resident experts looked at the scripts.Quote:
Originally Posted by Robbyn7
Works for me every time - every site it has been installed on - but a few people are having trouble getting it to work for unknown reasons.
Quote:
Originally Posted by Robbyn7
Quote:
Originally Posted by stellarweb
Ahhhhh Yeah. You keep saying that and a "few" of us keep saying it.
Amazing really. Its like Aice in Wonderland. I can't wait to pop out of the hole.
Well hmm [gogolf] I think it is interesting that a few got it working just fine and a few have the Exact same problem.
I would love it if one of the Zen 'heads' figured this one out.
For now, I am asking my sales rep to tell her potential clients to enter her name as a referall in the "Shipping Instructions" or whatever it is when a customer is placing an order on the site. This way I can make sure to pay her a proper commission if the customer was referred by her.
IT sucks, but until there's a proper way of solving the problem, it'll do.
Tomorrow (which means Friday) I'll be reinstalling the mod. I vaguely recall reinstalling it, but maybe I'll try something different ... a far cry since this is defintely a mod that has got me stumped. I'm going live in 2 days...
PS No offense stellarweb.
Tatiana
I'm all ears hear tatiana77.
PS. I love your lip stick.
No offense taken! :yes:
Let us know how it goes!
Quote:
Originally Posted by tatiana77
Me too! I have been 1/2 tempted to ask the zen team to just take my 1.3.7 revision of the mod off the download list because I feel so bad that it seems to work perfectly on the sites I install it on - but not for you and others.
To date, it has been downloaded over 4,500 times - it would be interesting to know how many of those downloads have been successful and how many could not get it installed. (Sorry that is what my hubby calls my ANALytical side coming out!) :ohmy:
Quote:
Originally Posted by gogolf
Stellarweb,
Don't take (my) our rantings personally. It is just frustrating to sit here and wonder what we are doing "wrong". As I said before this Mod is a fantastic, worthy and needed feature; in order to properly track and budget your advertising in marketing your product or service you NEED to know where your customers are coming from just as well as where they are not coming from.
I can tell you that some of the error messages I get, when running the sql patch through the Admin or simply through my phpMyAdmin, is that a: table, field or value already exists; as noted by other posts in this thread.
I'm not a sql guru however what I found was that if I reviewed all the errors noting the duplication and then deleted all those tables, fields or values from my database through phpMyAdmin and then ran the patch through phpMyAdmin I did not get an error report. However but there was error that popped up once but did not repeat itself and the related to "array". Reading through all the posts on this thread you can see bits and pieces of the whole problem we are encountering.
And somehow the referral values are not being posted to the database; if go into your database and post a value (ie. 1,2,3,...) manually the Admin/Customers does show the text value (ie. AOL, Yahoo, Zen...).
If some guru could resolve that part of the problem, getting the values into the database, I think the sql patch issue can be cleaned up quickly.
Why you are not having a problem I'm clueless. Why only a "few" of us are reporting errors I'm more than clueless. It would be a nifty feature to add to the download mod's section a feature that asked for a feedback on whether a user had success, or comments, or whatever; for now the forum will have to work. It is possible that though you may be seeing a high number of downloads that the user simply did not attempt to use the mod or made multiple downloads (such as me) thinking something did not come down or it changed.
Again, you have smart mod, it just needs a tweek here or there.
Thanks for the ego boost - but I didn't create the mod - just revised the 1.3.6 version to work with 1.3.7.
I wonder if maybe you would have better luck downloading the older version, then using winmerge or another comparison program and changing/integrating the files on your end.... or have you already done that?
BTW... The error about the table already existing should not pose a problem.
Quote:
Originally Posted by gogolf
gogolf,
Please PM me if you would like for me to take a swing at installing this mod on your server. I would need a fresh install of zencart - with no files changed - and none of the files in this mod on the server.
Quote:
Originally Posted by gogolf
Thank you.
I'll PM you details tomorrow.
Quote:
Originally Posted by stellarweb
Hi guys,
Please post any findings if you come up with a fix gogolf/stellarweb.
In the meantime, this is what I've noticed of late: 3 mods are not working for me - all three are admin mods (this one, user tracking and advanced stats)
I have changed the name to my Admin directory for security purposes.
Could this be a cause?
Good luck may the force be with you
Tatiana
PS I'm on the showcase come stop by!
I am using the applezen template. I have also installed the Ty Package tracker and customer tax exempt modules. Any help would be appreciated.
I get the following error in ADMIN> CUSTOMERS> ORDERS:
Parse error: syntax error, unexpected T_CASE in /home/aaadi3/public_html/admin/orders.php on line 195
Also when a customer submits a new login, the following error results:
[FONT=Times New Roman]Warning[/FONT]: Cannot modify header information - headers already sent by (output started at /home/aaadi3/public_html/includes/languages/english/create_account.php:110) in /home/aaadi3/public_html/includes/functions/functions_general.php on line 44
StellarWeb - Here is something that might or might not help. I was having problems with my Improved Attributes Controller Mod and someone helped out by posting an updated attributes_controller.php file. I know it's a completely different mod, but I noticed a specific set of strings while doing winMerge... seems like there was a 'code override' that fixed everything and now it works.
Do you think this would help for the referrals mod? I personally no the bare minimum for coding, but I'm trying to do some detective work to help fix this problem . I've attached this file, maybe you can gain some info.
Thanks,
Tatiana
Hello,
I followed everything step to install the "how do you hear from us" module. Everthing looks fine except I cannot find the "how do you hear from us" box?
I didn't see it in the register page. Did I miss anything?
By the way, the site is :http://www.loveinrose.com/index.php?...create_account
Lina:no:
I THINK I may have "stumbled" on to part of the problem:
I was reading over the early posts in this thread. Look at 7th July 2006, 09:46 PM posted by narsaw. They said, if I may quote "Turns that I was using and 'override' (includes/modules/my_template/create_accoutns.php file which I neglected to update with the inclues/modules/create_account.php from the contribution. Works beautifully."
So following the scheme I've been using for my customized Zen installation I then inserted a "custom" folder under the modules folder, like this:
includes/modules/custom/create_account.php
I then created a new customer and used the drop down box when you get to the bottom of the online form and choose "google" for instance from the default sources that came with this referral mod.
I then looked in my admin/customers screen and saw, low and behold, under TABLE_HEADING_REFERRED_BY there was "google" !
However when I ran the admin/reports/Customers Referral Report nothing was reported.
So at least half of the battle is won. Half a Zen is better then no Zen.
This makes me wonder if whether the issue or problem takes us back to the basics of the over- ride system that seems to be nailed all over the place and appears to the source of our problems in many cases; refer to this article on over-rides:
https://www.zen-cart.com/tutorials/index.php?article=36
If this is the solution (testing or logic will tell us) then what needs to be done (maybe) would be to put a YOUR_CUSTOM... folder in the folders that comes with this mod for each file that requires it so people like me who don't read instructions will get a hint.
One suggestion I will make and I'm sure its been covered as well, whenever you put a mod'd file in your store you may want to make a note in the top of the file so you know what you are working with. Stellar I'm not picking here but for example the header of the create_account.php file should have something in bold text or a note in the copyright section so the user can quickly tell what version of the file they are using, maybe something like this:
/**
* create_account header_php.php
*
* @package modules
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: create_account.php 4825 2006-10-23 22:25:11Z drbyte $
* MOD FOR HOW DID THEY HEAR ABOUT US.. BY STELLAR XX/XX/2007,
REVISION XXXX.
Just a suggestion.
I think I'll open another beer (too dark out to golf) and go back to files and put a "custom" folder in every folder this referral mod affects,just for giggles, to see what happens.
Stay Tuned!
go go gogolf!
I'll check it out, nice detective work. I'll repost if something happens (or doesn't):cool:
Tat
Ah ha! Good work detective.
I've got the reference for google showing up.
Hmm, I guess I put the create_account file in the includes/modules instead of my includes/modules/custom folder... well well.
As for the admin/reports/Customers Referral Report not reporting, nothing is showing up for me either... would this be only for the discount codes? I don't remember if this is part of the mod... sorry.
I also tested the 'other' source and typed ABC and when I checked Admin/Extras/Referral Sources, it just put it under 'other', which is ok because when I looked at Admin/Customers/Customers, ABC was written next to the appropriate user name. (as well as Google for the first 'customer' name)
Well , I have to hand it to you, from all the difficulties with the mods, this has been the best result.
Stellarweb when I opened up the zipfile, the directory associated with it is includes/modules, I would change it to includes/modules/custom.
[sigh of relief, pats gogolf on the back]
[cracks open a beer too!]
Tatiana
Hmmmm for some reason the How did you hear about fields are mandatory to create an account? That's really imposing I would think. Any way to change this?
Also, I entered "parents" as a discount code, and it showed up in admin/reports/customer referral reports (but nothing happens when I click on report...)
And it doesn't show up in admin/customers/customers... this is maybe a conflict with create_account.php... I'll check it. are you in the same boat?
Tat
gogolf,
Sounds like you are well on your way to figuring out the problem as it pertains to your site. GREAT JOB! :cool:
You may want to make sure you are using the updated admin/includes/languages/english/customers.php file with the mod that will take away the "TABLE_HEADING_REFERRED_BY" text and make it say Referred By
The only file that was suggested to put in the overrides directory was the includes\templates\YOUR-TEMPLATE\templates\tpl_modules_create_account.php - which I did put in a YOUR TEMPLATE folder in the mod files.
Not sure why your site is requiring you to put the other file in an override directory - because it works fine NOT in an override directory on all the sites I have installed it on ... but hey... who cares as long as it works!! :clap:
As for putting info in the header of the file - I think that is a great idea for each individual to do if they wish. Especially if they have several different mods that "modify" the same file - so to put those in that header area might be a good tracking idea for others! I put notes in my dreamweaver program on the different files - just to keep track of what is going on with the zencart websites I build for my clients.
The report you mentioned will not reflect the referrals from this mod. You will find this information under EXTRAS - Referrals and Referral Sources
stellarweb, any way to make these fields non-mandatory?
Thanks,
Tatiana
Fellow Zenner's.
Please let me know if you were able to get the referrals to finally appear in the admin/customers after you have tried putting the create_account.php in your includes/modules/"custom" (folder)
thank you.
In the admin panel go to configuration->customer details and you will see "require referral". Set that to false and you are all set.Quote:
Originally Posted by tatiana77
Yes, it's there in the customers section in between "account created" and "last login".Quote:
Originally Posted by gogolf
The only file I put into an override folder was the template file. I had to merge both the modules/create_account.php and the template file in includes and admin/customers.php and admin/orders.php as well as admin/includes/languages/english/customers.php. It can be a little tricky merging, I use examdiff pro - a free program that I think is available from Sourceforge, because sometimes the lines of code don't match up from file to file since there are other code snippets in one if you have modified it for another mod. This one was pretty easy because it was well commented. Basically you are looking in the new file for the snippets that are for that particular mod, so for this you are looking for //rmh referral start and copy until //rmh referral end.
I hope this helps you to get it working.
hello,
Couyld anyone help me with this problem? Thank you!!!
I followed everything step to install the "how do you hear from us" module. Everthing looks fine except I cannot find the "how do you hear from us" box?
I didn't see it in the register page. Did I miss anything?
By the way, the site is :http://www.loveinrose.com/index.php?...create_account
Lina
Gogolf, Tatiana, & others, I just wanted to report back in that I was able to get it working. My problem was that everything seemed fine except that the data was not getting posted to the db. The only thing I did to get it to work is to start over from scratch and repaste the code from the mod into my files.
At one point, I had made the same mistake you are discussing that I had a create_account.php in includes\modules\custom\ but I had pasted the mod code into includes\modules\. After I fixed that mistake, it still wasn't working (I think). Then I did my "do-over" and it worked. Sooo... my original mistake MAY have been a reason it wasn't working, but I really can't pinpoint why it was not working before and now is. I'm just thanking my lucky stars it's working. :clap: I'm pulling for you guys too... I know how frustrating it is. :frusty:
Lina, it should be showing up in the create_account page.... 2 thoughts: 1) did you paste the mod code into the tpl_modules_create_account.php file in your includes\templates\your_template\templates folder? 2) I can't remember if there is an admin setting to turn on the feature (I don't think so), but I remember there are a few different places across admin for this mod's settings (if I recall correctly).
LankeeYankee - Works, thanks!
MyGreyGoose/Gogolf/Stellarweb - It's working for me, thankfully!
Please see my last post...
Tat:smartalec:
[FONT=Tahoma][FONT=Arial]I moved the create_account.php to the folder as suggested and that did not correct my problem. [/FONT][/FONT]
[FONT=Tahoma][FONT=Arial][/FONT][/FONT]
[FONT=Tahoma][FONT=Arial]The displayed error message: [/FONT][/FONT]
[FONT=Tahoma][FONT=Arial](Parse error: syntax error, unexpected T_CASE in /home/aaadi3/public_html/admin/orders.php on line 195) [/FONT][/FONT]
[FONT=Tahoma][FONT=Arial]is a syntax error detected during php parsing. Such a syntax error must be corrected before a program can run. A syntax error could be wrong or missing punctuation, unrecognizable operators or statements, etc. The resulting code cannot execute. This contribution does not seem to be in a bug free condition.[/FONT][/FONT]
[FONT=Tahoma][FONT=Arial][FONT=Tahoma][FONT=Arial]Is the author of the code available to assist in debugging?[/FONT][/FONT][/FONT][/FONT]
[FONT=Tahoma][FONT=Arial]I use the applezen template and this contribution is not easy to uninstall. Any suggestions?[/FONT][/FONT]
(Parse error: syntax error, unexpected T_CASE in /home/aaadi3/public_html/admin/orders.php on line 195)
I got the same error when I was looking at my admin/orders however not being a "expert" with this mod I looked at the version of orders.php that comes with the new 1.3.7, that version is June 25, 2007 and the version that came with mod is December 28, 2006. If you you a file compare program you will see the differences in the two versions.
I'm guessing the error message we saw is a syntax as stated. I have not explored it, maybe something like a forgotten "}" bracket, but then again I'm the few who has problems with this mod.
I'm trying to see what effect having the original orders.php file has with this mod so I loaded the later version (that came with 1.3.7) back on my server to see which way it goes .... "hook or slice".
Thanks for the response! I gathered from your message that you have a procedure for removing the mod. Since I cannot get this issue resolved I want to remove it but I don't know how. Any suggestions?
I'm sure there is a posting on the procedure for replacing the changes you have made to your store. You'll the constant warning with any modification you read on the forum, such as back up, back up back up.
Look at the mod's folder and files. Make a note of them and their structure.
Locate the files in your store's server files. Delete those files.
Take your last saved store (folder and files) and upload those matching files.
If you have not modified any of those files, such as you have a new clean install, simply take the files out of the Zen packet of files.
Hopefully you made a back up of your database before you installed the mod.
Upload the back up copy of the database that you have before the mod was installed.
Quote:
Originally Posted by hllight
Glad to hear some of you have gotten this mod to partially work by adding a custom directory. I tried this, deleted the create_account.php from includes/modules. Added it instead to includes/modules/custom but no go for me. I received an error message after doing this so I added it back.
I get confused with all the problems the few of us can have with this mod.
Which was yours, the sql patch or the referral not showing up in the admin/customers ?
Quote:
Originally Posted by Robbyn7
Hey gogolf I'm confused myself!
My issues are when a customer registers and chooses a referral, it shows up in Admin, Customer, Referred as "None" each time. And if I check out referrals from within Admin, it shows not what the customer entered but "Other" instead.
Thanks,
Robyn
I'm clueless on the Zen application, php, sql, etc. I feel like I'm hacking a ball down a course I never played, in the dark, and though the fellow Zenner's who have played this course are trying their best to help the words just seem like crickets echoing in the back ground.Quote:
Originally Posted by Robbyn7
Maybe this might help you. If you go back to the beginning of this this thread you'll see the common errors that pop up related to making the sql changes to the database and the referral not appearing in admin.
I have yet to figure out why the sql patch does not install cleanly for me and others vs. others. I think that that problem relates to possibly a field or table already existing and/or simply syntax.
With regard to the field or table not being updated I found that putting a file in my "custom" folder worked for me.
I would suggest looking at your database and see if the values needed to post the referral names are listed there.
I think my problems with this mod are part my own (not understanding the Zen application and its languages) and simply the need for a better documentation with the mod.
I found the solution to get it to work for me required me to read all the posts to this thread again and again. Simply a lot of extra strokes.
Backups were made but there is a flaw in my backup procedures. I backup all the files and the database then do the install and if all seems to work I move on. UNFORTUNATLEY, I did not find the problem till days later. The database backups are dated, however the site files backup is overwritten with the latest stuff each time I backup. :-(
I wish I could find someone who has this installed this mod and is using the apple zen template. That would tell me if they are incompatible or not.
After reading this message again, you didn't say how you fixed it. Did you use the files from the December version? If so which files?Quote:
Originally Posted by gogolf
Correct. I never summarized how I got it to work. It is a frustrating problem some of us are facing.Quote:
Originally Posted by hllight
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.Quote:
Originally Posted by Robbyn7
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
see attached file only when unexpected T_ error.Quote:
Originally Posted by hllight
Forgive my ignorance but...
There are two orders.php files in the following directories:
\admin
\admin\includes\languages\english
Do both get replaced?
I think I finally got it. All errors are gone, I HOPE.Quote:
Originally Posted by importprijs.nl
Thank to everyone for your help!!!
Hello
I was also having this problem in /admin/order.php
I ended up doing the following;
1. Comment out lines 181 - 193
2. Comment out line 253 as it's a second declarationPHP Code:}
}
if (($action == 'edit') && isset($_GET['oID'])) {
$oID = zen_db_prepare_input($_GET['oID']);
$orders = $db->Execute("select orders_id from " . TABLE_ORDERS . "
where orders_id = '" . (int)$oID . "'");
$order_exists = true;
if ($orders->RecordCount() <= 0) {
$order_exists = false;
$messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');
Hope this helps someone - and if anyone thinks I'm wrong p[lease let me know...PHP Code:include(DIR_WS_CLASSES . 'order.php');
Thanks
Andy
We tried that too. Now try to create a new account now. I believe you will get a different error at the end of that process.
I will have to check my notes, but I believe putting the create_account.php in its proper location was step one and the second part of my probem was a second occurance of the orders.php file.
Just wanna thank everyone for their help. Whew! I finally got this mod to work.
Referrals now appear in my Admin, Customers, Referred by and also my Admin, Extras, Referrals. After using winmerge to do a comparison, I noticed my create_account.php files weren't identical. Once I got a match, I uploaded it to my server and everything started working.
Hope this helps someone else. :clap:
Hip Hip Hooray!
Robbyn,
Do you think you can remember all the steps you took to get the mod to work?
Quote:
Originally Posted by Robbyn7
Were you able to get the "other" referral to show the text entered into the "other" textbox on customer signup? When I click the "other" link in admin/extras/referral sources it shows 0 of 0 even though there are 8 "other" referrals.Quote:
Originally Posted by Robbyn7
Also, you mention it appearing in admin/customers/referred by but I don't have anything like that, only 2 links in extras - referrals and referral sources. Have I missed something?
Thanks,
Matt
Also got it working, just uploaded the create_account.php file again and this time my referral showed in the admin customers section.
Hip Hip Hooray!
Robbyn,
Do you think you can remember all the steps you took to get the mod to work?
Hello Gogolf,
I went back to one of your post where you put the create_account.php into a custom folder. Well, after no success with this I thought hmm...let me compare the files(again). So I downloaded this module again, compared it to what I already had, copy and pasted the .sql file(again). This time everything works! I can even see what someone puts in for "other" on my Referral Sources page. So I'm good to go.
Not for certain but I think the problem is in the create_account.php file. Try comparing it or uploading it again.
How far did you get?
Look Hot for Less!
Foxxy Diva Fashions
Hello Lankeeyankee,
Yes, I am now able to see the "Other" text entered upon signup. All I have to do now is double click "Other" from the Referral Source screen and Voila'.
If you click on Admin, Customers, you should see it as a header. At first I got --none--. Now I'm getting the actual results.
Did you copy and paste your .sql file?
Look Hot for Less!
Foxxy Diva Fashions
I just download this and I can't seem to get it to work. I have the same problem that everyone else is having. Can someone who got this to work do a step by step instruction on how to make the fix? I see bits and pieces but not one complete "ok do this to fix the problem.."
That would be so appreciated.
Here is the best I can offer you today, if it helps.Quote:
Originally Posted by TrvlFox
1) Read over my posts. Cut and paste them into wordpad or something and see if I was onto to something. I'd do this for you but it takes me about a dozen cups of coffee to turn on the pc.
2) Read the latest posts here from Robbyn7 who seems to have made it work as well.
I wish I could give you the magic pill here. However. I can tell you that many of the problems I run into with mods involve not having the right parts in the right places, such as having a "custom" folder and not putting things there or having a mod that is not looking there.
Hi TrvlFox,Quote:
Originally Posted by TrvlFox
Are you getting an error message?
Robyn
Foxxy Diva Fashions
I installed 1.37 and the front end is working fine, but I don't see any orders in the admin area. I do see the order in the database and if I put in the order id. When I click on Orders a blank page comes up.
I then upgraded my ZC install to 1.3.8 and also this mod to 1.3.8a. Now I can see the Orders page, but I can't see any orders on it! I can still get to them by entering id.
In my modules, Order Total ot_total is installed.
The only active payment module is - Credit Card - Offline Processing
I went through this entire post and some others multiple times but can't fix this issue.
Could this be a php 5.x issue?
---------------------------------------------------------------------
Zen Cart 1.3.8a (upgraded from 1.3.7)
Database Patch Level: 1.3.8
PHP Version 5.0.4
Mods: fual slimbox v0.1.4, How did you hear about us 1.3.8.a, image handler 2.0
I had considered my initial problem with getting the mod to work was a server, php or mysql issue. I don't think that was the case. If you read my posts you maybe be able to determine what I did to get it to work.
I can tell you however that in many cases the problem can be something as simple as having all right files in the proper folders or directories ;>)
Quote:
Originally Posted by dreamz
I just installed this module that i received from ranger lp for zencart 1.2.7
Everything installed fine - from a customer point of view it looks fine. However in the admin side i get a number of errors
On the admin referral sources page i receive this error
Fatal error: Cannot use object of type queryFactoryResult as array in /home/directory/public_html/shop/admin/stats_referral_sources.php on line 86
on the admin referral page i receive this error:
Fatal error: Cannot use object of type queryFactoryResult as array in /home/directory/public_html/shop/admin/referrals.php on line 112
Also I created a test account and it didnt seem to take the referral source i put in.
The server is using PHP version 4.4.4
Thanks in advance for your help!
Try to use these files instead. These are the ones I use on my 1.2.7 site.
Tony