[SOLVED] no shipping methodes after replacing backup

[RemySan]

Last week we were busy installing the Page Cache Ultimate module. This could not be installed Because the module Billion Themler Preview already created overrides. I contacted the Page Cache Ultimate developer, who said I had to put Billion Themler Preview down. I did this, but still the module did not want to install. I removed the Billion Themler Preview module to see if it helped but this meant that the entire website was gone. Then I wanted to install Billion Themler Preview again but this did not work because overrides were already made. We chose to return a backup of 3 days before. Everything worked again normally. One day later, we were tolt that when people want to buy thing out of the webshop they could not choose a shipping method. There was only a yellow warning box without text. I looked at the carriers then and they were all there. I have tried to remove it and re-place it, unfortunately this is unsuccessful. Now we are almost one week ahead and the shipping methods are still not returned.

 

How can I solve this?

 

Greetz,

Remy

Edited October 2, 2017 by RemySan (see edit history)

[Scully]

Always post the prestashop version in use.

[RemySan]

Sorry my fault, version 1.6.1.12

[Scully]

Are carriers set up within the products or are all products eligible to use all carriers?

How many and which carriers have you set up?

For which zones are these carriers enabled?

Did you check the zone settings under locatlization to make sure the zone belongs to the correct country?

[RemySan]

Are carriers set up within the products or are all products eligible to use all carriers?

How many and which carriers have you set up?

For which zones are these carriers enabled?

Did you check the zone settings under locatlization to make sure the zone belongs to the correct country?

 

Are carriers set up within the products or are all products eligible to use all carriers? All products are eligible to use all carriers.

 

How many and which carriers have you set up? I have 3 carriers, PostNL, GLS and pickup. These carriers are self created. Here a screen from one of the carriers how it's set up.

Carrier Setup:

 

For which zones are these carriers enabled? These zones are enabled: België, Germany, Netherland and Luxemburg. All of these zones are enabled. Look at the screen.

Zones:

 

Did you check the zone settings under locatlization to make sure the zone belongs to the correct country? Yes these settings are correct.

The weird thing of this situation is that it has worked. He stopped at once.

[Scully]

Settings look good so far.

 

My strong opinion is the following:

While installing and uninstalling modules with some troubles, something has interfered with your carrier settings or your backup was not a full backup and the carrier settings activated with the backup do not match other database settings.

Edited October 2, 2017 by Scully (see edit history)

[Scully]

Can you run some DB queries?

[RemySan]

I had this feeling that something has gone wrong in the database and the backup. What is the best way to solve this problem? It is an online store with more than 900 products and 600 categories. It will be really quite a shame if my customer needs to start all over again...

[RemySan]

Can you run some DB queries?

 

Can you explain this in more detail? Am not a big expert.

[Scully]

Just for my understanding: You are not the shop owner but a customer of yours is it?

And you are responsible in terms of technical stuff but you don't know what database queries are?

Edited October 2, 2017 by Scully (see edit history)

[RemySan]

Just for my understanding: You are not the shop owner but a customer of yours is it?

And you are responsible in terms of technical stuff but you don't know what database queries are?

 

No I'm not the owner of the shop. The company I work for builds websites and webshops for customers. It's not like it's a complete unknown territory for me. But I am also not an expert in. Am still learning.

Edited October 2, 2017 by RemySan (see edit history)

[Scully]

Lesson 1 to learn: Before installing any new or unknown module => make a full backup before. Full backup means not only datatabase but database and the entire filesystem. If something fails, just revert back. However, this did not succeed to to unknown reasons. Back to my question:

 

Are you familiar with MySQL? Can you open a database session and run some queries I would post?

Edited October 2, 2017 by Scully (see edit history)

[RemySan]

Lesson 1 to learn: Before installing any new or unknown module => make a full backup before. Full backup means not only datatabase but database and the entiere filesystem. If something fails, just revert back. However, this did not succeed to to unknown reasons. Back to my question:

 

