Changing Database

[kattiestags]

For some odd reason my prestashops is no longer working correctly and having tons of problems.  In the Configurations Information page there is a giant long list of "missing/changed files" beginning with the following:

• admin2840/autoupgrade/index.php
• admin2840/themes/default/template/controllers/index.php
• admin2840/themes/default/template/controllers/access/index.php
• admin2840/themes/default/template/controllers/access/helpers/index.php
• admin2840/themes/default/template/controllers/access/helpers/form/index.php
• admin2840/themes/default/template/controllers/addons_catalog/index.php
• admin2840/themes/default/template/controllers/addresses/index.php
• admin2840/themes/default/template/controllers/addresses/helpers/index.php
• admin2840/themes/default/template/controllers/addresses/helpers/form/index.php
• admin2840/themes/default/template/controllers/addresses/helpers/list/index.php
• admin2840/themes/default/template/controllers/attachments/index.php
• admin2840/themes/default/template/controllers/attribute_generator/index.php

and the list goes on forever.......

 

Rather than try to fix it I decided to do a fresh install but I have a bunch of products already added to the site and I would hate to have to re-do it.  so is there a way to point the new install to the Old database with all the products?

[NemoPS]

If you didn't get any order, you can simply save all product related tables (all the ones prefixed with product_)

And re-import after you reinstall. BUt really, prestashop says that even if you don't change anything. What kind of issue are you experiencing? Those index files can't be the problem

[kattiestags]

Thanks for the reply Nemo1.  The main problem I'm having is the "No carrier" error and also the paypal button is gone and no way to pay for it.  

 

For carriers, I've tried all sorts of settings.  Uninstalled and installed the carrier modules.  Iv'e enabled and disabled.  Iv'e done the location, I've set the ranges, I've assigned carriers at the product level.  nothing seems to work.  So I figure i start fresh and just move the database over to a new install of prestashop.

 

As for the Paypal it just wont show with a working button with express checkout and since I cant get to the final payment page due to no carrier error I cant see if it works on the last page.  

 

I'd like try your method of saving and importing.  Do you have a video or something that shows me how to do this? 

 

thanks

[NemoPS]

No video sadly you just have to login to phpmyadmin, select all ps_product* related tables, and hit export, then re-import in the new database (don't erase the previous one, keep 2 installations till the second runs smoothly)

[kattiestags]

I did what you said nemo. Had some help from my hosting company. But things still din't work correctly so I need more advice.

 

I now have 4 files that start with PS_product and 4 with xzl_product. It didnt work.

So I renamed the xzl files and changed the prefix of 4 imported files (Ps_product) to match the destination folder files (xzl_product). Still didn't work. When I open the site i'm not getting any erors but I sitll see the old products.  I tried clearing my cache and cookes but still didn't work.

 

Funny thing is when I delete products and attributes I see the table in the database changing.  It's just not working the other way around. Any ideas?

[NemoPS]

Well you must be sure to have those tables named the same way of course. Or, export them one by one, and import one by one as well by selecting each every time