errors on checkout (Purchase Orders version 1.3)

[pirosaint]

Hi

after installed the Purchase Orders version 1.3, i got this error in the end of the process,

after i click the confirm button..

 

 

am i missing something.??

 

any comments will be highly appreciate it.

 

nch

[safoo]

yes you are missing the column 'account_name' in the orders table.

 

for the first warning you probably have extra white spaces in checkout_process.php. Open the file and look at the last line. REmove any spaces or characters after the closing "?>".

 

I know you are new here, but next time search the forums before posting. A search for 'unknown column' or 'headers already sent' would have probably got you the answer.

Edited August 16, 2006 by safoo

[pirosaint]

yes you are missing the column 'account_name' in the orders table.

 

for the first warning you probably have extra white spaces in checkout_process.php. Open the file and look at the last line. REmove any spaces or characters after the closing "?>".

 

I know you are new here, but next time search the forums before posting. A search for 'unknown column' or 'headers already sent' would have probably got you the answer.

 

Hi

thanks for heads up, but this is what i got from the sql..

after i ran what i suppossed to:

ALTER TABLE `orders` ADD `account_name` VARCHAR( 32 ) NOT NULL AFTER `currency_value`;
ALTER TABLE `orders` ADD `account_number` VARCHAR ( 20 ) AFTER `account_name`;
ALTER TABLE `orders` ADD `po_number` VARCHAR ( 12 ) AFTER `account_number`;

 

this is the pic:

 

and after that this is the table "Orders".. last part of it:

 

any idea.. i am not good with sql.. but

i think here says that somehow the table is duplicate...

but when we are at the catalog and we press the confirm button, there it says that we are missing that "account_name" on the table.. how is that works??

 

thanks very much for your help

nch

[safoo]

hmm...

 

did you check for whitespace at the bottom of the file?

[pirosaint]

hmm...

 

did you check for whitespace at the bottom of the file?

yes i did and it had a blank space but i removed it

 

so i dont know what else could be

 

any extra idea??

 

thanks for your support

nch

[pirosaint]

Hi

 

can anyone tell me please..

 

how to verify if that table is not on the sql.. using another method..

 

 

i already went to it and it seems that is there, but when i ran the oscommerce is telling me that is not

 

how can i make sure that i am doing the right thing

 

thanks in advance for your comments

 

nch