Are you familiar with MySQL? Can you open a database session and run some queries I would post?

 

Haha good lesson, thanks !

 

Yes i'm familiar with MySQL and I can run some queries.

[Scully]

Run these queries and post results as code formatted text, one after the other.

Note that the table prefix might be different on your installation.

SELECT * FROM `ps_carrier` where active = 1 and deleted = 0 order by id_carrier DESC;
SELECT * FROM `ps_carrier_group` ORDER BY id_carrier DESC LIMIT 0,15;
SELECT * FROM `ps_carrier_shop` ORDER BY id_carrier DESC LIMIT 0,15;

Edited October 2, 2017 by Scully (see edit history)

[RemySan]

Did it. I hope I did a good job, here are the results:

Weergave van records 0 -  2 (3 totaal, Query duurde 0.0004 seconden.) [id_carrier: ]

SELECT * FROM `ps_carrier` where active = 1 and deleted = 0 order by id_carrier DESC


id_carrier       id_reference    id_tax_rules_group    name    url    active    deleted    shipping_handling    range_behavior    is_module    is_free    shipping_external    need_range    external_module_name    shipping_method    position    max_width    max_height    max_depth    max_weight    grade    

28    28    0    PostNL        1    0    1    0    0    0    0    0        1    2    0    0    0    0.000000    0    
27    25    0    Stealx        1    0    1    0    0    1    0    0        1    0    0    0    0    0.000000    0    
26    26    0    GLS        1    0    0    0    0    0    0    0        1    1    0    0    0    0.000000    0    


   

Weergave van records 0 - 14 (15 totaal, Query duurde 0.0002 seconden.) [id_carrier: ]

SELECT * FROM `ps_carrier_group` ORDER BY id_carrier DESC LIMIT 0,15


id_carrier       id_group    

28    4    
28    3    
28    2    
28    1    
27    4    
27    3    
27    2    
27    1    
26    4    
26    3    
26    2    
26    1    
25    4    
25    3    
25    2    

Weergave van records 0 - 14 (15 totaal, Query duurde 0.0002 seconden.) [id_carrier: ]
SELECT * FROM `ps_carrier_shop` ORDER BY id_carrier DESC LIMIT 0,15


id_carrier       id_shop    

28    1    
27    1    
26    1    
25    1    
24    1    
23    1    
22    1    
21    1    
20    1    
19    1    
18    1    
17    1    
16    1    
15    1    
14    1    

 

 

[Scully]

nothing uncommon - check this two as well:

SELECT count(id_product) FROM `ps_product_carrier`;

SELECT * FROM `ps_carrier_zone` where id_zone = 1;

[RemySan]

The results:

Weergave van records 0 - -1 (0 totaal, Query duurde 0.0002 seconden.)

SELECT count(id_product) FROM `ps_product_carrier`

0    

Weergave van records 0 - 14 (15 totaal, Query duurde 0.0006 seconden.)

SELECT * FROM `ps_carrier_zone` where id_zone = 1


id_carrier    id_zone    

1    1    
2    1    
7    1    
8    1    
9    1    
10    1    
11    1    
12    1    
15    1    
17    1    
19    1    
22    1    
24    1    
25    1    
27    1    

 

[Scully]

Seems some data is missing on the last query. Personally I would probably try to fix the database, but only before having tested this on a separate instances with a copy of the current shop. Other approach: delete all carriers and set them up as they where new.

[RemySan]

If you have the skills for it is indeed easy that you're trying to fix the database. I have these skills unfortunately not so it will have to do with the 2nd option. Removing and recreating the shipping methods. Miraculously it works again. I have tried this before but without success. I have just the performers through the database thrown out in far rather than through prestashop. Now the problem is solved. Thanks for your time and good support!

[Scully]

Thanks for the feedback. You could add 'SOLVED' to  your topic title or mark the best suitable answer.