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

[cowboyfred]

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:
#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?

This post was from awhile ago and i don't remember how i fixed it. However, i am running the most current version of Zen-Cart and everything is humming along just great.

[gogolf]

i'm "hacking" for better terms as trying to get this mod installed on an oldver of Zen, I guess it is a 1.3x version.

I can see the TABLE_HEADING_REFERRED_BY showing up through the Admin-Customers section

What field names are suppose to be added to the database?

[stellarweb]

If you will look in the install_referrals.sql file - it will tell you the tables that get added to the database.

i'm "hacking" for better terms as trying to get this mod installed on an oldver of Zen, I guess it is a 1.3x version.

I can see the TABLE_HEADING_REFERRED_BY showing up through the Admin-Customers section

What field names are suppose to be added to the database?

[gogolf]

Stellar, I appreciate your input. This is a great forum.

However being a newbie to sql , php, etc, I am trying to understand this.

I'm looking at my database in php and trying to confirm if the database was properly updated with the sql patch (since we all seem to have had problems with it).

When I plug in the patch for 1.3.6 I get the following message:

12 statements processed.
Error ERROR: Cannot ADD column customers_info_source_id because it already exists.
Error ERROR: Cannot insert configuration_key "DISPLAY_REFERRAL_OTHER" because it already exists
Error ERROR: Cannot insert configuration_key "REFERRAL_REQUIRED" because it already exists
Warning Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.

So can I assume that the proper tables were inserted or updated?

If you will look in the install_referrals.sql file - it will tell you the tables that get added to the database.

[stellarweb]

Yes, that is a safe assumption.

Stellar, I appreciate your input. This is a great forum.

However being a newbie to sql , php, etc, I am trying to understand this.

I'm looking at my database in php and trying to confirm if the database was properly updated with the sql patch (since we all seem to have had problems with it).

When I plug in the patch for 1.3.6 I get the following message:

12 statements processed.
Error ERROR: Cannot ADD column customers_info_source_id because it already exists.
Error ERROR: Cannot insert configuration_key "DISPLAY_REFERRAL_OTHER" because it already exists
Error ERROR: Cannot insert configuration_key "REFERRAL_REQUIRED" because it already exists
Warning Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.

So can I assume that the proper tables were inserted or updated?

[gogolf]

Yes, that is a safe assumption.

OK. So we can assume all the tables are now correct.

My next problem is I can't see the referral choices or drop down on the Login page under the Options, what could cause that though I have updated all the other files to the store site?

[stellarweb]

Do you have a link I can take a peek at?

OK. So we can assume all the tables are now correct.

My next problem is I can't see the referral choices or drop down on the Login page under the Options, what could cause that though I have updated all the other files to the store site?

[gogolf]

pm sent

[stellarweb]

Got it - and just sent you a reply. Hope it helps a little bit!

pm sent

[gogolf]

Well know that I know I'm (cough) using version 1.2.6 WE know that the Referral mod won't work "easily". Thanks for the tips Stellar. It seems I have to either trade in my wood for a graphite shaft or hack away with 1.3.7.