How Did You Hear About Us? Referrals Mod [Support Thread]

[mydanilo]

To ryk and anyone that had the orders.php problem with the referrals mod:

I simply downloaded a fresh install of zen cart and uploaded the new 1.3.7 orders.php file to my admin/ directory. That stopped the error on line 195, and I'm still getting who referred in my customer list. ....

This did the trick for me as well. I wonder what the difference is but I do not have the time right now...it works and will have to do for now. Thank you for the tip.

[DivaVocals]

I'm getting ready to install this, and wanted to verify something.. Shouldn't I be creating an override for the create_account.php file for this contribution.

i.e.: includes/modules/my_template/create_account.php

[DivaVocals]

okay i got the database working if anyone out there needs it here is what i did

in the last two insert lines of the sql file there is a piece at the end of both lines that goes

'zen_cfg_select_option(array(\'true\', \'false\'), ', now());

it should read
'zen_cfg_select_option(\'true\', \'false\')', now());

I too got the same SQL errors as was reported by a few folks in this thread.. My host is running MySQL 4.0, and I don't know if that is what the difference is or if this is just a syntax error in the contribution's script.. (I'll admit I only know enough SQL to be dangerous..) That said, the above fix did not work for me.. Here is the SQL that did work..

Find:
'zen_cfg_select_option(array(\'true\', \'false\'), ', now());

Replace with:
'zen_cfg_select_option(array('true', 'false'),' now());

HTH..

[DivaVocals]

I should add that even with the changes to the SQL, I still got the errors when I ran this using the SQL Patch installer.. I had to run the corrected insert statements using my MySQL manager..

Also thought that I should share this.. The array values are case sensitive.. Do not make the mistake I did of changing "true" to "True"..

[stellarweb]

I just did a clean install of the files that are currently in the downloads section to this site http://www.stellarsupplements.com/

I then copied and pasted the install_referrals.sql into the database in the admin section under tools/install sql patches... the code is pasted below.

The install went smoothly - and all worked well, with no changing of the files, so I am befuddled as to why you would have to change anything in the file in order to get it to work. I have installed this on several websites with the code intact, and it works fine on all of them.... BUT they were all on the same server with the same version of sql / php / etc running. Like you, I know enough sql to make me very dangerous so wondering if the problem is different versions of sql or php??

DROP TABLE IF EXISTS sources;
CREATE TABLE sources (
sources_id int NOT NULL auto_increment,
sources_name varchar(64) NOT NULL,
PRIMARY KEY (sources_id),
KEY IDX_SOURCES_NAME (sources_name)
);

INSERT INTO sources VALUES (1, 'Google');
INSERT INTO sources VALUES (2, 'Yahoo!');
INSERT INTO sources VALUES (3, 'AOL');
INSERT INTO sources VALUES (4, 'MSN');
INSERT INTO sources VALUES (5, 'ZenCart');

DROP TABLE IF EXISTS sources_other;
CREATE TABLE sources_other (
customers_id int NOT NULL default '0',
sources_other_name varchar(64) NOT NULL,
PRIMARY KEY (customers_id)
);

ALTER TABLE customers_info ADD customers_info_source_id int NOT NULL AFTER customers_info_date_account_last_modified;


INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display "Other" Referral option', 'DISPLAY_REFERRAL_OTHER', 'true', 'Display "Other - please specify" with text box in referral source in account creation', '1', '22', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Referral', 'REFERRAL_REQUIRED', 'true', 'Require the Referral Source in account creation', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());

I should add that even with the changes to the SQL, I still got the errors when I ran this using the SQL Patch installer.. I had to run the corrected insert statements using my MySQL manager..

Also thought that I should share this.. The array values are case sensitive.. Do not make the mistake I did of changing "true" to "True"..

[stellarweb]

PS...........

My php version is 4.4.6

SQL is 4.1.21 standard

[DivaVocals]

I just did a clean install of the files that are currently in the downloads section to this site http://www.stellarsupplements.com/

I then copied and pasted the install_referrals.sql into the database in the admin section under tools/install sql patches... the code is pasted below.

