nana Posted November 5, 2005 Author Share Posted November 5, 2005 amy run this in your phpmyadmin ALTER TABLE `customers` ADD `confirmation_key`VARCHAR(40) DEFAULT 'tempemptyconfirm' NOT NULL; Quote Link to comment Share on other sites More sharing options...
mousewebdesign Posted November 5, 2005 Share Posted November 5, 2005 amy run this in your phpmyadminALTER TABLE `customers` ADD `confirmation_key`VARCHAR(40) DEFAULT 'tempemptyconfirm' NOT NULL; Hi Frank and Amy, I've got the same problem. Even when I have inserted the database-query as above, but still the error 1054 does appear. please help us with that... ps: i've downloaded fast easy checkout version 2.0 and found an error in it: after filling in the quick order form and pressing the confirm button, it says 'please fill in your gender'. But there's no input field for gender, so I've inserted this myself, but it might be an issue to check for it for version 2.1??? marcus Quote Link to comment Share on other sites More sharing options...
mousewebdesign Posted November 5, 2005 Share Posted November 5, 2005 ps: i've downloaded fast easy checkout version 2.0 and found an error in it: after filling in the quick order form and pressing the confirm button, it says 'please fill in your gender'. But there's no input field for gender, so I've inserted this myself, but it might be an issue to check for it for version 2.1??? ps(2): i've found 2 other errormessages. I don't know if it's only on my pages, but maybe there's someone who can help me with this: error 1: on checkout_shipping.php after login if a customer is ok by his billingaddress he's clicking on the continue-button and the following error apears: 'document.checkout_payment.payment.lenght' is null or not an object. error 2: on checkout_account3.php while the page is loading the following error appears when showing the button for showing the billingaddress: 'document.getElementById(...)' is null or not an object I hope there's someone who can help me with this. marcus Quote Link to comment Share on other sites More sharing options...
nana Posted November 5, 2005 Author Share Posted November 5, 2005 there was an error in the instruction with the sql code which had a blank in it and it would not work that is why you have to insert this code and make sure the extra field is added i know about gender field and i will add it error 2 document.getElementById(...)' is null or not an object error is in the <body> tag just remove it see if it works error 1 use the checkout_shipping.php that i posted in the last few page if your problem presist please supply a link i will fix and post 2.1 by tommorrow Quote Link to comment Share on other sites More sharing options...
♥radders Posted November 5, 2005 Share Posted November 5, 2005 The contribution for editing the address worked for me. It would be useful to incorporate that into this contribution. The next thing I have to work on is using master password with this. Fine if the customer has created an account. If not then logging in as the customer in order to complete transactions where the customer wasn't returned from the external payment processor to osc doesn't work. Quote Link to comment Share on other sites More sharing options...
nana Posted November 5, 2005 Author Share Posted November 5, 2005 it might have to do with createaccount be set at Y and N that is where i would look Quote Link to comment Share on other sites More sharing options...
♥radders Posted November 5, 2005 Share Posted November 5, 2005 Yes I can see a way of fooling the login routines into continuing by changing that database query to just return the value of createaccount rather than only looking for createaccount = Y. Then a little bit of code to show an error if createaccount is 'N' unless master password is being used. Hopefully it will work and allow checkout without actually creating an account. Quote Link to comment Share on other sites More sharing options...
♥radders Posted November 5, 2005 Share Posted November 5, 2005 Well as I suspected it worked enough to enable the transaction to be completed on behalf of the customer. The only thing is that the email that is sent to the customer is as if he had created an account. But it goes most of the way there. Quote Link to comment Share on other sites More sharing options...
mousewebdesign Posted November 5, 2005 Share Posted November 5, 2005 there was an error in the instruction with the sql code which had a blank in it and it would not work that is why you have to insert this code and make sure the extra field is addedi know about gender field and i will add it error 2 document.getElementById(...)' is null or not an object error is in the <body> tag just remove it see if it works error 1 use the checkout_shipping.php that i posted in the last few page if your problem presist please supply a link i will fix and post 2.1 by tommorrow Frank, I've removed the document.getElementById at aprox. line 233 and removed 'onsubmit="return check_form();"' at aprox. line 302 in checkout_shipping.php this helpes and the problem is gone. also the 1054 MySQL-error is gone by removing the old confirmation_key in the database and putting in the new one. thanx for it all marcus Quote Link to comment Share on other sites More sharing options...
Tres Lunas Posted November 5, 2005 Share Posted November 5, 2005 Ok I have put in the correct sql var thing and used the shipping doc a couple pages back and it still persists. I am not sure how to remove the old confirmation key and replace it with the new one. Quote Link to comment Share on other sites More sharing options...
nana Posted November 5, 2005 Author Share Posted November 5, 2005 you have to go to your phpmyadmin or any other sql program your host provided in your website control panel the same place you entered it but what happends when you try to enter this ? do you get an error message? make sure you backup your db ncase you make a mistake Quote Link to comment Share on other sites More sharing options...
Tres Lunas Posted November 5, 2005 Share Posted November 5, 2005 (edited) when I enter the correct sql string it says that it is successfull. BTW you have to add a space between ' and var or you get an error. What I do not know is how to remove the old confermation key and add the new one as I am a newb and while I can follow step by step instructions I do not know where things are or how to do things with them unless it is obvious such as a button on the page. Also I was going to try a fresh install but when I went to my fantastico oscomerce was no longer an option. I have copied all the origional files into a folder on my computer as well as copying the modified files into a different folder. Edited November 5, 2005 by Tres Lunas Quote Link to comment Share on other sites More sharing options...
Tres Lunas Posted November 5, 2005 Share Posted November 5, 2005 ok I figured out how to remove the old confirmation key and replace it but I still get the same error. Quote Link to comment Share on other sites More sharing options...
nana Posted November 5, 2005 Author Share Posted November 5, 2005 try registering as a new customer see what happends also contact your webhost to find out why oscommerce is not an option anymore Quote Link to comment Share on other sites More sharing options...
Tres Lunas Posted November 5, 2005 Share Posted November 5, 2005 hmmm.... I get the same error when registering a new customer. I sent an e-mail to find out why its no longer an option. I would be willing to start from a fresh install if you can tell me how without fantastico. Quote Link to comment Share on other sites More sharing options...
nana Posted November 5, 2005 Author Share Posted November 5, 2005 can you go to your admin section and make a backup of your db first to make sure you can reverse what we are going to do Quote Link to comment Share on other sites More sharing options...
Tres Lunas Posted November 6, 2005 Share Posted November 6, 2005 ok it is backed up. I also have a copy of the origional instalation. Quote Link to comment Share on other sites More sharing options...
nana Posted November 6, 2005 Author Share Posted November 6, 2005 now let me know how many customers you have in the customers table Quote Link to comment Share on other sites More sharing options...
Tres Lunas Posted November 6, 2005 Share Posted November 6, 2005 just the 1 jhon doe that it comes with for testing. Quote Link to comment Share on other sites More sharing options...
nana Posted November 6, 2005 Author Share Posted November 6, 2005 run this in your phpmyadmin the same way you did the other one -- phpMyAdmin SQL Dump -- version 2.6.4-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 05, 2005 at 06:31 PM -- Server version: 4.0.25 -- PHP Version: 4.3.11 -- -- Database: `seelily_osc6` -- -- -------------------------------------------------------- -- -- Table structure for table `customers` -- DROP TABLE IF EXISTS `customers`; CREATE TABLE `customers` ( `customers_id` int(11) NOT NULL auto_increment, `customers_gender` char(1) NOT NULL default '', `customers_firstname` varchar(32) NOT NULL default '', `customers_lastname` varchar(32) NOT NULL default '', `customers_dob` datetime NOT NULL default '0000-00-00 00:00:00', `customers_email_address` varchar(96) NOT NULL default '', `customers_default_address_id` int(11) NOT NULL default '0', `customers_telephone` varchar(32) NOT NULL default '', `customers_fax` varchar(32) default NULL, `customers_password` varchar(40) NOT NULL default '', `customers_newsletter` char(1) default NULL, PRIMARY KEY (`customers_id`) ) TYPE=MyISAM AUTO_INCREMENT=28; -- -- Dumping data for table `customers` -- INSERT INTO `customers` VALUES (1, 'm', 'John', 'doe', '2001-01-01 00:00:00', 'root@localhost', 1, '12345', '', 'd95e8fa7f20a009372eb3477473fcd34:1c', '0'); then try to register a new customer Quote Link to comment Share on other sites More sharing options...
Tres Lunas Posted November 6, 2005 Share Posted November 6, 2005 nope still getting the same error..... I really appretiate your help with this. Quote Link to comment Share on other sites More sharing options...
nana Posted November 6, 2005 Author Share Posted November 6, 2005 can you post the error name of the page and maybe a link Quote Link to comment Share on other sites More sharing options...
nana Posted November 6, 2005 Author Share Posted November 6, 2005 (edited) no i am sorry my fault we are almost done i have actually sent you a fresh table now you have to run the two addition to the table just make sure you use the correct one ALTER TABLE `customers` ADD `confirmation_key`VARCHAR(40) DEFAULT 'tempemptyconfirm' NOT NULL; and the other one from the instruction hat should do it i am going to hang around till you get it Edited November 6, 2005 by nana Quote Link to comment Share on other sites More sharing options...
Tres Lunas Posted November 6, 2005 Share Posted November 6, 2005 1054 - Unknown column 'confirmation_key' in 'field list' insert into customers (customers_firstname, customers_lastname, customers_email_address, customers_telephone, customers_fax, customers_newsletter, confirmation_key, createaccount, customers_password, customers_dob) values ('Amy', 'mole', 'lady_slinky@yahoo.com', '425-246-0790', '', '', 'm3dwynn1', 'Y', 'a71feaf76d9a707fc4da1e37bce2ec52:cc', '19750819') [TEP STOP] the url of the page the error is on is http://tresluna.com/shop/create_account.php the shop is www.tresluna.com/shop Quote Link to comment Share on other sites More sharing options...
nana Posted November 6, 2005 Author Share Posted November 6, 2005 here is the second field ALTER TABLE `customers` ADD `createaccount` CHAR( 1 ) DEFAULT 'Y' NOT NULL ; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.