Additional Customers Fields

[rbepple]

I did as you instructed above and I still get the same message!

[TheOracle]

In that case, it is NOT related with my MOD since this SQL update statement is the only one involved for validating each variables that are NOT part of the core fields array as it does the modifications to your TABLE_CUSTOMERS table. By commenting it out, it should not be possible to have further writings to the table - period.

[Website Rob]

Although it's better to use PHP v5.2.1 or higher, I believe that using any version of mySQL v5.x is the root of the problem. It has been to known to screw up many databases. Not sure why, but perhaps the newer mySQL is not backwards compatible with some things?

[TheOracle]

Although it's better to use PHP v5.2.1 or higher, I believe that using any version of mySQL v5.x is the root of the problem. It has been to known to screw up many databases. Not sure why, but perhaps the newer mySQL is not backwards compatible with some things?

If things haven't changed so far, PHP v5.x has not yet been recognized as a flexible version neither mySQL v5.x. However, I agree with you regarding the root of the problem since some bugs were reported on mySQL manufacturer's web site regarding those error reports.

[TheOracle]

Update:

A new version has been released on my site. For those who needs to upgrade, simply follow upgrade and changelog documentation (very small update I might add).

[TheOracle]

Update:

Package updated from my site:

- Switched 'your_template' folder name under each modulated folders rather than leaving them default. This will give a better example towards users who would like to learn how to use the overrides with this cart.

[rbepple]

Does anybody know how to fix this error below because when ever I try to delete or edit a customers account from the admin side I get this error and unless I can fix it I am going to have to delete the MOD! Here's the error:

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 = '9']
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.

[TheOracle]

http://www.zen-cart.com/forum/showpo...&postcount=252

[TheOracle]

c.customers_id and c.customers_id = '9']

When I think of it, since, again, this has nothing to do with the MOD, go to your phpmyadmin and see the customers_id number 9 and see if there are any readings from your customers_default_address_id. I'd rather think that this field is simply empty - which is why you're seeing this error.

[rbepple]

Just another error for me! I am getting this error when I try to create an account on the customer side. I create a additional field named "customers_age" and labeled it "Sales Representative: " and a pull down menu with contents of "'None', 'Mel Kimmel', 'Boyd Thomas'". If I disable the additional field the customer form works. I enable it then I get this error on the customer side:

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 'customers_age = 'None', customers_age = 'None' where customers_i' at line 2
in:
[update customers set customers_default_address_id = '22'customers_age = 'None', customers_age = 'None' where customers_id = '22']