Additional Customers Fields

[rbepple]

it looks like this syntax is missing the "d" in where customers_i' at line 2. But, I don't know.

[TheOracle]

update customers set customers_default_address_id = '22',customers_age = 'None',

Probably a mySQL v5 error. In your admin/customers.php file,

replace:

if (isset($_POST[$key]) && isset($table_fields[$key]) && eregi("^[[:alnum:]][a-z0-9_.-]*@[a-z0-9.-]+\.[a-z]{2,6}$", zen_db_prepare_input($_POST[$key])) && zen_validate_email($_POST[$key])) {                              
                  $additional_sql .= "$key = '".zen_db_prepare_input($_POST[$key])."', ";
              } elseif (isset($_POST[$key]) && isset($table_fields[$key])) {
                  $additional_sql .= "$key = '".zen_db_prepare_input(strip_tags($_POST[$key]))."', ";          
              } 

with:

if (isset($_POST[$key]) && isset($table_fields[$key]) && eregi("^[[:alnum:]][a-z0-9_.-]*@[a-z0-9.-]+\.[a-z]{2,6}$", zen_db_prepare_input($_POST[$key])) && zen_validate_email($_POST[$key])) {                              
                  $additional_sql .= ", $key = '".zen_db_prepare_input($_POST[$key])."', ";
              } elseif (isset($_POST[$key]) && isset($table_fields[$key])) {
                  $additional_sql .= ", $key = '".zen_db_prepare_input(strip_tags($_POST[$key]))."', ";          
              } 

This should fix the issue for mySQL v5.

[TheOracle]

it looks like this syntax is missing the "d" in where customers_i' at line 2. But, I don't know.

No, this is simply a cut report to simply show you as close as possible where the error would be.

[rbepple]

OK this is where I am at. I have replaced all the codes as instructed earlier and everything is working great on the admin side. But, when I try to create a account on the customer side it gives me this 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 'sales_rep = 'Mel Kimmel', sales_rep = 'Mel Kimmel' where customer' at line 2
in:
[update customers set customers_default_address_id = '30'sales_rep = 'Mel Kimmel', sales_rep = 'Mel Kimmel' where customers_id = '30']

The account is still created but cannot be edited or removed, I have to manually go into the database and remove it.

To me it looks like there is a comma missing between '30' and sales_rep, but I don't know.

[TheOracle]

I cannot reproduce this error. It looks like your server handles these fields into different ways. It would probably require you some custom codings. If interested, you can always send me an email, as a custom contract, and I will see what I can do.

[mattallam]

Could someone please help! I have installed the above mod but i have a problem with adding additional customer fields as in it doesnt work - I add the field in customers>Add Customers Fields like you would expect and turn the field on but nothing happens on the customer side?

Also, slightly different to the recent problem above - I cant edit any of my customer accounts. It just comes up with -

1054 Unknown column 'c.customers_default_address_id' in 'on clause'
in:
[select c.customers_id, c.customers_gender, c.ustomers_firstname, c.ustomers_lastname, c.customers_dob, c.customers_email_address, a.entry_company and so on and so on.....

I have reset the additional customer fields. Im sort now at a loose end and dont know what else i can do without some help?!

If anyone could get back to me i would be very appreciative.

Kind Regards

Matthew Allam
www.giftwrapuk.co.uk

[TheOracle]

Could someone please help!

Again, this someone is me !

Please post the following details:

- mySQL Version
- PHP Version
- Zen-Cart Version

from my post above (http://www.zen-cart.com/forum/showpo...&postcount=262), did you applied the patch (if using mySQL v5.x) ?
Did you downloaded my latest release from my site (and NOT from the downloads section due to non-instant changes) ?

I see two other users on this topic (at least 10 different ones a day) as they only seem to watch and may experience similar problems. Rather than posting one-by-one, please post all at the same time in order to get rid of this problem more quickly.

[mattallam]

Thankyou for your help!!

MySQL 5.0
4.4.6 (Zend 1.3.0)
Zen Cart 1.3.7

And, yes i did stupidly download what i thought was your latest release from the downloads section.

Kind Regards

Matthew Allam

[TheOracle]

MySQL 5.0

Another case of mySQL v5.x.

4.4.6 (Zend 1.3.0)

This MOD wasn't tested under the newest PHP version. Would like to though.

and so on and so on.....

And what might be the rest of this 'and so on and so on' ?

[mattallam]

1054 Unknown column 'c.customers_default_address_id' in 'on clause'
in:
[select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id, c.customers_email_format, c.customers_group_pricing, c.customers_authorization, c.customers_referral, ac.field_name, ac.field_status from customers c, customers_additional ac left join address_book a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '64']
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.