Skipping Payment since mass deleting database sections

[philip937]

Hi,

Ive been doing some testing on a new site using 1.3.9e, after so many tests I decided to clear the database entries of customers/orders/paypal info.

Since then it seem that when checking out now it skips payment altogether and goes straight to checkout success..

did I delete something out of the database I Shouldnt have??

I emptied:

address_book
customers
customers_basket
customers_basket_attributes
customers_info
orders
orders_products
orders_products_attributes
orders_status_history
orders_total
paypal
paypal_payment_status_history
paypal_session

If I have done something wrong, is there a fix??

Cheers

[superprg]

Is the order successful
if yes, whats do you see in admin under Customers->Orders?

[philip937]

Is the order successful
if yes, whats do you see in admin under Customers->Orders?

Yes, and the order is created. I had the same thing happen earlier in a different machine I was testing with, I uninstalled paypal reinstalled, cleared pc cache and it worked, I thought it had fixed it but after testing with the machine I used a while ago the problem is still there.. Confused...
Posted via Mobile Device

[philip937]

this is driving me crazy!!!!!!

it makes no sense it was working fine before.

I tried a different database too and it made no difference!!!

Please someone help!??

[philip937]

Ok after more testing it appears that its skipping payment when using products imported from my 1.3.8 database.

If I install a clean database, create a test product in the admin it checks out fine, delete the product import the products from my existing website and completely skips payment, empty all products from database creat another test product, back to working absolutley fine...???

Can anyone tell me what i'm doing wrong please??

[DrByte]

So, you're saying that you're importing 1.3.8 data into a 1.3.9 database, without first upgrading the old data to the new format?

[philip937]

So, you're saying that you're importing 1.3.8 data into a 1.3.9 database, without first upgrading the old data to the new format?

Well sort of ?

I am building a fresh 1.3.9e install with database.

then exporting
specific product tables like products, attributes, descriptions, categories etc etc from the old database. 1.3.8

is that wrong then? If so what should I be doing?

I want to use a fresh database and simply import the values from the old database in where needed for products etc..

[DrByte]

If you're going to skip the official upgrade instructions which bring your *entire* old database forward into the new version, then you'll at least have to run zc_install on your old database before importing your selected tables into the new one.

FYI - Almost every time someone decides to just go off and selectively pull their own ideas of tables from old databases to new, they end up with unexplained problems. Thus, unless you have an intimate knowledge of what each table does, you really shouldn't be doing that. That's advanced work that requires careful study first.

[philip937]

If you're going to skip the official upgrade instructions which bring your *entire* old database forward into the new version, then you'll at least have to run zc_install on your old database before importing your selected tables into the new one.

FYI - Almost every time someone decides to just go off and selectively pull their own ideas of tables from old databases to new, they end up with unexplained problems. Thus, unless you have an intimate knowledge of what each table does, you really shouldn't be doing that. That's advanced work that requires careful study first.

I tried bringing the whole database across and upgrading it and that didn't work either.

I shall try importing from an updated database and see if that has any different results.

Bit confused why product data affect the payment module though?

Thanks for the advice.
Posted via Mobile Device

[philip937]

DrByte,

Well another attempt at it this morning.

This is what I did:

Installed zen-cart 1.3.9e

created an additional new database called "upgrade"

transferred a copy of live 1.3.8 database into the database "upgrade"

changed configure.php in catalogue and admin to point at "upgrade"

went to the new zen-cart 1.3.9e store /zc_install and ran the database upgrade.

uninstalled and re-installed payment module.

add product to cart, create account, choose shipping, choose paypal, click confirm, SKIPS PAYPAL and straight to checkout success!

So now i'm following the *official* instructions, what can you suggest I check??

cheers

Phil