Additional Customers Fields

[rbepple]

Here is my /catalog/includes/languages/english/extra_definitions/additional_customers_fields_create_account.php
[ php ] $additional_customers_fields_form_create_account_pull_down_title['customers_age'] = array('Sales Representative: ');
$additional_customers_fields_form_create_account_pull_down_content['customers_age'] = array('None', 'Mel Kimmel', 'Boyd Thomas');
[ /php ]

and here is my /catalog/includes/languages/english/extra_definitions/additional_customers_fields_account_edit.php
[ php ] $additional_customers_fields_form_account_edit_pull_down_title['customers_age'] = array('Sales Representative: ');
$additional_customers_fields_form_account_edit_pull_down_content['customers_age'] = array('None', 'Mel Kimmel', 'Boyd Thomas');
[ /php ]

create_account shows two identical fields and account_edit only shows one

[TheOracle]

Again - without spaces between the tags (same for the quotes btw):

Here is my /catalog/includes/languages/english/extra_definitions/additional_customers_fields_create_account.php

$additional_customers_fields_form_create_account_pull_down_title['customers_age'] = array('Sales Representative: ');
$additional_customers_fields_form_create_account_pull_down_content['customers_age'] = array('None', 'Mel Kimmel', 'Boyd Thomas'); 

and here is my /catalog/includes/languages/english/extra_definitions/additional_customers_fields_account_edit.php

$additional_customers_fields_form_account_edit_pull_down_title['customers_age'] = array('Sales Representative: ');
$additional_customers_fields_form_account_edit_pull_down_content['customers_age'] = array('None', 'Mel Kimmel', 'Boyd Thomas'); 

And the rest ... ? What does it say in both template files between // Additional customers fields and // End of additional customers fields paragraph ?

[TheOracle]

No updates regarding the rest of the infos from both template files in order to cover this problem ?

Was it covered already ?

[rbepple]

Sorry to bother you!
I have had nothing but problems for some reason. If I delete all the files from your mod my loggin works as soon as I upload them back into the appropriate directories I get this error:

1054 Unknown column 'moderators_level' in 'field list'
in:
[INSERT INTO customers (moderators_level, customers_firstname, customers_lastname, customers_email_address, customers_nick, customers_telephone, customers_fax, customers_newsletter, customers_email_format, customers_default_address_id, customers_password, customers_authorization, customers_gender) VALUES ('0', 'Robert', 'Bepple', '[email protected]', '', '5099432192', '', '0', 'TEXT', '0', 'e5b5473162202bc010bc033501662b7c:02', '0', 'm')]

[TheOracle]

You appear to have installed the 'Moderator level' MOD and probably missed one of my instructions. The 'moderators_level' field, from your TABLE_CUSTOMERS table, is considered a core field. Make sure to have created this field (using the query I added from my installation instruction) and have upgraded the $customers_table_fields from your extra_configure's additional_customers_fields.php file since this field must NOT be affected during any injections or update procedures.

[rbepple]

How do I do that?

[rbepple]

I ran the

CREATE TABLE customers_additional (
field_id int(11) NOT NULL auto_increment,
field_name varchar(255) NOT NULL default '',
field_status char(2) NOT NULL default '',
PRIMARY KEY (field_id)
) ENGINE=MyISAM;

in the Install SQL Patch of the admin site, if that is what you mean by installing the query.

[TheOracle]

in the Install SQL Patch of the admin site, if that is what you mean by installing the query.

No, that is not what was said. Since you installed the moderators level MOD, there's a specific instruction, from the installation text file, regarding the moderators_level field. This since MOD has nothing to do with the additional customers fields, I invite you to post to the official topic of the subject.

[rbepple]

My co-worker and I have read through the complete install.txt, upgrade.txt, and changelog.txt files along with the includes/languages/english/extra_definitions/additional_customers_fields.php and found nothing referring to moderators Mod.
I download Additional Customers Fields Mod v2.02 from the zencart.com download center. The v1.02 Mod I had before worked but I just had to do some configuring, this one doesn't work at all, I can uninstall it and site works great, reinstall it and doesn't work again.

[TheOracle]

Since I can't reproduce this error, please post your $customers_core_fields array table from your includes/extra_configures/additional_customers_fields.php file as well as your includes/modules/<your_template>/create_account.php array block where instructions were involved for the moderators_level field as well. I will investigate this more closely.