steinberginc Posted February 21, 2004 Posted February 21, 2004 I nee to create a new field in the account setting. Lets say I want the customers to leave the driver license number or SSN. In Germany may be the Passport number. The shop is based in USA and its not really possible to have Verification on the Address outside the USA ( i use Authorize.NET). I don't want the new field to interact with the credit card processing but only for the account sign up page. I attache a link with what I changed in the php file. May be on of you can see it. I am not that great in php... TIA. Dave See here my PHP file
♥yesudo Posted February 21, 2004 Posted February 21, 2004 you will need to amend the create_account_process.php file along with adding a new field to your customer table - to store the new information. Depending then on where you want to use this information( or you you can just look in your DB) you will need to feed the new data field thorough to the relevant areas. Your online success is Paramount.
steinberginc Posted February 21, 2004 Author Posted February 21, 2004 but how do I do this exactly. Can you may be show me.. TIA David
steinberginc Posted February 21, 2004 Author Posted February 21, 2004 nevermind... just came to me. got it:))
♥yesudo Posted February 21, 2004 Posted February 21, 2004 Hi, Also in the create_account file you need to include the code to show the box on the account sign-up form. e.g. <tr> <td class="main"><?php echo ENTRY_SSN; ?></td> <td class="main"><?php echo tep_draw_input_field('ssn') . ' ' . (tep_not_null(ENTRY_SSN_TEXT) ? '<span class="inputRequirement">' . ENTRY_SSN_TEXT . '</span>': ''); ?></td> </tr> you will need to define: ENTRY_SSN ENTRY_SSN_TEXT The other element to think about is whether or not this is a compulsory field - for customer completion. Look at how the syntax for telephone number(req'd field) and fax number(not req'd field) differ within both the create_account and create_account_process files. Your online success is Paramount.
steinberginc Posted February 21, 2004 Author Posted February 21, 2004 Ok. Now I got it working but I get this error: 1054 - Unknown column 'customers_driver_license_number' in 'field list' insert into customers (customers_firstname, customers_lastname, customers_driver_license_number, customers_email_address, customers_telephone, customers_fax, customers_newsletter, customers_password, customers_gender, customers_dob) values ('Michael', 'Mustermann', '6559-5584-5552S', '[email protected]', '06195-77447', '', '', '48d6ba7d373d78ef83b624cbf61658eb:43', 'm', '19700521') Here is the website I am working on: http://shop.yipgermany.com/catalog/ You can see when you sign up for an account that I added the driver license number. What am I missing???
♥yesudo Posted February 21, 2004 Posted February 21, 2004 have you created the field 'customers_driver_license_number' in the table 'customers' ? If you have just check spelling and that you have called them eaxctly the same thing. Your online success is Paramount.
steinberginc Posted February 21, 2004 Author Posted February 21, 2004 Thanks by the way for talking the time. I have create a new tab or field as you said in the create_account.php then i checked the complete document for where else I have to make some adjustments. Seems ok for me. Secondly I went into each language files and created the names for the filed. Germany and English. It seems to me that in the create_account.php everything is right but once I want to submit the info, something is missing. Where do I have to go now. TIA David
♥yesudo Posted February 21, 2004 Posted February 21, 2004 have you added the field in the customers table in your database ? Your online success is Paramount.
♥yesudo Posted February 21, 2004 Posted February 21, 2004 can you access phpmyadmin ? Also what is the maximum length that the SSN can be ? Your online success is Paramount.
♥yesudo Posted February 21, 2004 Posted February 21, 2004 are you on msn messenger ? - contact me using [email protected] Your online success is Paramount.
steinberginc Posted February 21, 2004 Author Posted February 21, 2004 OK... I did find the customer.php (admin folder)... I saw where i had to make the changes and add the fields... BUT... Still get the error... What do I do wrong? I changed now the: create_account.php customer.php and both language files (admin and normal) STILL HAVE THIS ERROR: 1054 - Unknown column 'customers_driver_license_number' in 'field list' insert into customers (customers_firstname, customers_lastname, customers_driver_license_number, customers_email_address, customers_telephone, customers_fax, customers_newsletter, customers_password, customers_gender, customers_dob) values ('Sebastian', 'Meister', '566587385444', '[email protected]', '3055349898', '', '', '28ed547c980bec131773d8f989ca6a1a:38', 'm', '19700521')
♥yesudo Posted February 21, 2004 Posted February 21, 2004 what is the maximum size an ssn would be ? Your online success is Paramount.
♥yesudo Posted February 21, 2004 Posted February 21, 2004 stick this in your sql editor in phpmyadmin: ALTER TABLE `customers` ADD `customers_driver_license_number` VARCHAR( 36 ) ; the number 36 above is the max length of the field - alter this( prior to putting the query in sql editor) to the max length you expect for an ssn. Your online success is Paramount.
bloodshoteyes Posted February 21, 2004 Posted February 21, 2004 Before the insert statement isn't there a db_query and a '$key' Statement. Seems to me having been through these files.
steinberginc Posted February 21, 2004 Author Posted February 21, 2004 what is the maximum size an ssn would be ? max 10 - 15
♥yesudo Posted February 21, 2004 Posted February 21, 2004 what is the maximum size an ssn would be ? max 10 - 15 stick this in your sql editor in phpmyadmin: ALTER TABLE `customers` ADD `customers_driver_license_number` VARCHAR( 15 ) ; Your online success is Paramount.
steinberginc Posted February 21, 2004 Author Posted February 21, 2004 stick this in your sql editor in phpmyadmin: ALTER TABLE `customers` ADD `customers_driver_license_number` VARCHAR( 36 ) ; the number 36 above is the max length of the field - alter this( prior to putting the query in sql editor) to the max length you expect for an ssn. thanks... worked great. I could fix this problem now. THANKS TO ALL OF YOU.. Seems to me that PHP Admin was a great tool.
steinberginc Posted February 21, 2004 Author Posted February 21, 2004 sorry, one more thing. So the new field works. Cool. I am very relieved:) Now when I check the new entry in my admin section (where I did also made changes and can see the field) nothing gets submitted. The field is blank. Just can see under customers the name but no date of entry and if I edit the user then all info is blank. I get this error in the header: Warning: reset(): Passed variable is not an array or object in /home/yipgerma/public_html/shop/catalog/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/yipgerma/public_html/shop/catalog/admin/includes/classes/object_info.php on line 18 Also, I opened this file. Seems empty. Don't know what to do? Sorry. :)) TIA David
psossa Posted August 4, 2004 Posted August 4, 2004 hey guys a (sligthly different) version of this problem 1054 - Unknown column 'p.products_retail_price' in 'field list' select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_retail_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name [TEP STOP] can anybody help me out? i am THIS close i love this forum ! Thank so much in advance for all your help
Recommended Posts
Archived
This topic is now archived and is closed to further replies.