1054 error in create account

[Guest]

I am in dyer need of help as this site has launched. www.ruffdudds.com

 

I have launched this site with the PayPal Standard Module.

 

PROBLEM

If you add a product to your cart, go to check out and select the "Returning Customer" option (the box on the right), the transaction processes seemlessly.

 

If you add a product to your cart, go to check out and select the "New Customer" option (the box on the left), you get the new customer information form as you should. But when you hit the "Continue," you get the following error:

 

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]

 

If you would like to test it, please go to ruffdudds.com. On the home page is an item called "test Item" for $0.00 represented by 2 cartoon chihuahuas. You do not need to complete the transaction to get the error.

 

I would appreciate anyone's help on this issue.

 

Thanx.

[johnnybebad]

Check that the create_account.php file and the database tables for the field thats in error, basically its saying it doesnt recognise the column 'customers_paypal_ec'

[Guest]

Check that the create_account.php file and the database tables for the field thats in error, basically its saying it doesnt recognise the column 'customers_paypal_ec'

 

 

Thanx for the reply, but I'm not a database guy. All the other references to the database are working. Is there something I should particularly look for?

[♥geoffreywalton]

Check your installation instructions and see if there is anything about running some sql.

 

Then follow the instructions.

 

You can't just miss out the bits you don't understand and expect it to work.

 

Good Luck

 

G

[MrPhil]

To elaborate on what geoffreywalton said, you evidently missed running SQL code (either a .sql file, or manual instructions to type in) to add columns to database tables. Your database was not updated with new information (fields) needed for the new PayPal function. Go back and re-read the instructions very carefully.

[Guest]

Thank you gentlemen. I did omit running the script. This happens when I work stupidly long days with hardly any sleep. As I mentioned previously, MySQL is not my forte.

 

I am in phpMyAdmin, I hit the SQL tab an wen I enter my script, I get syntax errors. I have tried several ways to do it by investigating online, but I cannot find a definitive answer. I located the section in the install instructions that states:

 

Once you have copied the files, you need to run a small SQL script. It is paypal_wpp.sql in this directory. The command to run it may vary depending on your database name and user, but will look something like:

 

mysql -u oscommerce -p oscommerce < paypal_wpp.sql

This assumes that your database user is named "oscommerce", and the name of the database is "oscommerce". You will be prompted for the database user's password.

 

the script to add the columns to the database in paypal_wpp.sql is:

ALTER TABLE `customers` ADD `customers_paypal_payerid` VARCHAR( 20 );

ALTER TABLE `customers` ADD `customers_paypal_ec` TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL;

 

Can someone please direct me how to properly run this script in MySQL 8?

 

Thank you

[BryceJr]

...

the script to add the columns to the database in paypal_wpp.sql is:

ALTER TABLE `customers` ADD `customers_paypal_payerid` VARCHAR( 20 );

ALTER TABLE `customers` ADD `customers_paypal_ec` TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL;

...

Can someone please direct me how to properly run this script in MySQL 8?

 

Running SQL Queries

[Guest]

Never mind. I Got It! Thank you for your responses.