Need help with SQL query syntax

[YanK1973]

Hi,

i need to apply to all products a specific module id so it is enabled for all.

So in Table: prstshp_modulex_product i need to add all products with modulex_id value 1

How should i syntax the query?

[PrestaHeroes USA]

1) make a copy of your production shop in a sub domain for example

2) open your phpmyadmin, there you can create sql statements and run them

else you can open a post in job offer for freelancer.

 

PS goofed on module by product, they did not provide a consolidated screen to display what modules are attached to what products, this puts onus on the developer of the module to create panel, that never happens.  rather than attach to ps product, it should be attached to product id's in the module so they can be managed.  a good idea done only half way