dnl07 Posted February 17, 2007 Share Posted February 17, 2007 1054 - Unknown column 'customers_paypal_ec' in 'field list' select customers_id as id, customers_paypal_ec as ec from customers where customers_email_address = '[email protected]' When trying to create a New Account i get this error when clicking the submit button. When i login as a returning customer it works just fine. Can anyone help? -DNL Link to comment Share on other sites More sharing options...
Velveeta Posted February 17, 2007 Share Posted February 17, 2007 1054 - Unknown column 'customers_paypal_ec' in 'field list' select customers_id as id, customers_paypal_ec as ec from customers where customers_email_address = '[email protected]' When trying to create a New Account i get this error when clicking the submit button. When i login as a returning customer it works just fine. Can anyone help? -DNL Looks like you've got that field specified in the query that first stores the customer data in the database, but you don't have the actual field added to your database table... The reason returning customers can login is that that field most likely isn't pulled in the queries that validate their password and then pull some info for storage in the session data... Either remove that field from the query in your create_account.php file, or add that field to the database... I would suggest the latter, as that's not a default field to be queried for, so it was obviously added to that query at some point for a purpose... Richard. Richard Lindsey Link to comment Share on other sites More sharing options...
dnl07 Posted February 17, 2007 Author Share Posted February 17, 2007 Looks like you've got that field specified in the query that first stores the customer data in the database, but you don't have the actual field added to your database table... The reason returning customers can login is that that field most likely isn't pulled in the queries that validate their password and then pull some info for storage in the session data... Either remove that field from the query in your create_account.php file, or add that field to the database... I would suggest the latter, as that's not a default field to be queried for, so it was obviously added to that query at some point for a purpose... Richard. So your suggestion is to remove it from the create_account.php instead of adding it to the database? -DNL Link to comment Share on other sites More sharing options...
Velveeta Posted February 17, 2007 Share Posted February 17, 2007 So your suggestion is to remove it from the create_account.php instead of adding it to the database? -DNL Nope, the exact opposite... That query doesn't call that field by default in oscommerce, so if someone added it into that query, it was for a reason... So I would advise adding that field to your database... Richard. Richard Lindsey Link to comment Share on other sites More sharing options...
dnl07 Posted February 17, 2007 Author Share Posted February 17, 2007 Nope, the exact opposite... That query doesn't call that field by default in oscommerce, so if someone added it into that query, it was for a reason... So I would advise adding that field to your database... Richard. Hmm okay... by any chance do you know to do that lol.... i'm still learning... i'm not a beginner but i'm still learning some of this stuff. -Doug Link to comment Share on other sites More sharing options...
Velveeta Posted February 17, 2007 Share Posted February 17, 2007 Hmm okay... by any chance do you know to do that lol.... i'm still learning... i'm not a beginner but i'm still learning some of this stuff. -Doug In the contribution you used to install that piece of code (I believe it comes from one of the paypal express checkout payment modules), it should have had some sql stuff for you to run to install those extra fields... Doublecheck to make sure you didn't miss a step... Richard. Richard Lindsey Link to comment Share on other sites More sharing options...
dnl07 Posted February 17, 2007 Author Share Posted February 17, 2007 Hmm okay... by any chance do you know to do that lol.... i'm still learning... i'm not a beginner but i'm still learning some of this stuff. -Doug Thanks for all of your help on this one! I got it to work: ALTER TABLE `customers` ADD `customers_paypal_payerid` VARCHAR( 20 ); ALTER TABLE `customers` ADD `customers_paypal_ec` TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL; Thanks! Link to comment Share on other sites More sharing options...
giellacustoms Posted November 11, 2007 Share Posted November 11, 2007 Thanks for all of your help on this one! I got it to work: ALTER TABLE `customers` ADD `customers_paypal_payerid` VARCHAR( 20 ); ALTER TABLE `customers` ADD `customers_paypal_ec` TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL; Thanks! ok so which folder did you find that file in so that i can do that too mine too, because I have the same error Link to comment Share on other sites More sharing options...
giellacustoms Posted November 11, 2007 Share Posted November 11, 2007 ok where do I go to do this Import the file "paypal_wpp.sql" into your database using phpMyAdmin. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.