If this is your first visit, check our documentation. To post, register or login.

MySQL

Locked

Started by kimhuff on 14 Sep 2006, 5:27 PM · Views: 1,077

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
14 Sep 2006, 5:27 PM
#1
kimhuff avatar

kimhuff

Zen Follower

Join Date:
Nov 2005
Posts:
88
Plugin Contributions:
0

MySQL

I know this is an odd request, but here goes.

I am not sure how it happened, but one of my products was deleted. I know you might be thinking.. well, just re-add it. But, I have some special coding in the site that looks at the products_id and depending on which one it is... it will continue to a different page when checking out. SO, I re-add the product, but of course it gave the product a different products_id value. I have tried going into MySQL and changing the product id to match the old one and it is showing up in the store and in the admin control panel. Unfortunately, it is not showing up in the Products Purchased Report. Anyone have any suggestions?

Thanks,

Kim

17 Sep 2006, 1:52 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: MySQL

You fixed all of the tables where a products_id is used related to this product?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

20 Sep 2006, 2:23 AM
#3
kimhuff avatar

kimhuff

Zen Follower

Join Date:
Nov 2005
Posts:
88
Plugin Contributions:
0

Re: MySQL

Yes, I have checked them all

20 Sep 2006, 2:29 AM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: MySQL

On Products Purchased ... it is spitting out a field that is calculated as orders are placed ...

products_ordered

Count them up in the orders_products table and update the value ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!