Additional Customers Fields

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

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 ?

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

Was it covered already ? :dontgetit

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')]

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.

How do I do that?

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.

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.

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.

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.

Here is the file you asked for, let me know if you need anything else.

<?php
//----------------------------------------------------------------------------------------
//--- Additional customers fields MOD v2.0 -----------------------------------------------
//----------------------------------------------------------------------------------------
// --- Coded by TheOracle on June 10th 2007. ---------------------------------------------
// --- Support: http://www.zen-cart.com/forum --------------------------------------------
// --- Designed for Zen-Cart v1.3x versions ----------------------------------------------
//----------------------------------------------------------------------------------------
// If you like this MOD, please send a donation to: [email protected] . ------------------
//----------------------------------------------------------------------------------------
 
$customers_table_fields = array(
  'customers_id' => 'customers_id',
  'customers_gender' => 'customers_gender',
  'customers_firstname' => 'customers_firstname',
  'customers_lastname' => 'customers_lastname',
  'customers_dob' => 'customers_dob',
  'customers_email_address' => 'customers_email_address',
  'customers_nick' => 'customers_nick',
  'customers_default_address_id' => 'customers_default_address_id',
  'customers_telephone' => 'customers_telephone',
  'customers_fax' => 'customers_fax',
  'customers_password' => 'customers_password',
  'customers_newsletter' => 'customers_newsletter',
  'customers_group_pricing' => 'customers_group_pricing',
  'customers_email_format' => 'customers_email_format',
  'customers_authorization' => 'customers_authorization',
  'customers_referral' => 'customers_referral',
  'customers_paypal_payerid' => 'customers_paypal_payerid',
  'customers_paypal_ec' => 'customers_paypal_ec',
  'moderators_level' => 'moderators_level'
  );
 
define('FILENAME_ADDITIONAL_CUSTOMERS_FIELDS', 'additional_customers_fields.php');
define('TABLE_ADDITIONAL_CUSTOMERS', DB_PREFIX.'customers_additional');
?>

if it will help I will even give you full access to my database and cPanel, because it is new and there is no important info there yet. I need this up by the end of the week to launch our site on monday. I will donate via paypal if I can get this to work.

remove this line from includes/modules/pages/create_acount/header.php

one of the first lines on the page

zen_redirect(zen_href_link(FILENAME_LOGIN, '', 'SSL'));

by putting a couple slashes in front of it.

// zen_redirect(zen_href_link(FILENAME_LOGIN, '', 'SSL'));

It was part of a different module but ends up redirecting if you leave it in with the new
zen_redirect(zen_href_link(FILENAME_DEFAULT, '', 'NONSSL'));

I think it was part of either the timezone and DOB dropdown mods

The modifications above is more about a personal choice regarding customization of your modules and templates. If you think it's best for you to do it this way, which isn't quite related with this MOD particularly, then why not. :smartalec:

@rbepple:

What does your includes/modules/your_template/create_account.php file mentions for the moderators_level array I instructed from my installation (or upgrade) text file ?

If you were asking me. I did install your moderators file because I think there was a bit of it inadvertently added into the add fields module and it was initially causing some small problems with the cart.

That was the way I figured it out is with your site.

Thanks again.

If you were asking me. I did install your moderators file because I think there was a bit of it inadvertently added into the add fields module and it was initially causing some small problems with the cart.

That was the way I figured it out is with your site.

Perhaps you'd like to elaborate that a little ... I believe I'm misunderstanding what you're trying to explain above . . .

This was about two days ago and a lot has changed since then...
The way I remember it, I was having trouble with is the problem mentioned by the other zencart newbee. I fixed it as mentioned and the other module still seemed to work. However something was still keeping me from seeing the change-customer-information pages on the the cart.
I noticed that in one of the class or function pages was referring to moderator level = 1 that did not seem to have reference to anything I had seen before.

At the time, I believed it was this that was conflicting with my cart.

I could not figure it out until I went to your site and saw the moderator package.

I loaded on the mod it seemed to fix that end of things. I do not know exactly what it was, but I have not been having problems since.

Sorry I could not be of more help - it is just not a problem currently, so it becomes difficult to remember the details.

I fixed it as mentioned and the other module still seemed to work.

And ... your version of modifications are ? ...

I noticed that in one of the class or function pages was referring to moderator level = 1 that did not seem to have reference to anything I had seen before.

Yes ... that was the idea of my creation ... 1 means disabled and 2 means enabled ...

The reason why I defaultly set the moderators_level field to '1' is because you'd surely not wish to set all your new / recent customers as moderators automatically without your conscent right ? :laugh:

I agree...

I believe I have somehow added almost all the module there are in the admin, others, and marketing sections of zencart downloads. There are also some added from several other websites.

It seems to be a good version to test modules on.

I have not gotten the german attributes module numbers to work with the cart - need sql 5.0

zencart 3.17
MySQL about 4.4