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

Wow, well I finally overcame my fear of mysql and actually LOOKED at the coding. It does clearly tell you which table and values are being created.

Anyway, the code I had already was the modified version of 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());

However.... I solved the problem :smile:

I had stupidly uploaded all the files in the folder Cart>admin>includes, BUT I had forgotten to do the ones for Cart>includes

As soon as they were uploaded (most are the same as the admin>includes files), it worked like a charm.

Thanks Diva Vocals, for all of your suggestions. When my programmer (!) husband comes home tonight I shall impress him by telling him that I know know how to find the values in a mysql table, how to delete and drop them etc. Maybe he will take me out to dinner :smile:

I'm glad you decided to give it a try, and that it all worked out for you.. Good luck with your site..

Quote:

---

Originally Posted by ttalk

it's working for me, just merge orders.php carefully as the core file was touched in 1.3.7. Note that in 1.3.6 location of an include file was in the middle of the file but in 1.3.7 it was moved to the top of the file, make sure you remove the one in the middle in your modified orders.php otherwise you'll hit a fatal error trying to declare a class twice.

---

I've run into this problem too, using the latest download on V1.3.7. I've made the changes as suggested -- no success. Any ideas??

What error exactly are you getting? Can you copy and paste the error here?

Also... you said you used the latest download and made changes... but the post you quoted I believe was referring to changes to the old files... so I guess we also need to know what changes you made..

Quote:

---

Originally Posted by rnet

I've run into this problem too, using the latest download on V1.3.7. I've made the changes as suggested -- no success. Any ideas??

---

Quote:

---

Originally Posted by stellarweb

What error exactly are you getting? Can you copy and paste the error here?

Also... you said you used the latest download and made changes... but the post you quoted I believe was referring to changes to the old files... so I guess we also need to know what changes you made..

---

I'm using the latest download, but when selecting any order from admin - I get a blank page. I tried to make the orders.php edits listed in prior posts without success. If I substitute the original (stock) orders.php file, it works -- however I do not see the referrals listed, except in the column under admin>Customers (column title Referred By).

Ideally you should not have to edit the latest download at all - at least not the orders.php file.

A couple of things to do....

1. Make sure you are using the 1.3.7 version and you have not made any changes to it.

2. Make sure you are uploading the install referrals sql file via your admin area (Tools / Install SQL Patches)

3. Double check and make sure that you have all the files put in their proper order / folders, etc.

4. If all that fails, in the sql file try changing

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

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

and see if that helps.

That is about all the advise I know to give. If you have modified your orders.php file with another mod.... that may be causing a problem ... you would have to use something like WinMerge to compare the two files.

Quote:

---

Originally Posted by rnet

I'm using the latest download, but when selecting any order from admin - I get a blank page. I tried to make the orders.php edits listed in prior posts without success. If I substitute the original (stock) orders.php file, it works -- however I do not see the referrals listed, except in the column under admin>Customers (column title Referred By).

---

I've confirmed that I'm using the correct versions.

The LOG file shows: PHP Parse error: parse error, unexpected T_CASE in /var/www/html/admin/orders.php on line 195

Suggestions?

Hi,
I am on zencart v1.3.7 and have been trying to install the How Did You Hear About Us Version 1.3.7 mod -- I was also getting the 1064 SQL syntax error message. I tried several of the suggestions here with no luck through the zencart sql patch screen. So, I went to my phpmyadmin screen on my hosting site and pasted 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());
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());

The error message that came up on their screen which said I needed to check the syntax indicated a difference in the word "now" just before the ()); and displayed that word in CAPS. Knowing nothing about SQL, I left everything else the same in the above sql patch, except I changed the "now" to "NOW" and submitted the sql again. I got a success message. I went back to my store, and now I have the two options showing up under the configuration for My Store and Customer Details. I just checked my "Online Catalog" and so far, the screen where customers can create an account looks correct with the "Other" option showing up as well as the text box where they can type.

I also get the error:

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());]
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.

when i import the SQL file i get this error:
Error

SQL query:
ALTER TABLE customers_info ADD customers_info_source_id int NOT NULL AFTER customers_info_date_account_last_modified;


MySQL said: http://209.85.82.130:2082/3rdparty/p...img/b_help.png
#1060 - Duplicate column name 'customers_info_source_id'

Here is some info:
Server version: 4.1.22-standard-log
phpMyAdmin - 2.10.0.2



I have modified the code 'zen_cfg_select_option(array('true', 'false'),'now());
and changed it several different ways. and no luck. Is there another solution?

Quote:

---

Originally Posted by rnet

I've confirmed that I'm using the correct versions.

The LOG file shows: PHP Parse error: parse error, unexpected T_CASE in /var/www/html/admin/orders.php on line 195

Suggestions?

---

I get the same error too . I have a suspicion that the Paypal updates may muck it up. as when i installed this Paypal stoped working ! may be coincedence.

Hope someone can suggest a fix.