lsaero Posted February 21, 2008 Posted February 21, 2008 Customers are receiving this error after the complete filling out the registration page and click on "Continue" - 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]' [TEP STOP] I am using PayPal Web Payments Standard (after having WP Pro installed, which I disabled at client request). What do I need to do here? Thanks. Mark
Jan Zonjee Posted February 21, 2008 Posted February 21, 2008 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]' [TEP STOP] I am using PayPal Web Payments Standard (after having WP Pro installed, which I disabled at client request). What do I need to do here? Add the field customers_paypal_ec to the table customers as the message tells you it is missing. Probably some step you missed in installing that contribution (or it was in the WP Pro, you removed it but left some of the code that needs that column in the shop).
lsaero Posted February 21, 2008 Author Posted February 21, 2008 Add the field customers_paypal_ec to the table customers as the message tells you it is missing. Probably some step you missed in installing that contribution (or it was in the WP Pro, you removed it but left some of the code that needs that column in the shop). That's interesting, you describe the events very closely. Originally, Client desired PayPal WP Pro, which I installed and tested and had working. However, client later decided they didn;t want to spend the $30/month in fees and wanted WP Standard instead. My process was to simply disable WP Pro and install, configure and enable WP Standard. I have not implemented any other code, either from mods, contribs or custom so there was really nothing to have left for it to still think it should see/use the field! So, going forward, what steps would best resolve this? Uninstall/remove the WP Pro contrib (disabling must not enough?). Remove all contribs and start over with fresh new oscommerce? Looking for some direction. Thanks. MArk
hari_shyam Posted February 21, 2008 Posted February 21, 2008 That's interesting, you describe the events very closely. Originally, Client desired PayPal WP Pro, which I installed and tested and had working. However, client later decided they didn;t want to spend the $30/month in fees and wanted WP Standard instead.My process was to simply disable WP Pro and install, configure and enable WP Standard. I have not implemented any other code, either from mods, contribs or custom so there was really nothing to have left for it to still think it should see/use the field! So, going forward, what steps would best resolve this? Uninstall/remove the WP Pro contrib (disabling must not enough?). Remove all contribs and start over with fresh new oscommerce? Looking for some direction. Thanks. MArk well try to trace back and remove the code changes you might have done to get the install in the first place.. as for the database part if the column is a nullable column it should not give you an issue.. Regards Hari
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.