Transplant module - E500

[zsadam]

Hello, I have a PS 1.7.3.0 and from my page missing sign in/login in button. I want to put it on top but when i click on transplant module button after a minute loading i get error 500. Is there way to transplant it manually?

Thanks in advance for the tips.

[joseantgv]

This is a bug in your version.

Check table ps_hook_module. You just need to find the ID from the module and from the hook to insert a record.

[zsadam]

On 3/26/2021 at 5:04 PM, joseantgv said:

This is a bug in your version.

Check table ps_hook_module. You just need to find the ID from the module and from the hook to insert a record.

Hello, so i found that displaytop hook is ID 21, and ps_customersignin module is ID 187. So how can i assign them. Im not really good in sql.

[musicmaster]

On 4/2/2021 at 11:18 AM, zsadam said:

Hello, so i found that displaytop hook is ID 21, and ps_customersignin module is ID 187. So how can i assign them. Im not really good in sql.

You can do that in the backoffice in Design->Positions and the "Transplant a hook".

"Transplant a hook" is a bit of a misnomer as it is about adding a hook for a module.

[zsadam]

Thanks but my problem is exactly that when i click on transplant module button i get error 500

[musicmaster]

You need to do two queries. First you need to find the first free position for this hook. That looks like

SELECT max(position) as pos FROM ps_hook_module WHERE id_hook=21

You add one to that position for the next query. So if it was 8 the next query will be:

INSERT INTO ps_hook SET id_hook=21,id_module=187, id_shop=1,position=9

 

[zsadam]

5 minutes ago, musicmaster said:

You need to do two queries. First you need to find the first free position for this hook. That looks like

SELECT max(position) as pos FROM ps_hook_module WHERE id_hook=21

You add one to that position for the next query. So if it was 8 the next query will be:

INSERT INTO ps_hook SET id_hook=21,id_module=187, id_shop=1,position=9

 

Thank you! However (as a not expert) where do i write these queries? 

[musicmaster]

8 minutes ago, zsadam said:

Thank you! However (as a not expert) where do i write these queries? 

Phpmyadmin. You have no choice. You will need to learn to use this.

[zsadam]

26 minutes ago, musicmaster said:

Phpmyadmin. You have no choice. You will need to learn to use this.

So i found that for first query pos 3, so second query needs to be position=4, however when i run it, it returns error #1054 - Unknown column 'id_module' in 'field list'

[musicmaster]

I see. I had an error in the second line. It should be:

INSERT INTO ps_hook_module SET id_hook=21,id_module=187, id_shop=1,position=9

 

[zsadam]

7 minutes ago, musicmaster said:

I see. I had an error in the second line. It should be:

INSERT INTO ps_hook_module SET id_hook=21,id_module=187, id_shop=1,position=9

 

Omg man! Big thanks! It works!