Actviation code contribution

[tangwaichee]

Hi, im running some problems with this : 1. Run this query in Database:

 

ALTER TABLE customers ADD customers_activation_code VARCHAR(32);

ALTER TABLE customers ADD customers_active_status CHAR(1);

 

 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

 

 

VALUES ('Activation Code for Registration', 'ACTIVATION_CODE', 'on', 'Do you want to activate Activation Code for Registration?', 5, 0, now(), now(), '', 'tep_cfg_select_option(array(\'on\',\'off\'),');

 

 

 

IF YOU HAVE EXISTING CUSTOMERS, YOU MUST run query below OR THEY WILL NOT BE ABLE TO LOGIN:

update customers set customers_active_status = '1';

 

what is the configuration sql??

 

please advice

[web-project]

what is the configuration sql??

configuration table contain the configuration sql

[tangwaichee]

configuration table contain the configuration sql

 

Him im dont understand the sql like that, or can you show me how to create it.. inorder

 

thanks you

[♥geoffreywalton]

William

 

You need to "run" these 4 bits of sql code against your database

 

ALTER TABLE customers ADD customers_activation_code VARCHAR(32);

 

ALTER TABLE customers ADD customers_active_status CHAR(1);

 

 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Activation Code for Registration', 'ACTIVATION_CODE', 'on', 'Do you want to activate Activation Code for Registration?', 5, 0, now(), now(), '', 'tep_cfg_select_option(array(\'on\',\'off\'),');

 

 

update customers set customers_active_status = '1';

 

Use phpmy admin. select your db, click on an sql tab, paste one of the commands into the window, click on "GO", repeat for each sql command above.

[tangwaichee]

William

 

You need to "run" these 4 bits of sql code against your database

 

ALTER TABLE customers ADD customers_activation_code VARCHAR(32);

 

ALTER TABLE customers ADD customers_active_status CHAR(1);

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Activation Code for Registration', 'ACTIVATION_CODE', 'on', 'Do you want to activate Activation Code for Registration?', 5, 0, now(), now(), '', 'tep_cfg_select_option(array(\'on\',\'off\'),');

update customers set customers_active_status = '1';

 

Use phpmy admin. select your db, click on an sql tab, paste one of the commands into the window, click on "GO", repeat for each sql command above.

Thanks you for all this while helping me...problem sloved

 

thanks you

[MrAliKorn]

Having problem after install.

Following error conformation code page , after submiting reg info.

 

Notice: Undefined index: activation_code in /misc/34/000/064/086/4/user/web/catelog.alikorn.com/account_activate.php on line 25

 

 

It still sends the conf Email, after following link back to activate page, conf code in place and hit continue to activate i get nothing but this:

 

 

Notice: Undefined index: activation_code in /misc/34/000/064/086/4/user/web/catelog.alikorn.com/account_activate.php on line 25

 

Notice: Undefined index: customers_active_status in /misc/34/000/064/086/4/user/web/catelog.alikorn.com/account_activate.php on line 49

 

Notice: Undefined index: customers_country_id in /misc/34/000/064/086/4/user/web/catelog.alikorn.com/account_activate.php on line 77

 

Notice: Undefined index: zone_id in /misc/34/000/064/086/4/user/web/catelog.alikorn.com/account_activate.php on line 78

 

Warning: Cannot modify header information - headers already sent by (output started at /misc/34/000/064/086/4/user/web/catelog.alikorn.com/account_activate.php:25) in /misc/34/000/064/086/4/user/web/catelog.alikorn.com/includes/functions/general.php on line 33

 

 

I have done the install both ways drop in and manual Im shure im missing somthing. Also shure that a one liner fix will kill all the errors Im just missing it.

Any Ideas?

MrAliKorn

[♥geoffreywalton]

Google

 

Warning: Cannot modify header information - headers already sent by

 

or read the online documentation/knowlwdgebase.

 

G

[MrAliKorn]

Google

 

Warning: Cannot modify header information - headers already sent by

 

or read the online documentation/knowlwdgebase.

 

G

If Googling any of the errors would have produced a fix i wouldnt have posted here. Its not a generic problem its a problem with the code. It seems to be in the DB sql portion, almost same to the above fellas problem. Best I can tell its putting in the "ACTIVATION_CODE" into the DB however Line 25 in the account_activate.php isn't picking it up resulting in the errors.

[paq1200]

great contribution but the only thing i see is that all someone has to do is go to :

 

http://www.yoursite.com/account_activate.php and click the button.

 

it takes you to the success page

 

from there all sort of orders can be made.

 

did I miss something or is this a bug.

 

Mike

[MrAliKorn]

after fresh instal Recieving Error:

 

Notice: Undefined index: activation_code in /Mysite.com/account_activate.php on line 25

 

for some reason the call is not finding activation_code in the DB. Have installed the sql per instructions and checked db to see if it took, it has.

How do I define activation_code in account_activate.php ?

 

Any Sugestions?

[F22-Raptor]

I've installed the contribution but no emails are sent out. I don't get any error just no email sent out with the code.

 

My store is 2.2rc2a with some other contribution.

 

Any idea why this is happening? Is there a log I can check out to see if there are are "store" errors?

 

 

If I disable the contribution from the Admin panel the osC welcome email is sent out.

 

Thanks

 

Dan

[F22-Raptor]

Did a little testing and here's what is happening:

- if the email is Hotmail or Yahoo then the email never gets to the destination

- I did get one email through (no idea how) but it was marked as spam

- if the email is different than Hotmail or Yahoo then the email is delivered (I sent one to work and got it right away)

 

Is it possible that Hotmail and/or Yahoo drop the emails because they are interpreted as spam?

 

How can the change the email content so it doesn't look like spam?

 

Thanks

 

I'll keep trying.