Database update in place? What update?

[gatorboy]

Hi Guys, great contribution. I've set up paypal pro for osc and I am loving it so far. I do have an issue and can't seem to find any related posts. I ran the Paypal Website Payments Pro Diagnostics and it showed a no for "database update in place?" I can't seem to find a reference to this on the forum. The site works fine and transactions are completed, paypal sends me notices of transaction success in e-mails, but the process stops after submitting and displays an error:

 

1146 - Table 'thisisa_bogusname.orders_status_history_transactions' doesn't exist

 

INSERT INTO orders_status_history_transactions ( `orders_status_history_id`, `transaction_id`, `transaction_type`, `payment_type`, `payment_status`, `transaction_amount`, `module_code`, `transaction_avs`, `transaction_cvv2`, `transaction_msgs` ) VALUES ( 1, 'somelongnumber', 'CHARGE', 'INSTANT', 'COMPLETED', 56.07, 'paypal_wpp', 'ZIP Five-digit ZIP code (no Address)', 'Match CVV2', '' )

 

[TEP STOP]

 

I checked the database and the table .orders_status_history_transactions in fact does not exist, is this possibly due to the "database update in place?" thing. Also, can I just create the table using the fieldnames from the insert query above, or is there more to it than meets the eye?

Sorry if this is unclear or a question that has been beat to death already, but I can't seem to find anything on it. Thanks in advance for the help and great contribution.

[♥geoffreywalton]

It looks like you missed out a step to run some sql that inserts/adds this new table.

 

Reread the installation instructions and find this step.

 

For more info on how to "run" sql see my profile or google this forum.

 

G

[gatorboy]

It looks like you missed out a step to run some sql that inserts/adds this new table.

 

Reread the installation instructions and find this step.

 

For more info on how to "run" sql see my profile or google this forum.

 

G

Thanks for the reply Geoff,

Actually the version I installed uses an install script, which does a really nice job of adding and modifying php files, I'm not sure why this one table was skipped, however there are no instructions covering adding sql anywhere. I am quite good with sql and I might try to create the necessary table(s) myself and try it. I have read at least 500 posts in the last 3 days and have run out of search terms. So I'll give it a go the hard way and let you know how it works out. Thanks again