The install went smoothly - and all worked well, with no changing of the files, so I am befuddled as to why you would have to change anything in the file in order to get it to work. I have installed this on several websites with the code intact, and it works fine on all of them.... BUT they were all on the same server with the same version of sql / php / etc running. Like you, I know enough sql to make me very dangerous so wondering if the problem is different versions of sql or php??

But there has to be some issue going on because reading through this thread at least three others (if I include myself) have reported having the EXACT same error that I got when installing this contribution..

hi i am getting the same error as another poster from a while back. when i install the sql patch i get this return:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'true', 'false'), ', now())' at line 1
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display "Other" Referral option', 'DISPLAY_REFERRAL_OTHER', 'true', 'Display "Other - please specify" with text box in referral source in account creation', '1', '22', 'zen_cfg_select_option(array('true', 'false'), ', now());]

then i dont get the configuration options in my admin>configuration>mystore and customer details.

Please note that this error occurs exactly in the section I changed to get the insert statements to work.. I too did a fresh install when I was testing this contribution.. I wiped out my dev store and started over with a fresh Zen Cart install.. I still got the error when SQL Patch Admin Tool attempted to execute the last two lines of the SQL that comes with this contribution.. I then attempted to run only those lines using my host's MySQL manager, and got the EXACT SAME error.. I then made the change I posted previously, and the code ran successfully. Once I was able to execute the inserts, the contribution worked perfectly..

Please note there is a slight difference between the SQL I ran and the one that comes with the contribution which I believe makes a difference in getting the error or not.. (I've highlighted that difference below) I also believe that the error message indicates that some versions of MySQL will get this error without making the change I had to make..

Find:
'zen_cfg_select_option(array(\'true\', \'false\'), ', now());

Replace with:
'zen_cfg_select_option(array('true', 'false'),'now());

Please note the difference between these two lines.. It really made the difference between getting an error and getting the correct entries into my configuration table and getting this contribution to work. Maybe one of the SQL gurus can chime in and explain why.. I'm pretty sure the answer lies in the differences in MySQL versions..

[DivaVocals]

I posted this on another thread.. maybe someone reading this thread can help..

I wanted to test this, so I created a test customer and chose "Other" I then entered the appropriate data in the "Other" field.. I then went to Extras>Referral Sources and this is what I see:
Sources------------------------Referred
Other --------------------------19

Is the number I see under "Referred" supposed to be a count of how many referrals came from the "Other" referral source?? If so this count is wrong and I need to know how it calculated this count.... More importantly.. How do I fix this???

I've confirmed part of my original question..

The "19" definitely is supposed to represent the number of referrals that came from the "Other" referral source.. However, the count is incorrect. At the time I ran this report, I had only added ONE test customer with "Other" as a referral source in my testing.. I have since added a second customer using the "Other" referral source in order to test that the count is at least incrementing by 1 correctly.. (It is incrementing correctly, and now it shows a count of 20)

So I still need to know how do I correct this so that the count accurately reflects 2 instead of 20.

[stellarweb]

Do you by any chance have other customers that signed up BEFORE you installed this mod? To try to recreate what you are seeing, I just created another account using "other" as the referral - and the one I created before this I chose google.

However, when I look at the "other" count - it is grouping ALL the customers that signed up prior to me installing this mod this morning into that category.... The "google" count is accurate. Does that make sense what I am saying?

I posted this on another thread.. maybe someone reading this thread can help..



I've confirmed part of my original question..

The "19" definitely is supposed to represent the number of referrals that came from the "Other" referral source.. However, the count is incorrect. At the time I ran this report, I had only added ONE test customer with "Other" as a referral source in my testing.. I have since added a second customer using the "Other" referral source in order to test that the count is at least incrementing by 1 correctly.. (It is incrementing correctly, and now it shows a count of 20)

So I still need to know how do I correct this so that the count accurately reflects 2 instead of 20.

[stellarweb]

If I can get a feel for what versions of mysql and php are being used to see if that is the problem, I could add a new file to the contribution that specifies the versions ..... so if anyone that has had this problem can post those two statistics, we can see if there is a common denominator.......