Jump to content

No order details in back end, and the table is empty


Recommended Posts

I've been searching for a fix for two days now and no luck so far.

 

Orders go through just fine. I'm using the PayPal Pro module and Presto-changos UPS. When you look at an order everything is in there but when you scroll down to the list of products, nothing is in there.

 

PayPal shows the products in the order in their interface & the confirmation email from the site shows the products that were ordered.

 

When I roll over to the database, ps_order_detail is completely empty.

 

I am making a back-up of the entire site to drop onto our test server, but with 10K products it takes a while.

 

I went back to our set up server and changed the modules to match the live site and I couldn't get the problem to manifest.

 

Turning on error reporting doesn't generate any messages.

 

The front end doesn't show any details either, but with a blank table it is what I would expect.

 

And I went into database and did a repair on all the tables.

Link to comment
Share on other sites

You should contact the developer of both extra modules, which is the same developer for both. One of the modules is causing the problem on your database. Perhaps one of them is not compatible with the Prestashop Version in use.

 

Support Prestochangeo: http://www.presto-changeo.com/en/my-account - use the support option on your order.

Link to comment
Share on other sites

Another item found.

 

The cart does show the products for the order, it's just not being copied over.

 

The PayPal module is the PayPal Direct from Prestashop. The shipping is Presto-Chango. I've got a support ticket in for them. I've got about 20,000 more files to copy over before I can set up a local test server to really jump into the code.

Link to comment
Share on other sites

If the cart is showing other products as ordered, than you deleted something manually in the database. Prestashop works with ID's and dependencies, if you delete something and don't delete the dependency too, than products ordered and products in cart could be others. Deletion could be manually done or by a bugged module.

 

In this case you should install a clean Prestashop and import all your products again to this clean install.

 

On your first topic you told Paypal Pro - this is from Prestochangeo too.

 

 

But indeed you problem seems to be a broken Prestashop and not a problem of that modules. The only way to debug this is: you contract a Prestashop specialist to analyze and repair your database, or you install Prestashop clean and import all your products to this clean database.

Link to comment
Share on other sites

It seems that I have the same problem and I have been migrated by www.carres-croises.com, so even agencies are sometimes creating errors...!

 

I have my orders fine in front end and in back office, but since migrated to V1.6.1.1, no more product details in all my orders. Btw, the site is in production, so this is a MAJOR problem for us. I checked in tables and nothing....any help welcome.

Thanks

Link to comment
Share on other sites

It seems that I have the same problem and I have been migrated by www.carres-croises.com, so even agencies are sometimes creating errors...!

 

I have my orders fine in front end and in back office, but since migrated to V1.6.1.1, no more product details in all my orders. Btw, the site is in production, so this is a MAJOR problem for us. I checked in tables and nothing....any help welcome.

Thanks

 

 

From what I read on first topic your problem is quite different. You did an upgrade.If the table of database is empty than yo should rollback your shop. Before you upgrade it again you should export the table ps_products from your database with phpMYAdmin.

Make an upgrade.

 

If again product descriptions are empty, than you should import with phpMyAdmin the table ps_products to this upgraded database.

 

BTW, are you using non-native modules ? Like strip ID's on URL for SEO ? Extra product description tab ?

Edited by selectshop.at (see edit history)
Link to comment
Share on other sites

×
×
  • Create New...