monicaamb Posted March 1, 2023 Share Posted March 1, 2023 HELLO I would like to obtain the url of all the images of my products making a query in PrestaShop. Could you help me? Link to comment Share on other sites More sharing options...
ps8modules Posted March 1, 2023 Share Posted March 1, 2023 Link to comment Share on other sites More sharing options...
monicaamb Posted March 1, 2023 Author Share Posted March 1, 2023 1 hour ago, ps8moduly.cz said: Thank you very much. However, I got this error: FROM doesn't exit , Link to comment Share on other sites More sharing options...
ps8modules Posted March 2, 2023 Share Posted March 2, 2023 Hi. This will not work in SQL manager, but in phpMyAdmin. SQL manager does not support GROUP_CONCAT. 1 Link to comment Share on other sites More sharing options...
idnovate.com Posted March 2, 2023 Share Posted March 2, 2023 Maybe you have a different database prefix than "ps_"? Link to comment Share on other sites More sharing options...
idnovate.com Posted March 2, 2023 Share Posted March 2, 2023 Related post Link to comment Share on other sites More sharing options...
ps8modules Posted March 2, 2023 Share Posted March 2, 2023 (edited) 8 minutes ago, idnovate.com said: Maybe you have a different database prefix than "ps_"? I wrote the reason why it doesn't work. When you put the query in phpMyAdmin, it works. It does not work only in Prestashop SQL manager, because GROUP_CONCAT is not enabled. https://docs.prestashop-project.org/1.7-documentation/user-guide/configuring-shop/advanced-parameters/database/sql-manager Edited March 2, 2023 by ps8moduly.cz (see edit history) 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now