retechp Posted November 18 Share Posted November 18 (edited) I am trying to build reports through the SQL Manager. I have built a test report but when I attempt to execute, the following error appears. It does not matter what is selected for the report when executing report. I have seen several issues similar but none relating to PrestaShop SQL Manager and version 8.2.0 I am running: - PrestaShop 8.2.0 - Apache 2 - MySQL version 8.0.40-0 - ubuntu0.20.04.1 Edited Thursday at 07:18 PM by retechp (see edit history) Link to comment Share on other sites More sharing options...
Prestashop Addict Posted November 18 Share Posted November 18 You mean a simple SELECT * FROM ps_order_invoice produce an error? If no put your SQL query here. Link to comment Share on other sites More sharing options...
retechp Posted November 19 Author Share Posted November 19 This was the info I entered into the query window. I allowed me to save it however when I tried to view or download it, the above error appeared. Link to comment Share on other sites More sharing options...
Prestashop Addict Posted November 19 Share Posted November 19 Your query must include all SQL elements SELECT id_order_invoice, id_order FROM ps_order_invoice 1 Link to comment Share on other sites More sharing options...
retechp Posted Thursday at 07:19 PM Author Share Posted Thursday at 07:19 PM Thanks On 11/19/2024 at 9:53 AM, Prestashop Addict said: Your query must include all SQL elements SELECT id_order_invoice, id_order FROM ps_order_invoice 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