Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error 1054 - Unknown Column - Please help!


lsaero

Recommended Posts

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

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...