Cant Create a Customer

[rkah]

Hi all,
Im having issues with creating a new customer. First off in the admin tool when trying to create an account i get this error:

Parse error: syntax error, unexpected $end in C:\domains\com-oscmax\catalog\admin\includes\modules\account_deta ils.php on line 485

Then if I try to add a customer through the regular website I get this error:
1364 - Field 'customers_payment_allowed' doesn't have a default value
insert into customers (customers_firstname, customers_lastname, customers_email_address, customers_telephone, customers_fax, customers_newsletter, customers_password) values ('rj', 'kelly', 'nowher@none.com', '913-915-9253', '', '1', 'd481cef4afa64c6ad3e824f84c250b4d:b5')
So I fire up the MySQL Browser and look at the fields and immeadiately notice a vast difference in the above query and what is required to populate a row. MySQL says that there are numerous fields that are required that are missing from my statement above. I feel I may have an outdated copy of the one of the files. Could someone please provide some direction in whats missing here.

Everything on the site is working correctly. The basket will add products, I can browse categories, do searches, modify site settings in admin panel. However checkout bombs for much of the same reasons, no matter if I create an account, or do "guest" checkout.

Here is my platform:

Database: MySQL 5.0.51a-community-nt
HTTP Server: Microsoft-IIS/6.0
PHP Version: 5.2.5 (Zend: 2.2.0)

[michael_s]

Ahhh, running on windows IIS. That is probably why I have never seen these errors before. I have not ever run RC3 on IIS, and I do not have access to an IIS server. Perhaps another windows user will see this and have some answers for you...

Have you tried setting a default value in the database for the fields that are throwing the errors?

[rkah]

I can let it slide on the admin panel (the first error). However on the customer side, I have looked around and there is not any full documentation on the table relationships. Im saying, I dont know where to look for the data this field requires. Can I just put anything in here? Its not readily apparent what data goes in here? Customer_payment_allowed? I can see the first error being maybe a platform issue, but this error is more of a programming one, in that the fields that are marked required, are not also included in the insert statement. It appears the statement is still configured for osCommerce and not osCmax style database. Would you agree with me on that? What version of this do you run mostly Linux or Windows? Im just afraid that populating it with junk is not a real fix, more like a bandaid. I can fix code that is not a problem for me....its more like there are more fields (approx 5-6) that require info, that do not appear in the insert statement.

[rkah]

Customer_payment_allowed, Customer_Shipment_Allowed, Customer_group_id, customer_group_name, Customer_group_ra, and gender are all required fields but are not included in the insert statement. I set the gender that was easy, and setting customer_group_id & customer_group_name are straightforward as well, but the customer_group_ra, customer_payment_allowed, and customer_shipment_allowed are not so intuitive. They are variable lenght fields so this goes beyond a true/false, 1/0 issue. Are these populated by some trigger maybe that is not included in the windows package?

[rkah]

OK, I've resolved that issue.... I will start a new thread to ask a new set of questions.

[chowhan]

Hi rkah , please if have solved the problem know the solve of this error, please do share here with all , as these forums are runing only with our share.

[rkah]

First off I will only say this worked in my situation, but it was a BASE install of oscmax, running PHP 5, MySql 5 and IIS 6. Those shouldnt matter for this scenario, but I provide no warranty of this working in your case, as every system is different.

Now, you need to know what methods you have set for payment and shipping (the default ones) IE Authorize.Net/Flat Rate Shipping.

After you have this data you need to EDIT the TABLE STRUCTURE for customers. The Customer_Payment_Allowed default value should be set to whatever payment module you have as the default. The values for this field can be obtained intuitively by knowing your default pay method, and matching that to the files in /Catalog/Includes/modules/payment. So if you use Authorize.NEt then you would make the default for the field authorizenet.php
Follow the same principal for shipping except look in the shipping folder.
HTH